DATAGUARD SYNC BUT...? [message #561944] |
Thu, 26 July 2012 06:16 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.gravatar.com/avatar/d777b4d88bc3a47e06bea876e6c84c40?s=64&d=mm&r=g) |
naveen9999
Messages: 3 Registered: August 2011 Location: VIZAG
|
Junior Member |
|
|
few doubts on dataguard configuration,please help me.
select max(sequence#) from v$archived_log;
on standby and primary are giving same sequence number but when giving a command select sequence#,applied on v$managed_standby on standby db its showing status as 'NO'.
ON STANDBY
select sequence#,applied on v$managed_standby;
SEQUENCE# APP
---------- ---
173 NO
89 rows selected.
SQL> select process,status from v$managed_standby;
PROCESS STATUS
--------- ------------
ARCH CLOSING
ARCH CLOSING
ARCH CLOSING
ARCH CLOSING
RFS IDLE
RFS IDLE
RFS IDLE
RFS IDLE
8 rows selected.
ON PRIMARY DB
SQL> select process,status from v$managed_standby;
173 NO
295 rows selected.
SQL> select process,status from v$managed_standby;
PROCESS STATUS
--------- ------------
ARCH CLOSING
ARCH CLOSING
ARCH CLOSING
ARCH CLOSING
LNS WRITING
now when i am trying to open standby database the error is:
SQL> ALTER DATABASE OPEN;
ALTER DATABASE OPEN
*
ERROR at line 1:
ORA-16004: backup database requires recovery
ORA-01194: file 1 needs more recovery to be consistent
ORA-01110: data file 1: 'C:\APP\NAVN\ORADATA\STAND\SYSTEM01.DBF'
|
|
|
|