Home » Applications » Other Application Suites » brbackup failing due to file in recovery mode (oracle 11.0.2)
brbackup failing due to file in recovery mode [message #583757] Fri, 03 May 2013 11:11 Go to next message
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
Re: brbackup failing due to file in recovery mode [message #583758 is a reply to message #583757] Fri, 03 May 2013 11:57 Go to previous messageGo to next message
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
Re: brbackup failing due to file in recovery mode [message #583759 is a reply to message #583758] Fri, 03 May 2013 12:03 Go to previous messageGo to next message
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
Re: brbackup failing due to file in recovery mode [message #583762 is a reply to message #583759] Fri, 03 May 2013 12:18 Go to previous message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
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
Previous Topic: SAP ordered to pay Oracle
Next Topic: SAP cannot find Java in the directory
Goto Forum:
  


Current Time: Thu Mar 28 08:04:30 CDT 2024