备份_12c

连接到CDB中的根容器
rman target=/

连接到指定容器
rman [email protected]

容器数据库（CDB）备份
rman target=/
BACKUP DATABASE PLUS ARCHIVELOG;


根容器备份
rman target=/
BACKUP DATABASE ROOT;

可插拔数据库（PDB）备份
rman target=/
BACKUP PLUGGABLE DATABASE pdb1, pdb2;

连接到特定的PDB
rman [email protected]
BACKUP DATABASE;

表空间和数据文件备份
rman [email protected]
BACKUP TABLESPACE system, sysaux, users;

rman [email protected]
BACKUP TABLESPACE pdb1:system, pdb1:sysaux, pdb1:users, pdb2:system;

日志备份
rman target=/
BACKUP ARCHIVELOG ALL;

容器数据库（CDB）完全恢复
RUN {
SHUTDOWN IMMEDIATE;
STARTUP MOUNT;
RESTORE DATABASE;
RECOVER DATABASE;
ALTER DATABASE OPEN;
}


根容器完全恢复
rman target=/
RUN {
SHUTDOWN IMMEDIATE;
STARTUP MOUNT;
RESTORE DATABASE ROOT;
RECOVER DATABASE ROOT;
ALTER DATABASE OPEN;
}


可插拔数据库（PDB）完全恢复
rman target=/
RUN {
ALTER PLUGGABLE DATABASE pdb1, pdb2 CLOSE;
RESTORE PLUGGABLE DATABASE pdb1, pdb2;
RECOVER PLUGGABLE DATABASE pdb1, pdb2;
ALTER PLUGGABLE DATABASE pdb1, pdb2 OPEN;
}


表空间和数据文件完全恢复
rman [email protected]
RUN {
ALTER TABLESPACE users OFFLINE;
RESTORE TABLESPACE users;
RECOVER TABLESPACE users;
ALTER TABLESPACE users ONLINE;
}

也可以这样恢复

RUN {
ALTER DATABASE DATAFILE 12 OFFLINE;
RESTORE DATAFILE 12;
RECOVER DATAFILE 12;
ALTER DATABASE DATAFILE 12 ONLINE;
}