SAP Data file error

[Former Member]

Hello,

I have changed the sap data file name using brtools  from /oracle/SID/sapdata3/sr4_22/sr4.data22 [D [D [D [D [D [D [D [D [D [D [D [D [D [D [D [D [D [D2 [C [C [C [C [C [C [C [C [C [C [C [C [C [C [C [C [C [C to /oracle/SID/sapdata3/sr4_22/sr4.data22

data file is online and no alert in alert log and health check but while i am taking backup getting error like

BR0069E File name /oracle/SID/sapdata2/sr4_23/sr4.data22 not unique - backup/verification not possible

BR0069E File name /oracle/SID/sapdata3/sr4_22/sr4.data22 not unique - backup/verification not possible

BR0056I End of database backup: besbarzc.and 2015-12-13 14.26.39

BR0280I BRBACKUP time stamp: 2015-12-13 14.26.39

BR0054I BRBACKUP terminated with errors

Please help.

Regards

Santosh

[ashish_mishra2]

BR0069E File name /oracle/SID/sapdata2/sr4_23/sr4.data22 not unique - backup/verification not possible
BR0069E File name /oracle/SID/sapdata3/sr4_22/sr4.data22 not unique -

You have datafile with name as sr4.data22 in two locations, one is inside sr4_23 and another is sr4_22 folder.

You will have to rename datafile inside sr4_23 folder from sr4.data22 to sr4.data23 (or to some other unique number) to remove duplicate names of datafiles at DB level.

You can achieve this using brtools  - Space management -  Alter data file - Rename data file

This should help.

Cheers !!!

Ashish

[Former Member]

Thanks Dear.

Problem solved.

[ashish_mishra2]

Awesome. If the problem has been solved, please close this thread as 'Answered'