Re: 9i Standby Database startup after backup

Solution:
On the primary database issue the following sql after you've brought up the standby instance:
alter system archive log stop
/
alter system archive log start
/

This effectively stops the (ARC) process and restarts it and then the archive_dest to the standby instance is now valid again. Note that this does not affect you ARCHIVELOG mode, just the archiver process.

BTW, using the standby instance for Backup and Recovery purposes also works great, no need to go to tape if you've lost a datafile, just copy it over, perform recovery and walla. Also, manual switchover between the two works pretty good.

Hope this helps someone else in the future.

Thanks,
Pete's

empete2000_at_yahoo.com (Pete's) wrote in message news:<6724a51f.0210231059.7ba0eedb_at_posting.google.com>...
> Setup: 2 - IBM p660-6H1's running AIX 4.3.3 ml09, Oracle 9.0.1.3, a
> primary instance and a standby instance each on different machines.
> Dataguard is setup for 'Instant Protection' mode. When the Standby
> instance is started before the Primary, the archive destination to the
> standby is valid. However, if you shutdown the standby, back it up,
> then mount it as a standby, the archive_dest to the standby will not
> be valid, in fact will have a ora-1034 or ora-3113. I've found that
> the only way to get the path valid again is to bounce the primary
> instance. Does anyone know if this is the only way to get this valid
> again and have the logs transmit again?
>
> Thanks,
> Pete's
Received on Fri Oct 25 2002 - 09:16:59 CDT