{"id":2686,"date":"2021-03-15T14:10:39","date_gmt":"2021-03-15T14:10:39","guid":{"rendered":"https:\/\/swiv.com.br\/backing-up-archived-redo-logs\/"},"modified":"2026-05-27T20:02:50","modified_gmt":"2026-05-27T19:02:50","slug":"backing-up-archived-redo-logs","status":"publish","type":"post","link":"https:\/\/swiv.com.br\/index.php\/2021\/03\/15\/backing-up-archived-redo-logs\/","title":{"rendered":"Backing Up Archived Redo Logs"},"content":{"rendered":"\n

Realizando o backup de todos os archived logs (como backupset e copy image):<\/p>\n\n\n

\n[oracle@oel8 ~]$ rman target \/\n \nRecovery Manager: Release 18.0.0.0.0 - Production on Mon Mar 15 10:37:19 2021\nVersion 18.3.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> BACKUP ARCHIVELOG ALL;\n \nStarting backup at 2021-03-15:10:40:59\ncurrent log archived\nusing target database control file instead of recovery catalog\nallocated channel: ORA_DISK_1\nchannel ORA_DISK_1: SID=71 device type=DISK\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=12 RECID=1 STAMP=1036965361\ninput archived log thread=1 sequence=13 RECID=2 STAMP=1039373324\ninput archived log thread=1 sequence=14 RECID=3 STAMP=1039385578\ninput archived log thread=1 sequence=15 RECID=4 STAMP=1039730500\ninput archived log thread=1 sequence=16 RECID=5 STAMP=1039730621\ninput archived log thread=1 sequence=17 RECID=6 STAMP=1039730703\ninput archived log thread=1 sequence=18 RECID=7 STAMP=1041720392\ninput archived log thread=1 sequence=19 RECID=8 STAMP=1065592715\ninput archived log thread=1 sequence=20 RECID=9 STAMP=1065710266\ninput archived log thread=1 sequence=21 RECID=10 STAMP=1065714954\ninput archived log thread=1 sequence=22 RECID=11 STAMP=1065717962\ninput archived log thread=1 sequence=23 RECID=12 STAMP=1066831250\ninput archived log thread=1 sequence=24 RECID=13 STAMP=1066972921\ninput archived log thread=1 sequence=25 RECID=14 STAMP=1066977292\ninput archived log thread=1 sequence=26 RECID=15 STAMP=1066977317\ninput archived log thread=1 sequence=27 RECID=16 STAMP=1067251262\nchannel ORA_DISK_1: starting piece 1 at 2021-03-15:10:41:04\nchannel ORA_DISK_1: finished piece 1 at 2021-03-15:10:41:39\npiece handle=\/oracle\/fra\/RMANDB\/backupset\/2021_03_15\/o1_mf_annnn_TAG20210315T104104_j4yrzjob_.bkp tag=TAG20210315T104104 comment=NONE\nchannel ORA_DISK_1: backup set complete, elapsed time: 00:00:35\nFinished backup at 2021-03-15:10:41:39\n \nStarting Control File and SPFILE Autobackup at 2021-03-15:10:41:39\npiece handle=\/oracle\/fra\/RMANDB\/autobackup\/2021_03_15\/o1_mf_s_1067251299_j4ys0nyo_.bkp comment=NONE\nFinished Control File and SPFILE Autobackup at 2021-03-15:10:41:42\n \nRMAN>\n<\/pre><\/div>\n\n
\nRMAN> BACKUP AS COPY ARCHIVELOG ALL;\n \nStarting backup at 2021-03-15:10:42:35\ncurrent log archived\nusing channel ORA_DISK_1\nchannel ORA_DISK_1: starting archived log copy\ninput archived log thread=1 sequence=20 RECID=9 STAMP=1065710266\noutput file name=\/oracle\/fra\/RMANDB\/archivelog\/2021_03_15\/o1_mf_1_20_j4ys2cvs_.arc RECID=18 STAMP=1067251357\nchannel ORA_DISK_1: archived log copy complete, elapsed time: 00:00:03\nchannel ORA_DISK_1: starting archived log copy\ninput archived log thread=1 sequence=18 RECID=7 STAMP=1041720392\noutput file name=\/oracle\/fra\/RMANDB\/archivelog\/2021_03_15\/o1_mf_1_18_j4ys2gyj_.arc RECID=19 STAMP=1067251360\nchannel ORA_DISK_1: archived log copy complete, elapsed time: 00:00:03\nchannel ORA_DISK_1: starting archived log copy\ninput archived log thread=1 sequence=19 RECID=8 STAMP=1065592715\noutput file name=\/oracle\/fra\/RMANDB\/archivelog\/2021_03_15\/o1_mf_1_19_j4ys2l37_.arc RECID=20 STAMP=1067251363\nchannel ORA_DISK_1: archived log copy complete, elapsed time: 00:00:03\nchannel ORA_DISK_1: starting archived log copy\ninput archived log thread=1 sequence=15 RECID=4 STAMP=1039730500\noutput file name=\/oracle\/fra\/RMANDB\/archivelog\/2021_03_15\/o1_mf_1_15_j4ys2o7s_.arc RECID=21 STAMP=1067251366\nchannel ORA_DISK_1: archived log copy complete, elapsed time: 00:00:03\nchannel ORA_DISK_1: starting archived log copy\ninput archived log thread=1 sequence=12 RECID=1 STAMP=1036965361\noutput file name=\/oracle\/fra\/RMANDB\/archivelog\/2021_03_15\/o1_mf_1_12_j4ys2rq4_.arc RECID=22 STAMP=1067251370\nchannel ORA_DISK_1: archived log copy complete, elapsed time: 00:00:03\nchannel ORA_DISK_1: starting archived log copy\ninput archived log thread=1 sequence=23 RECID=12 STAMP=1066831250\noutput file name=\/oracle\/fra\/RMANDB\/archivelog\/2021_03_15\/o1_mf_1_23_j4ys2vt1_.arc RECID=23 STAMP=1067251373\nchannel ORA_DISK_1: archived log copy complete, elapsed time: 00:00:03\nchannel ORA_DISK_1: starting archived log copy\ninput archived log thread=1 sequence=22 RECID=11 STAMP=1065717962\noutput file name=\/oracle\/fra\/RMANDB\/archivelog\/2021_03_15\/o1_mf_1_22_j4ys2z32_.arc RECID=24 STAMP=1067251376\nchannel ORA_DISK_1: archived log copy complete, elapsed time: 00:00:03\nchannel ORA_DISK_1: starting archived log copy\ninput archived log thread=1 sequence=17 RECID=6 STAMP=1039730703\noutput file name=\/oracle\/fra\/RMANDB\/archivelog\/2021_03_15\/o1_mf_1_17_j4ys32g6_.arc RECID=25 STAMP=1067251380\nchannel ORA_DISK_1: archived log copy complete, elapsed time: 00:00:03\nchannel ORA_DISK_1: starting archived log copy\ninput archived log thread=1 sequence=14 RECID=3 STAMP=1039385578\noutput file name=\/oracle\/fra\/RMANDB\/archivelog\/2021_03_15\/o1_mf_1_14_j4ys35g5_.arc RECID=26 STAMP=1067251382\nchannel ORA_DISK_1: archived log copy complete, elapsed time: 00:00:03\nchannel ORA_DISK_1: starting archived log copy\ninput archived log thread=1 sequence=16 RECID=5 STAMP=1039730621\noutput file name=\/oracle\/fra\/RMANDB\/archivelog\/2021_03_15\/o1_mf_1_16_j4ys38ml_.arc RECID=27 STAMP=1067251386\nchannel ORA_DISK_1: archived log copy complete, elapsed time: 00:00:03\nchannel ORA_DISK_1: starting archived log copy\ninput archived log thread=1 sequence=21 RECID=10 STAMP=1065714954\noutput file name=\/oracle\/fra\/RMANDB\/archivelog\/2021_03_15\/o1_mf_1_21_j4ys3crh_.arc RECID=28 STAMP=1067251389\nchannel ORA_DISK_1: archived log copy complete, elapsed time: 00:00:03\nchannel ORA_DISK_1: starting archived log copy\ninput archived log thread=1 sequence=27 RECID=16 STAMP=1067251262\noutput file name=\/oracle\/fra\/RMANDB\/archivelog\/2021_03_15\/o1_mf_1_27_j4ys3gvm_.arc RECID=29 STAMP=1067251392\nchannel ORA_DISK_1: archived log copy complete, elapsed time: 00:00:03\nchannel ORA_DISK_1: starting archived log copy\ninput archived log thread=1 sequence=13 RECID=2 STAMP=1039373324\noutput file name=\/oracle\/fra\/RMANDB\/archivelog\/2021_03_15\/o1_mf_1_13_j4ys3l2j_.arc RECID=30 STAMP=1067251395\nchannel ORA_DISK_1: archived log copy complete, elapsed time: 00:00:03\nchannel ORA_DISK_1: starting archived log copy\ninput archived log thread=1 sequence=24 RECID=13 STAMP=1066972921\noutput file name=\/oracle\/fra\/RMANDB\/archivelog\/2021_03_15\/o1_mf_1_24_j4ys3o6t_.arc RECID=31 STAMP=1067251397\nchannel ORA_DISK_1: archived log copy complete, elapsed time: 00:00:01\nchannel ORA_DISK_1: starting archived log copy\ninput archived log thread=1 sequence=25 RECID=14 STAMP=1066977292\noutput file name=\/oracle\/fra\/RMANDB\/archivelog\/2021_03_15\/o1_mf_1_25_j4ys3p9r_.arc RECID=32 STAMP=1067251398\nchannel ORA_DISK_1: archived log copy complete, elapsed time: 00:00:01\nchannel ORA_DISK_1: starting archived log copy\ninput archived log thread=1 sequence=26 RECID=15 STAMP=1066977317\noutput file name=\/oracle\/fra\/RMANDB\/archivelog\/2021_03_15\/o1_mf_1_26_j4ys3qgj_.arc RECID=33 STAMP=1067251399\nchannel ORA_DISK_1: archived log copy complete, elapsed time: 00:00:01\nchannel ORA_DISK_1: starting archived log copy\ninput archived log thread=1 sequence=28 RECID=17 STAMP=1067251355\noutput file name=\/oracle\/fra\/RMANDB\/archivelog\/2021_03_15\/o1_mf_1_28_j4ys3rmf_.arc RECID=34 STAMP=1067251400\nchannel ORA_DISK_1: archived log copy complete, elapsed time: 00:00:01\nFinished backup at 2021-03-15:10:43:21\n \nStarting Control File and SPFILE Autobackup at 2021-03-15:10:43:21\npiece handle=\/oracle\/fra\/RMANDB\/autobackup\/2021_03_15\/o1_mf_s_1067251401_j4ys3t95_.bkp comment=NONE\nFinished Control File and SPFILE Autobackup at 2021-03-15:10:43:24\n \nRMAN>\n<\/pre><\/div>\n\n\n
Deletando arquivos de backup:<\/p>\n\n\n
\nRMAN> DELETE BACKUPSET OF ARCHIVELOG ALL;\n \nusing channel ORA_DISK_1\n \nList of Backup Pieces\nBP Key  BS Key  Pc# Cp# Status      Device Type Piece Name\n------- ------- --- --- ----------- ----------- ----------\n37      37      1   1   AVAILABLE   DISK        \/oracle\/fra\/RMANDB\/backupset\/2021_03_15\/o1_mf_annnn_TAG20210315T104104_j4yrzjob_.bkp\n \nDo you really want to delete the above objects (enter YES or NO)? YES\ndeleted backup piece\nbackup piece handle=\/oracle\/fra\/RMANDB\/backupset\/2021_03_15\/o1_mf_annnn_TAG20210315T104104_j4yrzjob_.bkp RECID=37 STAMP=1067251264\nDeleted 1 objects\n \n \nRMAN> DELETE COPY OF ARCHIVELOG ALL;\n \nreleased channel: ORA_DISK_1\nallocated channel: ORA_DISK_1\nchannel ORA_DISK_1: SID=71 device type=DISK\nList of Archived Log Copies for database with db_unique_name RMANDB\n=====================================================================\n \nKey     Thrd Seq     S Low Time\n------- ---- ------- - -------------------\n22      1    12      A 2020-04-05:21:52:19\n        Name: \/oracle\/fra\/RMANDB\/archivelog\/2021_03_15\/o1_mf_1_12_j4ys2rq4_.arc\n \n30      1    13      A 2020-04-05:21:56:00\n        Name: \/oracle\/fra\/RMANDB\/archivelog\/2021_03_15\/o1_mf_1_13_j4ys3l2j_.arc\n \n26      1    14      A 2020-05-02:18:48:42\n        Name: \/oracle\/fra\/RMANDB\/archivelog\/2021_03_15\/o1_mf_1_14_j4ys35g5_.arc\n \n21      1    15      A 2020-05-02:22:12:55\n        Name: \/oracle\/fra\/RMANDB\/archivelog\/2021_03_15\/o1_mf_1_15_j4ys2o7s_.arc\n \n27      1    16      A 2020-05-06:22:01:37\n        Name: \/oracle\/fra\/RMANDB\/archivelog\/2021_03_15\/o1_mf_1_16_j4ys38ml_.arc\n \n25      1    17      A 2020-05-06:22:03:38\n        Name: \/oracle\/fra\/RMANDB\/archivelog\/2021_03_15\/o1_mf_1_17_j4ys32g6_.arc\n \n19      1    18      A 2020-05-06:22:05:00\n        Name: \/oracle\/fra\/RMANDB\/archivelog\/2021_03_15\/o1_mf_1_18_j4ys2gyj_.arc\n \n7       1    18      A 2020-05-06:22:05:00\n        Name: \/oracle\/archives\/1_18_1036964654.dbf\n \n20      1    19      A 2020-05-29:22:46:30\n        Name: \/oracle\/fra\/RMANDB\/archivelog\/2021_03_15\/o1_mf_1_19_j4ys2l37_.arc\n \n8       1    19      A 2020-05-29:22:46:30\n        Name: \/oracle\/archives\/1_19_1036964654.dbf\n \n18      1    20      A 2021-02-27:05:58:32\n        Name: \/oracle\/fra\/RMANDB\/archivelog\/2021_03_15\/o1_mf_1_20_j4ys2cvs_.arc\n \n9       1    20      A 2021-02-27:05:58:32\n        Name: \/oracle\/archives\/1_20_1036964654.dbf\n \n28      1    21      A 2021-02-28:14:37:43\n        Name: \/oracle\/fra\/RMANDB\/archivelog\/2021_03_15\/o1_mf_1_21_j4ys3crh_.arc\n \n10      1    21      A 2021-02-28:14:37:43\n        Name: \/oracle\/archives\/1_21_1036964654.dbf\n \n24      1    22      A 2021-02-28:15:55:52\n        Name: \/oracle\/fra\/RMANDB\/archivelog\/2021_03_15\/o1_mf_1_22_j4ys2z32_.arc\n \n11      1    22      A 2021-02-28:15:55:52\n        Name: \/oracle\/archives\/1_22_1036964654.dbf\n \n23      1    23      A 2021-02-28:16:46:00\n        Name: \/oracle\/fra\/RMANDB\/archivelog\/2021_03_15\/o1_mf_1_23_j4ys2vt1_.arc\n \n12      1    23      A 2021-02-28:16:46:00\n        Name: \/oracle\/archives\/1_23_1036964654.dbf\n \n31      1    24      A 2021-03-10:14:00:47\n        Name: \/oracle\/fra\/RMANDB\/archivelog\/2021_03_15\/o1_mf_1_24_j4ys3o6t_.arc\n \n13      1    24      A 2021-03-10:14:00:47\n        Name: \/oracle\/archives\/1_24_1036964654.dbf\n \n32      1    25      A 2021-03-12:05:21:59\n        Name: \/oracle\/fra\/RMANDB\/archivelog\/2021_03_15\/o1_mf_1_25_j4ys3p9r_.arc\n \n14      1    25      A 2021-03-12:05:21:59\n        Name: \/oracle\/archives\/1_25_1036964654.dbf\n \n33      1    26      A 2021-03-12:06:34:52\n        Name: \/oracle\/fra\/RMANDB\/archivelog\/2021_03_15\/o1_mf_1_26_j4ys3qgj_.arc\n \n15      1    26      A 2021-03-12:06:34:52\n        Name: \/oracle\/archives\/1_26_1036964654.dbf\n \n29      1    27      A 2021-03-12:06:35:17\n        Name: \/oracle\/fra\/RMANDB\/archivelog\/2021_03_15\/o1_mf_1_27_j4ys3gvm_.arc\n \n16      1    27      A 2021-03-12:06:35:17\n        Name: \/oracle\/archives\/1_27_1036964654.dbf\n \n34      1    28      A 2021-03-15:10:40:59\n        Name: \/oracle\/fra\/RMANDB\/archivelog\/2021_03_15\/o1_mf_1_28_j4ys3rmf_.arc\n \n17      1    28      A 2021-03-15:10:40:59\n        Name: \/oracle\/archives\/1_28_1036964654.dbf\n \n \nDo you really want to delete the above objects (enter YES or NO)? YES\ndeleted archived log\narchived log file name=\/oracle\/fra\/RMANDB\/archivelog\/2021_03_15\/o1_mf_1_12_j4ys2rq4_.arc RECID=22 STAMP=1067251370\ndeleted archived log\narchived log file name=\/oracle\/fra\/RMANDB\/archivelog\/2021_03_15\/o1_mf_1_13_j4ys3l2j_.arc RECID=30 STAMP=1067251395\ndeleted archived log\narchived log file name=\/oracle\/fra\/RMANDB\/archivelog\/2021_03_15\/o1_mf_1_14_j4ys35g5_.arc RECID=26 STAMP=1067251382\ndeleted archived log\narchived log file name=\/oracle\/fra\/RMANDB\/archivelog\/2021_03_15\/o1_mf_1_15_j4ys2o7s_.arc RECID=21 STAMP=1067251366\ndeleted archived log\narchived log file name=\/oracle\/fra\/RMANDB\/archivelog\/2021_03_15\/o1_mf_1_16_j4ys38ml_.arc RECID=27 STAMP=1067251386\ndeleted archived log\narchived log file name=\/oracle\/fra\/RMANDB\/archivelog\/2021_03_15\/o1_mf_1_17_j4ys32g6_.arc RECID=25 STAMP=1067251380\ndeleted archived log\narchived log file name=\/oracle\/fra\/RMANDB\/archivelog\/2021_03_15\/o1_mf_1_18_j4ys2gyj_.arc RECID=19 STAMP=1067251360\ndeleted archived log\narchived log file name=\/oracle\/archives\/1_18_1036964654.dbf RECID=7 STAMP=1041720392\ndeleted archived log\narchived log file name=\/oracle\/fra\/RMANDB\/archivelog\/2021_03_15\/o1_mf_1_19_j4ys2l37_.arc RECID=20 STAMP=1067251363\ndeleted archived log\narchived log file name=\/oracle\/archives\/1_19_1036964654.dbf RECID=8 STAMP=1065592715\ndeleted archived log\narchived log file name=\/oracle\/fra\/RMANDB\/archivelog\/2021_03_15\/o1_mf_1_20_j4ys2cvs_.arc RECID=18 STAMP=1067251357\ndeleted archived log\narchived log file name=\/oracle\/archives\/1_20_1036964654.dbf RECID=9 STAMP=1065710266\ndeleted archived log\narchived log file name=\/oracle\/fra\/RMANDB\/archivelog\/2021_03_15\/o1_mf_1_21_j4ys3crh_.arc RECID=28 STAMP=1067251389\ndeleted archived log\narchived log file name=\/oracle\/archives\/1_21_1036964654.dbf RECID=10 STAMP=1065714954\ndeleted archived log\narchived log file name=\/oracle\/fra\/RMANDB\/archivelog\/2021_03_15\/o1_mf_1_22_j4ys2z32_.arc RECID=24 STAMP=1067251376\ndeleted archived log\narchived log file name=\/oracle\/archives\/1_22_1036964654.dbf RECID=11 STAMP=1065717962\ndeleted archived log\narchived log file name=\/oracle\/fra\/RMANDB\/archivelog\/2021_03_15\/o1_mf_1_23_j4ys2vt1_.arc RECID=23 STAMP=1067251373\ndeleted archived log\narchived log file name=\/oracle\/archives\/1_23_1036964654.dbf RECID=12 STAMP=1066831250\ndeleted archived log\narchived log file name=\/oracle\/fra\/RMANDB\/archivelog\/2021_03_15\/o1_mf_1_24_j4ys3o6t_.arc RECID=31 STAMP=1067251397\ndeleted archived log\narchived log file name=\/oracle\/archives\/1_24_1036964654.dbf RECID=13 STAMP=1066972921\ndeleted archived log\narchived log file name=\/oracle\/fra\/RMANDB\/archivelog\/2021_03_15\/o1_mf_1_25_j4ys3p9r_.arc RECID=32 STAMP=1067251398\ndeleted archived log\narchived log file name=\/oracle\/archives\/1_25_1036964654.dbf RECID=14 STAMP=1066977292\ndeleted archived log\narchived log file name=\/oracle\/fra\/RMANDB\/archivelog\/2021_03_15\/o1_mf_1_26_j4ys3qgj_.arc RECID=33 STAMP=1067251399\ndeleted archived log\narchived log file name=\/oracle\/archives\/1_26_1036964654.dbf RECID=15 STAMP=1066977317\ndeleted archived log\narchived log file name=\/oracle\/fra\/RMANDB\/archivelog\/2021_03_15\/o1_mf_1_27_j4ys3gvm_.arc RECID=29 STAMP=1067251392\ndeleted archived log\narchived log file name=\/oracle\/archives\/1_27_1036964654.dbf RECID=16 STAMP=1067251262\ndeleted archived log\narchived log file name=\/oracle\/fra\/RMANDB\/archivelog\/2021_03_15\/o1_mf_1_28_j4ys3rmf_.arc RECID=34 STAMP=1067251400\ndeleted archived log\narchived log file name=\/oracle\/archives\/1_28_1036964654.dbf RECID=17 STAMP=1067251355\nDeleted 28 objects\n \n \nRMAN>\n<\/pre><\/div>\n\n\n
Neste ponto, farei o backup dos archived logs utilizando o SCN como par\u00e2metro:<\/p>\n\n\n
\nRMAN> BACKUP ARCHIVELOG FROM SCN 1821271;\n \nStarting backup at 2021-03-15:10:53:22\ncurrent log archived\nusing target database control file instead of recovery catalog\nallocated channel: ORA_DISK_1\nchannel ORA_DISK_1: SID=34 device type=DISK\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=29 RECID=35 STAMP=1067251785\ninput archived log thread=1 sequence=30 RECID=36 STAMP=1067251787\ninput archived log thread=1 sequence=31 RECID=37 STAMP=1067251790\ninput archived log thread=1 sequence=32 RECID=38 STAMP=1067251791\ninput archived log thread=1 sequence=33 RECID=39 STAMP=1067251791\ninput archived log thread=1 sequence=34 RECID=40 STAMP=1067252003\nchannel ORA_DISK_1: starting piece 1 at 2021-03-15:10:53:23\nchannel ORA_DISK_1: finished piece 1 at 2021-03-15:10:53:24\npiece handle=\/oracle\/fra\/RMANDB\/backupset\/2021_03_15\/o1_mf_annnn_TAG20210315T105323_j4yspmn7_.bkp tag=TAG20210315T105323 comment=NONE\nchannel ORA_DISK_1: backup set complete, elapsed time: 00:00:01\nFinished backup at 2021-03-15:10:53:24\n \nStarting Control File and SPFILE Autobackup at 2021-03-15:10:53:24\npiece handle=\/oracle\/fra\/RMANDB\/autobackup\/2021_03_15\/o1_mf_s_1067252004_j4yspo7t_.bkp comment=NONE\nFinished Control File and SPFILE Autobackup at 2021-03-15:10:53:25\n \nRMAN>\n<\/pre><\/div>\n\n
\nRMAN> BACKUP ARCHIVELOG FROM SCN 1821271 UNTIL SCN 1822035;\n \nStarting backup at 2021-03-15:10:54:08\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=29 RECID=35 STAMP=1067251785\ninput archived log thread=1 sequence=30 RECID=36 STAMP=1067251787\nchannel ORA_DISK_1: starting piece 1 at 2021-03-15:10:54:09\nchannel ORA_DISK_1: finished piece 1 at 2021-03-15:10:54:10\npiece handle=\/oracle\/fra\/RMANDB\/backupset\/2021_03_15\/o1_mf_annnn_TAG20210315T105408_j4ysr11w_.bkp tag=TAG20210315T105408 comment=NONE\nchannel ORA_DISK_1: backup set complete, elapsed time: 00:00:01\nFinished backup at 2021-03-15:10:54:10\n \nStarting Control File and SPFILE Autobackup at 2021-03-15:10:54:10\npiece handle=\/oracle\/fra\/RMANDB\/autobackup\/2021_03_15\/o1_mf_s_1067252050_j4ysr2or_.bkp comment=NONE\nFinished Control File and SPFILE Autobackup at 2021-03-15:10:54:13\n \nRMAN>\n<\/pre><\/div>\n\n
\nRMAN> BACKUP ARCHIVELOG UNTIL SCN 1822032;\n \nStarting backup at 2021-03-15:10:54:52\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=29 RECID=35 STAMP=1067251785\nchannel ORA_DISK_1: starting piece 1 at 2021-03-15:10:54:52\nchannel ORA_DISK_1: finished piece 1 at 2021-03-15:10:54:53\npiece handle=\/oracle\/fra\/RMANDB\/backupset\/2021_03_15\/o1_mf_annnn_TAG20210315T105452_j4yssdpk_.bkp tag=TAG20210315T105452 comment=NONE\nchannel ORA_DISK_1: backup set complete, elapsed time: 00:00:01\nFinished backup at 2021-03-15:10:54:53\n \nStarting Control File and SPFILE Autobackup at 2021-03-15:10:54:53\npiece handle=\/oracle\/fra\/RMANDB\/autobackup\/2021_03_15\/o1_mf_s_1067252093_j4yssg88_.bkp comment=NONE\nFinished Control File and SPFILE Autobackup at 2021-03-15:10:54:56\n \nRMAN>\n<\/pre><\/div>\n\n
\nRMAN> BACKUP ARCHIVELOG SCN BETWEEN 1821271 AND 1822035;\n \nStarting backup at 2021-03-15:10:55:36\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=29 RECID=35 STAMP=1067251785\ninput archived log thread=1 sequence=30 RECID=36 STAMP=1067251787\nchannel ORA_DISK_1: starting piece 1 at 2021-03-15:10:55:36\nchannel ORA_DISK_1: finished piece 1 at 2021-03-15:10:55:37\npiece handle=\/oracle\/fra\/RMANDB\/backupset\/2021_03_15\/o1_mf_annnn_TAG20210315T105536_j4ystrhy_.bkp tag=TAG20210315T105536 comment=NONE\nchannel ORA_DISK_1: backup set complete, elapsed time: 00:00:01\nFinished backup at 2021-03-15:10:55:37\n \nStarting Control File and SPFILE Autobackup at 2021-03-15:10:55:37\npiece handle=\/oracle\/fra\/RMANDB\/autobackup\/2021_03_15\/o1_mf_s_1067252137_j4ystt1x_.bkp comment=NONE\nFinished Control File and SPFILE Autobackup at 2021-03-15:10:55:40\n<\/pre><\/div>\n\n\n
Tamb\u00e9m podemos realizar os backups utilizando o par\u00e2metro SEQUENCE, como nos exemplos abaixo:<\/p>\n\n\n
\nRMAN> BACKUP ARCHIVELOG FROM SEQUENCE 29;\n \nStarting backup at 2021-03-15:10:58:42\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=29 RECID=35 STAMP=1067251785\ninput archived log thread=1 sequence=30 RECID=36 STAMP=1067251787\ninput archived log thread=1 sequence=31 RECID=37 STAMP=1067251790\ninput archived log thread=1 sequence=32 RECID=38 STAMP=1067251791\ninput archived log thread=1 sequence=33 RECID=39 STAMP=1067251791\ninput archived log thread=1 sequence=34 RECID=40 STAMP=1067252003\ninput archived log thread=1 sequence=35 RECID=41 STAMP=1067252322\nchannel ORA_DISK_1: starting piece 1 at 2021-03-15:10:58:42\nchannel ORA_DISK_1: finished piece 1 at 2021-03-15:10:58:43\npiece handle=\/oracle\/fra\/RMANDB\/backupset\/2021_03_15\/o1_mf_annnn_TAG20210315T105842_j4yt0lq2_.bkp tag=TAG20210315T105842 comment=NONE\nchannel ORA_DISK_1: backup set complete, elapsed time: 00:00:01\nFinished backup at 2021-03-15:10:58:43\n \nStarting Control File and SPFILE Autobackup at 2021-03-15:10:58:43\npiece handle=\/oracle\/fra\/RMANDB\/autobackup\/2021_03_15\/o1_mf_s_1067252323_j4yt0n94_.bkp comment=NONE\nFinished Control File and SPFILE Autobackup at 2021-03-15:10:58:44\n<\/pre><\/div>\n\n
\nRMAN> BACKUP ARCHIVELOG FROM SEQUENCE 29 UNTIL SEQUENCE 30;\n \nStarting backup at 2021-03-15:11:00:20\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=29 RECID=35 STAMP=1067251785\ninput archived log thread=1 sequence=30 RECID=36 STAMP=1067251787\nchannel ORA_DISK_1: starting piece 1 at 2021-03-15:11:00:20\nchannel ORA_DISK_1: finished piece 1 at 2021-03-15:11:00:21\npiece handle=\/oracle\/fra\/RMANDB\/backupset\/2021_03_15\/o1_mf_annnn_TAG20210315T110020_j4yt3nln_.bkp tag=TAG20210315T110020 comment=NONE\nchannel ORA_DISK_1: backup set complete, elapsed time: 00:00:01\nFinished backup at 2021-03-15:11:00:21\n \nStarting Control File and SPFILE Autobackup at 2021-03-15:11:00:21\npiece handle=\/oracle\/fra\/RMANDB\/autobackup\/2021_03_15\/o1_mf_s_1067252421_j4yt3pn3_.bkp comment=NONE\nFinished Control File and SPFILE Autobackup at 2021-03-15:11:00:24\n<\/pre><\/div>\n\n
\nRMAN> BACKUP ARCHIVELOG SEQUENCE BETWEEN 29 AND 32;\n \nStarting backup at 2021-03-15:11:00:48\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=29 RECID=35 STAMP=1067251785\ninput archived log thread=1 sequence=30 RECID=36 STAMP=1067251787\ninput archived log thread=1 sequence=31 RECID=37 STAMP=1067251790\ninput archived log thread=1 sequence=32 RECID=38 STAMP=1067251791\nchannel ORA_DISK_1: starting piece 1 at 2021-03-15:11:00:48\nchannel ORA_DISK_1: finished piece 1 at 2021-03-15:11:00:49\npiece handle=\/oracle\/fra\/RMANDB\/backupset\/2021_03_15\/o1_mf_annnn_TAG20210315T110048_j4yt4jj9_.bkp tag=TAG20210315T110048 comment=NONE\nchannel ORA_DISK_1: backup set complete, elapsed time: 00:00:01\nFinished backup at 2021-03-15:11:00:49\n \nStarting Control File and SPFILE Autobackup at 2021-03-15:11:00:49\npiece handle=\/oracle\/fra\/RMANDB\/autobackup\/2021_03_15\/o1_mf_s_1067252449_j4yt4l52_.bkp comment=NONE\nFinished Control File and SPFILE Autobackup at 2021-03-15:11:00:50\n<\/pre><\/div>\n\n\n
Tamb\u00e9m podemos usar o recurso de datas:<\/p>\n\n\n
\nRMAN> BACKUP ARCHIVELOG FROM TIME 'SYSDATE-1';\n \nStarting backup at 2021-03-15:11:01:49\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=29 RECID=35 STAMP=1067251785\ninput archived log thread=1 sequence=30 RECID=36 STAMP=1067251787\ninput archived log thread=1 sequence=31 RECID=37 STAMP=1067251790\ninput archived log thread=1 sequence=32 RECID=38 STAMP=1067251791\ninput archived log thread=1 sequence=33 RECID=39 STAMP=1067251791\ninput archived log thread=1 sequence=34 RECID=40 STAMP=1067252003\ninput archived log thread=1 sequence=35 RECID=41 STAMP=1067252322\ninput archived log thread=1 sequence=36 RECID=42 STAMP=1067252510\nchannel ORA_DISK_1: starting piece 1 at 2021-03-15:11:01:50\nchannel ORA_DISK_1: finished piece 1 at 2021-03-15:11:01:51\npiece handle=\/oracle\/fra\/RMANDB\/backupset\/2021_03_15\/o1_mf_annnn_TAG20210315T110150_j4yt6g8q_.bkp tag=TAG20210315T110150 comment=NONE\nchannel ORA_DISK_1: backup set complete, elapsed time: 00:00:01\nFinished backup at 2021-03-15:11:01:51\n \nStarting Control File and SPFILE Autobackup at 2021-03-15:11:01:51\npiece handle=\/oracle\/fra\/RMANDB\/autobackup\/2021_03_15\/o1_mf_s_1067252511_j4yt6j2k_.bkp comment=NONE\nFinished Control File and SPFILE Autobackup at 2021-03-15:11:01:52\n<\/pre><\/div>\n\n
\nRMAN> BACKUP ARCHIVELOG UNTIL TIME "TO_DATE('16\/03\/2021', 'DD\/MM\/YYYY')";\n \nStarting backup at 2021-03-15:11:03:07\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=29 RECID=35 STAMP=1067251785\ninput archived log thread=1 sequence=30 RECID=36 STAMP=1067251787\ninput archived log thread=1 sequence=31 RECID=37 STAMP=1067251790\ninput archived log thread=1 sequence=32 RECID=38 STAMP=1067251791\ninput archived log thread=1 sequence=33 RECID=39 STAMP=1067251791\ninput archived log thread=1 sequence=34 RECID=40 STAMP=1067252003\ninput archived log thread=1 sequence=35 RECID=41 STAMP=1067252322\ninput archived log thread=1 sequence=36 RECID=42 STAMP=1067252510\nchannel ORA_DISK_1: starting piece 1 at 2021-03-15:11:03:07\nchannel ORA_DISK_1: finished piece 1 at 2021-03-15:11:03:08\npiece handle=\/oracle\/fra\/RMANDB\/backupset\/2021_03_15\/o1_mf_annnn_TAG20210315T110307_j4yt8vfw_.bkp tag=TAG20210315T110307 comment=NONE\nchannel ORA_DISK_1: backup set complete, elapsed time: 00:00:01\nFinished backup at 2021-03-15:11:03:08\n \nStarting Control File and SPFILE Autobackup at 2021-03-15:11:03:08\npiece handle=\/oracle\/fra\/RMANDB\/autobackup\/2021_03_15\/o1_mf_s_1067252588_j4yt8x06_.bkp comment=NONE\nFinished Control File and SPFILE Autobackup at 2021-03-15:11:03:09\n<\/pre><\/div>\n\n\n
Por fim, tamb\u00e9m \u00e9 poss\u00edvel realizar o backup dos archivelogs no mesmo comando de backup do banco de dados. Nos bastidores, o Oracle executa um “ALTER SYSTEM ARCHIVE LOG CURRENT;”, depois um “BACKUP ARCHIVELOG ALL;”, realiza o backup solicitado do banco (por exemplo BACKUP DATABASE) e por fim um “ALTER SYSTEM ARCHIVE LOG CURRENT;” \u00e9 executado e os archives restantes s\u00e3o contemplados no backup. Vide exemplo abaixo:<\/p>\n\n\n
\nRMAN> BACKUP DATABASE PLUS ARCHIVELOG;\n \n \nStarting backup at 2021-03-15:11:05:55\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=29 RECID=35 STAMP=1067251785\ninput archived log thread=1 sequence=30 RECID=36 STAMP=1067251787\ninput archived log thread=1 sequence=31 RECID=37 STAMP=1067251790\ninput archived log thread=1 sequence=32 RECID=38 STAMP=1067251791\ninput archived log thread=1 sequence=33 RECID=39 STAMP=1067251791\ninput archived log thread=1 sequence=34 RECID=40 STAMP=1067252003\ninput archived log thread=1 sequence=35 RECID=41 STAMP=1067252322\ninput archived log thread=1 sequence=36 RECID=42 STAMP=1067252510\ninput archived log thread=1 sequence=37 RECID=43 STAMP=1067252755\nchannel ORA_DISK_1: starting piece 1 at 2021-03-15:11:05:55\nchannel ORA_DISK_1: finished piece 1 at 2021-03-15:11:05:56\npiece handle=\/oracle\/fra\/RMANDB\/backupset\/2021_03_15\/o1_mf_annnn_TAG20210315T110555_j4ytg3vn_.bkp tag=TAG20210315T110555 comment=NONE\nchannel ORA_DISK_1: backup set complete, elapsed time: 00:00:01\nFinished backup at 2021-03-15:11:05:56\n \nStarting backup at 2021-03-15:11:05:57\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=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-03-15:11:05:57\nchannel ORA_DISK_1: finished piece 1 at 2021-03-15:11:07:02\npiece handle=\/oracle\/fra\/RMANDB\/backupset\/2021_03_15\/o1_mf_nnndf_TAG20210315T110557_j4ytg5bd_.bkp tag=TAG20210315T110557 comment=NONE\nchannel ORA_DISK_1: backup set complete, elapsed time: 00:01:05\nFinished backup at 2021-03-15:11:07:02\n \nStarting backup at 2021-03-15:11:07:02\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=38 RECID=44 STAMP=1067252822\nchannel ORA_DISK_1: starting piece 1 at 2021-03-15:11:07:02\nchannel ORA_DISK_1: finished piece 1 at 2021-03-15:11:07:03\npiece handle=\/oracle\/fra\/RMANDB\/backupset\/2021_03_15\/o1_mf_annnn_TAG20210315T110702_j4ytj6gv_.bkp tag=TAG20210315T110702 comment=NONE\nchannel ORA_DISK_1: backup set complete, elapsed time: 00:00:01\nFinished backup at 2021-03-15:11:07:03\n \nStarting Control File and SPFILE Autobackup at 2021-03-15:11:07:03\npiece handle=\/oracle\/fra\/RMANDB\/autobackup\/2021_03_15\/o1_mf_s_1067252823_j4ytj85h_.bkp comment=NONE\nFinished Control File and SPFILE Autobackup at 2021-03-15:11:07:06\n<\/pre><\/div>\n\n\n
Caso queiramos que todos os archivelogs sejam removidos ap\u00f3s o backup, basta adicionar o par\u00e2metro DELETE ALL INPUT:<\/p>\n\n\n
\nRMAN> BACKUP ARCHIVELOG ALL DELETE ALL INPUT;\n \nStarting backup at 2021-03-15:11:08:58\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=29 RECID=35 STAMP=1067251785\ninput archived log thread=1 sequence=30 RECID=36 STAMP=1067251787\ninput archived log thread=1 sequence=31 RECID=37 STAMP=1067251790\ninput archived log thread=1 sequence=32 RECID=38 STAMP=1067251791\ninput archived log thread=1 sequence=33 RECID=39 STAMP=1067251791\ninput archived log thread=1 sequence=34 RECID=40 STAMP=1067252003\ninput archived log thread=1 sequence=35 RECID=41 STAMP=1067252322\ninput archived log thread=1 sequence=36 RECID=42 STAMP=1067252510\ninput archived log thread=1 sequence=37 RECID=43 STAMP=1067252755\ninput archived log thread=1 sequence=38 RECID=44 STAMP=1067252822\ninput archived log thread=1 sequence=39 RECID=45 STAMP=1067252938\nchannel ORA_DISK_1: starting piece 1 at 2021-03-15:11:08:58\nchannel ORA_DISK_1: finished piece 1 at 2021-03-15:11:08:59\npiece handle=\/oracle\/fra\/RMANDB\/backupset\/2021_03_15\/o1_mf_annnn_TAG20210315T110858_j4ytmtkx_.bkp tag=TAG20210315T110858 comment=NONE\nchannel ORA_DISK_1: backup set complete, elapsed time: 00:00:01\nchannel ORA_DISK_1: deleting archived log(s)\narchived log file name=\/oracle\/archives\/1_29_1036964654.dbf RECID=35 STAMP=1067251785\narchived log file name=\/oracle\/archives\/1_30_1036964654.dbf RECID=36 STAMP=1067251787\narchived log file name=\/oracle\/archives\/1_31_1036964654.dbf RECID=37 STAMP=1067251790\narchived log file name=\/oracle\/archives\/1_32_1036964654.dbf RECID=38 STAMP=1067251791\narchived log file name=\/oracle\/archives\/1_33_1036964654.dbf RECID=39 STAMP=1067251791\narchived log file name=\/oracle\/archives\/1_34_1036964654.dbf RECID=40 STAMP=1067252003\narchived log file name=\/oracle\/archives\/1_35_1036964654.dbf RECID=41 STAMP=1067252322\narchived log file name=\/oracle\/archives\/1_36_1036964654.dbf RECID=42 STAMP=1067252510\narchived log file name=\/oracle\/archives\/1_37_1036964654.dbf RECID=43 STAMP=1067252755\narchived log file name=\/oracle\/archives\/1_38_1036964654.dbf RECID=44 STAMP=1067252822\narchived log file name=\/oracle\/archives\/1_39_1036964654.dbf RECID=45 STAMP=1067252938\nFinished backup at 2021-03-15:11:08:59\n \nStarting Control File and SPFILE Autobackup at 2021-03-15:11:08:59\npiece handle=\/oracle\/fra\/RMANDB\/autobackup\/2021_03_15\/o1_mf_s_1067252939_j4ytmwkl_.bkp comment=NONE\nFinished Control File and SPFILE Autobackup at 2021-03-15:11:09:02\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":"
Realizando o backup de todos os archived logs (como backupset e copy image): Deletando arquivos de backup: Neste ponto, farei o backup dos archived logs utilizando o SCN como par\u00e2metro: Tamb\u00e9m podemos realizar os backups utilizando o par\u00e2metro SEQUENCE, como nos exemplos abaixo: Tamb\u00e9m podemos usar o recurso de datas: Por fim, tamb\u00e9m \u00e9 poss\u00edvel […]<\/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-2686","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\/2686","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=2686"}],"version-history":[{"count":1,"href":"https:\/\/swiv.com.br\/index.php\/wp-json\/wp\/v2\/posts\/2686\/revisions"}],"predecessor-version":[{"id":9231,"href":"https:\/\/swiv.com.br\/index.php\/wp-json\/wp\/v2\/posts\/2686\/revisions\/9231"}],"wp:attachment":[{"href":"https:\/\/swiv.com.br\/index.php\/wp-json\/wp\/v2\/media?parent=2686"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/swiv.com.br\/index.php\/wp-json\/wp\/v2\/categories?post=2686"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/swiv.com.br\/index.php\/wp-json\/wp\/v2\/tags?post=2686"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}