| Error in RMAN Backup [message #358994] |
Thu, 13 November 2008 03:32  |
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 #359059 is a reply to message #359008] |
Thu, 13 November 2008 09:53  |
varunvir
Messages: 389
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 |
 |
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; "
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
