RE: ARCHIVE LOG QUESTION

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.


-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On 
Behalf Of Denise Gwinn
Sent: Wednesday, November 09, 2011 4:52 PM
To: oracle-l@xxxxxxxxxxxxx
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?

Denise Gwinn
DBA WVNET
--
http://www.freelists.org/webpage/oracle-l


--
http://www.freelists.org/webpage/oracle-l


Other related posts: