File name not unique Backup verification not possible

[Former Member]

hi all,

i took backup through DB13 and also from BRTOOLS then i got the following error...................

BR0051I BRBACKUP 7.00 (32)

BR0055I Start of database backup: bebamvwt.and 2009-07-16 12.49.39

BR0484I BRBACKUP log file: /oracle/DEV/sapbackup/bebamvwt.and

BR0477I Oracle pfile /oracle/DEV/102_64/dbs/initDEV.ora created from spfile /ora cle/DEV/102_64/dbs/spfileDEV.ora

BR0280I BRBACKUP time stamp: 2009-07-16 12.49.40

BR0319I Control file copy created: /oracle/DEV/sapbackup/cntrlDEV.dbf 17678336

BR0069E File name /oracle/DEV/sapdata2/sr3_10/sr3.data10 not unique - backup/ver ification not possible

BR0069E File name /oracle/DEV/sapdata3/sr3_10/sr3.data10 not unique - backup/ver ification not possible

BR0069E File name /oracle/DEV/sapdata2/sr3_11/sr3.data11 not unique - backup/ver ification not possible

BR0069E File name /oracle/DEV/sapdata3/sr3_11/sr3.data11 not unique - backup/ver ification not possible

BR0069E File name /oracle/DEV/sapdata2/sr3_12/sr3.data12 not unique - backup/ver ification not possible

BR0069E File name /oracle/DEV/sapdata3/sr3_12/sr3.data12 not unique - backup/ver ification not possible

BR0069E File name /oracle/DEV/sapdata2/sr3_2/sr3.data2 not unique - backup/verif ication not possible

BR0069E File name /oracle/DEV/sapdata3/sr3_2/sr3.data2 not unique - backup/verif ication not possible

BR0069E File name /oracle/DEV/sapdata2/sr3_3/sr3.data3 not unique - backup/verif ication not possible

BR0069E File name /oracle/DEV/sapdata3/sr3_3/sr3.data3 not unique - backup/verif ication not possible

BR0069E File name /oracle/DEV/sapdata2/sr3_4/sr3.data4 not unique - backup/verif ication not possible

can anyone help me to findout that error.........

thanks....

[Former Member]

Hi,

Can you check your environment variables. Probably the environment variable LD_LIBRARY_PATH is not set or not set correctly. As a result, the catalog information has not been been to the control file by the Recovery Manager. I don't think this backup will result in a successful restore and recovery using the Recovery Manager since the catalog information is not present.

Thanks,

Subhajit.

[Former Member]

Aftab,

You need to rename these files one by one.

If you use BR*Tools, it will take care of stopping & starting of DB.

Thanks

Sushil

[Former Member]

hi Sushil

i renamed all the datafiles successfully, then i started full online + redo logfile backup by DB13

then it shows the following error below:

BR0063I 48 of 48 files processed - 107330.375 MB of 107330.375 MB done

BR0204I Percentage done: 100.00%, estimated end time: 15:20

BR0001I **************************************************

BR0280I BRBACKUP time stamp: 2009-07-17 15.20.31

BR0317I 'Alter tablespace SYSTEM end backup' successful

BR0280I BRBACKUP time stamp: 2009-07-17 15.20.33

BR0530I Cataloging backups of all database files...

BR0278E Command output of 'SHELL=/bin/sh /oracle/DEV/102_64/bin/rman nocatalog':

ld.so.1: rman: fatal: relocation error: file /oracle/DEV/102_64/bin/rman: symbol qmtinit_wait_evt_: referenced symbol not found

BR0280I BRBACKUP time stamp: 2009-07-17 15.20.34

BR0279E Return code from 'SHELL=/bin/sh /oracle/DEV/102_64/bin/rman nocatalog': 137

BR0536E RMAN call for database instance DEV failed

BR0280I BRBACKUP time stamp: 2009-07-17 15.20.34

BR0532E Cataloging backups of all database files failed

BR0056I End of database backup: bebascul.fnd 2009-07-17 15.20.34

BR0280I BRBACKUP time stamp: 2009-07-17 15.20.34

BR0054I BRBACKUP terminated with errors

BR0280I BRBACKUP time stamp: 2009-07-17 15.20.34

BR0291I BRARCHIVE will be started with options '-U -jid FLLOG20090717143211 -d disk -c force -p initDEV.sap -sd'

BR0280I BRBACKUP time stamp: 2009-07-17 15.20.36

BR0292I Execution of BRARCHIVE finished with return code 0

now how can i fix that error

thanks

aftab mansoor

[former_member475159]

Hi Aftab,

The 3rd party backup program that you are using had some sort of problem like:

- bad tape

- network problem

- backint crash

etc...

You must contact ypur backup administrator or somebody who looks after disk,network he`s the only one who can fix this problem. this is not a SAP/Oracle problem. ...

Thanks

Debdeep

[former_member475159]

Hi Aftab,

Let me explain you in detail. In one line of your error log the below info is present

"BR0279E Return code from 'SHELL=/bin/sh /oracle/DEV/102_64/bin/rman nocatalog': 137"

Shell script is giving return code 137. The meaning of Return code 137 is

Exit code 137: The job was killed because it exceeded the time limit.

This means the job waited for a particular amount of time to write in the disk but unfortunately disk was not avaliable due to some reason, it then killed itself.

So contact were network team or hardware vendor.

Thanks

Debdeep

[Former Member]

hi Debdeep

thanks for your detail explanation, but below script is showing that backup is 100% successfully done. So will you tell me that can i restore that backup file in another machine............ it would work fine ?

BR0063I 48 of 48 files processed - 107330.375 MB of 107330.375 MB done

BR0204I Percentage done: 100.00%, estimated end time: 15:20

BR0001I **************************************************

BR0280I BRBACKUP time stamp: 2009-07-17 15.20.31

BR0317I 'Alter tablespace SYSTEM end backup' successful

thanks

aftab

[former_member475159]

Hi Mansoor,

Your backup is successful, but after that it is trying to CATALOG something somewhere in the disk, and then it is not able to access the disk.

Yes sure you can go and try it in another server and lets see what happens,

Thanks

Debdeep

[Former Member]

Hi Aftab,

Check SAP Note 17163.

Check Oracle metalink 230449.1

Check below link which tells SYRMGR that SYRMGR is not present in these days in database, it was present in old Oracle release.

You can rename the datafile name by using BR*Tools as below

BRTools>2.space management>5 - Alter data file>Select option 3> Press continue-->select option 6 = Rename data file.

Here new data file name & press continue. DB will be remounted during this step.

Hope this helps

Thanks

Sushil

[Former Member]

hi

tell me that is there any option to remame these at once, bcz there are too many files

BR0069E File name /oracle/DEV/sapdata2/sr3_10/sr3.data10 not unique - backup/ver ification not possible

BR0069E File name /oracle/DEV/sapdata3/sr3_10/sr3.data10 not unique - backup/ver ification not possible

BR0069E File name /oracle/DEV/sapdata2/sr3_11/sr3.data11 not unique - backup/ver ification not possible

BR0069E File name /oracle/DEV/sapdata3/sr3_11/sr3.data11 not unique - backup/ver ification not possible

BR0069E File name /oracle/DEV/sapdata2/sr3_12/sr3.data12 not unique - backup/ver ification not possible

BR0069E File name /oracle/DEV/sapdata3/sr3_12/sr3.data12 not unique - backup/ver ification not possible

BR0069E File name /oracle/DEV/sapdata2/sr3_2/sr3.data2 not unique - backup/verif ication not possible

BR0069E File name /oracle/DEV/sapdata3/sr3_2/sr3.data2 not unique - backup/verif ication not possible

BR0069E File name /oracle/DEV/sapdata2/sr3_3/sr3.data3 not unique - backup/verif ication not possible

BR0069E File name /oracle/DEV/sapdata3/sr3_3/sr3.data3 not unique - backup/verif ication not possible

BR0069E File name /oracle/DEV/sapdata2/sr3_4/sr3.data4 not unique - backup/verif ication not possible

or i have to rename it one by one .......and also DB should be off or not

thanks for response

aftab

[anindya_bose]

Steps:

1. Shutdown the database

2. startup mount

so the control file is available without opening the datafiles.

3. Write a SQL script for all the datafile to be renamed and then execute that at once.

Example: Change_Name.SQL

>alter database rename file '<old file path1>' to '<new file path1>'

>alter database rename file '<old file path2>' to '<new file path2>'

so on...

4. alter database open;

5. Create a backup of new control file by executing command.

alter database backup controlfile to trace;

Edited by: Anindya Bose on Jul 17, 2009 1:08 PM

[Former Member]

Hi,

Check below link.

Regards

Ashok Dalai