Skip to Content
0
Former Member
May 03, 2013 at 05:17 PM

BR0334E brbackup failing due to file in recovery mode ( name seems to be corrupt)

363 Views

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

I cannot recreate the datafile using :

alter database create datafile as I receive error :

ORA-01516: nonexistent log file, data file, or temporary file

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'

SQL> SELECT * FROM v$recover_file;
FILE# ONLINE ONLINE_
---------- ------- -------
ERROR
CHANGE#
----------------------------------------------------------------- ----------
TIME
---------------
9 OFFLINE OFFLINE
FILE NOT FOUND


SQL> SQL> SELECT d.name, t.name
2 FROM v$datafile d, v$tablespace t
3 WHERE t.ts# = d.ts#
4 AND d.file# in (9);

NAME
--------------------------------------------------------------------------------
NAME
------------------------------
/oracle/PRD/112_64/dbs/PSAPR3I
PSAPR3I

I know datafile is empty as it was just created before the error started

Is there a way to force backup to ignore this error and backup . I have tried selecting just one tablespace, but backup always fails


Thanks for any help