OraFAQ Forum: Backup & Recovery » Oracle 9i - Cannot delete Archived Redolog files

Home » RDBMS Server » Backup & Recovery » Oracle 9i - Cannot delete Archived Redolog files

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Oracle 9i - Cannot delete Archived Redolog files [message #219079]

Mon, 12 February 2007 19:05

Ista
Messages: 14
Registered: January 2007

Junior Member

Greeitngs,

I noticed in our Oralce9i, that there is a large number of archived redolog files.
I tried the following commands to delete them using rman but could not.
Some of them go back as far as last August. It is currently using almost 29GB of disk usage.
I tried using the following commands but non of them seem to see these files.
When I try to list them I got only one file.
What are the available options to delete them?

Thanks.

=================================

RMAN> list archivelog all;

List of Archived Log Copies
Key Thrd Seq S Low Time Name
------- ---- ------- - --------- ----
10859 1 6116 A 12-FEB-07 /opt/app/db/oracle/u06/oradata/APP/1_6116.dbf

================

RMAN> report obsolete;

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of report command at 02/12/2007 18:19:31
RMAN-06525: RMAN retention policy is set to none

=========================================

RMAN> crosscheck archivelog all;

allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=104 devtype=DISK
specification does not match any archive log in the recovery catalog

=========================================

RMAN> list expired archivelog all;

specification does not match any archive log in the recovery catalog

===================================================

RMAN> DELETE ARCHIVELOG ALL;

released channel: ORA_DISK_1
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=104 devtype=DISK
specification does not match any archive log in the recovery catalog

Report message to a moderator

Re: Oracle 9i - Cannot delete Archived Redolog files [message #219082 is a reply to message #219079]

Mon, 12 February 2007 19:47

ebrian
Messages: 2794
Registered: April 2006

Senior Member

The archive logs are probably from a previous incarnation of the database. What is the output of:

RMAN> list incarnation;

If there are previous incarnations, then you can probably just delete the older archive logs if you are certain that you've recently got a successful backup.

Report message to a moderator

Re: Oracle 9i - Cannot delete Archived Redolog files [message #219286 is a reply to message #219079]

Tue, 13 February 2007 19:17

Ista
Messages: 14
Registered: January 2007

Junior Member

Thanks for all your info.
I tried the list incarnation but found only one instance:
RMAN> list incarnation;

using target database controlfile instead of recovery catalog

List of Database Incarnations
DB Key Inc Key DB Name DB ID CUR Reset SCN Reset Time
------- ------- -------- ---------------- --- ---------- ----------
1 1 APPDB 3286426219 YES 1 04-AUG-06

And the archived redologs go back to that date as well.

Any suggestions.

Thanks.

Report message to a moderator

Re: Oracle 9i - Cannot delete Archived Redolog files [message #219306 is a reply to message #219286]

Tue, 13 February 2007 22:53

ebrian
Messages: 2794
Registered: April 2006

Senior Member

What is your value for CONTROL_FILE_RECORD_KEEP_TIME and the output for:

RMAN> list backup;

* Do you get any output with SELECT * FROM V$RECOVER_FILE ?
* Have you excluded any tablespaces from backups?
* How are you deleting the backup sets themselves?

What's strange is the fact that your command for DELETE ARCHIVELOG ALL should have prompted to delete the one archivelog that your LIST command was showing.

Report message to a moderator

Previous Topic:	Archivelogs error
Next Topic:	Oracle 9i Backup getting stuck

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu May 02 16:00:14 CDT 2024