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:
[oracle@quiasma TALAMO]$ sqlplus / as sysdba
SQL*Plus: Release 18.0.0.0.0 - Production on Tue May 11 04:35:56 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,CDB FROM V$DATABASE;
NAME CDB
--------- ---
TALAMO YES
SQL> SELECT NAME FROM V$PDBS;
NAME
--------------------------------------------------------------------------------
PDB$SEED
HIPOFISE1
A primeira maneira de realizar um backup do PDB seria através do CDB$ROOT, conforme exemplo abaixo:
[oracle@quiasma TALAMO]$ rman target /
Recovery Manager: Release 18.0.0.0.0 - Production on Tue May 11 04:37:07 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> BACKUP PLUGGABLE DATABASE HIPOFISE1;
Starting backup at 11-MAY-21
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=106 device type=DISK
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_TAG20210511T043725_j9nf1p3c_.bkp tag=TAG20210511T043725 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:03
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_1072240649_j9nf1sdd_.bkp comment=NONE
Finished Control File and SPFILE Autobackup at 11-MAY-21
Realizando o mesmo processo, mas com backup do tipo image copy:
RMAN> BACKUP AS COPY PLUGGABLE DATABASE HIPOFISE1;
Starting backup at 11-MAY-21
using channel ORA_DISK_1
channel ORA_DISK_1: starting datafile copy
input datafile file number=00085 name=/oracle/dados/TALAMO/BFC37CDFCB3A0CF9E0536A00A8C0C9C5/datafile/o1_mf_system_j781yvm6_.dbf
output file name=/oracle/fra/TALAMO/BFC37CDFCB3A0CF9E0536A00A8C0C9C5/datafile/o1_mf_system_j9nf45t4_.dbf tag=TAG20210511T043845 RECID=4 STAMP=1072240726
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:03
channel ORA_DISK_1: starting datafile copy
input datafile file number=00086 name=/oracle/dados/TALAMO/BFC37CDFCB3A0CF9E0536A00A8C0C9C5/datafile/o1_mf_sysaux_j781yvmc_.dbf
output file name=/oracle/fra/TALAMO/BFC37CDFCB3A0CF9E0536A00A8C0C9C5/datafile/o1_mf_sysaux_j9nf4902_.dbf tag=TAG20210511T043845 RECID=5 STAMP=1072240730
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:03
channel ORA_DISK_1: starting datafile copy
input datafile file number=00087 name=/oracle/dados/TALAMO/BFC37CDFCB3A0CF9E0536A00A8C0C9C5/datafile/o1_mf_undotbs1_j781yvmc_.dbf
output file name=/oracle/fra/TALAMO/BFC37CDFCB3A0CF9E0536A00A8C0C9C5/datafile/o1_mf_undotbs1_j9nf4d1n_.dbf tag=TAG20210511T043845 RECID=6 STAMP=1072240732
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:01
channel ORA_DISK_1: starting datafile copy
input datafile file number=00088 name=/oracle/dados/TALAMO/BFC37CDFCB3A0CF9E0536A00A8C0C9C5/datafile/o1_mf_users_j7824z91_.dbf
output file name=/oracle/fra/TALAMO/BFC37CDFCB3A0CF9E0536A00A8C0C9C5/datafile/o1_mf_users_j9nf4f4c_.dbf tag=TAG20210511T043845 RECID=7 STAMP=1072240733
channel ORA_DISK_1: datafile copy 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_1072240734_j9nf4g9q_.bkp comment=NONE
Finished Control File and SPFILE Autobackup at 11-MAY-21
Também temos a opção de realizar o backup de mais de um PDB no mesmo comando:
RMAN> BACKUP PLUGGABLE DATABASE HIPOFISE1,"PDB$SEED";
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=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_TAG20210511T044118_j9nf8ywm_.bkp tag=TAG20210511T044118 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:03
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_TAG20210511T044118_j9nf9229_.bkp tag=TAG20210511T044118 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:03
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_1072240885_j9nf959v_.bkp comment=NONE
Finished Control File and SPFILE Autobackup at 11-MAY-21
Listando informações do último backup emitido (pois os iniciais eu já havia removido para liberar espaço em disco):
RMAN> LIST BACKUP OF PLUGGABLE DATABASE HIPOFISE1;
List of Backup Sets
===================
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
58 Full 667.87M DISK 00:00:01 11-MAY-21
BP Key: 58 Status: AVAILABLE Compressed: NO Tag: TAG20210511T044118
Piece Name: /oracle/fra/TALAMO/BFC37CDFCB3A0CF9E0536A00A8C0C9C5/backupset/2021_05_11/o1_mf_nnndf_TAG20210511T044118_j9nf8ywm_.bkp
List of Datafiles in backup set 58
Container ID: 3, PDB Name: HIPOFISE1
File LV Type Ckp SCN Ckp Time Abs Fuz SCN Sparse Name
---- -- ---- ---------- --------- ----------- ------ ----
85 Full 3710954 11-MAY-21 NO /oracle/dados/TALAMO/BFC37CDFCB3A0CF9E0536A00A8C0C9C5/datafile/o1_mf_system_j781yvm6_.dbf
86 Full 3710954 11-MAY-21 NO /oracle/dados/TALAMO/BFC37CDFCB3A0CF9E0536A00A8C0C9C5/datafile/o1_mf_sysaux_j781yvmc_.dbf
87 Full 3710954 11-MAY-21 NO /oracle/dados/TALAMO/BFC37CDFCB3A0CF9E0536A00A8C0C9C5/datafile/o1_mf_undotbs1_j781yvmc_.dbf
88 Full 3710954 11-MAY-21 NO /oracle/dados/TALAMO/BFC37CDFCB3A0CF9E0536A00A8C0C9C5/datafile/o1_mf_users_j7824z91_.dbf
A segunda maneira de realizar esses backups seria logando diretamente no PDB. Como restrições, não é possível alterar os parâmetros persistentes do RMAN, e também não é possível realizar backup/restore ou delete dos archivelogs. Para simular esta opção, vamos criar um common user com privilégio de sysbackup:
[oracle@quiasma TALAMO]$ sqlplus / as sysdba
SQL*Plus: Release 18.0.0.0.0 - Production on Tue May 11 04:58:26 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> CREATE USER C##LUXOR IDENTIFIED BY oracle CONTAINER=ALL;
User created.
SQL> GRANT SYSBACKUP TO C##LUXOR CONTAINER=ALL;
Grant succeeded.
Conectando no PDB diretamente e fazendo o backup do banco:
[oracle@quiasma TALAMO]$ rman target "'C##LUXOR/oracle@HIPOFISE1 as sysbackup'"
Recovery Manager: Release 18.0.0.0.0 - Production on Tue May 11 05:01:54 2021
Version 18.13.0.0.0
Copyright (c) 1982, 2018, Oracle and/or its affiliates. All rights reserved.
connected to target database: TALAMO:HIPOFISE1 (DBID=294818613)
RMAN> BACKUP DATABASE;
Starting backup at 11-MAY-21
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=106 device type=DISK
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_TAG20210511T050208_j9ngj0s1_.bkp tag=TAG20210511T050208 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:03
Finished backup at 11-MAY-21
Simulando o backup de archivelog, sendo reportado que não é possível:
[oracle@quiasma TALAMO]$ sqlplus / as sysdba
SQL*Plus: Release 18.0.0.0.0 - Production on Tue May 11 05:03:19 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> ALTER SYSTEM SWITCH LOGFILE;
System altered.
SQL> exit
Disconnected from Oracle Database 18c Enterprise Edition Release 18.0.0.0.0 - Production
Version 18.13.0.0.0
[oracle@quiasma TALAMO]$ rman target "'C##LUXOR/oracle@HIPOFISE1 as sysbackup'"
Recovery Manager: Release 18.0.0.0.0 - Production on Tue May 11 05:03:28 2021
Version 18.13.0.0.0
Copyright (c) 1982, 2018, Oracle and/or its affiliates. All rights reserved.
connected to target database: TALAMO:HIPOFISE1 (DBID=294818613)
RMAN> BACKUP ARCHIVELOG ALL;
Starting backup at 11-MAY-21
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=55 device type=DISK
skipping archived logs when connected to a PDB
backup cancelled because there are no files to backup
Finished backup at 11-MAY-21
Listando backup realizado:
RMAN> LIST BACKUP OF DATABASE;
List of Backup Sets
===================
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
61 Full 667.91M DISK 00:00:01 11-MAY-21
BP Key: 61 Status: AVAILABLE Compressed: NO Tag: TAG20210511T050208
Piece Name: /oracle/fra/TALAMO/BFC37CDFCB3A0CF9E0536A00A8C0C9C5/backupset/2021_05_11/o1_mf_nnndf_TAG20210511T050208_j9ngj0s1_.bkp
List of Datafiles in backup set 61
File LV Type Ckp SCN Ckp Time Abs Fuz SCN Sparse Name
---- -- ---- ---------- --------- ----------- ------ ----
85 Full 3712050 11-MAY-21 NO /oracle/dados/TALAMO/BFC37CDFCB3A0CF9E0536A00A8C0C9C5/datafile/o1_mf_system_j781yvm6_.dbf
86 Full 3712050 11-MAY-21 NO /oracle/dados/TALAMO/BFC37CDFCB3A0CF9E0536A00A8C0C9C5/datafile/o1_mf_sysaux_j781yvmc_.dbf
87 Full 3712050 11-MAY-21 NO /oracle/dados/TALAMO/BFC37CDFCB3A0CF9E0536A00A8C0C9C5/datafile/o1_mf_undotbs1_j781yvmc_.dbf
88 Full 3712050 11-MAY-21 NO /oracle/dados/TALAMO/BFC37CDFCB3A0CF9E0536A00A8C0C9C5/datafile/o1_mf_users_j7824z91_.dbf
Partial Backup
Realizando o backup de uma tablespace do PDB HIPOFISE1 logado diretamente neste PDB:
[oracle@quiasma TALAMO]$ rman target "'C##LUXOR/oracle@HIPOFISE1 as sysbackup'"
Recovery Manager: Release 18.0.0.0.0 - Production on Tue May 11 05:11:51 2021
Version 18.13.0.0.0
Copyright (c) 1982, 2018, Oracle and/or its affiliates. All rights reserved.
connected to target database: TALAMO:HIPOFISE1 (DBID=294818613)
RMAN> BACKUP TABLESPACE USERS;
Starting backup at 11-MAY-21
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=76 device type=DISK
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
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_TAG20210511T051221_j9nh35go_.bkp tag=TAG20210511T051221 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01
Finished backup at 11-MAY-21
Listando informações sobre o backup:
RMAN> LIST BACKUP OF TABLESPACE USERS;
List of Backup Sets
===================
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
62 Full 1.05M DISK 00:00:00 11-MAY-21
BP Key: 62 Status: AVAILABLE Compressed: NO Tag: TAG20210511T051221
Piece Name: /oracle/fra/TALAMO/BFC37CDFCB3A0CF9E0536A00A8C0C9C5/backupset/2021_05_11/o1_mf_nnndf_TAG20210511T051221_j9nh35go_.bkp
List of Datafiles in backup set 62
File LV Type Ckp SCN Ckp Time Abs Fuz SCN Sparse Name
---- -- ---- ---------- --------- ----------- ------ ----
88 Full 3713287 11-MAY-21 NO /oracle/dados/TALAMO/BFC37CDFCB3A0CF9E0536A00A8C0C9C5/datafile/o1_mf_users_j7824z91_.dbf
Logado no CDB$ROOT, também conseguimos realizar o backup da tablespace do PDB em questão, com o exemplo abaixo:
[oracle@quiasma TALAMO]$ rman target /
Recovery Manager: Release 18.0.0.0.0 - Production on Tue May 11 05:14:13 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> BACKUP TABLESPACE HIPOFISE1:USERS;
Starting backup at 11-MAY-21
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=78 device type=DISK
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
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_TAG20210511T051428_j9nh749p_.bkp tag=TAG20210511T051428 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_1072242869_j9nh75l3_.bkp comment=NONE
Finished Control File and SPFILE Autobackup at 11-MAY-21
Para listarmos as informações:
RMAN> LIST BACKUP OF TABLESPACE HIPOFISE1:USERS;
List of Backup Sets
===================
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
63 Full 1.05M DISK 00:00:00 11-MAY-21
BP Key: 63 Status: AVAILABLE Compressed: NO Tag: TAG20210511T051428
Piece Name: /oracle/fra/TALAMO/BFC37CDFCB3A0CF9E0536A00A8C0C9C5/backupset/2021_05_11/o1_mf_nnndf_TAG20210511T051428_j9nh749p_.bkp
List of Datafiles in backup set 63
File LV Type Ckp SCN Ckp Time Abs Fuz SCN Sparse Name
---- -- ---- ---------- --------- ----------- ------ ----
88 Full 3713443 11-MAY-21 NO /oracle/dados/TALAMO/BFC37CDFCB3A0CF9E0536A00A8C0C9C5/datafile/o1_mf_users_j7824z91_.dbf
É possível realizar o backup da tablespace USERS do CDB$ROOT e PDB ao mesmo tempo, conforme exemplo abaixo:
RMAN> BACKUP TABLESPACE USERS,HIPOFISE1:USERS;
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=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_TAG20210511T051653_j9nhcox3_.bkp tag=TAG20210511T051653 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
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_TAG20210511T051653_j9nhcq0p_.bkp tag=TAG20210511T051653 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_1072243016_j9nhcr62_.bkp comment=NONE
Finished Control File and SPFILE Autobackup at 11-MAY-21
E podemos também coletar as informações dos 2 backups ao mesmo tempo:
RMAN> LIST BACKUP OF TABLESPACE USERS,HIPOFISE1:USERS;
List of Backup Sets
===================
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
65 Full 1.05M DISK 00:00:00 11-MAY-21
BP Key: 65 Status: AVAILABLE Compressed: NO Tag: TAG20210511T051653
Piece Name: /oracle/fra/TALAMO/BFC37CDFCB3A0CF9E0536A00A8C0C9C5/backupset/2021_05_11/o1_mf_nnndf_TAG20210511T051653_j9nhcox3_.bkp
List of Datafiles in backup set 65
File LV Type Ckp SCN Ckp Time Abs Fuz SCN Sparse Name
---- -- ---- ---------- --------- ----------- ------ ----
88 Full 3713587 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
------- ---- -- ---------- ----------- ------------ ---------------
66 Full 1.05M DISK 00:00:00 11-MAY-21
BP Key: 66 Status: AVAILABLE Compressed: NO Tag: TAG20210511T051653
Piece Name: /oracle/fra/TALAMO/backupset/2021_05_11/o1_mf_nnndf_TAG20210511T051653_j9nhcq0p_.bkp
List of Datafiles in backup set 66
File LV Type Ckp SCN Ckp Time Abs Fuz SCN Sparse Name
---- -- ---- ---------- --------- ----------- ------ ----
7 Full 3713588 11-MAY-21 NO /oracle/dados/TALAMO/datafile/o1_mf_users_j3w1czy4_.dbf
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