cancel
Showing results for 
Search instead for 
Did you mean: 

BR restore error while refresh data from Production from Quality

Former Member
0 Kudos

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.

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi Jose,

You should delete existing datafiles on destination host.

Best regards,

Orkun Gedik

Former Member
0 Kudos

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_member188883
Active Contributor
0 Kudos

Hi Jose,

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

Regards,

Deepak Kori

Former Member
0 Kudos

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
0 Kudos

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.

Answers (2)

Answers (2)

former_member182034
Active Contributor
0 Kudos

hi Jose,

Not enough disk

the above error will be eliminate when you make required free space otherwise you can not restore because brrestore command automatically calculate the everything which is required for restore.

Regards,

former_member188883
Active Contributor
0 Kudos

Hi Jose,

If the file system space is same in PRD and QAS , you may need to cleanup older files from following locations on QAS server

Oracle/SID/dapdata1 and sapdata5

Post this it should work

Regards,

Deepak Kori