#### 備份全庫
``` 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

【RMAN】Oracle12c以後rman 備份恢復命令參考

相關文章