Offline backup fail

[Former Member]

Hi, Offline back is getting failed due to the following error in test server where as online backup

is successful.

BR0069E File name /oracle/QAS/sapdata1/temp_1/temp.data1 not unique - backup/verification not possible

BR0069E File name /oracle/QAS/sapdata4/temp_1/temp.data1 not unique - backup/verification not possible

Any thoughts!!! - Thanks.

[Former Member]

Hi,

Use brtools to rename file /oracle/QAS/sapdata4/temp_1/temp.data1 to /oracle/QAS/sapdata4/temp_2/temp.data2

Please try this and it shall work.

Thanks

Rishi Abrol

[Former Member]

Hi Jack,

Please rename one of the file. ther are two type of doing offline nad online.

Online process

Login to SQLPlus.

Connect as SYS DBA with CONNECT / AS SYSDBA command

ALTER TABLESPACE <tablespace name> OFFLINE;

ALTER TABLESPACE <tablespace name> RENAME DATAFILE u2018<fully qualified path to original data file name>u2019 TO u2018<new or original fully qualified path to new or original data file name>u2019;

ALTER TABLESPACE alter tablespace <tablespace name> ONLINE;

Regards,

Kiran Madhu

[Former Member]

Hi Jai,

Stop the

BR0069E File name %s not unique - backup/verification impossible.

Because the file name is not unique, files in the backup directory could be overwritten (during a backup to disk).

User action: Stop the database. Rename the file at operating system level.

Run the BRBACKUP

--Venkat