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

oracle import backup oracle11g rman
blerontin picture blerontin · Nov 18, 2010 · Viewed 17.9k times · Source

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.

Answer

Viper picture Viper · Nov 18, 2010

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.

Related questions

Oracle: Import CSV file

I've been searching for a while now but can't seem to find answers so here goes... I've got a CSV file that I want to import into a table in Oracle (9i/10i). Later on I plan to use this …

Read More
Migrate from Oracle to MySQL

We ran into serious performance problems with our Oracle database and we would like to try to migrate it to a MySQL-based database (either MySQL directly or, more preferably, Infobright). The thing is, we need to let the old and …

Read More
Importing selective data using impdp

I have an entire DB to be imported as a dump into my own. I want to exclude data out of certain tables(mostly because they are huge in size and not useful). I cannot entirely exclude those tables since …

Read More