ARCHIVE LOG QUESTION

From: Denise Gwinn <denise_at_mail.wvnet.edu>
Date: Wed, 09 Nov 2011 16:51:37 -0500
Message-ID: <4EBAF5E9.7060300_at_mail.wvnet.edu>

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

Received on Wed Nov 09 2011 - 15:51:37 CST