Home » RDBMS Server » Backup & Recovery » Error in RMAN Backup (10.2.0.3.0 on Linux 64 bit)
Error in RMAN Backup [message #358994] Thu, 13 November 2008 03:32 Go to next message
MIFI
Messages: 256
Registered: February 2008
Location: U.K.
Senior Member
Hi,
Using 10.2.0.3.0 on linux 64 bit

I have scheduled daily back up by RMAN on production, following is my script.

run
{
backup database plus archivelog;
crosscheck archivelog all;
delete expired archivelog all;
}

Above scripts run scuccessfully on 11th and 12th but third day on 13th it is giving folloiwng error.

What can be the reason?

connected to target database: PROD(DBID=111873993000)
using target database control file instead of recovery catalog
Starting backup at 13-NOV-08

}

delete expired archivelog all;

crosscheck archivelog all;

backup database plus archivelog;

{

run

Additional information: 3

ORA-27037: unable to obtain file status
ORA-19625: error identifying file /home/u01/app/oracle/product/10.2.0/db_1/flash_recovery_area/PROD/archivelog/2008_11_08/o1_
RMAN-06059: expected archived log not found, lost of archived log compromises recoverability
RMAN-03002: failure of backup plus archivelog command at 11/13/2008 02:30:03
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
channel ORA_DISK_2: sid=421 devtype=DISK
allocated channel: ORA_DISK_2
channel ORA_DISK_1: sid=436 devtype=DISK
allocated channel: ORA_DISK_1
current log archived

Linux-x86_64 Error: 2: No such file or directory
Re: Error in RMAN Backup [message #359008 is a reply to message #358994] Thu, 13 November 2008 05:24 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
Have archive logs been deleted manually?

What is the output of:

RMAN> crosscheck archivelog all;
RMAN> list expired archivelog all;
Re: Error in RMAN Backup [message #359059 is a reply to message #359008] Thu, 13 November 2008 09:53 Go to previous messageGo to next message
varunvir
Messages: 363
Registered: November 2007
Senior Member
Hi Ebrian,
Can this issue be solved by giving crosscheck comand prior to
delete expired archive logs like:-
crosscheck archivelog all;
delete nopropmt expired archivelog;
Regards,
Varun Punj,
Re: Error in RMAN Backup [message #359061 is a reply to message #359059] Thu, 13 November 2008 10:14 Go to previous message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
Possibly. Delete would be the recommendation assuming the list showed files that were expired.

varunvir wrote on Thu, 13 November 2008 10:53

delete nopropmt expired archivelog;

However, the command would be "delete nopropmt expired archivelog ALL; "

Previous Topic: ORA-01157: cannot identify/lock data file 1 - see DBWR trace file
Next Topic: Recover Standby Database
Goto Forum:
  


Current Time: Wed Dec 07 14:26:29 CST 2016

Total time taken to generate the page: 0.08977 seconds