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

[Former 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

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

[paul_power]

Dear Tezza,

You could also try to rename or move this datafile as per SAP note 868750  How to relocate/rename a datafile

If that doesnt work you may need to use the solution given in SAP Note 19519.

As per this note, there are two solutions:

Option 1 is possible without loss of data, however, you must either
have a backup of the missing file and all the redo logs created since
that file was backed up.

Option 2 is possible without the missing file and without a recovery.
However, all data of tables partially or entirely contained in the
missing data file are lost.

Recommended is to use Option 1. e.g.
1)alter database rename file which is causing the issue' to 'filename';
2)The backup of the missing file has to be stored under
  'filename' again.
3)recover datafile 'filename';          or

recover database;                     (see Note 4161)

4)alter database open

Please read the whole note 19519 very carefully and see the current
scenario in your case and proceed with the respective solution.This will

Regards,

Paul

[Reagan]

Hello

I believe he very well knows how to drop a datafile and the requirement is to take a full backup before he does anything to fix this issue.

Have you considered taking the datafile offline and then trigger a backup ?

Cheers

RB

[former_member188883]

Hi Tezza,

If the datafile is empty could you drop the datafile and then try to take backup.

alter tablespace <tablespace name> drop datafile '/oracle/PRD/112_64/dbs/PSAPR3I';

Hope this helps.

Regards,

Deepak Kori