Restoring Offline backup from External Hdd as i don't have space in local

[Former Member]

HI

I have taken Offline backup to External Disk and now i want to restore from External.

Wat parameter value need to be changed in INIT<SID>.SAP ?

as i don't have space in local Harddisk.. i Want to import the data From Expernal itself..

While taking backup i have given the Path fro parameter .. but when i try to restore from external HDD- it's searching in Oracle_ home/Sapbackup.

how can I proceed With this...

Thanks in Advance

Regards

Srinivas

[Former Member · Accepted solution]

Changed the parameter values and Tried..Still no Luck

# default: disk

backup_dev_type = disk

# backup root directory [<path_name> | (<path_name_list>)]

# default: %SAPDATA_HOME%\sapbackup

backup_root_dir = G:\sapbackup

# stage root directory [<path_name> | (<path_name_list>)]

# default: value of the backup_root_dir parameter

#stage_root_dir = D:\oracle\EH5\sapbackup

stage_root_dir = G:\sapbackup

# compression flag [no | yes | hardware | only | brtools]

# default: no

Regards

Srini

[Former Member · Accepted solution]

Hi,

  Can you please attach the error you are getting ?

SInce you have taken a offline backup, why cant you to try manually restore instead of using Brtools options.

Thanks and Regards,

Vimal

[Former Member · Accepted solution]

Hi Vimal,

Here With the Log

C:\Users\eh5adm>brrestore

BR0401I BRRESTORE 7.20 (1)

BR0405I Start of file restore: rekifwjd.rsb 2013-01-15 15.41.01

BR0484I BRRESTORE log file: D:\oracle\EH5\sapbackup\rekifwjd.rsb

BR0252E Function fopen() failed for 'D:\oracle\EH5\sapbackup\backEH5.log' at loc

ation last_back_get-1

BR0253E errno 2: No such file or directory

BR0121E Processing of log file D:\oracle\EH5\sapbackup\backEH5.log failed

BR0406I End of file restore: rekifwjd.rsb 2013-01-15 15.41.02

BR0280I BRRESTORE time stamp: 2013-01-15 15.41.02

BR0404I BRRESTORE terminated with errors

Thanks

[Former Member · Accepted solution]

Hi,

   Please go D:\oracle\EH5\sapbackup\ and check whether  backEH5.log is available.

If yes, please attach that file.

Are you trying to restore the same DB in which backup was performed ???

As well as please attach the initSID.sap file which is available inside the backup folder

Thanks and Regards,

Vimal

[Former Member · Accepted solution]

Hi Vimal, there is no backEH5.log ..instead  restEH5.log.

log content below..

rekifoxl rsb  2013-01-15 14.17.05  2013-01-15 14.17.06  3      0     0     0  ............ .......... ............  .... 7.20 (1)

rekifpfq rsb  2013-01-15 14.20.38  2013-01-15 14.20.38  3      0     0     0  ............ .......... ............  .... 7.20 (1)

rekifpjn rsb  2013-01-15 14.22.19  2013-01-15 14.22.19  3      0     0     0  ............ .......... ............  .... 7.20 (1)

rekifpmd rsb  2013-01-15 14.23.27  2013-01-15 14.23.27  3      0     0     0  ............ .......... ............  .... 7.20 (1)

rekifpsj rsb  2013-01-15 14.26.09  2013-01-15 14.26.09  3      0     0     0  ............ .......... ............  .... 7.20 (1)

rekifpuz rsb  2013-01-15 14.27.17  2013-01-15 14.27.17  3      0     0     0  ............ .......... ............  .... 7.20 (1)

rekifqxm rsb  2013-01-15 14.39.38  2013-01-15 14.39.38  3      0     0     0  ............ .......... ............  .... 7.20 (1)

rekifwjd rsb  2013-01-15 15.41.01  2013-01-15 15.41.02  3      0     0     0  ............ .......... ............  .... 7.20 (1)

[Former Member · Accepted solution]

backEH5.log file created in Backup Directory in external Hdd where i have taken the backup..

