Re: Restore from Hot Backup Question

Comments below
"Gary Luck" <klokwerks_at_yahoo.com> wrote in message news:1b60dac2.0201160552.2549a713_at_posting.google.com...
> On testing disaster recovery, I format the box and then rebuild the
> RAIDs, install NT and Oracle. The reason I'm running 7.3.4 is that
> Oracle is wrapped in an Agilent proprietary app called Chemstore.
> When I run the Chemstor install, it also runs a canned perl script
> that creates the DB instance. After that has been completed, I
> shutdown the database instance that was just created and stop all
> oracle services.
>
> When I restore, I simply copy all of the datafiles, binary
> controlfile, init file and archive logs dated after the date of the
> hot backup.
>
> I have tried to restore with simply my hot backup in this fashion and
> I have a few questions:
>
> Like I said, I have two controlfiles on separate disks for safety.
> When my backup script executes 'alter database backup controlfile
> 'backup dir' reuse;' it backs up a binary copy of the first
> controlfile. After I restore, I start the DB in 'startup mount' and
> it complains that the second controlfile isn't there. Can I simply
> copy the controlfile into the second location and rename it
> 'controlfile2' and then open the DB in mount, or should I edit my init
> file before I open the DB to reflect only one controlfile and then
> after recovery is done, create a second controlfile in sql?
Yes you can just copy and rename.
>

<snip>
Could anyone give me a definitive procedure to restore from a hot
> backup?
>

I suggest you read

http://www.hjrdba.com/books.htm

which is excellent and clear.

--
Niall Litchfield
Oracle DBA
Audit Commission UK
*****************************************
Please include version and platform
and SQL where applicable
It makes life easier and increases the
likelihood of a good answer

******************************************