Search code examples
oracleimportbackuporacle11grman

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


I have got a backupset of an Oracle 11g database which was created with RMAN. Now I want to import/restore the backupset onto a new and empty database server. I know that the command to create the backupset was

run {
  backup as compressed backupset database
  tag "FULLBACKUP"
  format "/orabackup/rman/backup/FULL_%d_%T_%U";
  backup as compressed backupset archivelog all
  tag "ARCHIVELOGS"
  format "/orabackup/rman/backup/ARCH_%d_%T_%U"
  delete all input;
}

but I cannot find out how to make the files produced by this command known to RMAN on my new database server and import the backupset using RESTORE/RECOVER.


Solution

  • 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.