Home » Server Options » Data Guard » Archived applied status showing NO in v$archived_log (11.2.0.1)
Archived applied status showing NO in v$archived_log [message #599247] Wed, 23 October 2013 04:40 Go to next message
AnilKampiri
Messages: 69
Registered: September 2012
Location: Chennai
Member

Hi ,

Good day Please note we unable to update datagurad after doing incremental backup,In v$archived_log applied status shows NO,But archives are in sync,Please update on this.

Regards,
Anil
icon5.gif  Re: Archived applied status showing NO in v$archived_log [message #599257 is a reply to message #599247] Wed, 23 October 2013 05:42 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Post commands and their result that lead you to this diagnosis.

Re: Archived applied status showing NO in v$archived_log [message #599284 is a reply to message #599257] Wed, 23 October 2013 08:28 Go to previous messageGo to next message
AnilKampiri
Messages: 69
Registered: September 2012
Location: Chennai
Member

Hi,Please find My MRP status and log_history

MRP status:

SQL> select process, thread#, sequence#, status from v$managed_standby where process='MRP0';

PROCESS THREAD# SEQUENCE# STATUS
--------- ---------- ---------- ------------
MRP0 1 67196 WAIT_FOR_GAP

Archived_Log:

SQL> select thread#,max(sequence#) from v$archived_log where applied='YES' group by thread#;

no rows selected

SQL>

Log_history status:

SQL> select thread#,max(sequence#) from v$log_history group by thread#;

THREAD# MAX(SEQUENCE#)
---------- --------------
1 67581
2 39511
3 40117

SQL>

All are in standby database as per me log_history showing sequence are up to date but my MRP still waiting for old log.

Regards,
Anil




icon5.gif  Re: Archived applied status showing NO in v$archived_log [message #599293 is a reply to message #599284] Wed, 23 October 2013 08:47 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Are the missing logs still available on the primary?

Re: Archived applied status showing NO in v$archived_log [message #599301 is a reply to message #599293] Wed, 23 October 2013 09:08 Go to previous messageGo to next message
AnilKampiri
Messages: 69
Registered: September 2012
Location: Chennai
Member

Yes we tried to register archived in standby too. But still MRP is waiting


icon5.gif  Re: Archived applied status showing NO in v$archived_log [message #599303 is a reply to message #599301] Wed, 23 October 2013 09:21 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

And nothing in the alert.log (both sides)?

Re: Archived applied status showing NO in v$archived_log [message #599304 is a reply to message #599301] Wed, 23 October 2013 09:24 Go to previous message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Metalink note 1542907.1
Previous Topic: doubt in log applied or not
Next Topic: log archive miss
Goto Forum:
  


Current Time: Thu Mar 28 06:08:19 CDT 2024