Home » Server Options » Data Guard » v$view to lookup last apply log in automatic recover standby database (oracle 10g r2 solaris 5.10)
v$view to lookup last apply log in automatic recover standby database [message #476042] Tue, 21 September 2010 00:32 Go to next message
reyazan
Messages: 53
Registered: February 2005
Member
I have standby database of oracle 10g R2 Enterprise edition on Solaris 5.10 Os.
I have manually apply the log with the command

alter database recover automatic standby database;

then i check the alter log to lookup the last apply logs
and then issue for register logfile

alter database register logfile '/oracle/ECP/oraarch/Orclarch1_152011_650474625.dbf';

Is there any v$view to lookup the last apply logs
after run sql alter database recover automatic standby database;

Please Help

Re: v$view to lookup last apply log in automatic recover standby database [message #476048 is a reply to message #476042] Tue, 21 September 2010 01:34 Go to previous message
John Watson
Messages: 8922
Registered: January 2010
Location: Global Village
Senior Member
From the Data Guard Concepts and Admin guide:

On the standby database, query the V$ARCHIVED_LOG view to verify the archived redo log files were applied.

SQL> SELECT SEQUENCE#,APPLIED FROM V$ARCHIVED_LOG
2 ORDER BY SEQUENCE#;

SEQUENCE# APP
--------- ---
8 YES
9 YES
10 YES
11 YES


Previous Topic: redo apply
Next Topic: ORA-01154: database busy. Error in Creating Physical StandBy Database in the same Server
Goto Forum:
  


Current Time: Fri Mar 29 10:13:29 CDT 2024