OraFAQ Forum: Data Guard » archived log files not applied to standby

Home » Server Options » Data Guard » archived log files not applied to standby (9i R2, Linux)

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

archived log files not applied to standby [message #335502]

Tue, 22 July 2008 06:20

sajut
Messages: 69
Registered: January 2007

Member

Dear All,

I just setup a test standby db for my development db server. The db and listener are running on both primary and standby. after a few logfile switches, when I tried this on Primary,

select sequence#, applied from v$archived_log where dest_id=2;

       172 NO
       173 YES
       174 YES
       175 NO
       176 NO
       177 NO
       178 NO
       179 YES
       180 YES
       181 NO
       182 YES

on standby

why it shows some sequences not applied on primary, and applied on standby? And on the standby db, in the archive log destination, the archived log files from 175 are not seen.
But, when I opened the standby in readonly mode, I could the data I last commited on the primary db.

How could this happen

Thanks in advance

Report message to a moderator

Re: archived log files not applied to standby [message #335685 is a reply to message #335502]

Wed, 23 July 2008 05:13

sajut
Messages: 69
Registered: January 2007

Member

Dear all

Found the problem myself. The parameter standby_archive_dest in the initstndby.ora of standby db was wrongly specified, becauase of which the archived log files from primary was moved to /opt/oracle/920/dbs directory. Modified to /data/archive/ directory, restarted and now it is working

Thanks
Saju

Report message to a moderator

Previous Topic:	Logical Standby Database
Next Topic:	Physical Standby Database problems

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Mar 12 01:33:57 CDT 2025