Home » Server Options » Data Guard » applied archived_log on standby database RAC (Oracle 10g, 10.2.0, linux x86_64)
applied archived_log on standby database RAC [message #295313] Tue, 22 January 2008 02:00 Go to next message
ms_mdr
Messages: 8
Registered: January 2008
Junior Member
Dear list,

I really needs help here.

I have RAC server with 4 nodes, and 1 physical standyby database.

The problems is:
when I check this syntax
select count(applied) from v$archived_log
where applied='NO'


the result
5272 rows selected.

Please help me to find the solution.
What should I do with my standby database?

Please...

Best regards,
Re: applied archived_log on standby database RAC [message #295579 is a reply to message #295313] Tue, 22 January 2008 15:42 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
Do you see anything in your alert logs?

What does the following show:

SQL> SELECT DESTINATION, ERROR FROM GV$ARCHIVE_DEST; 
Re: applied archived_log on standby database RAC [message #296155 is a reply to message #295313] Thu, 24 January 2008 21:46 Go to previous messageGo to next message
ms_mdr
Messages: 8
Registered: January 2008
Junior Member
Sir,

I've run the query from my primary database.
I send you the result of the query.

Is there something wrong?
I'm sorry for the question.. I'm really new in oracle.

Thank you.
Re: applied archived_log on standby database RAC [message #296328 is a reply to message #296155] Fri, 25 January 2008 16:22 Go to previous message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
And what if anything was in your alert logs?

How did the standby get created?
Have the archive logs ever gotten applied at the standby?
Previous Topic: Interesting Problem
Next Topic: Not able to apply the archivelog file in DR-site
Goto Forum:
  


Current Time: Thu Mar 28 14:19:40 CDT 2024