Home » Server Options » Data Guard » archived log files not applied to standby (9i R2, Linux)
archived log files not applied to standby [message #335502] Tue, 22 July 2008 06:20 Go to next message
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
      
       172 YES
       173 YES
       174 YES
       175 YES
       176 YES
       177 YES
       178 YES
       179 YES
       180 YES
       181 YES
       182 YES



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
Re: archived log files not applied to standby [message #335685 is a reply to message #335502] Wed, 23 July 2008 05:13 Go to previous message
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
Previous Topic: Logical Standby Database
Next Topic: Physical Standby Database problems
Goto Forum:
  


Current Time: Sun Dec 04 06:30:02 CST 2016

Total time taken to generate the page: 0.04237 seconds