OraFAQ Forum: Backup & Recovery

Home » RDBMS Server » Backup & Recovery » Backup Failed (WIndows 2008 r2, oracle 11g)

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

Backup Failed [message #606981]

Fri, 31 January 2014 10:39

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

Report message to a moderator

Re: Backup Failed [message #606982 is a reply to message #606981]

Fri, 31 January 2014 10:53

John Watson
Messages: 9005
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.

Report message to a moderator

Re: Backup Failed [message #606988 is a reply to message #606982]

Fri, 31 January 2014 12:29

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.

Report message to a moderator

Re: Backup Failed [message #606989 is a reply to message #606988]

Fri, 31 January 2014 13:42

Michel Cadot
Messages: 68785
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

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

Report message to a moderator

Re: Backup Failed [message #607012 is a reply to message #606988]

Sat, 01 February 2014 07:38

EdStevens
Messages: 1377
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.

Report message to a moderator

Re: Backup Failed [message #607129 is a reply to message #606988]

Mon, 03 February 2014 02:48

gazzag
Messages: 1119
Registered: November 2010
Location: Bedwas, 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

Report message to a moderator

Previous Topic:	restore online backup to different server with different dir
Next Topic:	Incremental Vs Ar chive log backups

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Sep 15 10:54:42 CDT 2026