Re: How to make Standby DB to be consistent with Primary db again?

On 25 May 2005 19:55:12 -0700, cnwy_at_263.net (yoke wang) wrote:

>> As you are missing archivelogs on the primary, rebuilding using rman
>> or any other hot backup mechanism is the only option you have.
> You mean I can do hot backup for each tablespace and copy the datafile to standby?
> Alter tablespace xxx begin backup;
> cp xx.dbf to standby
> Alter tablespace xxx end backup;
> Is that all I must do?
>
>wy.

No.
You'll need to make a hot backup of your complete primary database, and create a *new* standby database from that hot backup!

--
Sybrand Bakker, Senior Oracle DBA