Home » RDBMS Server » Backup & Recovery » Apply archive logs standby
Apply archive logs standby [message #266199] Mon, 10 September 2007 03:18 Go to next message
Messages: 199
Registered: March 2007
Senior Member
Version : Oracle 10gR2
We have a standby database which needs to be used only for reporting purpose and is located at the branch office with a private IP.
We use a script to copy the archive logs from primary to standby.The steps for applying the archive logs on standby is
connect / as sysdba
shutdown abort
startup nomount
alter database mount standby database
recover automatic standby database
alter database open read only
Do we need to run the above command every time there is a new archive log which needs to be applied or is it possible to run "recover automatic standby database" while the database is open in read only mode or we need to close the database then do the recovery and open it again.
Re: Apply archive logs standby [message #293561 is a reply to message #266199] Mon, 14 January 2008 02:03 Go to previous message
Messages: 8
Registered: September 2007
Location: India
Junior Member
If the Standby Database is opened in read only mode , the Recovery process cannot be done.
You can run the following command whenever you want to apply the archived redo logs
SQL>Alter database recover managed standby database disconnect;
The MRP process will apply the archived redo logs. Once it is finished , you can switch the standby database to read only mode

SQL> Alter database recover managed standby database cancel;
SQL> Alter database open read only;
Previous Topic: Can I force the clone DB to receive data from primary DB?
Next Topic: Archive log before full backup
Goto Forum:

Current Time: Thu Aug 17 05:00:00 CDT 2017

Total time taken to generate the page: 0.11315 seconds