DATAGUARD SYNC BUT...? [message #561944] |
Thu, 26 July 2012 06:16 |
|
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'
|
|
|
|