cancel
Showing results for 
Search instead for 
Did you mean: 

Restore DB13 Backup

former_member182034
Active Contributor
0 Kudos

hi All,

I took Whole Database Offline backup with DB13 now i want to restore this backup. the size of backup is 49GB while there is only 30GB free space in main SAP data directory. if I put backup on external directory then please tell me which parameter i have to change for this.

befvlvhy afd  2011-05-08 22.03.38  2011-05-09 03.17.02  0      
 5.0867:1     34    34     0     42745        636474713    42745 
636474713  ALL          offline_force   disk             ---k-c 7.00 (43)

please tell me in above log, which number i will use as a sequence in restore command.

Regards,

majamil

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

Hi Majamil,

hi All,

> I took Whole Database Offline backup with DB13 now i want to restore this backup. the size of backup is 49GB while there is only 30GB free space in main SAP data directory. if I put backup on external directory then please tell me which parameter i have to change for this.

>

>

befvlvhy afd  2011-05-08 22.03.38  2011-05-09 03.17.02  0      
>  5.0867:1     34    34     0     42745        636474713    42745 
> 636474713  ALL          offline_force   disk             ---k-c 7.00 (43)

>

> please tell me in above log, which number i will use as a sequence in restore command.

>

> Regards,

> majamil

In order to change the target location, check the link, below;

http://help.sap.com/saphelp_45b/helpdata/en/a0/897415dc4ad111950d0060b03c6b76/content.htm

brrestore -m /oracle/C11/sapdata1=/oracle/C11/sapdata5
Restore all the database data files from the subdirectories of 
/oracle/C11/sapdata1 into the directory /oracle/C11/sapdata5.

> please tell me in above log, which number i will use as a sequence in restore command.

You don't need to import offline redolog files into the system, if you just want to open the database. But, if you would like to come to the specific time, you need to find the correct log sequence in the backup log file, near the "Next log sequence to archive" string. However, the system will request the correct sequence number when you are importing offline redolog files in to the system.

Best regards,

Orkun Gedik

Former Member
0 Kudos

Hi,

You can replace the location of the file in the backup log which you will be providing for restore as well.

Replace each path with the redirected location.

Regards,

Karan Shah

Former Member
0 Kudos

Hi Karan,

It is correct, also. But, with the patch 20 of BRTools 7.00 you don't need to have any modification on neither a log file nor configuration file. Check the note 1003028 - Enhanced support for database copy in BRTools. This is the easiest way to redirect restore target to another location.

Best regards,

Orkun Gedik

Former Member
0 Kudos

By default the backup will be taken to /oracle/<SID>/sapbackup (UNIX) and <drive>\oracle\<SID>\sapbackup (windows)

if this the case then if you want to restore the database then you should be able to do it as you need to delete the existing database before you start restoring. Mean you will get disk space back if you delete. If not then you need to change the parameter in /oracle/<SID>/<db_version>/dbs/init<SID>.sap and change the parameter backup_root_dir.