MERCADOS FINANCIEROS

jueves, 16 de julio de 2020

RMAN BACKUP ARCHIVELOG DELETE INPUT - BACKUP ARCHIVELOG ALL NOT BACKED UP

[oracle@localhost ~]$ rman target /

Recovery Manager: Release 12.1.0.1.0 - Production on Thu Jul 16 20:58:48 2020

Copyright (c) 1982, 2013, Oracle and/or its affiliates.  All rights reserved.

connected to target database: ACME (DBID=2033062067)

RMAN> backup archivelog all delete input;

Starting backup at 16-JUL-20
current log archived
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=26 device type=DISK
channel ORA_DISK_1: starting archived log backup set
channel ORA_DISK_1: specifying archived log(s) in backup set
input archived log thread=1 sequence=96 RECID=92 STAMP=1045765588
input archived log thread=1 sequence=97 RECID=93 STAMP=1045765746
input archived log thread=1 sequence=98 RECID=94 STAMP=1045775298
input archived log thread=1 sequence=99 RECID=95 STAMP=1045778863
input archived log thread=1 sequence=100 RECID=96 STAMP=1045796445
input archived log thread=1 sequence=101 RECID=97 STAMP=1045832437
input archived log thread=1 sequence=102 RECID=98 STAMP=1045855635
input archived log thread=1 sequence=103 RECID=99 STAMP=1045862756
input archived log thread=1 sequence=104 RECID=100 STAMP=1045865866
input archived log thread=1 sequence=105 RECID=101 STAMP=1045915239
input archived log thread=1 sequence=106 RECID=102 STAMP=1045937427
input archived log thread=1 sequence=107 RECID=103 STAMP=1045937613
input archived log thread=1 sequence=108 RECID=104 STAMP=1045947407
input archived log thread=1 sequence=109 RECID=105 STAMP=1045947539
channel ORA_DISK_1: starting piece 1 at 16-JUL-20
channel ORA_DISK_1: finished piece 1 at 16-JUL-20
piece handle=+FRA/ACME/BACKUPSET/2020_07_16/annnf0_tag20200716t205900_0.267.1045947543 tag=TAG20200716T205900 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:25
channel ORA_DISK_1: deleting archived log(s)
archived log file name=+FRA/ACME/ARCHIVELOG/2020_07_14/thread_1_seq_96.264.1045765587 RECID=92 STAMP=1045765588
archived log file name=+FRA/ACME/ARCHIVELOG/2020_07_14/thread_1_seq_97.279.1045765745 RECID=93 STAMP=1045765746
archived log file name=+FRA/ACME/ARCHIVELOG/2020_07_14/thread_1_seq_98.289.1045775295 RECID=94 STAMP=1045775298
archived log file name=+FRA/ACME/ARCHIVELOG/2020_07_14/thread_1_seq_99.265.1045778813 RECID=95 STAMP=1045778863
archived log file name=+FRA/ACME/ARCHIVELOG/2020_07_15/thread_1_seq_100.263.1045796439 RECID=96 STAMP=1045796445
archived log file name=+FRA/ACME/ARCHIVELOG/2020_07_15/thread_1_seq_101.260.1045832433 RECID=97 STAMP=1045832437
archived log file name=+FRA/ACME/ARCHIVELOG/2020_07_15/thread_1_seq_102.272.1045855633 RECID=98 STAMP=1045855635
archived log file name=+FRA/ACME/ARCHIVELOG/2020_07_15/thread_1_seq_103.300.1045862755 RECID=99 STAMP=1045862756
archived log file name=+FRA/ACME/ARCHIVELOG/2020_07_15/thread_1_seq_104.301.1045865821 RECID=100 STAMP=1045865866
archived log file name=+FRA/ACME/ARCHIVELOG/2020_07_16/thread_1_seq_105.302.1045915235 RECID=101 STAMP=1045915239
archived log file name=+FRA/ACME/ARCHIVELOG/2020_07_16/thread_1_seq_106.303.1045937425 RECID=102 STAMP=1045937427
archived log file name=+FRA/ACME/ARCHIVELOG/2020_07_16/thread_1_seq_107.294.1045937613 RECID=103 STAMP=1045937613
archived log file name=+FRA/ACME/ARCHIVELOG/2020_07_16/thread_1_seq_108.266.1045947405 RECID=104 STAMP=1045947407
archived log file name=+FRA/ACME/ARCHIVELOG/2020_07_16/thread_1_seq_109.273.1045947539 RECID=105 STAMP=1045947539
Finished backup at 16-JUL-20

Starting Control File and SPFILE Autobackup at 16-JUL-20
piece handle=+FRA/ACME/AUTOBACKUP/2020_07_16/s_1045947576.273.1045947577 comment=NONE
Finished Control File and SPFILE Autobackup at 16-JUL-20

RMAN> 


RMAN> BACKUP ARCHIVELOG ALL NOT BACKED UP;

Starting backup at 21-JUL-20
current log archived
using channel ORA_DISK_1
skipping archived logs of thread 1 from sequence 73 to 93; already backed up
channel ORA_DISK_1: starting archived log backup set
channel ORA_DISK_1: specifying archived log(s) in backup set
input archived log thread=1 sequence=94 RECID=90 STAMP=1046378942
channel ORA_DISK_1: starting piece 1 at 21-JUL-20
channel ORA_DISK_1: finished piece 1 at 21-JUL-20
piece handle=+FRA/ACME/BACKUPSET/2020_07_21/annnf0_tag20200721t204902_0.300.1046378943 tag=TAG20200721T204902 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01
Finished backup at 21-JUL-20

Starting Control File and SPFILE Autobackup at 21-JUL-20
piece handle=+FRA/ACME/AUTOBACKUP/2020_07_21/s_1046378943.301.1046378945 comment=NONE
Finished Control File and SPFILE Autobackup at 21-JUL-20

RMAN> 




No hay comentarios: