brrestore

[Former Member]

I make Full database offline backup

Source System Parameters in initSID.sap

backup_mode     = FULL

backup_type        = offline_force

backup_dev_type = disk

backup_root_dir    = G:\oracle\PRD\sapbackup

stage_root_dir     = G:\oracle\PRD\sapbackup

compress          = brtools

I have copied the backup file in F:\sapbackup folder on target system

Target system Parameters in initSID.sap

backup_mode=FULL

backup_type=offline_force

backup_dev_type = disk

backup_root_dir = F:\sapbackup

stage_root_dir = F:\sapbackup

compress=brtools

while oracle and kernel are same on both

somebody tell what is the full command for brrestore or something else...???

Regards,

[former_member182034 · Accepted solution]

Dear Kashif,

the target system parameters are ok, would you share the name of folder and files which were created after backup then I share the brrestore command.

Regards,

[Former Member · Accepted solution]

Dear MAJamil,

these are the files which are listed in the SAP backup folder

bejpkegd

PRD

backPRD.log

bejpkegd.ffd

Regards

[former_member182034 · Accepted solution]

Dear Kashif,

You need to copy the backup logs (bejpkegd.ffd & PRD) from F:\sapbackup to G:\oracle\TST\sapbackup. Change the SID from PRD to TST and path From G:\oracle\TST\sapbackup to F:\sapbackup in  bejpkegd.ffd file. now You can run any below brrestore command.

brrestore -m full -b bejpkegd.ffd

brrestore -b bejpkegd.ffd -p initTST.sap

Regards,

[Former Member · Accepted solution]

You can restore with the command

$ brrestore -b bejpkegd.ffd

or

$ brrestore -b last (if required backup was last successful backup performed)

In this case standard $ORACLE_HOME/dbs/init<SID..sap profile will be used. If this is not what you want add to command -p option with required profile file.

$ brrestore -b bejpkegd.ffd -p <initSID.sap>

or

$ brrestore -b last -p <initSID.sap> (if required backup was last successful backup performed)

You can also specify additional options to overwrite those specified in init<SID>.sap profile.

Regards

Roman

[Former Member · Accepted solution]

Dear MAJamil,

Should i created new folder named tst for this? because it is not exist in my scenario.

Regards

[former_member182034 · Accepted solution]

Dear Kashif,

I was assuming that you are doing this on test system. so, I mentioned the TST is SID.

Regards,

[Former Member · Accepted solution]

Dear Jamil & Roman

Now i'm getting below log

brrestore -b bejpkegd.ffd -p initTST.sap

BR0401I BRRESTORE 7.10 (42)

BR0405I Start of file restore: rejqiyml.rsb 2012-10-12 10.50.59

BR0484I BRRESTORE log file: G:\oracle\TST\sapbackup\rejqiyml.rsb

BR0360E Not enough disk space in G:\ORACLE\TST\SAPDATA1 for restore, missing at

least 41343.459 MB

BR0406I End of file restore: rejqiyml.rsb 2012-10-12 10.50.59

BR0280I BRRESTORE time stamp: 2012-10-12 10.50.59

BR0404I BRRESTORE terminated with errors

Regards

[former_member182034 · Accepted solution]

Dear,

BR0360E Not enough disk space in G:\ORACLE\TST\SAPDATA1 for restore, missing at
least 41343.459 MB

You are getting issue due to less space. So, now you have to increase the mentioned space in G partition.

Regards,

[Former Member · Accepted solution]

Please read Error during system refresh on windows/Oracle. You have problems with free space on G:\ORACLE\TST\SAPDATA1.

Regards

Roman

[Former Member · Accepted solution]

Dear jamil & roman

let me to do this after make free space i will update you.

Regards

[Former Member]

brbackup and brrestore utilities create/uses its own log files. You need to copy this files also to the destination server and specify them with -b option. In addition you need to synchronize profiles init<SID>.sap (on source and destination) or create new and use -p option. For example,

$ brrestore -b <brbackup log file> -p <initSID.sap>

you restore backup from <brbackup log file> with options in <initSID.sap> profile. You also can use -b last option, but you need to copy back<SID>.log file also.

Regards

Roman

[Former Member]

Go through the link and you will all the options... http://help.sap.com/saphelp_nw04/helpdata/en/0d/d3077b4a0c11d182b80000e829fbfe/frameset.htm

[Former Member]

Dear sunil,

     We have checked the SAP Note: 14004 - Description of the call options for BRRESTORE but command is not executing.that''s I already mentioned the source and target profile parameters.

Regards,

[Former Member]

Could you please provide the error message you are getting and if possible the resote log file.