Home » RDBMS Server » Backup & Recovery » Backup Failed (WIndows 2008 r2, oracle 11g)
Backup Failed [message #606981] Fri, 31 January 2014 10:39 Go to next message
fariha
Messages: 2
Registered: January 2014
Location: mississauga, Canada
Junior Member
Hi,

every night my database backup successfully completed at 5PM but last evening i got following error.

released channel: CH1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of backup command on CH1 channel at 01/30/2014 17:13:58
ORA-19505: failed to identify file "F:\DBDATA\FAST_RECOVERY_AREA\KENNADM\ARCHIVELOG\2014_01_28\O1_MF_1_10699_9GJWFWSQ_.ARC"
ORA-27041: unable to open file
OSD-04002: unable to open file
O/S-Error: (OS 2) The system cannot find the file specified.

Recovery Manager complete.

please help me to resolve this

Fariha
Re: Backup Failed [message #606982 is a reply to message #606981] Fri, 31 January 2014 10:53 Go to previous messageGo to next message
John Watson
Messages: 4548
Registered: January 2010
Location: Global Village
Senior Member
Run a crosscheck of your archive logfiles to see what is missing. Then you have to decide whether to delete expired archives from the repository, or whether to try to find out what happened.
You might want to crosscheck your backupsets and copies: if something has damaged an archive logfile, it may have damaged other files too.
Re: Backup Failed [message #606988 is a reply to message #606982] Fri, 31 January 2014 12:29 Go to previous messageGo to next message
fariha
Messages: 2
Registered: January 2014
Location: mississauga, Canada
Junior Member
Thank you so much for your reply. I am confuse when i run crosscheck archivelog all; it does not show me all the file some files vanish very quickly how i can see all the archive log file.
Re: Backup Failed [message #606989 is a reply to message #606988] Fri, 31 January 2014 13:42 Go to previous messageGo to next message
Michel Cadot
Messages: 59065
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Why do you mean by "it does not show me all the file some files vanish very quickly "?

Re: Backup Failed [message #607012 is a reply to message #606988] Sat, 01 February 2014 07:38 Go to previous messageGo to next message
EdStevens
Messages: 271
Registered: September 2013
Senior Member
fariha wrote on Fri, 31 January 2014 12:29
Thank you so much for your reply. I am confuse when i run crosscheck archivelog all; it does not show me all the file some files vanish very quickly how i can see all the archive log file.


Just to expand on Michael's response ... what are you expecting from a crosscheck command? Crosscheck reads the record of archivelogs (or backups) as recorded in the control file, then checks that those archivelogs (or backups) actually exist. If a particular archivelog (or backup) is found to have gone missing, its record in the control file is marked as 'expired'. That is all. While running, the command reports the results of every record/file that it is crosschecking.
Re: Backup Failed [message #607129 is a reply to message #606988] Mon, 03 February 2014 02:48 Go to previous message
gazzag
Messages: 315
Registered: November 2010
Location: Bristol, UK
Senior Member
RMAN> SPOOL LOG TO arclog_chk.log
RMAN> CROSSCHECK ARCHIVELOG ALL;
RMAN> SPOOL LOG OFF


Then review the contents of the log file, "arclog_chk.log".

HTH
-g
Previous Topic: restore online backup to different server with different dir
Next Topic: Incremental Vs Ar chive log backups
Goto Forum:
  


Current Time: Mon Sep 15 04:58:53 CDT 2014

Total time taken to generate the page: 0.13578 seconds