Oracle12c多租户数据库备份与恢复 - 备份CDB和下面的所有PDBs

最新推荐文章于 2025-07-11 16:25:53 发布

转载最新推荐文章于 2025-07-11 16:25:53 发布 · 143 阅读

Oracle 12.1.0 , 多租户数据库

[oracle@nkgttv2024rhl tmp]$ sqlplus / as sysdba
SQL> show con_name

CON_NAME
------------------------------
CDB$ROOT
SQL>
SQL> show pdbs

    CON_ID CON_NAME                       OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
         2 PDB$SEED                       READ ONLY NO
         3 PLUGDB                         READ WRITE NO
         4 CONT01_PLUG01                  MOUNTED
         5 MYPDB1                         READ WRITE NO
SQL>
SQL> exit

---- 备份CDB和下面的所有PDBs (整个数据库)

syntax : backup database

范例：
$RMAN target /
RMAN>
run {
     allocate channel c1 type disk ;
     allocate channel c2 type disk ;
     allocate channel c3 type disk ;
      crosscheck archivelog all ;
      backup as compressed backupset database plus archivelog format '/data01/tmp/fullbak/db_full_%U_%p_%T_%s.bak';
      backup current controlfile format '/data01/tmp/fullbak/contorlfile_%T_%U_%s.ctlbak';
     release channel c1;
     release channel c2;
     release channel c3;
}