RE: ARCHIVE LOG QUESTION
Date: Thu, 10 Nov 2011 14:11:41 +0000
Denise, you do not delete from v$archive_log. The control file area that keeps track of the archived redo logs is used in a circular fashion.
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Denise Gwinn Sent: Wednesday, November 09, 2011 4:52 PM To: oracle-l_at_freelists.org
Subject: ARCHIVE LOG QUESTION
I have set up rman using flash_recovery. I've run a couple of backups
for testing. When I do the command:
SQL> archive log list
It returns oldest online sequence of 926; next log sequence to archive is 928.
However when I do:
SQL> select name from v$archived_log;
It returns 664 rows.
Is there a graceful way to get rid of the first 661 rows?
http://www.freelists.org/webpage/oracle-l Received on Thu Nov 10 2011 - 08:11:41 CST