Skip to main content
Solved

Archive deletion for Oracle DB backup to be disabled from Commvault

  • December 9, 2021
  • 2 replies
  • 892 views

Forum|alt.badge.img+2

I would like to ask some opinion on this option.   Upon the request of our Oracle DBAs in our small company we are disabling the Archive deletion
within the Oracle database backup. We will let our Oracle DBAs manage the Archive logs including the deletion

I would like some opinion/points on this before we even proceed.   I am not an Expert in Oracle and would like some advice 

Any help is appreciated

 

Best answer by Sunil

Hi,

Would like to understand you question in more detail. But answering below as per what I understood.

 

Usually people delete archive logs once they are backed up as part of the Commvault backup job itself so that the log area doesn’t get filled up and bring down the database. Not deleting the Archive logs during Commvault backup is not a problem as long as the DBAs take care of cleaning them up.

And it will not cause any issues with database recoverability as long as the logs are continuously backed up to Commvault.

 

However, if the Archive logs are not cleaned up promptly, it might increase the backup size as the same Archive logs may get backed up multiple times.

 

Thanks,

Sunil

 

View original
Did this answer your question?

2 replies

Sunil
Vaulter
Forum|alt.badge.img+13
  • Vaulter
  • 300 replies
  • Answer
  • December 9, 2021

Hi,

Would like to understand you question in more detail. But answering below as per what I understood.

 

Usually people delete archive logs once they are backed up as part of the Commvault backup job itself so that the log area doesn’t get filled up and bring down the database. Not deleting the Archive logs during Commvault backup is not a problem as long as the DBAs take care of cleaning them up.

And it will not cause any issues with database recoverability as long as the logs are continuously backed up to Commvault.

 

However, if the Archive logs are not cleaned up promptly, it might increase the backup size as the same Archive logs may get backed up multiple times.

 

Thanks,

Sunil

 


RubeckDK
Byte
Forum|alt.badge.img+10
  • Byte
  • 68 replies
  • December 9, 2021

“However, if the Archive logs are not cleaned up promptly, it might increase the backup size as the same Archive logs may get backed up multiple times.” 

 

Very good point @Sunil … I’ve just been there and done that recently. A really “doooh!” scenario just because one wanted to help the DBA out.. :-) 

 

/Rubeck 


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings