This content has been marked as final. Show 6 replies
Assuming you have this set :
You only need to move the backup files.
RMAN>CONFIGURE CONTROLFILE AUTOBACKUP ON;
The restore you are speaking of is kind of an SCN Roll forward. Is that what you want to do or do you want to replace the whole database?
I have a similar example which may help :
Levi makes a great point. This is a very good habit and will probably save your bacon at some point.
I would do both :
CONFIGURE CONTROLFILE AUTOBACKUP ON;
h3. Thanks Levi!
RMAN> backup full as compressed backupset database include current controlfile plus archivelog delete input;
Yes I have my production Oracle database server to auto backup the control file:
So basically I need to move then which files over to the new server. The new server has Oracle 11g R2 installed but I've installed the database software only. I did not run DBCA utility to create the backup systems 1st database / schema. My other question is with that being said, do I need to run DBCA if I'm going to restore this machine from a backup from my production server?
RMAN> show all; using target database control file instead of recovery catalog RMAN configuration parameters for database with db_unique_name ORCL are: CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # default CONFIGURE BACKUP OPTIMIZATION OFF; # default CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default CONFIGURE CONTROLFILE AUTOBACKUP ON;
You do not have to run DBCA. You just need to restore the backup of the Production on to the new server.
Since you are on 11g, refer this http://shivanandarao.wordpress.com/2012/04/28/duplicating-database-without-connecting-to-target-database-or-catalog-database-in-oracle-11g/
Referring to the above link, you get in a new database on the new server with the desired name that you look out for.
You can also refer this http://shivanandarao.wordpress.com/2012/04/19/duplicating-primary-database-to-a-new-host-without-connecting-to-the-primary-database-in-oracle-10g11g/ but here, you need to set the DBID of the Production database, and once the restoration and recovery is done, you'll have to change the name of the database to the desired name using NID utility.
No to DBCA.
Notice in the notes I provided the create directory for the database. That example allows you to "clone" without a catalog ( handy ) and should handle everything for you.
If there's any part of the example you don't understand go ahead and ask as it is all fresh in my head.