Re: standby db

nitin_kaul_at_rediffmail.com wrote:
> hi
> I work on oracle 9.2.0.1.0...win2k
>
> i take cold backup of physical standby(datagaurd) not primary ...coz
> cant have enough downtime....so instead of taking backup of primary
is
> it ok if i backup stanby db..or is there any need to backup the
primary
> control file.... the datafile location on primary is same as
standby..
>
> we work on archivelog mode...so we have archive files...only 1
month..
>
> In case of any crash..let it be a disk or just a datafile
> corruption...can i restore it from stanby and if required apply
archive
> to recover it if the cold backup was taken 1 week back....will there
be
> any inconsistency..

If you do it right...
http://metalink.oracle.com/metalink/plsql/ml2_documents.showFrameDocument?p_database_id=NOT&p_id=211734.1

http://metalink.oracle.com/metalink/plsql/ml2_documents.showFrameDocument?p_database_id=NOT&p_id=290817.1

http://metalink.oracle.com/metalink/plsql/ml2_documents.showFrameDocument?p_database_id=NOT&p_id=203980.1  etc.

jg

--
@home.com is bogus.
http://automobilemag.com/reviews/coupes/0502_chevrolet_corvette_z06/