Home » RDBMS Server » Backup & Recovery » Oracle 9i - Cannot delete Archived Redolog files
Oracle 9i - Cannot delete Archived Redolog files [message #219079] Mon, 12 February 2007 19:05 Go to next message
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
Re: Oracle 9i - Cannot delete Archived Redolog files [message #219082 is a reply to message #219079] Mon, 12 February 2007 19:47 Go to previous messageGo to next message
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.
Re: Oracle 9i - Cannot delete Archived Redolog files [message #219286 is a reply to message #219079] Tue, 13 February 2007 19:17 Go to previous messageGo to next message
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.
Re: Oracle 9i - Cannot delete Archived Redolog files [message #219306 is a reply to message #219286] Tue, 13 February 2007 22:53 Go to previous message
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.

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


Current Time: Mon Dec 05 20:57:38 CST 2016

Total time taken to generate the page: 0.04903 seconds