Home » Server Options » Data Guard » applying logs
applying logs [message #160410] Sat, 25 February 2006 04:51 Go to next message
Messages: 312
Registered: May 2005
Senior Member
hi i managed to create a physical standby database
on the same xp host
and i checked that redo logs are transferred to the standby
but ther are not applied help plz
i did everything using the dataguard admin guide

Re: applying logs [message #244671 is a reply to message #160410] Wed, 13 June 2007 13:05 Go to previous messageGo to next message
sharan alva
Messages: 57
Registered: November 1999
Not applying, have you placed the standby in managed recovery mode ?

You can do the following test, check first to see if you can manually recover the standby database

sql>alter database mount standby database;
sql>recover standby database

This will ask for the next sequence, hit enter if you have the file in the specified location or provide the full path and filename.

Here it should apply the log and ask for the next sequence. Then you know that it is applying at this stage, hit auto and allow all the logs to apply then type cancel

Now place it in managed recovery mode and then switch a log on the primary and ensure that the logs get shipped across and applies
Re: applying logs [message #244676 is a reply to message #244671] Wed, 13 June 2007 13:41 Go to previous message
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member

On the STANDBY database execute the following command to start Managed Recovery Process (MRP). This command is executed on Mount stage.

•	SQL> Alter Database Recover Managed Standby Database;

Database Altered.

By executing the above command the current session will become hanged because MRP is a foreground recovery process. It waits for the logs to come and apply them. To avoid this hanging, you can execute the following command with DISCONNECT option.

SQL> Alter Database Recover Managed Standby Database Disconnect;

Database Altered.

Now the session will be available to you and MRP will work as a background process and apply the redo logs.

You can check whether the log is applied or not by querying V$ARCHIVED_LOG.

•	SQL> Select Name, Applied, Archived
from v$Archived_log;

This query will return the name of archived files and their status of being archived and applied.
Previous Topic: Standby Database with 10g Standard Edtion
Next Topic: lost standby controlfile
Goto Forum:

Current Time: Sat Feb 27 06:54:58 CST 2021