Neste artigo vamos explorar 2 maneiras de realizar backups de PDBs na arquitetura Multitenant.<\/p>\n\n\n\n
Checando o nome do CDB$ROOT e do seu PDB no ambiente que usaremos de estudos:<\/p>\n\n\n
\n[oracle@quiasma TALAMO]$ sqlplus \/ as sysdba\n \nSQL*Plus: Release 18.0.0.0.0 - Production on Tue May 11 04:35:56 2021\nVersion 18.13.0.0.0\n \nCopyright (c) 1982, 2018, Oracle. All rights reserved.\n \n \nConnected to:\nOracle Database 18c Enterprise Edition Release 18.0.0.0.0 - Production\nVersion 18.13.0.0.0\n \nSQL> SELECT NAME,CDB FROM V$DATABASE;\n \nNAME CDB\n--------- ---\nTALAMO YES\n \nSQL> SELECT NAME FROM V$PDBS;\n \nNAME\n--------------------------------------------------------------------------------\nPDB$SEED\nHIPOFISE1\n<\/pre><\/div>\n\n\nA primeira maneira de realizar um backup do PDB seria atrav\u00e9s do CDB$ROOT, conforme exemplo abaixo:<\/p>\n\n\n
\n[oracle@quiasma TALAMO]$ rman target \/\n \nRecovery Manager: Release 18.0.0.0.0 - Production on Tue May 11 04:37:07 2021\nVersion 18.13.0.0.0\n \nCopyright (c) 1982, 2018, Oracle and\/or its affiliates. All rights reserved.\n \nconnected to target database: TALAMO (DBID=2194831545)\n \nRMAN> BACKUP PLUGGABLE DATABASE HIPOFISE1;\n \nStarting backup at 11-MAY-21\nusing target database control file instead of recovery catalog\nallocated channel: ORA_DISK_1\nchannel ORA_DISK_1: SID=106 device type=DISK\nchannel ORA_DISK_1: starting full datafile backup set\nchannel ORA_DISK_1: specifying datafile(s) in backup set\ninput datafile file number=00085 name=\/oracle\/dados\/TALAMO\/BFC37CDFCB3A0CF9E0536A00A8C0C9C5\/datafile\/o1_mf_system_j781yvm6_.dbf\ninput datafile file number=00086 name=\/oracle\/dados\/TALAMO\/BFC37CDFCB3A0CF9E0536A00A8C0C9C5\/datafile\/o1_mf_sysaux_j781yvmc_.dbf\ninput datafile file number=00087 name=\/oracle\/dados\/TALAMO\/BFC37CDFCB3A0CF9E0536A00A8C0C9C5\/datafile\/o1_mf_undotbs1_j781yvmc_.dbf\ninput datafile file number=00088 name=\/oracle\/dados\/TALAMO\/BFC37CDFCB3A0CF9E0536A00A8C0C9C5\/datafile\/o1_mf_users_j7824z91_.dbf\nchannel ORA_DISK_1: starting piece 1 at 11-MAY-21\nchannel ORA_DISK_1: finished piece 1 at 11-MAY-21\npiece handle=\/oracle\/fra\/TALAMO\/BFC37CDFCB3A0CF9E0536A00A8C0C9C5\/backupset\/2021_05_11\/o1_mf_nnndf_TAG20210511T043725_j9nf1p3c_.bkp tag=TAG20210511T043725 comment=NONE\nchannel ORA_DISK_1: backup set complete, elapsed time: 00:00:03\nFinished backup at 11-MAY-21\n \nStarting Control File and SPFILE Autobackup at 11-MAY-21\npiece handle=\/oracle\/fra\/TALAMO\/autobackup\/2021_05_11\/o1_mf_s_1072240649_j9nf1sdd_.bkp comment=NONE\nFinished Control File and SPFILE Autobackup at 11-MAY-21\n<\/pre><\/div>\n\n\nRealizando o mesmo processo, mas com backup do tipo image copy:<\/p>\n\n\n
\nRMAN> BACKUP AS COPY PLUGGABLE DATABASE HIPOFISE1;\n \nStarting backup at 11-MAY-21\nusing channel ORA_DISK_1\nchannel ORA_DISK_1: starting datafile copy\ninput datafile file number=00085 name=\/oracle\/dados\/TALAMO\/BFC37CDFCB3A0CF9E0536A00A8C0C9C5\/datafile\/o1_mf_system_j781yvm6_.dbf\noutput file name=\/oracle\/fra\/TALAMO\/BFC37CDFCB3A0CF9E0536A00A8C0C9C5\/datafile\/o1_mf_system_j9nf45t4_.dbf tag=TAG20210511T043845 RECID=4 STAMP=1072240726\nchannel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:03\nchannel ORA_DISK_1: starting datafile copy\ninput datafile file number=00086 name=\/oracle\/dados\/TALAMO\/BFC37CDFCB3A0CF9E0536A00A8C0C9C5\/datafile\/o1_mf_sysaux_j781yvmc_.dbf\noutput file name=\/oracle\/fra\/TALAMO\/BFC37CDFCB3A0CF9E0536A00A8C0C9C5\/datafile\/o1_mf_sysaux_j9nf4902_.dbf tag=TAG20210511T043845 RECID=5 STAMP=1072240730\nchannel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:03\nchannel ORA_DISK_1: starting datafile copy\ninput datafile file number=00087 name=\/oracle\/dados\/TALAMO\/BFC37CDFCB3A0CF9E0536A00A8C0C9C5\/datafile\/o1_mf_undotbs1_j781yvmc_.dbf\noutput file name=\/oracle\/fra\/TALAMO\/BFC37CDFCB3A0CF9E0536A00A8C0C9C5\/datafile\/o1_mf_undotbs1_j9nf4d1n_.dbf tag=TAG20210511T043845 RECID=6 STAMP=1072240732\nchannel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:01\nchannel ORA_DISK_1: starting datafile copy\ninput datafile file number=00088 name=\/oracle\/dados\/TALAMO\/BFC37CDFCB3A0CF9E0536A00A8C0C9C5\/datafile\/o1_mf_users_j7824z91_.dbf\noutput file name=\/oracle\/fra\/TALAMO\/BFC37CDFCB3A0CF9E0536A00A8C0C9C5\/datafile\/o1_mf_users_j9nf4f4c_.dbf tag=TAG20210511T043845 RECID=7 STAMP=1072240733\nchannel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:01\nFinished backup at 11-MAY-21\n \nStarting Control File and SPFILE Autobackup at 11-MAY-21\npiece handle=\/oracle\/fra\/TALAMO\/autobackup\/2021_05_11\/o1_mf_s_1072240734_j9nf4g9q_.bkp comment=NONE\nFinished Control File and SPFILE Autobackup at 11-MAY-21\n<\/pre><\/div>\n\n\nTamb\u00e9m temos a op\u00e7\u00e3o de realizar o backup de mais de um PDB no mesmo comando:<\/p>\n\n\n
\nRMAN> BACKUP PLUGGABLE DATABASE HIPOFISE1,"PDB$SEED";\n \nStarting backup at 11-MAY-21\nusing channel ORA_DISK_1\nchannel ORA_DISK_1: starting full datafile backup set\nchannel ORA_DISK_1: specifying datafile(s) in backup set\ninput datafile file number=00085 name=\/oracle\/dados\/TALAMO\/BFC37CDFCB3A0CF9E0536A00A8C0C9C5\/datafile\/o1_mf_system_j781yvm6_.dbf\ninput datafile file number=00086 name=\/oracle\/dados\/TALAMO\/BFC37CDFCB3A0CF9E0536A00A8C0C9C5\/datafile\/o1_mf_sysaux_j781yvmc_.dbf\ninput datafile file number=00087 name=\/oracle\/dados\/TALAMO\/BFC37CDFCB3A0CF9E0536A00A8C0C9C5\/datafile\/o1_mf_undotbs1_j781yvmc_.dbf\ninput datafile file number=00088 name=\/oracle\/dados\/TALAMO\/BFC37CDFCB3A0CF9E0536A00A8C0C9C5\/datafile\/o1_mf_users_j7824z91_.dbf\nchannel ORA_DISK_1: starting piece 1 at 11-MAY-21\nchannel ORA_DISK_1: finished piece 1 at 11-MAY-21\npiece handle=\/oracle\/fra\/TALAMO\/BFC37CDFCB3A0CF9E0536A00A8C0C9C5\/backupset\/2021_05_11\/o1_mf_nnndf_TAG20210511T044118_j9nf8ywm_.bkp tag=TAG20210511T044118 comment=NONE\nchannel ORA_DISK_1: backup set complete, elapsed time: 00:00:03\nchannel ORA_DISK_1: starting full datafile backup set\nchannel ORA_DISK_1: specifying datafile(s) in backup set\ninput datafile file number=00005 name=\/oracle\/dados\/TALAMO\/datafile\/o1_mf_system_j3w1q776_.dbf\ninput datafile file number=00006 name=\/oracle\/dados\/TALAMO\/datafile\/o1_mf_sysaux_j3w1q76z_.dbf\ninput datafile file number=00008 name=\/oracle\/dados\/TALAMO\/datafile\/o1_mf_undotbs1_j3w1q779_.dbf\nchannel ORA_DISK_1: starting piece 1 at 11-MAY-21\nchannel ORA_DISK_1: finished piece 1 at 11-MAY-21\npiece handle=\/oracle\/fra\/TALAMO\/BC8B772AA6A82204E0536B00A8C0CF6B\/backupset\/2021_05_11\/o1_mf_nnndf_TAG20210511T044118_j9nf9229_.bkp tag=TAG20210511T044118 comment=NONE\nchannel ORA_DISK_1: backup set complete, elapsed time: 00:00:03\nFinished backup at 11-MAY-21\n \nStarting Control File and SPFILE Autobackup at 11-MAY-21\npiece handle=\/oracle\/fra\/TALAMO\/autobackup\/2021_05_11\/o1_mf_s_1072240885_j9nf959v_.bkp comment=NONE\nFinished Control File and SPFILE Autobackup at 11-MAY-21\n<\/pre><\/div>\n\n\nListando informa\u00e7\u00f5es do \u00faltimo backup emitido (pois os iniciais eu j\u00e1 havia removido para liberar espa\u00e7o em disco):<\/p>\n\n\n
\nRMAN> LIST BACKUP OF PLUGGABLE DATABASE HIPOFISE1;\n \n \nList of Backup Sets\n===================\n \n \nBS Key Type LV Size Device Type Elapsed Time Completion Time\n------- ---- -- ---------- ----------- ------------ ---------------\n58 Full 667.87M DISK 00:00:01 11-MAY-21\n BP Key: 58 Status: AVAILABLE Compressed: NO Tag: TAG20210511T044118\n Piece Name: \/oracle\/fra\/TALAMO\/BFC37CDFCB3A0CF9E0536A00A8C0C9C5\/backupset\/2021_05_11\/o1_mf_nnndf_TAG20210511T044118_j9nf8ywm_.bkp\n List of Datafiles in backup set 58\n Container ID: 3, PDB Name: HIPOFISE1\n File LV Type Ckp SCN Ckp Time Abs Fuz SCN Sparse Name\n ---- -- ---- ---------- --------- ----------- ------ ----\n 85 Full 3710954 11-MAY-21 NO \/oracle\/dados\/TALAMO\/BFC37CDFCB3A0CF9E0536A00A8C0C9C5\/datafile\/o1_mf_system_j781yvm6_.dbf\n 86 Full 3710954 11-MAY-21 NO \/oracle\/dados\/TALAMO\/BFC37CDFCB3A0CF9E0536A00A8C0C9C5\/datafile\/o1_mf_sysaux_j781yvmc_.dbf\n 87 Full 3710954 11-MAY-21 NO \/oracle\/dados\/TALAMO\/BFC37CDFCB3A0CF9E0536A00A8C0C9C5\/datafile\/o1_mf_undotbs1_j781yvmc_.dbf\n 88 Full 3710954 11-MAY-21 NO \/oracle\/dados\/TALAMO\/BFC37CDFCB3A0CF9E0536A00A8C0C9C5\/datafile\/o1_mf_users_j7824z91_.dbf\n<\/pre><\/div>\n\n\nA segunda maneira de realizar esses backups seria logando diretamente no PDB. Como restri\u00e7\u00f5es, n\u00e3o \u00e9 poss\u00edvel alterar os par\u00e2metros persistentes do RMAN, e tamb\u00e9m n\u00e3o \u00e9 poss\u00edvel realizar backup\/restore ou delete dos archivelogs. Para simular esta op\u00e7\u00e3o, vamos criar um common user com privil\u00e9gio de sysbackup:<\/p>\n\n\n
\n[oracle@quiasma TALAMO]$ sqlplus \/ as sysdba\n \nSQL*Plus: Release 18.0.0.0.0 - Production on Tue May 11 04:58:26 2021\nVersion 18.13.0.0.0\n \nCopyright (c) 1982, 2018, Oracle. All rights reserved.\n \n \nConnected to:\nOracle Database 18c Enterprise Edition Release 18.0.0.0.0 - Production\nVersion 18.13.0.0.0\n \nSQL> CREATE USER C##LUXOR IDENTIFIED BY oracle CONTAINER=ALL;\n \nUser created.\n \nSQL> GRANT SYSBACKUP TO C##LUXOR CONTAINER=ALL;\n \nGrant succeeded.\n<\/pre><\/div>\n\n\nConectando no PDB diretamente e fazendo o backup do banco:<\/p>\n\n\n
\n[oracle@quiasma TALAMO]$ rman target "'C##LUXOR\/oracle@HIPOFISE1 as sysbackup'"\n \nRecovery Manager: Release 18.0.0.0.0 - Production on Tue May 11 05:01:54 2021\nVersion 18.13.0.0.0\n \nCopyright (c) 1982, 2018, Oracle and\/or its affiliates. All rights reserved.\n \nconnected to target database: TALAMO:HIPOFISE1 (DBID=294818613)\n \nRMAN> BACKUP DATABASE;\n \nStarting backup at 11-MAY-21\nusing target database control file instead of recovery catalog\nallocated channel: ORA_DISK_1\nchannel ORA_DISK_1: SID=106 device type=DISK\nchannel ORA_DISK_1: starting full datafile backup set\nchannel ORA_DISK_1: specifying datafile(s) in backup set\ninput datafile file number=00085 name=\/oracle\/dados\/TALAMO\/BFC37CDFCB3A0CF9E0536A00A8C0C9C5\/datafile\/o1_mf_system_j781yvm6_.dbf\ninput datafile file number=00086 name=\/oracle\/dados\/TALAMO\/BFC37CDFCB3A0CF9E0536A00A8C0C9C5\/datafile\/o1_mf_sysaux_j781yvmc_.dbf\ninput datafile file number=00087 name=\/oracle\/dados\/TALAMO\/BFC37CDFCB3A0CF9E0536A00A8C0C9C5\/datafile\/o1_mf_undotbs1_j781yvmc_.dbf\ninput datafile file number=00088 name=\/oracle\/dados\/TALAMO\/BFC37CDFCB3A0CF9E0536A00A8C0C9C5\/datafile\/o1_mf_users_j7824z91_.dbf\nchannel ORA_DISK_1: starting piece 1 at 11-MAY-21\nchannel ORA_DISK_1: finished piece 1 at 11-MAY-21\npiece handle=\/oracle\/fra\/TALAMO\/BFC37CDFCB3A0CF9E0536A00A8C0C9C5\/backupset\/2021_05_11\/o1_mf_nnndf_TAG20210511T050208_j9ngj0s1_.bkp tag=TAG20210511T050208 comment=NONE\nchannel ORA_DISK_1: backup set complete, elapsed time: 00:00:03\nFinished backup at 11-MAY-21\n<\/pre><\/div>\n\n\nSimulando o backup de archivelog, sendo reportado que n\u00e3o \u00e9 poss\u00edvel:<\/p>\n\n\n
\n[oracle@quiasma TALAMO]$ sqlplus \/ as sysdba\n \nSQL*Plus: Release 18.0.0.0.0 - Production on Tue May 11 05:03:19 2021\nVersion 18.13.0.0.0\n \nCopyright (c) 1982, 2018, Oracle. All rights reserved.\n \n \nConnected to:\nOracle Database 18c Enterprise Edition Release 18.0.0.0.0 - Production\nVersion 18.13.0.0.0\n \nSQL> ALTER SYSTEM SWITCH LOGFILE;\n \nSystem altered.\n \nSQL> exit\nDisconnected from Oracle Database 18c Enterprise Edition Release 18.0.0.0.0 - Production\nVersion 18.13.0.0.0\n[oracle@quiasma TALAMO]$ rman target "'C##LUXOR\/oracle@HIPOFISE1 as sysbackup'"\n \nRecovery Manager: Release 18.0.0.0.0 - Production on Tue May 11 05:03:28 2021\nVersion 18.13.0.0.0\n \nCopyright (c) 1982, 2018, Oracle and\/or its affiliates. All rights reserved.\n \nconnected to target database: TALAMO:HIPOFISE1 (DBID=294818613)\n \nRMAN> BACKUP ARCHIVELOG ALL;\n \nStarting backup at 11-MAY-21\nusing target database control file instead of recovery catalog\nallocated channel: ORA_DISK_1\nchannel ORA_DISK_1: SID=55 device type=DISK\nskipping archived logs when connected to a PDB\nbackup cancelled because there are no files to backup\nFinished backup at 11-MAY-21\n<\/pre><\/div>\n\n\nListando backup realizado:<\/p>\n\n\n
\nRMAN> LIST BACKUP OF DATABASE;\n \n \nList of Backup Sets\n===================\n \n \nBS Key Type LV Size Device Type Elapsed Time Completion Time\n------- ---- -- ---------- ----------- ------------ ---------------\n61 Full 667.91M DISK 00:00:01 11-MAY-21\n BP Key: 61 Status: AVAILABLE Compressed: NO Tag: TAG20210511T050208\n Piece Name: \/oracle\/fra\/TALAMO\/BFC37CDFCB3A0CF9E0536A00A8C0C9C5\/backupset\/2021_05_11\/o1_mf_nnndf_TAG20210511T050208_j9ngj0s1_.bkp\n List of Datafiles in backup set 61\n File LV Type Ckp SCN Ckp Time Abs Fuz SCN Sparse Name\n ---- -- ---- ---------- --------- ----------- ------ ----\n 85 Full 3712050 11-MAY-21 NO \/oracle\/dados\/TALAMO\/BFC37CDFCB3A0CF9E0536A00A8C0C9C5\/datafile\/o1_mf_system_j781yvm6_.dbf\n 86 Full 3712050 11-MAY-21 NO \/oracle\/dados\/TALAMO\/BFC37CDFCB3A0CF9E0536A00A8C0C9C5\/datafile\/o1_mf_sysaux_j781yvmc_.dbf\n 87 Full 3712050 11-MAY-21 NO \/oracle\/dados\/TALAMO\/BFC37CDFCB3A0CF9E0536A00A8C0C9C5\/datafile\/o1_mf_undotbs1_j781yvmc_.dbf\n 88 Full 3712050 11-MAY-21 NO \/oracle\/dados\/TALAMO\/BFC37CDFCB3A0CF9E0536A00A8C0C9C5\/datafile\/o1_mf_users_j7824z91_.dbf\n<\/pre><\/div>\n\n\nPartial Backup<\/h2>\n\n\n\n
Realizando o backup de uma tablespace do PDB HIPOFISE1 logado diretamente neste PDB:<\/p>\n\n\n
\n[oracle@quiasma TALAMO]$ rman target "'C##LUXOR\/oracle@HIPOFISE1 as sysbackup'"\n \nRecovery Manager: Release 18.0.0.0.0 - Production on Tue May 11 05:11:51 2021\nVersion 18.13.0.0.0\n \nCopyright (c) 1982, 2018, Oracle and\/or its affiliates. All rights reserved.\n \nconnected to target database: TALAMO:HIPOFISE1 (DBID=294818613)\n \nRMAN> BACKUP TABLESPACE USERS;\n \nStarting backup at 11-MAY-21\nusing target database control file instead of recovery catalog\nallocated channel: ORA_DISK_1\nchannel ORA_DISK_1: SID=76 device type=DISK\nchannel ORA_DISK_1: starting full datafile backup set\nchannel ORA_DISK_1: specifying datafile(s) in backup set\ninput datafile file number=00088 name=\/oracle\/dados\/TALAMO\/BFC37CDFCB3A0CF9E0536A00A8C0C9C5\/datafile\/o1_mf_users_j7824z91_.dbf\nchannel ORA_DISK_1: starting piece 1 at 11-MAY-21\nchannel ORA_DISK_1: finished piece 1 at 11-MAY-21\npiece handle=\/oracle\/fra\/TALAMO\/BFC37CDFCB3A0CF9E0536A00A8C0C9C5\/backupset\/2021_05_11\/o1_mf_nnndf_TAG20210511T051221_j9nh35go_.bkp tag=TAG20210511T051221 comment=NONE\nchannel ORA_DISK_1: backup set complete, elapsed time: 00:00:01\nFinished backup at 11-MAY-21\n<\/pre><\/div>\n\n\nListando informa\u00e7\u00f5es sobre o backup:<\/p>\n\n\n
\nRMAN> LIST BACKUP OF TABLESPACE USERS;\n \n \nList of Backup Sets\n===================\n \n \nBS Key Type LV Size Device Type Elapsed Time Completion Time\n------- ---- -- ---------- ----------- ------------ ---------------\n62 Full 1.05M DISK 00:00:00 11-MAY-21\n BP Key: 62 Status: AVAILABLE Compressed: NO Tag: TAG20210511T051221\n Piece Name: \/oracle\/fra\/TALAMO\/BFC37CDFCB3A0CF9E0536A00A8C0C9C5\/backupset\/2021_05_11\/o1_mf_nnndf_TAG20210511T051221_j9nh35go_.bkp\n List of Datafiles in backup set 62\n File LV Type Ckp SCN Ckp Time Abs Fuz SCN Sparse Name\n ---- -- ---- ---------- --------- ----------- ------ ----\n 88 Full 3713287 11-MAY-21 NO \/oracle\/dados\/TALAMO\/BFC37CDFCB3A0CF9E0536A00A8C0C9C5\/datafile\/o1_mf_users_j7824z91_.dbf\n<\/pre><\/div>\n\n\nLogado no CDB$ROOT, tamb\u00e9m conseguimos realizar o backup da tablespace do PDB em quest\u00e3o, com o exemplo abaixo:<\/p>\n\n\n
\n[oracle@quiasma TALAMO]$ rman target \/\n \nRecovery Manager: Release 18.0.0.0.0 - Production on Tue May 11 05:14:13 2021\nVersion 18.13.0.0.0\n \nCopyright (c) 1982, 2018, Oracle and\/or its affiliates. All rights reserved.\n \nconnected to target database: TALAMO (DBID=2194831545)\n \nRMAN> BACKUP TABLESPACE HIPOFISE1:USERS;\n \nStarting backup at 11-MAY-21\nusing target database control file instead of recovery catalog\nallocated channel: ORA_DISK_1\nchannel ORA_DISK_1: SID=78 device type=DISK\nchannel ORA_DISK_1: starting full datafile backup set\nchannel ORA_DISK_1: specifying datafile(s) in backup set\ninput datafile file number=00088 name=\/oracle\/dados\/TALAMO\/BFC37CDFCB3A0CF9E0536A00A8C0C9C5\/datafile\/o1_mf_users_j7824z91_.dbf\nchannel ORA_DISK_1: starting piece 1 at 11-MAY-21\nchannel ORA_DISK_1: finished piece 1 at 11-MAY-21\npiece handle=\/oracle\/fra\/TALAMO\/BFC37CDFCB3A0CF9E0536A00A8C0C9C5\/backupset\/2021_05_11\/o1_mf_nnndf_TAG20210511T051428_j9nh749p_.bkp tag=TAG20210511T051428 comment=NONE\nchannel ORA_DISK_1: backup set complete, elapsed time: 00:00:01\nFinished backup at 11-MAY-21\n \nStarting Control File and SPFILE Autobackup at 11-MAY-21\npiece handle=\/oracle\/fra\/TALAMO\/autobackup\/2021_05_11\/o1_mf_s_1072242869_j9nh75l3_.bkp comment=NONE\nFinished Control File and SPFILE Autobackup at 11-MAY-21\n<\/pre><\/div>\n\n\nPara listarmos as informa\u00e7\u00f5es:<\/p>\n\n\n
\nRMAN> LIST BACKUP OF TABLESPACE HIPOFISE1:USERS;\n \n \nList of Backup Sets\n===================\n \n \nBS Key Type LV Size Device Type Elapsed Time Completion Time\n------- ---- -- ---------- ----------- ------------ ---------------\n63 Full 1.05M DISK 00:00:00 11-MAY-21\n BP Key: 63 Status: AVAILABLE Compressed: NO Tag: TAG20210511T051428\n Piece Name: \/oracle\/fra\/TALAMO\/BFC37CDFCB3A0CF9E0536A00A8C0C9C5\/backupset\/2021_05_11\/o1_mf_nnndf_TAG20210511T051428_j9nh749p_.bkp\n List of Datafiles in backup set 63\n File LV Type Ckp SCN Ckp Time Abs Fuz SCN Sparse Name\n ---- -- ---- ---------- --------- ----------- ------ ----\n 88 Full 3713443 11-MAY-21 NO \/oracle\/dados\/TALAMO\/BFC37CDFCB3A0CF9E0536A00A8C0C9C5\/datafile\/o1_mf_users_j7824z91_.dbf\n<\/pre><\/div>\n\n\n\u00c9 poss\u00edvel realizar o backup da tablespace USERS do CDB$ROOT e PDB ao mesmo tempo, conforme exemplo abaixo:<\/p>\n\n\n
\nRMAN> BACKUP TABLESPACE USERS,HIPOFISE1:USERS;\n \nStarting backup at 11-MAY-21\nusing channel ORA_DISK_1\nchannel ORA_DISK_1: starting full datafile backup set\nchannel ORA_DISK_1: specifying datafile(s) in backup set\ninput datafile file number=00088 name=\/oracle\/dados\/TALAMO\/BFC37CDFCB3A0CF9E0536A00A8C0C9C5\/datafile\/o1_mf_users_j7824z91_.dbf\nchannel ORA_DISK_1: starting piece 1 at 11-MAY-21\nchannel ORA_DISK_1: finished piece 1 at 11-MAY-21\npiece handle=\/oracle\/fra\/TALAMO\/BFC37CDFCB3A0CF9E0536A00A8C0C9C5\/backupset\/2021_05_11\/o1_mf_nnndf_TAG20210511T051653_j9nhcox3_.bkp tag=TAG20210511T051653 comment=NONE\nchannel ORA_DISK_1: backup set complete, elapsed time: 00:00:01\nchannel ORA_DISK_1: starting full datafile backup set\nchannel ORA_DISK_1: specifying datafile(s) in backup set\ninput datafile file number=00007 name=\/oracle\/dados\/TALAMO\/datafile\/o1_mf_users_j3w1czy4_.dbf\nchannel ORA_DISK_1: starting piece 1 at 11-MAY-21\nchannel ORA_DISK_1: finished piece 1 at 11-MAY-21\npiece handle=\/oracle\/fra\/TALAMO\/backupset\/2021_05_11\/o1_mf_nnndf_TAG20210511T051653_j9nhcq0p_.bkp tag=TAG20210511T051653 comment=NONE\nchannel ORA_DISK_1: backup set complete, elapsed time: 00:00:01\nFinished backup at 11-MAY-21\n \nStarting Control File and SPFILE Autobackup at 11-MAY-21\npiece handle=\/oracle\/fra\/TALAMO\/autobackup\/2021_05_11\/o1_mf_s_1072243016_j9nhcr62_.bkp comment=NONE\nFinished Control File and SPFILE Autobackup at 11-MAY-21\n<\/pre><\/div>\n\n\nE podemos tamb\u00e9m coletar as informa\u00e7\u00f5es dos 2 backups ao mesmo tempo:<\/p>\n\n\n
\nRMAN> LIST BACKUP OF TABLESPACE USERS,HIPOFISE1:USERS;\n \n \nList of Backup Sets\n===================\n \n \nBS Key Type LV Size Device Type Elapsed Time Completion Time\n------- ---- -- ---------- ----------- ------------ ---------------\n65 Full 1.05M DISK 00:00:00 11-MAY-21\n BP Key: 65 Status: AVAILABLE Compressed: NO Tag: TAG20210511T051653\n Piece Name: \/oracle\/fra\/TALAMO\/BFC37CDFCB3A0CF9E0536A00A8C0C9C5\/backupset\/2021_05_11\/o1_mf_nnndf_TAG20210511T051653_j9nhcox3_.bkp\n List of Datafiles in backup set 65\n File LV Type Ckp SCN Ckp Time Abs Fuz SCN Sparse Name\n ---- -- ---- ---------- --------- ----------- ------ ----\n 88 Full 3713587 11-MAY-21 NO \/oracle\/dados\/TALAMO\/BFC37CDFCB3A0CF9E0536A00A8C0C9C5\/datafile\/o1_mf_users_j7824z91_.dbf\n \nBS Key Type LV Size Device Type Elapsed Time Completion Time\n------- ---- -- ---------- ----------- ------------ ---------------\n66 Full 1.05M DISK 00:00:00 11-MAY-21\n BP Key: 66 Status: AVAILABLE Compressed: NO Tag: TAG20210511T051653\n Piece Name: \/oracle\/fra\/TALAMO\/backupset\/2021_05_11\/o1_mf_nnndf_TAG20210511T051653_j9nhcq0p_.bkp\n List of Datafiles in backup set 66\n File LV Type Ckp SCN Ckp Time Abs Fuz SCN Sparse Name\n ---- -- ---- ---------- --------- ----------- ------ ----\n 7 Full 3713588 11-MAY-21 NO \/oracle\/dados\/TALAMO\/datafile\/o1_mf_users_j3w1czy4_.dbf\n<\/pre><\/div>\n\n\nObs: Este procedimento foi criado pelo senhor Ahmed Baraka (www.ahmedbaraka.com) e foi apenas reproduzido por mim em um laborat\u00f3rio pessoal para fins de aprendizado.<\/p>\n","protected":false},"excerpt":{"rendered":"
Neste artigo vamos explorar 2 maneiras de realizar backups de PDBs na arquitetura Multitenant. Whole Backup Checando o nome do CDB$ROOT e do seu PDB no ambiente que usaremos de estudos: A primeira maneira de realizar um backup do PDB seria atrav\u00e9s do CDB$ROOT, conforme exemplo abaixo: Realizando o mesmo processo, mas com backup do […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3,8],"tags":[],"class_list":["post-4508","post","type-post","status-publish","format-standard","hentry","category-backup-recovery","category-multitenant"],"_links":{"self":[{"href":"https:\/\/swiv.com.br\/index.php\/wp-json\/wp\/v2\/posts\/4508","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/swiv.com.br\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/swiv.com.br\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/swiv.com.br\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/swiv.com.br\/index.php\/wp-json\/wp\/v2\/comments?post=4508"}],"version-history":[{"count":1,"href":"https:\/\/swiv.com.br\/index.php\/wp-json\/wp\/v2\/posts\/4508\/revisions"}],"predecessor-version":[{"id":9142,"href":"https:\/\/swiv.com.br\/index.php\/wp-json\/wp\/v2\/posts\/4508\/revisions\/9142"}],"wp:attachment":[{"href":"https:\/\/swiv.com.br\/index.php\/wp-json\/wp\/v2\/media?parent=4508"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/swiv.com.br\/index.php\/wp-json\/wp\/v2\/categories?post=4508"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/swiv.com.br\/index.php\/wp-json\/wp\/v2\/tags?post=4508"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}