Re: standby db

From: Volker Hetzer <volker.hetzer_at_ieee.org>
Date: Wed, 16 Feb 2005 14:16:00 +0100
Message-ID: <cuvh2g$866$1@nntp.fujitsu-siemens.com>

<nitin_kaul_at_rediffmail.com> schrieb im Newsbeitrag news:1108525136.321693.61360_at_z14g2000cwz.googlegroups.com...
> 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..

Why don't you use rman and back up without taking the db down?

Lots of Greetings!
Volker Received on Wed Feb 16 2005 - 07:16:00 CST