如何在新数据库服务器上导入Oracle 11g RMAN备份集？ [英] How to import a Oracle 11g RMAN backupset on a new database server?

问题描述

我有一个使用RMAN创建的Oracle 11g数据库的备份集。现在我想将备份集导入/恢复到新的空数据库服务器上。我知道创建备份集的命令是

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;
}

但是我无法知道如何通过此命令生成文件在我的新数据库服务器上使用RMAN并使用RESTORE / RECOVER导入备份集。

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.

推荐答案

我从未使用过此工具，但我谷歌了几分钟也许这对你有帮助...

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

直接链接： RMAP导入

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; 

//编辑：这是来自 OraFaq 。

// Here is another link from the OraFaq.

这篇关于如何在新数据库服务器上导入Oracle 11g RMAN备份集？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！