【RMAN】Oracle12c以后rman 备份恢复命令参考

来源：这里教程网时间：2026-03-03 17:21:24 作者：

#### 备份全库
``` sql
run {
	allocate channel ch1 type disk;
	allocate channel ch2 type disk;
	alter system archive log current;
	alter system archive log current;
	backup format '/backup/mypdb_full_%T_%s_%p' database plus archivelog delete all input;
	backup format '/backup/mypdb_controlfile_%T_%s_%p' current controlfile;
	alter system archive log current;
	backup format '/backup/mypdb_arch_%Y%M%D_%s_%p' archivelog all;
	release channel ch1;
	release channel ch2;
}
```
#### 备份root/模板 pdb
``` sql
--root
run {
	allocate channel ch1 type disk;
	allocate channel ch2 type disk;
	alter system archive log current;
	alter system archive log current;
	backup format '/backup/root_full_%T_%s_%p' database root plus archivelog delete all input;
	backup format '/backup/pdbseed_full_%T_%s_%p' database 'PDB$SEED';
	backup format '/backup/root_controlfile_%T_%s_%p' current controlfile;
	alter system archive log current;
	backup format '/backup/root_arch_%Y%M%D_%s_%p' archivelog all;
	release channel ch1;
	release channel ch2;
}
--模板
backup format '/backup/pdbseed_full_%T_%s_%p' database 'PDB$SEED';
```
#### 恢复命令参考
``` sql
--恢复 cdb+pdbseed
restore controlfile from '/backup/mypdb_controlfile_20200215_52_1';
alter database mount;
run 
{
     restore database root;
     restore database 'pdb$seed';
	 switch database 'PDB$SEED' to copy;
	 switch database root to copy;
     recover database root;
     recover database 'pdb$seed';
 }

switch pluggable database BPMDB_PRD to copy;
--跳过pdb 数据库，open
alter session set container=mypdb;
select file#,name,status from v$datafile;
alter database datafile 9,10,11,12,13 offline;
--open
alter database open resetlogs;
```
#### 恢复某个pdb
``` sql
--恢复pdb
col pdb_name for a20
select pdb_name,status from dba_pdbs;
restore pluggable database mypdb;
recover pluggable database mypdb;
alter session set container=mypdb;
alter database datafile 9,10,11,12,13 online;
alter database open;
--or
alter session set container="CDB$ROOT";
alter pluggable database mypdb open;
alter database datafile 14,15,16,17,18 online;
--卸载，装载
ALTER PLUGGABLE DATABASE mypdb UNPLUG INTO '/home/oracle/mypdb.xml';
create pluggable database mypdb using '/home/oracle/mypdb.xml' nocopy tempfile reuse;
--不完全恢复需要指定AUXILIARY DESTINATION
run{
set until sequence 22;
recover database root AUXILIARY DESTINATION '/tmp';
}
```
#### 参考
- http://www.ohsdba.cn/index.php?m=Article&a=show&id=44