on 04-24-2014 7:07 AM
Hello,
I have taken an offline backup for the database through Netbackup and restored the backup to another server and now i want to restore the archive logs in a sequence, what is the proper way or th eexact command to do so? throgh brrestore or rman?
Thanks,
Hi,
Why don't you just use Oracle dataguard for this?
Restore the online backup of production and enable dataguard, it will take care of shipping and application of archive logs.
Regards,
Nick Loy
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
You shouldn't sync your control files between primary and standby databases.
Data guard takes care of archive log shipping, application.
Refer below link OR Google/Search SDN with a key word "Oracle Data guard".
ORACLE-BASE - Data Guard Physical Standby Setup in Oracle Database 11g Release 2
Regards,
Nick Loy
Apply command recover standby database;
Please use this after getting redo logs under oraarch directory.Also share are you able to connect this server from Netbackup end.
Thanks,
Gaurav
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Ola,
I have taken an offline backup for the database through Netbackup and restored the backup to another server and now i want to restore the archive logs in a sequence.
First you need to consider SAP system copy methods by following System Copy - SAP NetWeaver Library: Function-Oriented View - SAP Library
On other end i.e Netbackup end are you able to get details of ID7 system on Netbackup server .Your system should be under resolvable conditions as like below.
Gaurav
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Ola,
Okay.So you are performing DR creation for your production server.So in this regards you need to follow standard SAP DR creation methods as well as Oracle data guard steps.You just need to perform Managed recovery mode.
Simply restore left redo from Netbackup end to the new server after complete client connectivity .
Please follow guide
http://www.oracle.com/us/solutions/sap/wp-ora4sap-dataguard11g-303811.pdf
Gaurav
Hi Ola,
You need not execute startup command.
What I mentioned was , shutdown database
Mount the DR database using
SQL> ALTER DATABASE MOUNT STANDBY DATABASE;
Then recover using the command
SQL>ALTER DATABASE RECOVER MANAGED STANDBY DATABASE DISCONNECT FROM SESSION;
Hope this helps.
Regards,
Deepak Kori
Hello,
It can be done through either BR*Tools
Command Options for BRRECOVER - SAP Database Guide: Oracle (BC-DB-ORA-DBA) - SAP Library
Or using rman
Or simply at sqlplus prompt
recover database until cancel
Brest regards
605062 - FAQ: Restore and recovery
602497 - BRRECOVER - New tool for Oracle Restore and Recovery
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
I have tried this command but it gave an error
Hi Ola,
On Production database execute
SQL> alter database backup controlfile to trace;
This will create a trace file under saptrace/usertrace folder.
Copy this trace file to Standby server and rename it as CONTROL.SQL.
Change the SID in this file to Standby and replace "reuse" to "set"
Mount the standby database and excute the control.sql scrip
SQL> @<path of CONTROL.SQL file>
Hope this helps.
Regards,
Deepak Kori
User | Count |
---|---|
101 | |
13 | |
13 | |
11 | |
11 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.