Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Why are archived logs getting deleted during RMAN DUPLICATE ?

PeaceMongerAug 20 2022 — edited Aug 25 2022

DB verion : 19c on RHEL 8.4

Below is a log from RMAN DUPLICATE from tape backup. 
During restore to the auxiliary DB CLONE, I can see archived logs being restored. But, the log also shows some archived logs are deleted even before recovery starts, I think.
See the deleting archived log(s) messages below.
Why is RMAN restoring archived logs from tape only to delete it later ? 

archived log file name=+FRA_DG/CLONE/ARCHIVELOG/2022_08_20/thread_2_seq_55240.3447.1113248079 thread=2 sequence=55240
channel clone_default: deleting archived log(s)
archived log file name=+FRA_DG/CLONE/ARCHIVELOG/2022_08_20/thread_2_seq_55240.3447.1113248079 RECID=45 STAMP=1113248092
channel aux_ch4: starting archived log restore to default destination
channel aux_ch4: restoring archived log
archived log thread=2 sequence=55342
channel aux_ch4: restoring archived log
archived log thread=1 sequence=63113
channel aux_ch4: restoring archived log
archived log thread=2 sequence=55343
channel aux_ch4: restoring archived log
archived log thread=2 sequence=55344
channel aux_ch4: restoring archived log
archived log thread=2 sequence=55345
channel aux_ch4: restoring archived log
archived log thread=1 sequence=63114
channel aux_ch4: restoring archived log
archived log thread=2 sequence=55346
channel aux_ch4: reading from backup piece xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
channel aux_ch5: piece handle=XXXXXXXXXXXXXXXXXXXXXX tag=TAG20220819T033537
channel aux_ch5: restored backup piece 1
channel aux_ch5: restore complete, elapsed time: 00:10:57
archived log file name=+FRA_DG/CLONE/ARCHIVELOG/2022_08_20/thread_2_seq_55241.3440.1113248365 thread=2 sequence=55241
channel clone_default: deleting archived log(s)
archived log file name=+FRA_DG/CLONE/ARCHIVELOG/2022_08_20/thread_1_seq_63078.3457.1113248081 RECID=32 STAMP=1113248082
archived log file name=+FRA_DG/CLONE/ARCHIVELOG/2022_08_20/thread_1_seq_63079.3377.1113248367 thread=1 sequence=63079
channel clone_default: deleting archived log(s)
archived log file name=+FRA_DG/CLONE/ARCHIVELOG/2022_08_20/thread_2_seq_55241.3440.1113248365 RECID=177 STAMP=1113248382
archived log file name=+FRA_DG/CLONE/ARCHIVELOG/2022_08_20/thread_2_seq_55242.3508.1113248279 thread=2 sequence=55242
channel clone_default: deleting archived log(s)
archived log file name=+FRA_DG/CLONE/ARCHIVELOG/2022_08_20/thread_2_seq_55242.3508.1113248279 RECID=150 STAMP=1113248323
archived log file name=+FRA_DG/CLONE/ARCHIVELOG/2022_08_20/thread_2_seq_55243.3509.1113248279 thread=2 sequence=55243
channel clone_default: deleting archived log(s)
archived log file name=+FRA_DG/CLONE/ARCHIVELOG/2022_08_20/thread_2_seq_55243.3509.1113248279 RECID=149 STAMP=1113248323
archived log file name=+FRA_DG/CLONE/ARCHIVELOG/2022_08_20/thread_2_seq_55244.3488.1113248325 thread=2 sequence=55244
channel clone_default: deleting archived log(s)

Comments

Post Details

Added on Aug 20 2022
1 comment
447 views