Re: Archive logs files accumulating on my Oracle log mode Database

Osso wrote:
> Thanks for your the quick response.
>
> Just one point, surely once you have performed a backup of an oracle
> database configured in archive log mode, any archive logs files
> generated before the backup can be purged from the system?
>
> After all the last backup operation should have brought the backup
> files upto date? however any archive logs files generated after the
> backup should be kept so that if the system does fail, you can recover
> the last backup performed, and roll the database forwards using the log
> files to the point before the failure?
>
> Regards
> James
>

In theory, yes. But what if this backup proves to be faulty? Ah - you have a previous backup, ok. Ooops! Not the redo log files to go with it...

And remember: a "hot" backup is always an inconsistent backup. Always. Inconsistent.

-- 
Regards,
Frank van Bortel

Top-posting is one way to shut me up...