Os mesmos comandos emitidos para um backup de banco “Non-CDB” são aplicáveis para um banco do tipo CDB. Quando esta operação de backup full é realizada no root container, tanto o root quantos todos os PDBs serão contemplados. Caso seja necessário alterar o archivelog mode do banco, o processo é exatamente o mesmo da arquitetura antiga. Por fim, também conseguimos checar todos os parâmetros do RMAN através do comando SHOW ALL. Neste artigo, vamos praticar a execução de um backup em arquitetura multitenant, considerando esses pormenores técnicos citados.
Avaliando o atual CDB$ROOT e seus PDBs:
[oracle@quiasma ~]$ sqlplus / as sysdba
SQL*Plus: Release 18.0.0.0.0 - Production on Tue May 11 04:02:16 2021
Version 18.13.0.0.0
Copyright (c) 1982, 2018, Oracle. All rights reserved.
Connected to:
Oracle Database 18c Enterprise Edition Release 18.0.0.0.0 - Production
Version 18.13.0.0.0
SQL> SELECT NAME,LOG_MODE,CDB FROM V$DATABASE;
NAME LOG_MODE CDB
--------- ------------ ---
TALAMO ARCHIVELOG YES
SQL> SELECT NAME FROM V$PDBS;
NAME
--------------------------------------------------------------------------------
PDB$SEED
HIPOFISE1
Avaliando os parâmetros persistentes do RMAN:
[oracle@quiasma ~]$ rman target /
Recovery Manager: Release 18.0.0.0.0 - Production on Tue May 11 04:07:37 2021
Version 18.13.0.0.0
Copyright (c) 1982, 2018, Oracle and/or its affiliates. All rights reserved.
connected to target database: TALAMO (DBID=2194831545)
RMAN> SHOW ALL;
using target database control file instead of recovery catalog
RMAN configuration parameters for database with db_unique_name TALAMO are:
CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # default
CONFIGURE BACKUP OPTIMIZATION OFF; # default
CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default
CONFIGURE CONTROLFILE AUTOBACKUP ON; # default
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default
CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO BACKUPSET; # default
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE MAXSETSIZE TO UNLIMITED; # default
CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
CONFIGURE COMPRESSION ALGORITHM 'BASIC' AS OF RELEASE 'DEFAULT' OPTIMIZE FOR LOAD TRUE ; # default
CONFIGURE RMAN OUTPUT TO KEEP FOR 7 DAYS; # default
CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/oracle/18.0.0/product/dbs/snapcf_TALAMO.f'; # default
Avaliando o destino dos backups na FRA, vemos que é necessário aumentar o seu tamanho limite para evitar problemas de espaço durante o backup:
SQL> SHOW PARAMETER DB_RECOVERY_FILE_DEST;
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
db_recovery_file_dest string /oracle/fra
db_recovery_file_dest_size big integer 1G
SQL> ALTER SYSTEM SET db_recovery_file_dest_size=5G;
System altered.
SQL> SHOW PARAMETER DB_RECOVERY_FILE_DEST;
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
db_recovery_file_dest string /oracle/fra
db_recovery_file_dest_size big integer 5G
Como nos parâmetros do RMAN já está considerando o autobackup do control file, vamos emitir o comando de backup abaixo, que fará o backup do CDB$ROOT e todos os seus PDBs. Como os archives também serão contemplados, e o backup está sendo emitido com o banco no ar, o mesmo deve estar em archivelog mode:
RMAN> BACKUP DATABASE PLUS ARCHIVELOG;
Starting backup at 11-MAY-21
current log archived
using channel ORA_DISK_1
channel ORA_DISK_1: starting archived log backup set
channel ORA_DISK_1: specifying archived log(s) in backup set
input archived log thread=1 sequence=43 RECID=40 STAMP=1072239246
channel ORA_DISK_1: starting piece 1 at 11-MAY-21
channel ORA_DISK_1: finished piece 1 at 11-MAY-21
piece handle=/oracle/fra/TALAMO/backupset/2021_05_11/o1_mf_annnn_TAG20210511T041406_j9ncoy9j_.bkp tag=TAG20210511T041406 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01
Finished backup at 11-MAY-21
Starting backup at 11-MAY-21
using channel ORA_DISK_1
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00001 name=/oracle/dados/TALAMO/datafile/o1_mf_system_j3w17w26_.dbf
input datafile file number=00003 name=/oracle/dados/TALAMO/datafile/o1_mf_sysaux_j3w1bkdm_.dbf
input datafile file number=00004 name=/oracle/dados/TALAMO/datafile/o1_mf_undotbs1_j3w1cyoh_.dbf
input datafile file number=00007 name=/oracle/dados/TALAMO/datafile/o1_mf_users_j3w1czy4_.dbf
channel ORA_DISK_1: starting piece 1 at 11-MAY-21
channel ORA_DISK_1: finished piece 1 at 11-MAY-21
piece handle=/oracle/fra/TALAMO/backupset/2021_05_11/o1_mf_nnndf_TAG20210511T041407_j9ncozj1_.bkp tag=TAG20210511T041407 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:15
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00085 name=/oracle/dados/TALAMO/BFC37CDFCB3A0CF9E0536A00A8C0C9C5/datafile/o1_mf_system_j781yvm6_.dbf
input datafile file number=00086 name=/oracle/dados/TALAMO/BFC37CDFCB3A0CF9E0536A00A8C0C9C5/datafile/o1_mf_sysaux_j781yvmc_.dbf
input datafile file number=00087 name=/oracle/dados/TALAMO/BFC37CDFCB3A0CF9E0536A00A8C0C9C5/datafile/o1_mf_undotbs1_j781yvmc_.dbf
input datafile file number=00088 name=/oracle/dados/TALAMO/BFC37CDFCB3A0CF9E0536A00A8C0C9C5/datafile/o1_mf_users_j7824z91_.dbf
channel ORA_DISK_1: starting piece 1 at 11-MAY-21
channel ORA_DISK_1: finished piece 1 at 11-MAY-21
piece handle=/oracle/fra/TALAMO/BFC37CDFCB3A0CF9E0536A00A8C0C9C5/backupset/2021_05_11/o1_mf_nnndf_TAG20210511T041407_j9ncpgmk_.bkp tag=TAG20210511T041407 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:07
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00005 name=/oracle/dados/TALAMO/datafile/o1_mf_system_j3w1q776_.dbf
input datafile file number=00006 name=/oracle/dados/TALAMO/datafile/o1_mf_sysaux_j3w1q76z_.dbf
input datafile file number=00008 name=/oracle/dados/TALAMO/datafile/o1_mf_undotbs1_j3w1q779_.dbf
channel ORA_DISK_1: starting piece 1 at 11-MAY-21
channel ORA_DISK_1: finished piece 1 at 11-MAY-21
piece handle=/oracle/fra/TALAMO/BC8B772AA6A82204E0536B00A8C0CF6B/backupset/2021_05_11/o1_mf_nnndf_TAG20210511T041407_j9ncpoqs_.bkp tag=TAG20210511T041407 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:07
Finished backup at 11-MAY-21
Starting backup at 11-MAY-21
current log archived
using channel ORA_DISK_1
channel ORA_DISK_1: starting archived log backup set
channel ORA_DISK_1: specifying archived log(s) in backup set
input archived log thread=1 sequence=44 RECID=41 STAMP=1072239276
channel ORA_DISK_1: starting piece 1 at 11-MAY-21
channel ORA_DISK_1: finished piece 1 at 11-MAY-21
piece handle=/oracle/fra/TALAMO/backupset/2021_05_11/o1_mf_annnn_TAG20210511T041436_j9ncpwyt_.bkp tag=TAG20210511T041436 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01
Finished backup at 11-MAY-21
Starting Control File and SPFILE Autobackup at 11-MAY-21
piece handle=/oracle/fra/TALAMO/autobackup/2021_05_11/o1_mf_s_1072239278_j9ncpy9s_.bkp comment=NONE
Finished Control File and SPFILE Autobackup at 11-MAY-21
Listando os backups:
RMAN> LIST BACKUP;
List of Backup Sets
===================
BS Key Size Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
49 167.44M DISK 00:00:00 11-MAY-21
BP Key: 49 Status: AVAILABLE Compressed: NO Tag: TAG20210511T041406
Piece Name: /oracle/fra/TALAMO/backupset/2021_05_11/o1_mf_annnn_TAG20210511T041406_j9ncoy9j_.bkp
List of Archived Logs in backup set 49
Thrd Seq Low SCN Low Time Next SCN Next Time
---- ------- ---------- --------- ---------- ---------
1 43 3639906 08-MAY-21 3709681 11-MAY-21
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
50 Full 1.42G DISK 00:00:08 11-MAY-21
BP Key: 50 Status: AVAILABLE Compressed: NO Tag: TAG20210511T041407
Piece Name: /oracle/fra/TALAMO/backupset/2021_05_11/o1_mf_nnndf_TAG20210511T041407_j9ncozj1_.bkp
List of Datafiles in backup set 50
File LV Type Ckp SCN Ckp Time Abs Fuz SCN Sparse Name
---- -- ---- ---------- --------- ----------- ------ ----
1 Full 3709696 11-MAY-21 NO /oracle/dados/TALAMO/datafile/o1_mf_system_j3w17w26_.dbf
3 Full 3709696 11-MAY-21 NO /oracle/dados/TALAMO/datafile/o1_mf_sysaux_j3w1bkdm_.dbf
4 Full 3709696 11-MAY-21 NO /oracle/dados/TALAMO/datafile/o1_mf_undotbs1_j3w1cyoh_.dbf
7 Full 3709696 11-MAY-21 NO /oracle/dados/TALAMO/datafile/o1_mf_users_j3w1czy4_.dbf
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
51 Full 667.92M DISK 00:00:04 11-MAY-21
BP Key: 51 Status: AVAILABLE Compressed: NO Tag: TAG20210511T041407
Piece Name: /oracle/fra/TALAMO/BFC37CDFCB3A0CF9E0536A00A8C0C9C5/backupset/2021_05_11/o1_mf_nnndf_TAG20210511T041407_j9ncpgmk_.bkp
List of Datafiles in backup set 51
Container ID: 3, PDB Name: HIPOFISE1
File LV Type Ckp SCN Ckp Time Abs Fuz SCN Sparse Name
---- -- ---- ---------- --------- ----------- ------ ----
85 Full 3709702 11-MAY-21 NO /oracle/dados/TALAMO/BFC37CDFCB3A0CF9E0536A00A8C0C9C5/datafile/o1_mf_system_j781yvm6_.dbf
86 Full 3709702 11-MAY-21 NO /oracle/dados/TALAMO/BFC37CDFCB3A0CF9E0536A00A8C0C9C5/datafile/o1_mf_sysaux_j781yvmc_.dbf
87 Full 3709702 11-MAY-21 NO /oracle/dados/TALAMO/BFC37CDFCB3A0CF9E0536A00A8C0C9C5/datafile/o1_mf_undotbs1_j781yvmc_.dbf
88 Full 3709702 11-MAY-21 NO /oracle/dados/TALAMO/BFC37CDFCB3A0CF9E0536A00A8C0C9C5/datafile/o1_mf_users_j7824z91_.dbf
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
52 Full 713.02M DISK 00:00:05 11-MAY-21
BP Key: 52 Status: AVAILABLE Compressed: NO Tag: TAG20210511T041407
Piece Name: /oracle/fra/TALAMO/BC8B772AA6A82204E0536B00A8C0CF6B/backupset/2021_05_11/o1_mf_nnndf_TAG20210511T041407_j9ncpoqs_.bkp
List of Datafiles in backup set 52
Container ID: 2, PDB Name: PDB$SEED
File LV Type Ckp SCN Ckp Time Abs Fuz SCN Sparse Name
---- -- ---- ---------- --------- ----------- ------ ----
5 Full 3007123 30-MAR-21 NO /oracle/dados/TALAMO/datafile/o1_mf_system_j3w1q776_.dbf
6 Full 3007123 30-MAR-21 NO /oracle/dados/TALAMO/datafile/o1_mf_sysaux_j3w1q76z_.dbf
8 Full 3007123 30-MAR-21 NO /oracle/dados/TALAMO/datafile/o1_mf_undotbs1_j3w1q779_.dbf
BS Key Size Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
53 10.50K DISK 00:00:00 11-MAY-21
BP Key: 53 Status: AVAILABLE Compressed: NO Tag: TAG20210511T041436
Piece Name: /oracle/fra/TALAMO/backupset/2021_05_11/o1_mf_annnn_TAG20210511T041436_j9ncpwyt_.bkp
List of Archived Logs in backup set 53
Thrd Seq Low SCN Low Time Next SCN Next Time
---- ------- ---------- --------- ---------- ---------
1 44 3709681 11-MAY-21 3709717 11-MAY-21
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
54 Full 17.95M DISK 00:00:00 11-MAY-21
BP Key: 54 Status: AVAILABLE Compressed: NO Tag: TAG20210511T041438
Piece Name: /oracle/fra/TALAMO/autobackup/2021_05_11/o1_mf_s_1072239278_j9ncpy9s_.bkp
SPFILE Included: Modification time: 11-MAY-21
SPFILE db_unique_name: TALAMO
Control File Included: Ckp SCN: 3709733 Ckp time: 11-MAY-21
Percebemos que o Backup Set número 52 reporta que até o PDB$SEED foi considerado no backup (é possível identificar isso pelo GUID que é usado no nome do backup piece):
SQL> SELECT NAME,GUID FROM V$PDBS;
NAME
--------------------------------------------------------------------------------
GUID
--------------------------------
PDB$SEED
BC8B772AA6A82204E0536B00A8C0CF6B
HIPOFISE1
BFC37CDFCB3A0CF9E0536A00A8C0C9C5
Obs: Este procedimento foi criado pelo senhor Ahmed Baraka (www.ahmedbaraka.com) e foi apenas reproduzido por mim em um laboratório pessoal para fins de aprendizado.
Portuguese
English
Spanish