ADSM-L

Re: TDP for SAP R/3 Disaster Recovery

2001-09-21 13:18:44
Subject: Re: TDP for SAP R/3 Disaster Recovery
From: "Ramboux, Jean-Claude" <JRamboux AT KRAFTEUROPE DOT COM>
Date: Fri, 21 Sep 2001 19:19:22 +0200
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

<Prev in Thread] Current Thread [Next in Thread>