Home » RDBMS Server » Backup & Recovery » RMAN error question from a newbie (Oracle 10.2.0.3.0)
RMAN error question from a newbie [message #283624] Tue, 27 November 2007 14:14 Go to next message
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




Re: RMAN error question from a newbie [message #283641 is a reply to message #283624] Tue, 27 November 2007 16:20 Go to previous messageGo to next message
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.
Re: RMAN error question from a newbie [message #288802 is a reply to message #283624] Tue, 18 December 2007 14:49 Go to previous message
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.
Previous Topic: RMAN Parallel Recovery
Next Topic: Flashback archive in oracle 11g
Goto Forum:
  


Current Time: Mon Dec 05 11:18:03 CST 2016

Total time taken to generate the page: 0.10520 seconds