Re: [Veritas-bu] [RETENTION] Application Backup Schedules ...

I'll confirm that it is the "Application"-type schedule that actually accepts the data and determines retention, NOT the Automatic schedule. Backing up with multiple retentions in one policy may be tricky, but can be done. One way is to ensure that two different-retention Application schedules have different windows and you initiate a backup during the open window of the one you want.

Remember, too, that in order for RMAN/Oracle to do a restore that you must configure RMAN/Oracle ("control_file_record_keep_time =ndays") to retain the information on your backups for sufficient time. Your DB backup information must be available from NetBackup and Oracle, whether control file or catalog.

cheers, wayne

On 6/11/07, Wilkinson, Alex <alex.wilkinson AT dsto.defence.gov DOT au> wrote:

Hi all,

Over the past 2 days I have been trying to pull together the mammoth amounts of
information on backing up Oracle via Netbackup/RMAN. In doing so I have been
re-reading lots of the documentation.

One of the pieces of reading that glaringly stood out to me was the following:

PG 78 "NetBackup for Oracle Sys Admin Guide for UNIX and Linux"

   "Retention Frequency-based scheduling:

    The retention period for an Application Backup schedule refers to the length
    of time that NetBackup keeps backup images.  <------------- EEEEEKKKKK !!!!!

    The retention period for an Automatic Full Backup, Automatic Differential
    Incremental Backup, or Automatic Cumulative Incremental Backup schedule
    controls how long NetBackup keeps records of when scheduled backups have occurred."

If I interpret this correctly this means for all "Application Backup Schedules"
(MSSQL,Oracle,SYBASE etc) - backup images are only being kept for 1 month.

We have always been under the impression that the retention set for "Automatic Full
Backup" was what NB used to keep backup images e.g. we have that set to 12
weeks, thinking that we could do a restore from 12 weeks in the past.

I hope I am wrong but this is how it looks.

Can someone please comment on the aforementioned ? Have 'I' misinterpreted the documentation ?

-aW

IMPORTANT: This email remains the property of the Australian Defence Organisation and is subject to the jurisdiction of section 70 of the CRIMES ACT 1914.  If you have received this email in error, you are requested to contact the sender and delete the email.

_______________________________________________
Veritas-bu maillist  -  Veritas-bu AT mailman.eng.auburn DOT edu
http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu

_______________________________________________
Veritas-bu maillist  -  Veritas-bu AT mailman.eng.auburn DOT edu
http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu