Shulou(Shulou.com)06/01 Report--

CONFIGURE RMAN OUTPUT TO KEEP FOR 7 DAYS; # default

Enable the archive delete policy:

RMAN > CONFIGURE ARCHIVELOG DELETION POLICY TO BACKED UP 1 TIMES TO DISK

New RMAN configuration parameters:

CONFIGURE ARCHIVELOG DELETION POLICY TO BACKED UP 1 TIMES TO DISK

New RMAN configuration parameters have been successfully stored

Configure an archive deletion policy that requires only one archive backup to disk, after which the archive is allowed to be deleted.

RMAN > backup archivelog all delete all input

Starting with backup, which is located in 02-February-18

The current log is archived

Use channel ORA_DISK_1

Channel ORA_DISK_1: starting archive log backup set

Channel ORA_DISK_1: specifying archive logs in backup set

Enter archive log thread = 1 sequence = 1 RECID=86 STAMP=966098143

Enter archive log thread = 1 sequence = 12 RECID=97 STAMP=966181095

Enter archive log thread = 1 sequence = 13 RECID=98 STAMP=966204231

Enter archive log thread = 1 sequence = 14 RECID=99 STAMP=966214774

Enter archive log thread = 1 sequence = 15 RECID=100 STAMP=966249490

Enter archive log thread = 1 sequence = 16 RECID=101 STAMP=966290451

Enter archive log thread = 1 sequence = 17 RECID=102 STAMP=966301443

Enter archive log thread = 1 sequence = 18 RECID=103 STAMP=966681162

Enter archive log thread = 1 sequence = 19 RECID=104 STAMP=966682974

Enter archive log thread = 1 sequence = 20 RECID=105 STAMP=966693752

Enter archive log thread = 1 sequence = 21 RECID=106 STAMP=966722515

Enter archive log thread = 1 sequence = 22 RECID=107 STAMP=966759560

Enter archive log thread = 1 sequence = 23 RECID=111 STAMP=966778358

Channel ORA_DISK_1: starting segment 1 from 02 to February-18

Channel ORA_DISK_1: completed startup segment 1 from 02 to February-18

Fragment handle = E:\ RECOVERYFLASH\ NEWTEST\ BACKUPSET\ 2018'02'02\ O1_MF_ANNNN_TAG20180202T103836F77MSF62.BKP tag = TAG20180202T103836 comment = NONE

Channel ORA_DISK_1: backup set completed, time: 00:05:06

Channel ORA_DISK_1: deleting archive log

Archive log file name = C:\ APP\ ADMINISTRATOR\ VIRTUAL\ ARCHIVELOG\ ARC0000000001_0966075864.0001 RECID=86 STAMP=966098143

Archive log file name = C:\ APP\ ADMINISTRATOR\ VIRTUAL\ ARCHIVELOG\ ARC0000000012_0966075864.0001 RECID=97 STAMP=966181095

Archive log file name = C:\ APP\ ADMINISTRATOR\ VIRTUAL\ ARCHIVELOG\ ARC0000000013_0966075864.0001 RECID=98 STAMP=966204231

Archive log file name = C:\ APP\ ADMINISTRATOR\ VIRTUAL\ ARCHIVELOG\ ARC0000000014_0966075864.0001 RECID=99 STAMP=966214774

Archive log file name = C:\ APP\ ADMINISTRATOR\ VIRTUAL\ ARCHIVELOG\ ARC0000000015_0966075864.0001 RECID=100 STAMP=966249490

Archive log file name = C:\ APP\ ADMINISTRATOR\ VIRTUAL\ ARCHIVELOG\ ARC0000000016_0966075864.0001 RECID=101 STAMP=966290451

Archive log file name = C:\ APP\ ADMINISTRATOR\ VIRTUAL\ ARCHIVELOG\ ARC0000000017_0966075864.0001 RECID=102 STAMP=966301443

Archive log file name = C:\ APP\ ADMINISTRATOR\ VIRTUAL\ ARCHIVELOG\ ARC0000000018_0966075864.0001 RECID=103 STAMP=966681162

Archive log file name = C:\ APP\ ADMINISTRATOR\ VIRTUAL\ ARCHIVELOG\ ARC0000000019_0966075864.0001 RECID=104 STAMP=966682974

Archive log file name = C:\ APP\ ADMINISTRATOR\ VIRTUAL\ ARCHIVELOG\ ARC0000000020_0966075864.0001 RECID=105 STAMP=966693752

Archive log file name = C:\ APP\ ADMINISTRATOR\ VIRTUAL\ ARCHIVELOG\ ARC0000000021_0966075864.0001 RECID=106 STAMP=966722515

