{"id":3605,"date":"2021-04-09T08:24:34","date_gmt":"2021-04-09T08:24:34","guid":{"rendered":"https:\/\/swiv.com.br\/obtaining-information-about-rman-backups-using-list-command\/"},"modified":"2026-05-27T20:02:33","modified_gmt":"2026-05-27T19:02:33","slug":"obtaining-information-about-rman-backups-using-list-command","status":"publish","type":"post","link":"https:\/\/swiv.com.br\/index.php\/2021\/04\/09\/obtaining-information-about-rman-backups-using-list-command\/","title":{"rendered":"Obtaining Information about RMAN backups using LIST command"},"content":{"rendered":"\n

O comando LIST nos auxilia a extrair diversas informa\u00e7\u00f5es sobre os nossos backups do RMAN. Para simular o seu uso, dispararemos uma por\u00e7\u00e3o de backups abaixo para utilizar o comando posteriormente.<\/p>\n\n\n\n

Ajustando pol\u00edtica de redund\u00e2ncia do RMAN:<\/p>\n\n\n

\n[oracle@oel8 ~]$ rman target \/\n \nRecovery Manager: Release 18.0.0.0.0 - Production on Fri Apr 9 04:29:35 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: RMANDB (DBID=3825250984)\n \nRMAN> SHOW RETENTION POLICY;\n \nusing target database control file instead of recovery catalog\nRMAN configuration parameters for database with db_unique_name RMANDB are:\nCONFIGURE RETENTION POLICY TO REDUNDANCY 1; # default\n \nRMAN> CONFIGURE RETENTION POLICY TO REDUNDANCY 2;\n \nnew RMAN configuration parameters:\nCONFIGURE RETENTION POLICY TO REDUNDANCY 2;\nnew RMAN configuration parameters are successfully stored\n \nRMAN>\n<\/pre><\/div>\n\n\n
Realizando backup do banco como backupset:<\/p>\n\n\n
\nRMAN> BACKUP AS BACKUPSET DATABASE TAG 'DB_FULL_BS';\n \nStarting backup at 2021-04-09:04:31:05\nallocated channel: ORA_DISK_1\nchannel ORA_DISK_1: SID=1 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=00001 name=\/oracle\/dados\/RMANDB\/datafile\/o1_mf_system_h8nynqfx_.dbf\ninput datafile file number=00003 name=\/oracle\/dados\/RMANDB\/datafile\/o1_mf_sysaux_h8nyq35q_.dbf\ninput datafile file number=00004 name=\/oracle\/dados\/RMANDB\/datafile\/o1_mf_undotbs1_h8nyrjdr_.dbf\ninput datafile file number=00005 name=\/oracle\/dados\/RMANDB\/datafile\/ts_cortex_catalog.dbf\ninput datafile file number=00007 name=\/oracle\/dados\/RMANDB\/datafile\/o1_mf_users_h8nyrkn7_.dbf\nchannel ORA_DISK_1: starting piece 1 at 2021-04-09:04:31:05\nchannel ORA_DISK_1: finished piece 1 at 2021-04-09:04:32:21\npiece handle=\/oracle\/fra\/RMANDB\/backupset\/2021_04_09\/o1_mf_nnndf_DB_FULL_BS_j700oxtx_.bkp tag=DB_FULL_BS comment=NONE\nchannel ORA_DISK_1: backup set complete, elapsed time: 00:01:16\nFinished backup at 2021-04-09:04:32:21\n \nStarting Control File and SPFILE Autobackup at 2021-04-09:04:32:21\npiece handle=\/oracle\/fra\/RMANDB\/autobackup\/2021_04_09\/o1_mf_s_1069389141_j700r62m_.bkp comment=NONE\nFinished Control File and SPFILE Autobackup at 2021-04-09:04:32:24\n<\/pre><\/div>\n\n\n
Executando o backup da tablespace USERS 2 vezes:<\/p>\n\n\n
\nRMAN> BACKUP TABLESPACE USERS TAG 'USERS_BS';\n \nStarting backup at 2021-04-09:04:34:08\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=00007 name=\/oracle\/dados\/RMANDB\/datafile\/o1_mf_users_h8nyrkn7_.dbf\nchannel ORA_DISK_1: starting piece 1 at 2021-04-09:04:34:09\nchannel ORA_DISK_1: finished piece 1 at 2021-04-09:04:34:10\npiece handle=\/oracle\/fra\/RMANDB\/backupset\/2021_04_09\/o1_mf_nnndf_USERS_BS_j700vk1w_.bkp tag=USERS_BS comment=NONE\nchannel ORA_DISK_1: backup set complete, elapsed time: 00:00:01\nFinished backup at 2021-04-09:04:34:10\n \nStarting Control File and SPFILE Autobackup at 2021-04-09:04:34:10\npiece handle=\/oracle\/fra\/RMANDB\/autobackup\/2021_04_09\/o1_mf_s_1069389250_j700vlmc_.bkp comment=NONE\nFinished Control File and SPFILE Autobackup at 2021-04-09:04:34:11\n \nRMAN> BACKUP TABLESPACE USERS TAG 'USERS_BS';\n \nStarting backup at 2021-04-09:04:34:16\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=00007 name=\/oracle\/dados\/RMANDB\/datafile\/o1_mf_users_h8nyrkn7_.dbf\nchannel ORA_DISK_1: starting piece 1 at 2021-04-09:04:34:16\nchannel ORA_DISK_1: finished piece 1 at 2021-04-09:04:34:17\npiece handle=\/oracle\/fra\/RMANDB\/backupset\/2021_04_09\/o1_mf_nnndf_USERS_BS_j700vrh3_.bkp tag=USERS_BS comment=NONE\nchannel ORA_DISK_1: backup set complete, elapsed time: 00:00:01\nFinished backup at 2021-04-09:04:34:17\n \nStarting Control File and SPFILE Autobackup at 2021-04-09:04:34:17\npiece handle=\/oracle\/fra\/RMANDB\/autobackup\/2021_04_09\/o1_mf_s_1069389257_j700vt63_.bkp comment=NONE\nFinished Control File and SPFILE Autobackup at 2021-04-09:04:34:20\n<\/pre><\/div>\n\n\n
Disparando backup do banco de dados como image copy:<\/p>\n\n\n
\nRMAN> BACKUP AS COPY DATABASE TAG 'DB_FULL_CP';\n \nStarting backup at 2021-04-09:04:37:57\nusing channel ORA_DISK_1\nchannel ORA_DISK_1: starting datafile copy\ninput datafile file number=00001 name=\/oracle\/dados\/RMANDB\/datafile\/o1_mf_system_h8nynqfx_.dbf\noutput file name=\/oracle\/fra\/RMANDB\/datafile\/o1_mf_system_j7012ook_.dbf tag=DB_FULL_CP RECID=38 STAMP=1069389517\nchannel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:45\nchannel ORA_DISK_1: starting datafile copy\ninput datafile file number=00003 name=\/oracle\/dados\/RMANDB\/datafile\/o1_mf_sysaux_h8nyq35q_.dbf\noutput file name=\/oracle\/fra\/RMANDB\/datafile\/o1_mf_sysaux_j70142vo_.dbf tag=DB_FULL_CP RECID=39 STAMP=1069389555\nchannel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:35\nchannel ORA_DISK_1: starting datafile copy\ninput datafile file number=00004 name=\/oracle\/dados\/RMANDB\/datafile\/o1_mf_undotbs1_h8nyrjdr_.dbf\noutput file name=\/oracle\/fra\/RMANDB\/datafile\/o1_mf_undotbs1_j701561x_.dbf tag=DB_FULL_CP RECID=40 STAMP=1069389580\nchannel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:25\nchannel ORA_DISK_1: starting datafile copy\ninput datafile file number=00005 name=\/oracle\/dados\/RMANDB\/datafile\/ts_cortex_catalog.dbf\noutput file name=\/oracle\/fra\/RMANDB\/datafile\/o1_mf_ts_corte_j7015z6l_.dbf tag=DB_FULL_CP RECID=41 STAMP=1069389593\nchannel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:15\nchannel ORA_DISK_1: starting datafile copy\ninput datafile file number=00007 name=\/oracle\/dados\/RMANDB\/datafile\/o1_mf_users_h8nyrkn7_.dbf\noutput file name=\/oracle\/fra\/RMANDB\/datafile\/o1_mf_users_j7016gbr_.dbf tag=DB_FULL_CP RECID=42 STAMP=1069389598\nchannel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:01\nFinished backup at 2021-04-09:04:39:59\n \nStarting Control File and SPFILE Autobackup at 2021-04-09:04:39:59\npiece handle=\/oracle\/fra\/RMANDB\/autobackup\/2021_04_09\/o1_mf_s_1069389599_j7016hx3_.bkp comment=NONE\nFinished Control File and SPFILE Autobackup at 2021-04-09:04:40:00\n<\/pre><\/div>\n\n\n
Backup dos archive logs:<\/p>\n\n\n
\nRMAN> BACKUP ARCHIVELOG ALL TAG 'ARC_BS';\n \nStarting backup at 2021-04-09:04:43:00\ncurrent log archived\nusing channel ORA_DISK_1\nchannel ORA_DISK_1: starting archived log backup set\nchannel ORA_DISK_1: specifying archived log(s) in backup set\ninput archived log thread=1 sequence=67 RECID=74 STAMP=1068374400\ninput archived log thread=1 sequence=68 RECID=75 STAMP=1069389781\nchannel ORA_DISK_1: starting piece 1 at 2021-04-09:04:43:02\nchannel ORA_DISK_1: finished piece 1 at 2021-04-09:04:43:05\npiece handle=\/oracle\/fra\/RMANDB\/backupset\/2021_04_09\/o1_mf_annnn_ARC_BS_j701d662_.bkp tag=ARC_BS comment=NONE\nchannel ORA_DISK_1: backup set complete, elapsed time: 00:00:03\nFinished backup at 2021-04-09:04:43:05\n \nStarting Control File and SPFILE Autobackup at 2021-04-09:04:43:05\npiece handle=\/oracle\/fra\/RMANDB\/autobackup\/2021_04_09\/o1_mf_s_1069389785_j701d9kj_.bkp comment=NONE\nFinished Control File and SPFILE Autobackup at 2021-04-09:04:43:06\n<\/pre><\/div>\n\n\n
Backup dos archive logs como image copy:<\/p>\n\n\n
\nRMAN> BACKUP AS COPY ARCHIVELOG ALL;\n \nStarting backup at 2021-04-09:04:49:50\ncurrent log archived\nusing channel ORA_DISK_1\nskipping archived logs of thread 1 from sequence 67 to 68; already backed up\nchannel ORA_DISK_1: starting archived log copy\ninput archived log thread=1 sequence=69 RECID=76 STAMP=1069390190\noutput file name=\/oracle\/fra\/RMANDB\/archivelog\/2021_04_09\/o1_mf_1_69_j701rz69_.arc RECID=77 STAMP=1069390191\nchannel ORA_DISK_1: archived log copy complete, elapsed time: 00:00:01\nFinished backup at 2021-04-09:04:49:52\n \nStarting Control File and SPFILE Autobackup at 2021-04-09:04:49:52\npiece handle=\/oracle\/fra\/RMANDB\/autobackup\/2021_04_09\/o1_mf_s_1069390192_j701s0pz_.bkp comment=NONE\nFinished Control File and SPFILE Autobackup at 2021-04-09:04:49:53\n<\/pre><\/div>\n\n\n
O comando abaixo apresenta os backupsets gerados no ambiente:<\/p>\n\n\n
\nRMAN> LIST BACKUP;\n \n \nList of Backup Sets\n===================\n \n \nBS Key  Type LV Size       Device Type Elapsed Time Completion Time\n------- ---- -- ---------- ----------- ------------ -------------------\n154     Full    1.23G      DISK        00:00:58     2021-04-09:04:32:03\n        BP Key: 154   Status: AVAILABLE  Compressed: NO  Tag: DB_FULL_BS\n        Piece Name: \/oracle\/fra\/RMANDB\/backupset\/2021_04_09\/o1_mf_nnndf_DB_FULL_BS_j700oxtx_.bkp\n  List of Datafiles in backup set 154\n  File LV Type Ckp SCN    Ckp Time            Abs Fuz SCN Sparse Name\n  ---- -- ---- ---------- ------------------- ----------- ------ ----\n  1       Full 2260904    2021-04-09:04:31:05              NO    \/oracle\/dados\/RMANDB\/datafile\/o1_mf_system_h8nynqfx_.dbf\n  3       Full 2260904    2021-04-09:04:31:05              NO    \/oracle\/dados\/RMANDB\/datafile\/o1_mf_sysaux_h8nyq35q_.dbf\n  4       Full 2260904    2021-04-09:04:31:05              NO    \/oracle\/dados\/RMANDB\/datafile\/o1_mf_undotbs1_h8nyrjdr_.dbf\n  5       Full 2260904    2021-04-09:04:31:05              NO    \/oracle\/dados\/RMANDB\/datafile\/ts_cortex_catalog.dbf\n  7       Full 2260904    2021-04-09:04:31:05              NO    \/oracle\/dados\/RMANDB\/datafile\/o1_mf_users_h8nyrkn7_.dbf\n \nBS Key  Type LV Size       Device Type Elapsed Time Completion Time\n------- ---- -- ---------- ----------- ------------ -------------------\n155     Full    10.52M     DISK        00:00:01     2021-04-09:04:32:22\n        BP Key: 155   Status: AVAILABLE  Compressed: NO  Tag: TAG20210409T043221\n        Piece Name: \/oracle\/fra\/RMANDB\/autobackup\/2021_04_09\/o1_mf_s_1069389141_j700r62m_.bkp\n  SPFILE Included: Modification time: 2021-04-09:04:17:52\n  SPFILE db_unique_name: RMANDB\n  Control File Included: Ckp SCN: 2261675      Ckp time: 2021-04-09:04:32:21\n \nBS Key  Type LV Size       Device Type Elapsed Time Completion Time\n------- ---- -- ---------- ----------- ------------ -------------------\n156     Full    2.16M      DISK        00:00:00     2021-04-09:04:34:09\n        BP Key: 156   Status: AVAILABLE  Compressed: NO  Tag: USERS_BS\n        Piece Name: \/oracle\/fra\/RMANDB\/backupset\/2021_04_09\/o1_mf_nnndf_USERS_BS_j700vk1w_.bkp\n  List of Datafiles in backup set 156\n  File LV Type Ckp SCN    Ckp Time            Abs Fuz SCN Sparse Name\n  ---- -- ---- ---------- ------------------- ----------- ------ ----\n  7       Full 2261773    2021-04-09:04:34:09              NO    \/oracle\/dados\/RMANDB\/datafile\/o1_mf_users_h8nyrkn7_.dbf\n \nBS Key  Type LV Size       Device Type Elapsed Time Completion Time\n------- ---- -- ---------- ----------- ------------ -------------------\n157     Full    10.52M     DISK        00:00:00     2021-04-09:04:34:10\n        BP Key: 157   Status: AVAILABLE  Compressed: NO  Tag: TAG20210409T043410\n        Piece Name: \/oracle\/fra\/RMANDB\/autobackup\/2021_04_09\/o1_mf_s_1069389250_j700vlmc_.bkp\n  SPFILE Included: Modification time: 2021-04-09:04:17:52\n  SPFILE db_unique_name: RMANDB\n  Control File Included: Ckp SCN: 2261782      Ckp time: 2021-04-09:04:34:10\n \nBS Key  Type LV Size       Device Type Elapsed Time Completion Time\n------- ---- -- ---------- ----------- ------------ -------------------\n158     Full    2.16M      DISK        00:00:00     2021-04-09:04:34:16\n        BP Key: 158   Status: AVAILABLE  Compressed: NO  Tag: USERS_BS\n        Piece Name: \/oracle\/fra\/RMANDB\/backupset\/2021_04_09\/o1_mf_nnndf_USERS_BS_j700vrh3_.bkp\n  List of Datafiles in backup set 158\n  File LV Type Ckp SCN    Ckp Time            Abs Fuz SCN Sparse Name\n  ---- -- ---- ---------- ------------------- ----------- ------ ----\n  7       Full 2261805    2021-04-09:04:34:16              NO    \/oracle\/dados\/RMANDB\/datafile\/o1_mf_users_h8nyrkn7_.dbf\n \nBS Key  Type LV Size       Device Type Elapsed Time Completion Time\n------- ---- -- ---------- ----------- ------------ -------------------\n159     Full    10.52M     DISK        00:00:01     2021-04-09:04:34:18\n        BP Key: 159   Status: AVAILABLE  Compressed: NO  Tag: TAG20210409T043417\n        Piece Name: \/oracle\/fra\/RMANDB\/autobackup\/2021_04_09\/o1_mf_s_1069389257_j700vt63_.bkp\n  SPFILE Included: Modification time: 2021-04-09:04:17:52\n  SPFILE db_unique_name: RMANDB\n  Control File Included: Ckp SCN: 2261815      Ckp time: 2021-04-09:04:34:17\n \nBS Key  Type LV Size       Device Type Elapsed Time Completion Time\n------- ---- -- ---------- ----------- ------------ -------------------\n160     Full    10.52M     DISK        00:00:00     2021-04-09:04:39:59\n        BP Key: 160   Status: AVAILABLE  Compressed: NO  Tag: TAG20210409T043959\n        Piece Name: \/oracle\/fra\/RMANDB\/autobackup\/2021_04_09\/o1_mf_s_1069389599_j7016hx3_.bkp\n  SPFILE Included: Modification time: 2021-04-09:04:17:52\n  SPFILE db_unique_name: RMANDB\n  Control File Included: Ckp SCN: 2262018      Ckp time: 2021-04-09:04:39:59\n \nBS Key  Size       Device Type Elapsed Time Completion Time\n------- ---------- ----------- ------------ -------------------\n161     71.87M     DISK        00:00:00     2021-04-09:04:43:02\n        BP Key: 161   Status: AVAILABLE  Compressed: NO  Tag: ARC_BS\n        Piece Name: \/oracle\/fra\/RMANDB\/backupset\/2021_04_09\/o1_mf_annnn_ARC_BS_j701d662_.bkp\n \n  List of Archived Logs in backup set 161\n  Thrd Seq     Low SCN    Low Time            Next SCN   Next Time\n  ---- ------- ---------- ------------------- ---------- ---------\n  1    67      2245574    2021-03-27:05:26:16 2255756    2021-03-28:10:39:58\n  1    68      2255756    2021-03-28:10:39:58 2262113    2021-04-09:04:43:00\n \nBS Key  Type LV Size       Device Type Elapsed Time Completion Time\n------- ---- -- ---------- ----------- ------------ -------------------\n162     Full    10.52M     DISK        00:00:00     2021-04-09:04:43:05\n        BP Key: 162   Status: AVAILABLE  Compressed: NO  Tag: TAG20210409T044305\n        Piece Name: \/oracle\/fra\/RMANDB\/autobackup\/2021_04_09\/o1_mf_s_1069389785_j701d9kj_.bkp\n  SPFILE Included: Modification time: 2021-04-09:04:17:52\n  SPFILE db_unique_name: RMANDB\n  Control File Included: Ckp SCN: 2262164      Ckp time: 2021-04-09:04:43:05\n \nBS Key  Type LV Size       Device Type Elapsed Time Completion Time\n------- ---- -- ---------- ----------- ------------ -------------------\n163     Full    10.52M     DISK        00:00:00     2021-04-09:04:49:52\n        BP Key: 163   Status: AVAILABLE  Compressed: NO  Tag: TAG20210409T044952\n        Piece Name: \/oracle\/fra\/RMANDB\/autobackup\/2021_04_09\/o1_mf_s_1069390192_j701s0pz_.bkp\n  SPFILE Included: Modification time: 2021-04-09:04:17:52\n  SPFILE db_unique_name: RMANDB\n  Control File Included: Ckp SCN: 2262521      Ckp time: 2021-04-09:04:49:52\n<\/pre><\/div>\n\n\n
Para termos um formato mais palat\u00e1vel, podemos usar o SUMMARY conforme exemplo abaixo:<\/p>\n\n\n
\nRMAN> LIST BACKUP SUMMARY;\n \n \nList of Backups\n===============\nKey     TY LV S Device Type Completion Time     #Pieces #Copies Compressed Tag\n------- -- -- - ----------- ------------------- ------- ------- ---------- ---\n154     B  F  A DISK        2021-04-09:04:32:03 1       1       NO         DB_FULL_BS\n155     B  F  A DISK        2021-04-09:04:32:22 1       1       NO         TAG20210409T043221\n156     B  F  A DISK        2021-04-09:04:34:09 1       1       NO         USERS_BS\n157     B  F  A DISK        2021-04-09:04:34:10 1       1       NO         TAG20210409T043410\n158     B  F  A DISK        2021-04-09:04:34:16 1       1       NO         USERS_BS\n159     B  F  A DISK        2021-04-09:04:34:18 1       1       NO         TAG20210409T043417\n160     B  F  A DISK        2021-04-09:04:39:59 1       1       NO         TAG20210409T043959\n161     B  A  A DISK        2021-04-09:04:43:02 1       1       NO         ARC_BS\n162     B  F  A DISK        2021-04-09:04:43:05 1       1       NO         TAG20210409T044305\n163     B  F  A DISK        2021-04-09:04:49:52 1       1       NO         TAG20210409T044952\n<\/pre><\/div>\n\n\n
Podemos listar os backups do banco de dados:<\/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------- ---- -- ---------- ----------- ------------ -------------------\n154     Full    1.23G      DISK        00:00:58     2021-04-09:04:32:03\n        BP Key: 154   Status: AVAILABLE  Compressed: NO  Tag: DB_FULL_BS\n        Piece Name: \/oracle\/fra\/RMANDB\/backupset\/2021_04_09\/o1_mf_nnndf_DB_FULL_BS_j700oxtx_.bkp\n  List of Datafiles in backup set 154\n  File LV Type Ckp SCN    Ckp Time            Abs Fuz SCN Sparse Name\n  ---- -- ---- ---------- ------------------- ----------- ------ ----\n  1       Full 2260904    2021-04-09:04:31:05              NO    \/oracle\/dados\/RMANDB\/datafile\/o1_mf_system_h8nynqfx_.dbf\n  3       Full 2260904    2021-04-09:04:31:05              NO    \/oracle\/dados\/RMANDB\/datafile\/o1_mf_sysaux_h8nyq35q_.dbf\n  4       Full 2260904    2021-04-09:04:31:05              NO    \/oracle\/dados\/RMANDB\/datafile\/o1_mf_undotbs1_h8nyrjdr_.dbf\n  5       Full 2260904    2021-04-09:04:31:05              NO    \/oracle\/dados\/RMANDB\/datafile\/ts_cortex_catalog.dbf\n  7       Full 2260904    2021-04-09:04:31:05              NO    \/oracle\/dados\/RMANDB\/datafile\/o1_mf_users_h8nyrkn7_.dbf\n \nBS Key  Type LV Size       Device Type Elapsed Time Completion Time\n------- ---- -- ---------- ----------- ------------ -------------------\n156     Full    2.16M      DISK        00:00:00     2021-04-09:04:34:09\n        BP Key: 156   Status: AVAILABLE  Compressed: NO  Tag: USERS_BS\n        Piece Name: \/oracle\/fra\/RMANDB\/backupset\/2021_04_09\/o1_mf_nnndf_USERS_BS_j700vk1w_.bkp\n  List of Datafiles in backup set 156\n  File LV Type Ckp SCN    Ckp Time            Abs Fuz SCN Sparse Name\n  ---- -- ---- ---------- ------------------- ----------- ------ ----\n  7       Full 2261773    2021-04-09:04:34:09              NO    \/oracle\/dados\/RMANDB\/datafile\/o1_mf_users_h8nyrkn7_.dbf\n \nBS Key  Type LV Size       Device Type Elapsed Time Completion Time\n------- ---- -- ---------- ----------- ------------ -------------------\n158     Full    2.16M      DISK        00:00:00     2021-04-09:04:34:16\n        BP Key: 158   Status: AVAILABLE  Compressed: NO  Tag: USERS_BS\n        Piece Name: \/oracle\/fra\/RMANDB\/backupset\/2021_04_09\/o1_mf_nnndf_USERS_BS_j700vrh3_.bkp\n  List of Datafiles in backup set 158\n  File LV Type Ckp SCN    Ckp Time            Abs Fuz SCN Sparse Name\n  ---- -- ---- ---------- ------------------- ----------- ------ ----\n  7       Full 2261805    2021-04-09:04:34:16              NO    \/oracle\/dados\/RMANDB\/datafile\/o1_mf_users_h8nyrkn7_.dbf\n<\/pre><\/div>\n\n\n
Exibindo os backups do tipo image copy:<\/p>\n\n\n
\nRMAN> LIST COPY;\n \nspecification does not match any control file copy in the repository\nList of Datafile Copies\n=======================\n \nKey     File S Completion Time     Ckp SCN    Ckp Time            Sparse\n------- ---- - ------------------- ---------- ------------------- ------\n38      1    A 2021-04-09:04:38:37 2261947    2021-04-09:04:37:57 NO\n        Name: \/oracle\/fra\/RMANDB\/datafile\/o1_mf_system_j7012ook_.dbf\n        Tag: DB_FULL_CP\n \n39      3    A 2021-04-09:04:39:15 2261976    2021-04-09:04:38:42 NO\n        Name: \/oracle\/fra\/RMANDB\/datafile\/o1_mf_sysaux_j70142vo_.dbf\n        Tag: DB_FULL_CP\n \n40      4    A 2021-04-09:04:39:40 2261992    2021-04-09:04:39:18 NO\n        Name: \/oracle\/fra\/RMANDB\/datafile\/o1_mf_undotbs1_j701561x_.dbf\n        Tag: DB_FULL_CP\n \n41      5    A 2021-04-09:04:39:53 2262002    2021-04-09:04:39:43 NO\n        Name: \/oracle\/fra\/RMANDB\/datafile\/o1_mf_ts_corte_j7015z6l_.dbf\n        Tag: DB_FULL_CP\n \n42      7    A 2021-04-09:04:39:58 2262009    2021-04-09:04:39:58 NO\n        Name: \/oracle\/fra\/RMANDB\/datafile\/o1_mf_users_j7016gbr_.dbf\n        Tag: DB_FULL_CP\n \nList of Archived Log Copies for database with db_unique_name RMANDB\n=====================================================================\n \nKey     Thrd Seq     S Low Time\n------- ---- ------- - -------------------\n74      1    67      A 2021-03-27:05:26:16\n        Name: \/oracle\/archives\/1_67_1036964654.dbf\n \n75      1    68      A 2021-03-28:10:39:58\n        Name: \/oracle\/archives\/1_68_1036964654.dbf\n \n77      1    69      A 2021-04-09:04:43:00\n        Name: \/oracle\/fra\/RMANDB\/archivelog\/2021_04_09\/o1_mf_1_69_j701rz69_.arc\n \n76      1    69      A 2021-04-09:04:43:00\n        Name: \/oracle\/archives\/1_69_1036964654.dbf\n<\/pre><\/div>\n\n\n
Exibir os backupsets que comp\u00f5em o backup da tablespace USERS:<\/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------- ---- -- ---------- ----------- ------------ -------------------\n154     Full    1.23G      DISK        00:00:58     2021-04-09:04:32:03\n        BP Key: 154   Status: AVAILABLE  Compressed: NO  Tag: DB_FULL_BS\n        Piece Name: \/oracle\/fra\/RMANDB\/backupset\/2021_04_09\/o1_mf_nnndf_DB_FULL_BS_j700oxtx_.bkp\n  List of Datafiles in backup set 154\n  File LV Type Ckp SCN    Ckp Time            Abs Fuz SCN Sparse Name\n  ---- -- ---- ---------- ------------------- ----------- ------ ----\n  7       Full 2260904    2021-04-09:04:31:05              NO    \/oracle\/dados\/RMANDB\/datafile\/o1_mf_users_h8nyrkn7_.dbf\n \nBS Key  Type LV Size       Device Type Elapsed Time Completion Time\n------- ---- -- ---------- ----------- ------------ -------------------\n156     Full    2.16M      DISK        00:00:00     2021-04-09:04:34:09\n        BP Key: 156   Status: AVAILABLE  Compressed: NO  Tag: USERS_BS\n        Piece Name: \/oracle\/fra\/RMANDB\/backupset\/2021_04_09\/o1_mf_nnndf_USERS_BS_j700vk1w_.bkp\n  List of Datafiles in backup set 156\n  File LV Type Ckp SCN    Ckp Time            Abs Fuz SCN Sparse Name\n  ---- -- ---- ---------- ------------------- ----------- ------ ----\n  7       Full 2261773    2021-04-09:04:34:09              NO    \/oracle\/dados\/RMANDB\/datafile\/o1_mf_users_h8nyrkn7_.dbf\n \nBS Key  Type LV Size       Device Type Elapsed Time Completion Time\n------- ---- -- ---------- ----------- ------------ -------------------\n158     Full    2.16M      DISK        00:00:00     2021-04-09:04:34:16\n        BP Key: 158   Status: AVAILABLE  Compressed: NO  Tag: USERS_BS\n        Piece Name: \/oracle\/fra\/RMANDB\/backupset\/2021_04_09\/o1_mf_nnndf_USERS_BS_j700vrh3_.bkp\n  List of Datafiles in backup set 158\n  File LV Type Ckp SCN    Ckp Time            Abs Fuz SCN Sparse Name\n  ---- -- ---- ---------- ------------------- ----------- ------ ----\n  7       Full 2261805    2021-04-09:04:34:16              NO    \/oracle\/dados\/RMANDB\/datafile\/o1_mf_users_h8nyrkn7_.dbf\n<\/pre><\/div>\n\n\n
Image copies com o backup da tablespace USERS:<\/p>\n\n\n
\nRMAN> LIST COPY OF TABLESPACE USERS;\n \nList of Datafile Copies\n=======================\n \nKey     File S Completion Time     Ckp SCN    Ckp Time            Sparse\n------- ---- - ------------------- ---------- ------------------- ------\n42      7    A 2021-04-09:04:39:58 2262009    2021-04-09:04:39:58 NO\n        Name: \/oracle\/fra\/RMANDB\/datafile\/o1_mf_users_j7016gbr_.dbf\n        Tag: DB_FULL_CP\n<\/pre><\/div>\n\n\n
Backupsets filtrados por tag:<\/p>\n\n\n
\nRMAN> LIST BACKUPSET TAG 'ARC_BS';\n \n \nList of Backup Sets\n===================\n \n \nBS Key  Size       Device Type Elapsed Time Completion Time\n------- ---------- ----------- ------------ -------------------\n161     71.87M     DISK        00:00:00     2021-04-09:04:43:02\n        BP Key: 161   Status: AVAILABLE  Compressed: NO  Tag: ARC_BS\n        Piece Name: \/oracle\/fra\/RMANDB\/backupset\/2021_04_09\/o1_mf_annnn_ARC_BS_j701d662_.bkp\n \n  List of Archived Logs in backup set 161\n  Thrd Seq     Low SCN    Low Time            Next SCN   Next Time\n  ---- ------- ---------- ------------------- ---------- ---------\n  1    67      2245574    2021-03-27:05:26:16 2255756    2021-03-28:10:39:58\n  1    68      2255756    2021-03-28:10:39:58 2262113    2021-04-09:04:43:00\n<\/pre><\/div>\n\n\n
Listando todos os archive logs:<\/p>\n\n\n
\nRMAN> LIST ARCHIVELOG ALL;\n \nList of Archived Log Copies for database with db_unique_name RMANDB\n=====================================================================\n \nKey     Thrd Seq     S Low Time\n------- ---- ------- - -------------------\n74      1    67      A 2021-03-27:05:26:16\n        Name: \/oracle\/archives\/1_67_1036964654.dbf\n \n75      1    68      A 2021-03-28:10:39:58\n        Name: \/oracle\/archives\/1_68_1036964654.dbf\n \n77      1    69      A 2021-04-09:04:43:00\n        Name: \/oracle\/fra\/RMANDB\/archivelog\/2021_04_09\/o1_mf_1_69_j701rz69_.arc\n \n76      1    69      A 2021-04-09:04:43:00\n        Name: \/oracle\/archives\/1_69_1036964654.dbf\n<\/pre><\/div>\n\n\n
Exibindo archive logs gerados nas \u00faltimas 24 horas:<\/p>\n\n\n
\nRMAN> LIST ARCHIVELOG TIME BETWEEN 'SYSDATE-1' AND 'SYSDATE';\n \nList of Archived Log Copies for database with db_unique_name RMANDB\n=====================================================================\n \nKey     Thrd Seq     S Low Time\n------- ---- ------- - -------------------\n75      1    68      A 2021-03-28:10:39:58\n        Name: \/oracle\/archives\/1_68_1036964654.dbf\n \n77      1    69      A 2021-04-09:04:43:00\n        Name: \/oracle\/fra\/RMANDB\/archivelog\/2021_04_09\/o1_mf_1_69_j701rz69_.arc\n \n76      1    69      A 2021-04-09:04:43:00\n        Name: \/oracle\/archives\/1_69_1036964654.dbf\n<\/pre><\/div>\n\n\n
Usando SEQUENCE como filtro:<\/p>\n\n\n
\nRMAN> LIST ARCHIVELOG SEQUENCE BETWEEN 67 and 68;\n \nList of Archived Log Copies for database with db_unique_name RMANDB\n=====================================================================\n \nKey     Thrd Seq     S Low Time\n------- ---- ------- - -------------------\n74      1    67      A 2021-03-27:05:26:16\n        Name: \/oracle\/archives\/1_67_1036964654.dbf\n \n75      1    68      A 2021-03-28:10:39:58\n        Name: \/oracle\/archives\/1_68_1036964654.dbf\n<\/pre><\/div>\n\n\n
Listando os backups dos archive logs (como backupset):<\/p>\n\n\n
\nRMAN> LIST BACKUP OF ARCHIVELOG ALL;\n \n \nList of Backup Sets\n===================\n \n \nBS Key  Size       Device Type Elapsed Time Completion Time\n------- ---------- ----------- ------------ -------------------\n161     71.87M     DISK        00:00:00     2021-04-09:04:43:02\n        BP Key: 161   Status: AVAILABLE  Compressed: NO  Tag: ARC_BS\n        Piece Name: \/oracle\/fra\/RMANDB\/backupset\/2021_04_09\/o1_mf_annnn_ARC_BS_j701d662_.bkp\n \n  List of Archived Logs in backup set 161\n  Thrd Seq     Low SCN    Low Time            Next SCN   Next Time\n  ---- ------- ---------- ------------------- ---------- ---------\n  1    67      2245574    2021-03-27:05:26:16 2255756    2021-03-28:10:39:58\n  1    68      2255756    2021-03-28:10:39:58 2262113    2021-04-09:04:43:00\n<\/pre><\/div>\n\n\n
Backups de archive log gerados nas \u00faltimas 24 horas:<\/p>\n\n\n
\nRMAN> LIST BACKUP OF ARCHIVELOG TIME BETWEEN 'SYSDATE-1' AND 'SYSDATE';\n \n \nList of Backup Sets\n===================\n \n \nBS Key  Size       Device Type Elapsed Time Completion Time\n------- ---------- ----------- ------------ -------------------\n161     71.87M     DISK        00:00:00     2021-04-09:04:43:02\n        BP Key: 161   Status: AVAILABLE  Compressed: NO  Tag: ARC_BS\n        Piece Name: \/oracle\/fra\/RMANDB\/backupset\/2021_04_09\/o1_mf_annnn_ARC_BS_j701d662_.bkp\n \n  List of Archived Logs in backup set 161\n  Thrd Seq     Low SCN    Low Time            Next SCN   Next Time\n  ---- ------- ---------- ------------------- ---------- ---------\n  1    68      2255756    2021-03-28:10:39:58 2262113    2021-04-09:04:43:00\n<\/pre><\/div>\n\n\n
Obs: 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":"
O comando LIST nos auxilia a extrair diversas informa\u00e7\u00f5es sobre os nossos backups do RMAN. Para simular o seu uso, dispararemos uma por\u00e7\u00e3o de backups abaixo para utilizar o comando posteriormente. Ajustando pol\u00edtica de redund\u00e2ncia do RMAN: Realizando backup do banco como backupset: Executando o backup da tablespace USERS 2 vezes: Disparando backup do banco […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-3605","post","type-post","status-publish","format-standard","hentry","category-backup-recovery"],"_links":{"self":[{"href":"https:\/\/swiv.com.br\/index.php\/wp-json\/wp\/v2\/posts\/3605","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=3605"}],"version-history":[{"count":1,"href":"https:\/\/swiv.com.br\/index.php\/wp-json\/wp\/v2\/posts\/3605\/revisions"}],"predecessor-version":[{"id":9184,"href":"https:\/\/swiv.com.br\/index.php\/wp-json\/wp\/v2\/posts\/3605\/revisions\/9184"}],"wp:attachment":[{"href":"https:\/\/swiv.com.br\/index.php\/wp-json\/wp\/v2\/media?parent=3605"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/swiv.com.br\/index.php\/wp-json\/wp\/v2\/categories?post=3605"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/swiv.com.br\/index.php\/wp-json\/wp\/v2\/tags?post=3605"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}