| Apply archive logs standby [message #266199] |
Mon, 10 September 2007 03:18  |
preet_kumar
Messages: 204
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
cancel
alter database open read only
quit
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  |
vishym_68
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;
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