Archive log file name = C:\ APP\ ADMINISTRATOR\ VIRTUAL\ ARCHIVELOG\ ARC0000000022_0966075864.0001 RECID=107 STAMP=966759560

Archive log file name = C:\ APP\ ADMINISTRATOR\ VIRTUAL\ ARCHIVELOG\ ARC0000000023_0966075864.0001 RECID=111 STAMP=966778358

Channel ORA_DISK_1: starting archive log backup set

Channel ORA_DISK_1: specifying archive logs in backup set

Enter archive log thread = 1 sequence = 1 RECID=119 STAMP=966963208

Enter archive log thread = 1 sequence = 2 RECID=120 STAMP=966963209

Enter archive log thread = 1 sequence = 3 RECID=121 STAMP=966963211

Enter archive log thread = 1 sequence = 4 RECID=122 STAMP=966963469

Enter archive log thread = 1 sequence = 5 RECID=123 STAMP=966963470

Enter archive log thread = 1 sequence = 6 RECID=124 STAMP=966963473

Enter archive log thread = 1 sequence = 7 RECID=125 STAMP=966964031

Enter archive log thread = 1 sequence = 8 RECID=126 STAMP=966964599

Enter archive log thread = 1 sequence = 9 RECID=127 STAMP=966981651

Enter archive log thread = 1 sequence = 10 RECID=128 STAMP=966991659

Enter archive log thread = 1 sequence = 11 RECID=129 STAMP=967022631

Enter archive log thread = 1 sequence = 12 RECID=130 STAMP=967022631

Enter archive log thread = 1 sequence = 13 RECID=131 STAMP=967023107

Enter archive log thread = 1 sequence = 14 RECID=132 STAMP=967023648

Channel ORA_DISK_1: starting segment 1 from 02 to February-18

Channel ORA_DISK_1: completed startup segment 1 from 02 to February-18

Fragment handle = E:\ RECOVERYFLASH\ NEWTEST\ BACKUPSET\ 2018'02'02\ O1_MF_ANNNN_TAG20180202T103836F77N3535.BKP tag = TAG20180202T103836 comment = NONE

Channel ORA_DISK_1: backup set completed, time: 00:01:17

Channel ORA_DISK_1: starting archive log backup set

Channel ORA_DISK_1: specifying archive logs in backup set

Enter archive log thread = 1 sequence = 1 RECID=112 STAMP=966778394

Enter archive log thread = 1 sequence = 2 RECID=113 STAMP=966778395

Enter archive log thread = 1 sequence = 3 RECID=114 STAMP=966778395

Channel ORA_DISK_1: starting segment 1 from 02 to February-18

Channel ORA_DISK_1: completed startup segment 1 from 02 to February-18

Fragment handle = E:\ RECOVERYFLASH\ NEWTEST\ BACKUPSET\ 2018'02'02\ O1_MF_ANNNN_TAG20180202T103836F77N5KV5.BKP tag = TAG20180202T103836 comment = NONE

Channel ORA_DISK_1: backup set completed, time: 00:00:08

Channel ORA_DISK_1: deleting archive log

Archive log file name = C:\ APP\ ADMINISTRATOR\ VIRTUAL\ ARCHIVELOG\ ARC0000000001_0966768541.0001 RECID=112 STAMP=966778394

Archive log file name = C:\ APP\ ADMINISTRATOR\ VIRTUAL\ ARCHIVELOG\ ARC0000000002_0966768541.0001 RECID=113 STAMP=966778395

Archive log file name = C:\ APP\ ADMINISTRATOR\ VIRTUAL\ ARCHIVELOG\ ARC0000000003_0966768541.0001 RECID=114 STAMP=966778395

Channel ORA_DISK_1: starting archive log backup set

Channel ORA_DISK_1: specifying archive logs in backup set

Enter archive log thread = 1 sequence = 1 RECID=118 STAMP=966780967

Channel ORA_DISK_1: starting segment 1 from 02 to February-18

Channel ORA_DISK_1: completed startup segment 1 from 02 to February-18

Fragment handle = E:\ RECOVERYFLASH\ NEWTEST\ BACKUPSET\ 2018'02'02\ O1_MF_ANNNN_TAG20180202T103836F77N5TMR.BKP tag = TAG20180202T103836 comment = NONE

Channel ORA_DISK_1: backup set completed, time: 00:00:03

Channel ORA_DISK_1: deleting archive log

Archive log file name = C:\ APP\ ADMINISTRATOR\ VIRTUAL\ ARCHIVELOG\ ARC0000000001_0966778394.0001 RECID=118 STAMP=966780967

