configuration for initSID.SAP for online backup

[Former Member]

Hi Gurus ,

Kindly tell me the configuration and parameter for taking online backup of SAP in the disk at initSID.sap file .

Regards

Selvan

[Former Member · Accepted solution]

Hi,

You need to change these parameters inthe initSID.sap file.

backup_dev_type = disk

backup_root_dir = <Directory Name>

compress = yes

Mahesh

[Former Member]

Hi Santhosh ,

Thanks i successfully completed backup using whole online + redologs . Then i want to restore the backup to the server . KIndly tell me which option i have to select in brtools for restore . And also tell me which one i want to restore first Archlogs or Data ? Kindlky advice me ,

Regards

Selvan

[Former Member]

Hi selvan,

U can check out this link...

[]

--> Backup and Recovery

Regards,

Santosh

Edited by: santosh sunkara on Feb 21, 2009 11:36 AM

[Former Member]

Dear Solman manager;

I faced the same issue, as i am able to have the online backup but the redo log backup not. If i change from cds to sd would this fix the issue?

Best Regards

~Amal

[Former Member]

Hi Rohit ,

If i run redologs backup only to disk , I geeting the below mentioned error in the job log

Job started

Step 001 started (program RSDBAJOB, variant &0000000000071, user ID DDIC)

Execute logical command BRARCHIVE On host NCCDEV

Parameters: -u / -c force -p initDEV.sap -cds

BR002I BRARCHIVE 6.20 (128)

BR181E Option '-cds' not supported for 'disk'

BR007I End of offline redo log processing: adzyqrwr.log 2009-02-19 16.50.49

BR280I Time stamp 2009-02-19 16.50.49

BR005I BRARCHIVE terminated with errors

External program terminated with exit code 3

BRARCHIVE returned error status E

Job finished

KIndly advice me

REgards

Selvan

[Former Member]

Hi,

SAP Note 17163 will help you to interpret BRbackup error message and solve the problem.

[https://websmp130.sap-ag.de/sap(bD1lbiZjPTAwMQ==)/bc/bsp/spn/sapnotes/index2.htm?numm=17163]

Hope this helps.

Manoj Chintawar

Edited by: Manoj Chintawar on Feb 19, 2009 11:33 AM

[Former Member]

Hello Selvan,

just go for the save option and not delete-save

the command shuld be -cs

Hope it helps

Rohit

[Former Member]

Hi Selvan,

After selecting the Redolog backup in DB13, u will be prompted for "options for Redolog backup". Select the function as either '-s' or '-sd'. The remaining will not support for disk backup.

-s Create the first copy of offline redo log files

-sd Create the first copy and delete

Hope this helps..

Regards,

Santosh

[Former Member]

HI Rhishabh ,

As per your reference i completed the backup , But ended with BR292I Execution of BRARCHIVE terminated with return code 3 . Then i checked the backup folder , all files backed up sucessfully , but in redo log folder is empty . In db13 i select whole database and redo rogs only . KIndly advice me .

REgards

Selvan

[Former Member]

Hii

try running the backup of online redo log files only and then see what the error message that u get

Also check the permissions of the saparch directory and the online redo log files directory

might be it is not able to read either of these two directories

Rohit

[Former Member]

Hi,

You need to set the parameter in init<SID>.sap file. (location: oracle\ora92\database).

Change all these Parameter in init<SID>.sap

backup_type = online

backup_dev_type = disk

backup_root_dir = Create Backup Folder and provide their path like E:\Backup

stage_root_dir = Copy Same Path which you have given to back_root_dir

archive_copy_dir = Create Redologs Folder & Provide their path like E:\Backup\Redologs

archive_stage_dir = Copy Same Path which you have given to archive_copy_dir

Then run DB13, schedule Online Backup with Redo logs.......

Thanks

Rhishabh

[Former Member]

Hi Mahesh ,

Actually i try to take a backup in my external hard disk , not in sap defalult backup folder /oracle/SID/sapbackup . Shall i give the path of the external hard disk folder instead of /oracle/SID/sapbackup in those parameters .

Regards

Selvan

[Former Member]

Hello Selvan,

you need to give /oracle/SID/sapbackup in the parameters.

this is actually where the backup logs will be written,let the backup happpen anywhere

Rohit

[Former Member]

Hi Mahesh ,

Thanks for your reference . Kindly tell me below parametres also . What parameters i have to set for the below . .

archive_function =

stage_root_dir =

Regards

Selvan

[Former Member]

stage_root_dir = /oracle/SID/sapbackup

archive_function = save

archive_copy_dir = /oracle/SID/sapbackup

Mahesh