Hi,

Your strategy of not having RMAN do archivelog backups could expose you to
recovery issues if you are using a backup of your database which is older
than 7 days. This would be most obvious when doing hot backups with RMAN,
since the archive logs will be needed for the recovery.

What I would suggest is that you have RMAN backup your archive logs, then
delete the archivelogs older than 7 days. You can do a few little tricks
such as backing up archivelogs that have not been backed up a certain number
of times, or you can back up those which have been generated in the last
few days. This gives you multiple copies of the archivelogs (in case one
backup becomes corrupt).

With your current strategy, it would appear that if you had to do a recocery,
you would need to know up front what archivelogs were needed. With RMAN it
will simply use them when required, and automatically restore them to your
archive_dest if the required logs are not already there.

I suggest you have a tinker in a development environment to see what works
and what doesn't.

Paul




>-- Original Message --
>To: "LazyDBA Discussion" <[Email address protected]
>From: "BenBart " <oracledba-ezmlmshield-x76354306.[Email address protected]
>Date: Wed, 1 Mar 2006 12:39:03 +1300
>Subject: RMAN backup excluding the ARCHIVED logs
>
>
>Hi all,
>
>Am running out of space for my RMAN backup to disk. At the moment, there
>is an RMAN script that does a full backup to disk of the database and the
>archived logs and the archived logs themselves are retained on disks for
>7-days. The RMAN script does not delete the archived logs, there is another
>UNIX script that deletes the archived logs.
>
>I do not want to change dramatically the way the backup is going at the
moment,
>i.e., I do not want to change the RMAN script to do full backup of the database
>and the archived logs and then delete the archived logs after. WHY? No point,
>'coz the location of the RMAN backup to disk is different from where the
>archived logs are retained on a 7-day period. Besides, I didn't write the
>script so don't want to "stir" it a lot as it may get upset ... :-)
>
>Anyway, now, my question is, since I am retaining the archived logs on a
>7-day basis, technically, I should be able to just do an RMAN full database
>backup and forget about doing the RMAN archived logs backups. My only worry
>is whether RMAN will complain that I have not done an archived log backup
>when doing a restore or whether it will just pick up the archived logs as
>where they are now at present.
>
>It will be very much appreciated if I can hear from anyone who is currently
>doing the RMAN backup as how I want it to be ... Thanks in advance ...
>
>
>
>
>
>--------
>website: http://www.LazyDBA.com
>Please don't reply to RTFM questions
>Oracle documentation is here: http://tahiti.oracle.com
>To unsubscribe: see http://www.lazydba.com/unsubscribe.html
>To subscribe: see http://www.lazydba.com
>By using this list you agree to these terms:http://www.lazydba.com/legal.html
>


Oracle LazyDBA home page