Restore to a new host with an autobackup of the controlfile(Step-by-Step)
635728Apr 29 2008 — edited May 2 2008I'm the greenest of greenhorns when it comes to Oracle servers, so I'll be needing very detailed assistance on this. I've tried working with the documentation, but haven't had much luck at all. I'm working through backup/recovery scenarios with a test server and cannot figure out restoring to a new host.
In order to backup the database, I'm simply running
RMAN> backup database;
My RMAN configuration parameters are as follows:
RMAN> show all;
RMAN configuration parameters are:
CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # default
CONFIGURE BACKUP OPTIMIZATION OFF; # default
CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default
CONFIGURE CONTROLFILE AUTOBACKUP ON;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default
CONFIGURE DEVICE TYPE DISK PARALLELISM 1; # default
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE MAXSETSIZE TO UNLIMITED; # default
CONFIGURE SNAPSHOT CONTROLFILE NAME TO 'C:\ORACLE\ORA92\DATABASE\SNCFCSDS.ORA';
# default
Anyway, this creates two files in my C:\oracle\ora92\database directory. They are listed below.
06JF14BO_1_1
C-2023346244-20080429-00
I transfer these files over to my test server from the development server and drop them in the same location as the development server. It is at this point that I get extremely confused. Do I need a database created to restore my backup to? How do I know what to connect to with RMAN. How do I point it to the controlfile? Could someone please help me work through this? Let me know if you need any more information and I will get it ASAP.
Thanks.