Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Restore to a new host with an autobackup of the controlfile(Step-by-Step)

635728Apr 29 2008 — edited May 2 2008
I'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.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 30 2008
Added on Apr 29 2008
19 comments
2,681 views