Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: difficult RMAN archivelog requirements

Re: difficult RMAN archivelog requirements

From: hpuxrac <johnbhurley_at_sbcglobal.net>
Date: 15 Feb 2005 17:11:02 -0800
Message-ID: <1108516262.444937.316520@z14g2000cwz.googlegroups.com>


What's wrong with this (runs once a day or weekly whatever)

step 1 ... crosscheck archivelog

step 2 ... rman backup of just the archive logs "all"

step 3 .... remove anything older than 1 day/week os utility / whatever ( may want to change criteria)

step 4 ... crosscheck archivelog

step 5 ... archive log current then rman backup of database include archive logs all ...

Most people would advocate keeping 2+ days of archive logs on your system if you are doing daily backups, 2+ weeks on your system if doing weekly (depends on volume etc). Received on Tue Feb 15 2005 - 19:11:02 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US