Question Re: BR restore error while refresh data from Production from Quality in Technology Q&A

BR restore error while refresh data from Production from Quality

Former Member — Wed, 10 Apr 2013 05:08:22 GMT

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.

Re: BR restore error while refresh data from Production from Quality

Former Member — Wed, 10 Apr 2013 08:58:43 GMT

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

Re: BR restore error while refresh data from Production from Quality

Former Member — Wed, 10 Apr 2013 08:58:50 GMT

Hi Jose,

You should delete existing datafiles on destination host.

Best regards,

Orkun Gedik

Re: BR restore error while refresh data from Production from Quality

Former Member — Wed, 10 Apr 2013 09:08:55 GMT

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.

Re: BR restore error while refresh data from Production from Quality

former_member182034 — Wed, 10 Apr 2013 10:31:00 GMT

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,

Re: BR restore error while refresh data from Production from Quality

Former Member — Wed, 10 Apr 2013 12:35:53 GMT

Hi Jose,

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

Regards,

Deepak Kori

Re: BR restore error while refresh data from Production from Quality

Former Member — Wed, 10 Apr 2013 12:38:24 GMT

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

Re: BR restore error while refresh data from Production from Quality

Former Member — Thu, 11 Apr 2013 08:37:55 GMT

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.