OraFAQ Forum: Backup & Recovery » RMAN error question from a newbie

Home » RDBMS Server » Backup & Recovery » RMAN error question from a newbie (Oracle 10.2.0.3.0)

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

RMAN error question from a newbie [message #283624]

Tue, 27 November 2007 14:14

giovannym
Messages: 4
Registered: November 2007

Junior Member

Greetings everyone,

I just joined this community the other day and I have to say lots of great information for newbies such as myself. I was recently blessed to the dba position with no training. I started looking at our OEM nightly backups and noticed backups have been failing. This is the error msg:
"
...
...
channel oem_disk_backup: reading from backup piece /u02/flashback/LIVE/backupset/2007_11_12/o1_mf_nnnd1_TAG20071112T220130_3mlhfvt7_.bkp
released channel: oem_disk_backup
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 11/26/2007 21:00:22
ORA-19870: error reading backup piece /u02/flashback/LIVE/backupset/2007_11_12/o1_mf_nnnd1_TAG20071112T220130_3mlhfvt7_.bkp
ORA-19505: failed to identify file "/u02/flashback/LIVE/backupset/2007_11_12/o1_mf_nnnd1_TAG20071112T220130_3mlhfvt7_.bkp"
ORA-27037: unable to obtain file status
Linux Error: 2: No such file or directory
Additional information: 3

RMAN> exit;

Recovery Manager complete."

Like I mentioned I have never used RMAN or had any training as a dba so i'm self teaching myself here hehe. I'm not sure why a bkp file is not there for it to find, but I read somewhere that perhaps I might need to purge the RMAN catalog. Anyone run into this before?

Again I apologize in advance if this is a dumb question but i'm totally new and a bit lost Sad

Report message to a moderator

Re: RMAN error question from a newbie [message #283641 is a reply to message #283624]

Tue, 27 November 2007 16:20

ebrian
Messages: 2794
Registered: April 2006

Senior Member

Are you using a recovery catalog?

First verify if the file is actually on the filesystem. Then run the following command while in RMAN from the command prompt:

RMAN> crosscheck backup;
RMAN> delete expired backup;

Then try the backup again.

With being new, the following documentation may also help:

� Backup and Recovery Basics
� Backup and Recovery Quick Start Guide
� Backup and Recovery Advanced User's Guide

BTW...welcome to the forum.

Report message to a moderator

Re: RMAN error question from a newbie [message #288802 is a reply to message #283624]

Tue, 18 December 2007 14:49

giovannym
Messages: 4
Registered: November 2007

Junior Member

I know this is late, sry been on vacation but thank you so much for your response it was very helpful.

Report message to a moderator

Previous Topic:	RMAN Parallel Recovery
Next Topic:	Flashback archive in oracle 11g

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Apr 25 21:14:13 CDT 2026