Re: Restore from Hot Backup Question

Gary,

Remember you need to restore the archive logs generated from the point in time that the first database file got backed-up -- to recover the database you must have all the redo going back to the first transaction that occurred after you did the ALTER TABLESPACE <> BEGIN BACKUP.

You should not need to run the Chemstore script to create the Database -- you will be restoring the entire database. However, since this is WinNT, you will need to create the service to startup the instance, using ORADMIN.

You can restore the binary backup of the controlfile (I hope it was generated with an ALTER DATABASE BACKUP CONTROLFILE TO <filename>) to both the locations specified by the init.ora parameter control_files= OR You can restore only one copy and edit the init.ora parameter before you mount the database. Both options are OK. [note if doing a non-DR recovery where you do still have the current controlfiles present on disk, you do not need to restore the backup controlfile].

As you are doing a DR recovery and do not have the current redo logs of the database you are recovering, you do not need any redo logs present on disk. You will be doing a RECOVER DATABASE UNTIL CANCEL USING BACKUP CONTROLFILE. You will then be doing an ALTER DATABASE OPEN RESETLOGS which command will create the required online redo log files for you.

Hemant K Chitale

"Gary Luck" <klokwerks_at_yahoo.com> wrote in message news:1b60dac2.0201160552.2549a713_at_posting.google.com...
> I'm running Oracle 7.3.4 on NT4.0SP6a(I have to run this
> configuration). I have a 15GB database with two controlfiles on
> separate disks and the DB is running in archive mode. I have written
> the standard sql script for hot backups every night to set each
> tablespace into backup mode and file copy the datafiles. I also get a
> binary and trace of the controlfile, the trace dump directory, the
> init and password files and the archive logs.
>
> 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?
>
> Also, since I was restoring over the newer install, the online
> redologs are ofcourse not consistent with the restored DB. Should I
> delete these new redologs before I start the DB in mount?
>
> Am I doing this wrong? Should I just rebuild my controlfile from
> trace?
>
> Could anyone give me a definitive procedure to restore from a hot
> backup?
>
> Any help is greatly appreciated.
>
> Thanks in Advance, gary.
Received on Wed Jan 16 2002 - 08:43:08 CST