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
Karma: 0
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
Karma: 0
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
Karma: 0
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
Karma: 0
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: Comparing Oracle 9i with 10g
Next Topic: rman repository and duplicate DBID's
Goto Forum:
  


Current Time: Tue Aug 22 11:53:56 CDT 2017

Total time taken to generate the page: 0.04161 seconds