Re: TDP for SAP R/3 Disaster Recovery
2001-09-21 13:18:44
Hello,
To find what file are backup with TDP/R3 use the command ( as ora<SID> ) :
ora<SID> # backfm -p /oracle/<SID>/dbs/init<SID>.utl
Seen after the DR procedure for the SAP with TDP/R3
* find the logfile of the brbackup in the directory
/oracle/<SID>/sapbackup or restore this file with backfm
In this directories, you must find some files like bdgghfsr.anf or
bdgghfsr.aff.
The .aff is for the offline backup and the .anf is for the online
backup.
After use the command (as ora<SID>):
ora<SID> # cd /oracle/<SID>/sapbackup
ora<SID> # brrestore -m full -b bdgghfsr.anf
To restore the last redolog used generated during the brbackup online:
ora<SID> # /oracle/<SID>/sapbackup
ora<SID> # grep SCN bdgghfsr.anf
Current log sequence 2989 SCN: 31357833
Current log sequence 2990 SCN: 31397586
ora<SID> # brrestore -a 2989
or
ora<SID> # grep SCN bdgghfsr.anf
Current log sequence 2989 SCN: 31357833
Current log sequence 2995 SCN: 31397586
ora<SID> # brrestore -a 2989-2994
Now you must apply all thredolog in ORACLE
ora<SID> # svrmgrl
SVRMGR> connect internal
SVRMGR> startup mount
SVRMGR> recover database using backup controlfile until cancel;
The system suggests each redo log and recovers to the end of
it, press ENTER until it gets to the last redo log (in this
case 2990 or 2995), reply CANCEL when it asks when it asks for redo log
numy.
SVRMGR> alter database open resetlogs;
SVRMGR> exit
|
|
|