Backup e Restore PDB
Assicurarsi che i pdb sono up e running
SQL> show pdbsCON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
2 PDB$SEED READ ONLY NO
3 ORCLPDB READ WRITE NO
[oracle@test ~]$ rman target =/
Recovery Manager: Release 18.0.0.0.0 - Production on Mon Dec 7 16:36:29 2020
Version 18.3.0.0.0
Copyright (c) 1982, 2018, Oracle and/or its affiliates. All rights reserved.
connected to target database: ORCL (DBID=1577757327)
Backup del pdb + archivelog
RMAN> backup database orclpdb plus archivelog;
Verifiche post backup.
RMAN> list backup of database orclpdb;
List of Backup Sets
===================
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
5 Full 776.48M DISK 00:00:09 07-DEC-20
BP Key: 5 Status: AVAILABLE Compressed: NO Tag: TAG20201207T143425
Piece Name: /u01/app/oracle/fast_recovery_area/ORCL/AE3ED9EC84541FB8E053C58E670AB441/backupset/2020_12_07/o1_mf_nnndf_TAG20201207T143425_hwwcvv28_.bkp
List of Datafiles in backup set 5
Container ID: 3, PDB Name: ORCLPDB
File LV Type Ckp SCN Ckp Time Abs Fuz SCN Sparse Name
---- -- ---- ---------- --------- ----------- ------ ----
9 Full 12882023 07-DEC-20 NO /u01/app/oracle/oradata/ORCL/orclpdb/system01.dbf
10 Full 12882023 07-DEC-20 NO /u01/app/oracle/oradata/ORCL/orclpdb/sysaux01.dbf
11 Full 12882023 07-DEC-20 NO /u01/app/oracle/oradata/ORCL/orclpdb/undotbs01.dbf
12 Full 12882023 07-DEC-20 NO /u01/app/oracle/oradata/ORCL/orclpdb/users01.dbf
84 Full 12882023 07-DEC-20 NO /u01/app/oracle/oradata/ORCL/orclpdb/users02.dbf
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
10 Full 775.77M DISK 00:00:05 07-DEC-20
BP Key: 10 Status: AVAILABLE Compressed: NO Tag: TAG20201207T163732
Piece Name: /u01/app/oracle/fast_recovery_area/ORCL/AE3ED9EC84541FB8E053C58E670AB441/backupset/2020_12_07/o1_mf_nnndf_TAG20201207T163732_hwwm1wj4_.bkp
List of Datafiles in backup set 10
Container ID: 3, PDB Name: ORCLPDB
File LV Type Ckp SCN Ckp Time Abs Fuz SCN Sparse Name
---- -- ---- ---------- --------- ----------- ------ ----
9 Full 12889342 07-DEC-20 NO /u01/app/oracle/oradata/ORCL/orclpdb/system01.dbf
10 Full 12889342 07-DEC-20 NO /u01/app/oracle/oradata/ORCL/orclpdb/sysaux01.dbf
11 Full 12889342 07-DEC-20 NO /u01/app/oracle/oradata/ORCL/orclpdb/undotbs01.dbf
12 Full 12889342 07-DEC-20 NO /u01/app/oracle/oradata/ORCL/orclpdb/users01.dbf
84 Full 12889342 07-DEC-20 NO /u01/app/oracle/oradata/ORCL/orclpdb/users02.dbf
Esempio:
Cancelliamo il file system01 del pdb e stoppiamo il pdb
SQL> alter pluggable database orclpdb close;
Pluggable database altered.
SQL> show pdbs
CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
2 PDB$SEED READ ONLY NO
3 ORCLPDB MOUNTED
SQL> alter pluggable database orclpdb open;
alter pluggable database orclpdb open
*
ERROR at line 1:
ORA-65368: unable to open the pluggable database due to errors during recovery
ORA-01110: data file 9: '/u01/app/oracle/oradata/ORCL/orclpdb/system01.dbf'
ORA-01157: cannot identify/lock data file 9 - see DBWR trace file
ORA-01110: data file 9: '/u01/app/oracle/oradata/ORCL/orclpdb/system01.dbf'
ORA-01113: file 84 needs media recovery
ORA-01110: data file 84: '/u01/app/oracle/oradata/ORCL/orclpdb/users02.dbf'
RMAN> RUN
{
RESTORE PLUGGABLE DATABASE orclpdb;
RECOVER PLUGGABLE DATABASE orclpdb;
ALTER PLUGGABLE DATABASE orclpdb open;
}
Verifica:
SQL> show pdbs;
CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
2 PDB$SEED READ ONLY NO
3 ORCLPDB READ WRITE NO