Channel ORA_DISK_1: deleting archive log

Archive log file name = C:\ APP\ ADMINISTRATOR\ VIRTUAL\ ARCHIVELOG\ ARC0000000001_0966780966.0001 RECID=119 STAMP=966963208

Archive log file name = C:\ APP\ ADMINISTRATOR\ VIRTUAL\ ARCHIVELOG\ ARC0000000002_0966780966.0001 RECID=120 STAMP=966963209

Archive log file name = C:\ APP\ ADMINISTRATOR\ VIRTUAL\ ARCHIVELOG\ ARC0000000003_0966780966.0001 RECID=121 STAMP=966963211

Archive log file name = C:\ APP\ ADMINISTRATOR\ VIRTUAL\ ARCHIVELOG\ ARC0000000004_0966780966.0001 RECID=122 STAMP=966963469

Archive log file name = C:\ APP\ ADMINISTRATOR\ VIRTUAL\ ARCHIVELOG\ ARC0000000005_0966780966.0001 RECID=123 STAMP=966963470

Archive log file name = C:\ APP\ ADMINISTRATOR\ VIRTUAL\ ARCHIVELOG\ ARC0000000006_0966780966.0001 RECID=124 STAMP=966963473

Archive log file name = C:\ APP\ ADMINISTRATOR\ VIRTUAL\ ARCHIVELOG\ ARC0000000007_0966780966.0001 RECID=125 STAMP=966964031

Archive log file name = C:\ APP\ ADMINISTRATOR\ VIRTUAL\ ARCHIVELOG\ ARC0000000008_0966780966.0001 RECID=126 STAMP=966964599

Archive log file name = C:\ APP\ ADMINISTRATOR\ VIRTUAL\ ARCHIVELOG\ ARC0000000009_0966780966.0001 RECID=127 STAMP=966981651

Archive log file name = C:\ APP\ ADMINISTRATOR\ VIRTUAL\ ARCHIVELOG\ ARC0000000010_0966780966.0001 RECID=128 STAMP=966991659

Archive log file name = C:\ APP\ ADMINISTRATOR\ VIRTUAL\ ARCHIVELOG\ ARC0000000011_0966780966.0001 RECID=129 STAMP=967022631

Archive log file name = C:\ APP\ ADMINISTRATOR\ VIRTUAL\ ARCHIVELOG\ ARC0000000012_0966780966.0001 RECID=130 STAMP=967022631

Archive log file name = C:\ APP\ ADMINISTRATOR\ VIRTUAL\ ARCHIVELOG\ ARC0000000013_0966780966.0001 RECID=131 STAMP=967023107

Archive log file name = C:\ APP\ ADMINISTRATOR\ VIRTUAL\ ARCHIVELOG\ ARC0000000014_0966780966.0001 RECID=132 STAMP=967023648

Channel ORA_DISK_1: starting archive log backup set

Channel ORA_DISK_1: specifying archive logs in backup set

Enter archive log thread = 1 sequence = 1 RECID=133 STAMP=967025059

Enter archive log thread = 1 sequence = 2 RECID=134 STAMP=967025061

Enter archive log thread = 1 sequence = 3 RECID=135 STAMP=967027115

Channel ORA_DISK_1: starting segment 1 from 02 to February-18

Channel ORA_DISK_1: completed startup segment 1 from 02 to February-18

Fragment handle = E:\ RECOVERYFLASH\ NEWTEST\ BACKUPSET\ 2018'02'02\ O1_MF_ANNNN_TAG20180202T103836F77N5ZPR.BKP tag = TAG20180202T103836 comment = NONE

Channel ORA_DISK_1: backup set completed, time: 00:00:01

Channel ORA_DISK_1: deleting archive log

Archive log file name = C:\ APP\ ADMINISTRATOR\ VIRTUAL\ ARCHIVELOG\ ARC0000000001_0967023648.0001 RECID=133 STAMP=967025059

Archive log file name = C:\ APP\ ADMINISTRATOR\ VIRTUAL\ ARCHIVELOG\ ARC0000000002_0967023648.0001 RECID=134 STAMP=967025061

Archive log file name = C:\ APP\ ADMINISTRATOR\ VIRTUAL\ ARCHIVELOG\ ARC0000000003_0967023648.0001 RECID=135 STAMP=967027115

Completed backup in 02-February-18.

Starting with Control File and SPFILE Autobackup, which is located in 02-February-18

Fragment handle = E:\ CONTROLBACKUP\ CF-C-1779551310-20180202-03 comment = NONE

Completed Control File and SPFILE Autobackup in 02-February-18.

Look at the archive log file again and find that it has been deleted.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.