RE: Newbie database restore question (PLEASE HELP!)

[Tilo Heinrich]

Hello Yusuf,

if you have a complete backup and all the log in log backups you have to something like
the following

1.) Install the new database for recovery (if using DBMGUI use "Install for recovery" when
asked for, using dbmcli stop after "dbmcli ... util_execute init config") Do not change
the database state from ADMIN to ONLINE

2.) create appropriate backup media for the new database

3.) Restore the complete data backup

e.g.: dbmcli -d ... -u ...,... -uUTL -c recover_start <DataMedium>

4.) Restore the log backups

e.g.:

dbmcli -d ... -u ...,... -uUTL
>recover_start <LogMedium>
>recover_replace <LogMedium> <loc> <nnn>
...
>recover_replace <LogMedium> <loc> <mmm>
>recover_ignore

Best Regards,
Tilo Heinrich
SAP Labs Berlin




-----Original Message-----
From: Yusuf Gangat [mailto:yusuf.gangat@stripped]
Sent: Friday, October 17, 2003 2:46 PM
To: maxdb@stripped
Subject: FW: Newbie database restore question (PLEASE HELP!)


Hi 
 
We need some help? We are running sapdb as our database, however our
server crashed and keepings restarting itself. The hard drives are still
ok, therefore the database files and logs are still ok on the hard
drive. What we need to do is install the database on a new machine. Our
DBA can do this but the problem is that the last backup was done a month
and a half ago. We do have all the logs since the last backup. How do we
go about restoring the logs?
 
Any help will be appreciated as our system is down at the moment.
 
Thanks
Yusuf 

---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.525 / Virus Database: 322 - Release Date: 10/9/2003
 


-- 
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe:    http://lists.mysql.com/maxdb?unsub=1