Home » Server Options » Data Guard » DATAGUARD SYNC BUT...? (11gr2,windows7)
DATAGUARD SYNC BUT...? [message #561944] Thu, 26 July 2012 06:16 Go to next message
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'
Re: DATAGUARD SYNC BUT...? [message #561950 is a reply to message #561944] Thu, 26 July 2012 06:31 Go to previous message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
The archived log has been but not yet applied.

Regards
Michel
Previous Topic: datagurad configuration
Next Topic: dataguard error in startup using pfileORCL.ora
Goto Forum:
  


Current Time: Thu Mar 28 08:12:44 CDT 2024