OraFAQ Forum: Backup & Recovery » RMAN Backup failed

Home » RDBMS Server » Backup & Recovery » RMAN Backup failed - RMAN-06059 error

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

RMAN Backup failed - RMAN-06059 error [message #203322]

Tue, 14 November 2006 15:35

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

Report message to a moderator

Re: RMAN Backup failed - RMAN-06059 error [message #203324 is a reply to message #203322]

Tue, 14 November 2006 15:40

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.

Report message to a moderator

Re: RMAN Backup failed - RMAN-06059 error [message #203325 is a reply to message #203322]

Tue, 14 November 2006 15:47

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

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.

Report message to a moderator

Re: RMAN Backup failed - RMAN-06059 error [message #203332 is a reply to message #203322]

Tue, 14 November 2006 16:10

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;

Report message to a moderator

Re: RMAN Backup failed - RMAN-06059 error [message #203334 is a reply to message #203332]

Tue, 14 November 2006 16:25

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.

Report message to a moderator

Re: RMAN Backup failed - RMAN-06059 error [message #203545 is a reply to message #203322]

Wed, 15 November 2006 08:22

pzlj6x
Messages: 107
Registered: May 2005
Location: Louisville

Senior Member

No restore performed recently to that database.
We are using Oracle 10g R2.

Report message to a moderator

Previous Topic:	ORA-01156 on deleting tablespace
Next Topic:	Backup Strategy

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Dec 23 11:57:37 CST 2024