RE: ARCHIVE LOG QUESTION
- From: "Powell, Mark" <mark.powell2@xxxxxx>
- To: "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
- 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.
-----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
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
