Re: How to recover datafile from a previous hot backup after the master database had a media crash

Peter,

What you want to do is called a "Complete Recovery".

Please refer to Chapter 3: "Performing User-Managed Restore Operations" of the Oracle 9.2 "User-Managed Backup and Recovery Guide (A96572-01)".

The procedure is explained there. There is an online version of this manual at http://www.oracle.com/technology/documentation/oracle9i.html

Douglas Hawthorne

<huskeyPeter_at_yahoo.com> wrote in message news:1102493779.506125.167330_at_c13g2000cwb.googlegroups.com...
> Hi all,
>
> I just build a new database succesfully at another server from my
> production database using hot backup techniques.
>
> If the production database has a media crash on one of the datafile
> before a new hot backup is taken again. And assume there is still some
> good copy of achived logs and redo logs at production server due to the
> multiplexing to different disk driver. How can I apply those new redo
> logs and achived logs to the hot backup server and make it become the
> new production server without losing any data?
> Any help is greatly appreciated.
>
> Thanks.
>
> Peter
>
Received on Wed Dec 08 2004 - 04:23:19 CST