BR restore error while refresh data from Production from Quality

[Former Member]

HI Experts,

              I am doing quality refresh using online backup. I have done the online backup. I have copied the backup label and log file into Production server to Quality (/oracle/SID/sapbackup). My production volume database size is 1.3 TB. while restoring data it is giving the error. Not enough disk Ospace in Oracle/SID/dapdata1 and sapdata5. I have analized the space in Quality and production. Sizing in quality and production server are same.

Quality server

Datafile1

Size 98gb     used 89gb    avail 8.0gb     capacity92%

Datafile 5

Size 69gb     used 66gb    avail 2.2gb    capacity97%

Production Server

Datafile1

Size 98gb     used 93gb   avail 4.6gb     capacity96%

Datafile 5

Size 69gb     used 65gb     avail 2.7gb     capacity97%

I am running the command brrestore -b bekxzcjd.fnt -m ful. It is giving the error Not enough disk Ospace in Oracle/SID/dapdata1 and sapdata5. Can any one pelase help me to solve this issue.

Regards

Jose H.

[Former Member · Accepted solution]

Hi Jose,

You should delete existing datafiles on destination host.

Best regards,

Orkun Gedik

[Former Member · Accepted solution]

Hi Orkun,

             Data fills not overwrite the existing data files? more than  200 data files are there, we need to delete all the existing the data files? Is there any alternative solution to overwrite the existing files. Please advise.

Thanks & Regards

Jose H.

[Former Member · Accepted solution]

Hi Jose,

You need to delete existing files and then restore from backup.

Regards,

Deepak Kori

[Former Member · Accepted solution]

Hi,

>> Data fills not overwrite the existing data files

It is easy to drop the sapdata files;

Go to /oracle/<DBSID>/sapdata<n>

rm -R *

Execute this operation for each sapdata folder over the system.

brrestore will create rest of the folder structure during the restore.

Best regards,

Orkun Gedik

[Former Member · Accepted solution]

Hi Orkun Gedik,

                   I deleted and recreated all the folders and started the restore. It was completed successfully.

Thanks for all your guidance

Thanks & Regards

Jose H.