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>
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