OraFAQ Forum: Other Application Suites » brbackup failing due to file in recovery mode

Home » Applications » Other Application Suites » brbackup failing due to file in recovery mode (oracle 11.0.2)

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

brbackup failing due to file in recovery mode [message #583757]

Fri, 03 May 2013 11:11

tezza105
Messages: 2
Registered: May 2013

Junior Member

Hi there
I have an issue with a empty datafile (name seems to be corrupt)
I would like to get a backup before doing anything to fix this,
Because of this backups have failed for 2 days now - is there a way to get brbackup to ignore this datafile.

Backup command is :
brbackup -t online -d disk -k no -m all -c force -o dist,time -u / -a -p initP.sap save_delete -d disk -k no -l E -c force -u /

I have tried backing up just one tablespace, but any backup I try results in BR0334E error shown below

BR0051I BRBACKUP 7.20 (29)
BR0055I Start of database backup: belcqxat.pnd 2013-05-03 09.16.15
BR0484I BRBACKUP log file: /oracle/PRD/backup/belcqxat.pnd
BR0477I Oracle pfile /oracle/PRD/112_64/dbs/initP.ora created from spfile /oracle/
PRD/112_64/dbs/spfileP.ora
BR0334E Status of database file /oracle/PRD/112_64/dbs/PSAPR3I ^?;^? is
RECOVER
BR0274W File '/oracle/PRD/112_64/dbs/PSAPR3I ^?;^?' not found
BR0314E Collection of information on database files failed

BR0056I End of database backup: belcqxat.pnd 2013-05-03 09.16.18
BR0280I BRBACKUP time stamp: 2013-05-03 09.16.18
BR0054I BRBACKUP terminated with errors

Thanks for any help

Report message to a moderator

Re: brbackup failing due to file in recovery mode [message #583758 is a reply to message #583757]

Fri, 03 May 2013 11:57

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

I do not recognize that backup command at all.
Do any additional clues exist within alert_SID.log file

Report message to a moderator

Re: brbackup failing due to file in recovery mode [message #583759 is a reply to message #583758]

Fri, 03 May 2013 12:03

tezza105
Messages: 2
Registered: May 2013

Junior Member

Hi there
its a SAP backup command for oracle.
I cant get rid or re-create the datafile, as it cant find it due to the corrupt name. ( i have tried using file id instead of name but oracle still cant find file name)
SQL> recover datafile 9;
ORA-00283: recovery session canceled due to errors
ORA-01110: data file 9: '/oracle/PRD/112_64/dbs/PSAPR3I'
ORA-01157: cannot identify/lock data file 9 - see DBWR trace file
ORA-01110: data file 9: '/oracle/PRD/112_64/dbs/PSAPR3I'

Is there an oracle backup command to ignore errors and continue backing up everything else
Thanks

Report message to a moderator

Re: brbackup failing due to file in recovery mode [message #583762 is a reply to message #583759]

Fri, 03 May 2013 12:18

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

Senior Member
Account Moderator

Quote:

its a SAP backup command for oracle.I

This should then be posted in a SAP forum not an Oracle one.

Regards
Michel

Report message to a moderator

Previous Topic:	SAP ordered to pay Oracle
Next Topic:	SAP cannot find Java in the directory

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Dec 21 08:20:31 CST 2024