OraFAQ Forum: Data Guard » applied archived

Home » Server Options » Data Guard » applied archived_log on standby database RAC (Oracle 10g, 10.2.0, linux x86_64)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

applied archived_log on standby database RAC [message #295313]

Tue, 22 January 2008 02:00

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,

Report message to a moderator

Re: applied archived_log on standby database RAC [message #295579 is a reply to message #295313]

Tue, 22 January 2008 15:42

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;

Report message to a moderator

Re: applied archived_log on standby database RAC [message #296155 is a reply to message #295313]

Thu, 24 January 2008 21:46

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.

Attachment: SELECT DESTINATION ERROR FROM ARCHIVE_DEST.bmp
(Size: 317.74KB, Downloaded 2170 times)

Report message to a moderator

Re: applied archived_log on standby database RAC [message #296328 is a reply to message #296155]

Fri, 25 January 2008 16:22

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?

Report message to a moderator

Previous Topic:	Interesting Problem
Next Topic:	Not able to apply the archivelog file in DR-site

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Oct 02 08:17:41 CDT 2025