Re: Backup planning experience

From: Howard J. Rogers <howardjr_at_www.com>
Date: Tue, 13 Feb 2001 10:05:41 +1100
Message-ID: <z5_h6.168$305.61879@inet16.us.oracle.com>

"J. Bavendiek" <johannesbavendiek_at_my-deja.com> wrote in message news:968vsh$5j4$1_at_nnrp1.deja.com...
[Snip]
>
>
> Imagine using offline backup.
> What about the badest situation (all disks lost)?
> When I have to restore the whole database from backup media
> AND I have to use a backup controlfile.
> Can I recover forward from a offline backup using backup controlfile?

Yes, provided you have all necessary redo. The command is 'recover database using backup controlfile' -and the 'using backup controlfile' keywords instruct Oracle to ignore the Control File as the source of the SCN to which the database should be synchronised.

It gets tricky, especially if you've restored all your datafiles to new (ie, different) locations on the replacement disks, but it can be done.

> Or does Oracle finish recovery with the (consistent) SCN in all
> datafiles???
> cu
> Johannes
> --
> *** "First think and than do and do not forget ***
> *** each of them", the old, wise man said. ***
>
>
> Sent via Deja.com
> http://www.deja.com/
Received on Mon Feb 12 2001 - 17:05:41 CST