Re: Deleting Archive Logs after backup

This keeps on cropping up.

The theory is dead easy: Once you have a complete backup, hot or cold, you may delete all archives that existed prior to the *start* of the backup.

But as I keep posting, and as many have concurred, you would be totally and completely mad (not to mention irresponsible) to simply delete in this fashion. It's far too aggressive. You are relying on the fact that when disaster strikes, the immediately-prior backup is retrievable and functional -because if it isn't, you will want to restore the backup before that... only that's now unseable because there are no archives between then and now.

And I speak from bitter experience in dropping tapes on the server room floor and discovering the backup before that had not actually been completed successfully.

I don't understand the comment about 'when you backup, Oracle was still looking for files to exist in their original location'. When you backup, Oracle isn't looking for anything, and certainly not archive logs (unless you are using RMAN??). If you mean, when you *recover* the database, Oracle prompts for archives from their old location, you can simply supply the correct location by typing it in. If you want to automate the recovery, you can do an 'alter system archive log start to 'new_path' ' just before doing it.

But it all sounds dodgy -I suspect the issue isonly arising because your init.ora is still telling the system to archive to the old location. Check your settings for log_archive_dest (or variants thereof).

Regards
HJR <woodsyj_at_my-deja.com> wrote in message news:8t23p1$gbl$1_at_nnrp1.deja.com...
> I have read that once you backup a database, you can delete the archive
> logs from the disk. How do you cooridinate this with Oracle. Here is
> an example of what we have done. We have moved from a 3 disk
> configuration to a 6 disk configuration. When we did this, we moved
> our archive log destination to another disk. We also moved all
> existing arhived logs. When I tried to do a backup, Oracle was still
> looking for the files to exist in their original location. Shouldn't I
> be able to just get rid of the older archives? How do I tell Oracle
> that they have moved or that they no longer exist on disk? Any help on
> the subject would be greatly appreciated.
>
> Thanks
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Tue Oct 24 2000 - 03:37:22 CDT