RE: ARCHIVE LOG QUESTION

From: Powell, Mark <mark.powell2_at_hp.com>
Date: Thu, 10 Nov 2011 14:11:41 +0000
Message-ID: <7C4BF3B32B80CC44AE37D31B172415937DCEBFE809_at_GVW1337EXC.americas.hpqcorp.net>

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_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?

Denise Gwinn
DBA WVNET
--

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

--

http://www.freelists.org/webpage/oracle-l Received on Thu Nov 10 2011 - 08:11:41 CST