Thanks for the question, Vishnu.
Asked: March 06, 2020 - 5:11 am UTC
Last updated: March 10, 2020 - 2:41 pm UTC
Version: oracle 12c
Viewed 1000+ times
You Asked
Hello All,
We have a third party tool called Commvault which uses RMAN for archive log and full backups.
Ever since we have scheduled backups from this tool we are facing a strange issue. Our archive backups are scheduled to run for every 30mins and full backup runs every night at 9 PM. Suppose if an archive backup starts at 13:00, initially it selects and processes few files and later it will not go into finish status and indeed selects few more new files generated for processing again. Like a single job is picking the files in loop and the job never finishes or takes too long to finish.
BR0522I 2197 of 2197 files / save sets processed by RMAN
BR0280I BRARCHIVE time stamp: 2020-03-03 14:58:21
BR0542I Offline redolog backup using RMAN successful
BR0280I BRARCHIVE time stamp: 2020-03-03 14:58:21
BR0015I Offline redolog file /migexport/ph1oraarch/1_1616797_967549239.dbf deleted
BR0280I BRARCHIVE time stamp: 2020-03-03 14:59:05
BR0012I 1416 next offline redolog files found for processing, total size 122114.001 MB
BR0280I BRARCHIVE time stamp: 2020-03-03 14:59:05
BR0541I Starting offline redolog backup using RMAN...
BR0280I BRARCHIVE time stamp: 2020-03-03 14:59:27
Can anyone explain the above behavior and how to avoid this archive loop.
Regards,
Vishnu
and Connor said...
I dont know Commvault but it might due to the RMAN configuration.
"backup archivelog"
does exactly that. Backs up all the archivelogs you have (based on the rman defaults).
Typically those defaults (you can check with "show all") are based on retention or number of copies, but if they have been altered, then you might be backing up every archivelog that can be found on the system.
(That's just a guess, because I don't know Commvault) but perhaps look at a "show all" command in RMAN to see what your archive log backup defaults are.
Rating
(1 rating)
Is this answer out of date? If it is, please let us know via a Comment