Re: Ocopy and Archived Logs
Date: Sat, 12 Dec 2009 09:30:19 -0800 (PST)
On Dec 8, 9:26 am, Gary <gjwater..._at_gmail.com> wrote:
> What command can be used to show which archive log files needed to
> restore from the most recent ocopy backup? Is there such a command?
You can query something like:
from v$archived_log l,
where l.activation# = d.activation#
and l.next_change# <
(select min(change#) from v$backup);
The above query lists all archivelogs older than the earliest startbackup time of all datafiles. You can delete logs in this list, assuming that:
- You are in fact using tablespace hot backup mode. If not, then all open backups are invalid.
- You never want to recover to a point in time prior to the most recent backup using a prior backup
- You are in fact copying all files that you put into backup mode
- Your controlfile record keep time is longer than the age of your oldest archivelog
Blue Gecko, Inc.
http://www.bluegecko.net Received on Sat Dec 12 2009 - 11:30:19 CST