Oracle physical standby database received redo has not been applied

Posted by Arthur Aoife on Server Fault See other posts from Server Fault or by Arthur Aoife
Published on 2010-03-22T09:12:01Z Indexed on 2010/03/22 9:21 UTC
Read the original article Hit count: 364

Filed under:
|
|
|

Hi,

I followed the steps in oracle documentation on creation of a physical standby database.

The link to the configuration steps, http://download.oracle.com/docs/cd/B28359_01/server.111/b28294/create_ps.htm#i63561

When I perform "Step 4 Verfiy that received redo has been applied." my query result is not as expected, following is the result,

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

SEQUENCE# APP


    5 NO
    6 NO
    7 NO
    8 NO

4 rows selected.

Appreciate any advice on how to proceed, thanks.

© Server Fault or respective owner

Related posts about Oracle

Related posts about standby