How to import a Oracle 11g RMAN backupset on a new database server?

I never used this tool, but I google a few minutes any maybe this will help you.

I never used this tool, but I google a few minutes any maybe this will help you... Direct Link: RMAP Import Here is the script I use to restore the database from the backup, (I always clean up the database before restoring it. ) * Startup nomout; * Set dbid xxxxxxxx // This is the dbid of your database * Run { Set controlfile autobackup format for device type disk to ''; // e.g. '/ora101/oradata/TAR/%F' Restore controlfile from autobackup; } * Alter database mount; // can't restore without the database mounted * Restore database; // can't run recover without first restore * Recover database; // if the backup was from incremental, RMAN will try to apply all the logfiles generated after the backup was started. * Alter database open resetlogs; // EDIT: Here is another link from the OraFaq.

OK, with your help I finally found out that to restore a backupset one has to restore the controlfile and then the backupset is known automagically if it uses the same file location as used during backup on the original machine. Unfortunately I still get errors as the datafiles on the original machine were stored using ASM which is not available on the new server but I guess this should be posted as a separate question. – blerontin Nov 18 '10 at 10:51.

One other method to use is to restore the control file(s) from a backup. Startup no mount; run { allocate channel device type disk; restore from '/u01/......'; } At this point I would shutdown and startup mount. (Make sure the pfile/spfile have the correct entries for the controlfile names and location) once in mount mode enter the command catalog start with '/u01/.....' (The controlfile backup should be a good place to start) You will be asked if you want to add the information from the file.

Also this can be repeated for any backuppiece you have. Now if you do a list backups you should see all the items from you orignal rman backup and then start the process of restoring/recovering the database. Disclaimer: The commands are taken from memory so the syntax might not be 100% correct but a quick google of it should put you on the right track.

EDIT: To get the datafiles to be renamed you migh find this command useful. It puts data files into ASM but you should be able to go the other way by replacing the +DATA with the correct datafile name and location run { set newname for datafile 1 to "+DATA"; set newname for datafile 2 to "+DATA"; set newname for datafile 3 to "+DATA"; set newname for datafile 4 to "+DATA"; set newname for datafile 5 to "+DATA"; restore database; switch datafile all; recover database }.

I cant really gove you an answer,but what I can give you is a way to a solution, that is you have to find the anglde that you relate to or peaks your interest. A good paper is one that people get drawn into because it reaches them ln some way.As for me WW11 to me, I think of the holocaust and the effect it had on the survivors, their families and those who stood by and did nothing until it was too late.