Re: ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS

"Hemant K Chitale" <hkchital_nospam_at_singnet_nospam.com.sg> wrote in message news:capma7$12f$1_at_mawar.singnet.com.sg...
>
> HJR,
>
> You write
> "The making of a physical alteration to your
> : primary database renders your standby database invalid, such that it
needs
> : to be re-created from scratch (one of the major pains-in-the-butt
> regarding
> : standby databases since time immemorial).
> "
>
> The only changes that would actually require rebuilding the Standby would
> be a RESETLOGS or a CLEAR LOG on the primary.
>
> Surely, Oracle provides a mechanism to add the new file into the Standby
as
> well ...
> ALTER DATABASE CREATE DATAFILE ' ...' AS '...' ;
> so that Recovery can proceed.
> That is why I do in my 8.1.7 database where I have a Standby.
>
> 9i DataGuard uses the "STANDBY_FILE_MANAGEMENT=AUTO" parameter
> but I haven't used 9iDG.
> And I don't have the 8.1.7 documentation to quote from it as to how to use
> ALTER DATABASE CREATE DATAFILE and continue recovery.
>
> Hemant

Please read the rest of the thread.

HJR Received on Wed Jun 16 2004 - 15:29:59 CDT