Oldest Archive Log needed

From: <zipRoberts_at_gmail.com>
Date: Fri, 28 Dec 2007 14:09:37 -0800 (PST)
Message-ID: <159ac737-e888-428b-bbde-f60244442adf@j64g2000hsj.googlegroups.com>

I have an oracle 10g database in archivelog mode. It runs for a few days generating archive log files and I do a hot backup, a few more days go by and I do another backup.

Assuming the last two backups are good and I only need the last one how do I determine the oldest archive log to keep so I can delete the old ones not needed for the most recent backup.

Thanks. Received on Fri Dec 28 2007 - 16:09:37 CST

Original text of this message