Yes. i am restoring Dadatabse in to the same system from which i have taken Offline Databse backup.

[Former Member · Accepted solution]

Hi,

    Please attach the rsb file as well as initSID.sap file which is available in backup folder.

Please confirm whether you are trying to restore the DB on the same system where you took backup.

Thanks and Regards,

Vimal

[Former Member · Accepted solution]

Hi,

Please copy backEH5.log to D:\oracle\EH5\sapbackup\ location and check whether it works.

Thanks and Regards,

Vimal

[Former Member · Accepted solution]

Hi Vimal,

Copied.. Still no luck,

C:\Users\eh5adm>brrestore

BR0401I BRRESTORE 7.20 (1)

BR0405I Start of file restore: rekigamu.rsb 2013-01-15 16.27.40

BR0484I BRRESTORE log file: D:\oracle\EH5\sapbackup\rekigamu.rsb

BR0252E Function fopen() failed for 'D:\oracle\EH5\sapbackup\bekibpts.afd' at lo

cation BrbLogRead-1

BR0253E errno 2: No such file or directory

BR0121E Processing of log file D:\oracle\EH5\sapbackup\bekibpts.afd failed

BR0406I End of file restore: rekigamu.rsb 2013-01-15 16.27.40

BR0280I BRRESTORE time stamp: 2013-01-15 16.27.40

BR0404I BRRESTORE terminated with errors

[Former Member · Accepted solution]

Hi,

  Sorry. I missed this.

Please copy bekibpts.afd which will be available in your backup folder to D:\oracle\EH5\sapbackup\.

Please check and provide your feedback.

Thanks and Regards,

Vimal

[Former Member · Accepted solution]

Hi VIMAL,

it says the following...

C:\Users\eh5adm>brrestore -m full -b bekibpts.afd -c

BR0401I BRRESTORE 7.20 (1)

BR0405I Start of file restore: rekigcfr.rsb 2013-01-15 16.47.07

BR0484I BRRESTORE log file: D:\oracle\EH5\sapbackup\rekigcfr.rsb

BR0460W Termination message not found in D:\oracle\EH5\sapbackup\bekibpts.afd -

log file incomplete (this is OK if the log file was restored)

BR0280I BRRESTORE time stamp: 2013-01-15 16.47.07

BR0256I Enter 'c[ont]' to continue, 's[top]' to cancel BRRESTORE:

Regards

Srini

[Former Member · Accepted solution]

Hi,

This is a normal.

please type c and continue...

Thanks & Regards,

Vimal

[Former Member · Accepted solution]

Hi,

  Please confirm whether you are able to restore the DB now.

If not, please let us know the error message.

Please check and provide your feedback.

Thanks and Regards,

Vimal

[Former Member · Accepted solution]

OK VImal,

Thank you Vimal, It's working Now... Going On.

Regards

Srini

[Former Member]

Hi Srinivas,

You need to change the path to the external drive in the backup log file.

Best regards,

Orkun Gedik

[Former Member]

Hi,

  You need to maintain few parameters in initSID.sap file available in oracle_home/dbs for linux or oracle_home/database for windows.

1.backup_dev_type = tape => change to disk

2.backup_root_dir = /oracle/SID/sapbackup => specify the location of the backup

3.stage_root_dir = /oracle/SIDD/sapbackup  => Specify the location of the backup

Please check and provide your feedback

THanks and Regards,

Vimal

[Former Member]

Changed the parameter values and Tried..Still no Luck

# default: disk

backup_dev_type = disk

# backup root directory [<path_name> | (<path_name_list>)]

# default: %SAPDATA_HOME%\sapbackup

backup_root_dir = G:\sapbackup

# stage root directory [<path_name> | (<path_name_list>)]

# default: value of the backup_root_dir parameter

#stage_root_dir = D:\oracle\EH5\sapbackup

stage_root_dir = G:\sapbackup

# compression flag [no | yes | hardware | only | brtools]

# default: no

Regards

Srini