cancel
Showing results for 
Search instead for 
Did you mean: 

BE 2014 - Oracle Backup - Question about the Archived Log options.

AlexanderD
Level 2

Hello,

We are slowly moving our Backups over to BE 2014.
While i already tested the Oracle backup, i still have a problem with the archive logs.

Oracle says to only delete the "Archived redo Logs" after they have been backed up successfully at least three times.
I think i saw a technote that said two times.

Now it seems to me that non of the options available, concerning the Oracle Archived Logs, are useful.

Please tell me if i'm wrong about the options:
"Do not back up archived logfiles that have already been backed up" -- After a Log has been backed up once, it is ignored by all farther backups.
"Delete backed up archived log files" -- Log get's deleted after it has been backed up once
 

I'm hoping that the "Delete backed up archived log files" option uses the Oracle practice of "delete after three successfull backups" but i fear that we will have to use rman scripts again to have everything go as we want.

 

Regards,
AlexanderD

2 REPLIES 2

VJware
Level 6
Employee Accredited Certified

Can you point the article which mentions archived redo logs should be deleted only after 3 successful backups ?

Verbatim from http://docs.oracle.com/cd/B28359_01/backup.111/b28270/rcmmaint.htm#BRADV89633

"By default the deletion policy is configured to NONE, which means logs are eligible for deletion if they have been backed up at least once to disk or tape or the logs are obsolete according to the backup retention policy."

And verbatim from http://docs.oracle.com/cd/B28359_01/backup.111/b28270/rcmconfb.htm#BRADV89439

RMAN considers archived redo log files in the recovery area as eligible for deletion if they meet both of the following conditions:

  • The archived redo logs, whether in the flash recovery area or outside of it, have been transferred to the required remote destinations specified by LOG_ARCHIVE_DEST_n.

  • The archived redo logs have been backed up at least once to disk or SBT or the logs are obsolete according to the backup retention policy

If you see both the articles, it mentions atleast one backup.

lmosla
Level 6

Small addition to VJware, Best practices for Backup Exec 2014 Agent for Oracle on Windows or Linux Servers http://www.symantec.com/docs/HOWTO74434