Home » RDBMS Server » Backup & Recovery » RMAN Backup failed - RMAN-06059 error
RMAN Backup failed - RMAN-06059 error [message #203322] Tue, 14 November 2006 15:35 Go to next message
pzlj6x
Messages: 107
Registered: May 2005
Location: Louisville
Senior Member


Could somebody help me this problem? The RMAN does not find the archived log file
test11_2754_5979.dbf while doing the HOT BACKUP.
Where as the previous archivelogs backup fine and next archivelogs are backup fine.
Any idea as what could cause this and what's the remidy for it.


RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of backup command at 11/14/2006 02:25:15
RMAN-06059: expected archived log not found, lost of archived log compromises recoverability
ORA-19625: error identifying file /opt/orafilelocs/arc/test/test11_2754_5979.dbf
ORA-27037: unable to obtain file status
SVR4 Error: 2: No such file or directory
Additional information: 3
RMAN Backup failed
Re: RMAN Backup failed - RMAN-06059 error [message #203324 is a reply to message #203322] Tue, 14 November 2006 15:40 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
Does the file actually exist on the filesystem? You can run:

RMAN> crosscheck archivelog all;

and then run:

RMAN> list expired archivelog all;

to see if it lists any missing archive logs.
Re: RMAN Backup failed - RMAN-06059 error [message #203325 is a reply to message #203322] Tue, 14 November 2006 15:47 Go to previous messageGo to next message
pzlj6x
Messages: 107
Registered: May 2005
Location: Louisville
Senior Member
The file does not exist in the filesystem. it has a threshold as > 10%, unix cleans it up.

Got the following while doing a crosscheck archivelog all;

RMAN> connect target sys/***@test

connected to target database: TEST (DBID=15******)

RMAN> connect rcvcat rman/****@testdmp0

connected to recovery catalog database

RMAN> crosscheck archivelog all;

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

RMAN> exit

What does this mean ?

[Updated on: Tue, 14 November 2006 15:50]

Report message to a moderator

Re: RMAN Backup failed - RMAN-06059 error [message #203331 is a reply to message #203325] Tue, 14 November 2006 16:00 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
For future reference, you should have RMAN remove the archivelogs from the filesystem.

For your current problem, you can try to issue:

RMAN> delete force obsolete;

and then try to backup the archivelogs again.
Re: RMAN Backup failed - RMAN-06059 error [message #203332 is a reply to message #203322] Tue, 14 November 2006 16:10 Go to previous messageGo to next message
pzlj6x
Messages: 107
Registered: May 2005
Location: Louisville
Senior Member
Sorry, I probably misunderstood your question. RMAN does remove the archivelog files to filesystem.

What does this command do ?

delete force obsolete;
Re: RMAN Backup failed - RMAN-06059 error [message #203334 is a reply to message #203332] Tue, 14 November 2006 16:25 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
If you say that RMAN actually removed these archivelogs from the filesystem, then was there a restore performed recently ? What version of the target database, RMAN client and recovery catalog are you using ?

In your case, the 'delete force obsolete' should resolve any inconsistencies between the recovery catalog and the controlfile.
Re: RMAN Backup failed - RMAN-06059 error [message #203545 is a reply to message #203322] Wed, 15 November 2006 08:22 Go to previous message
pzlj6x
Messages: 107
Registered: May 2005
Location: Louisville
Senior Member
No restore performed recently to that database.
We are using Oracle 10g R2.
Previous Topic: ORA-01156 on deleting tablespace
Next Topic: Backup Strategy
Goto Forum:
  


Current Time: Mon Dec 05 04:38:39 CST 2016

Total time taken to generate the page: 0.26520 seconds