initsid.sap

[former_member657020]

Hi Team,

here iam upto to take backup for ecc 6.0 using db13 t.code.I know i need to change some parameters in initsid.sap file. Here iam using an external device for backup is 70GB HDD which is already installed to a computer where i can access my sap frontend also.I need to know which parameters i have to change in initsid.sap file in oredr to confugre the exetrnal device. How can i run the backup in daily and periodically way. Please suggest.My database i oracle 10g.

[former_member657020]

Resolved

[Former Member]

Hi have logged in as SIDADM & pls make sure that disk which is mapped must be "read write executable" permissions.

Also also you SIDADM & SAPServiceSID have full permissions.

rahul

[former_member657020]

Thank you for the support.

I have done required changes in initsid.sap file but i get two errors. Please check this :

BR0252E function fopen () failed for "F:\ORACLE\KSM\SAPBACKUP\bdxwnvel.log' at location file_prinout-4.

BR0253E ERRNO : 2 no file or such directory exists.

external program terminated with exist code 5.

return code 003 error during intilization.

Where iam missing.Please assist

Thanks in advance.

[Former Member]

Hi Chiranjeev,

May be you are manually deleted .log file in /sapbackup folder check once again in /sapbackup folder whether the .log file exist or not

Regards

Chandra

[former_member657020]

Thank you for the support.

Here iam going for a disk for my SAPbackup using db13 t.code.While iam scheduling the backup i have mentioned the disk name.Profile : initsid.sap,functinolity : and .I have changed the following parameters in initsid.sap :

backup_dev_type = disk

What i have to mention for :

backup_root_dir =

stage_root_dir =

My backup device disk is located on the I.P address 192.168.1.137. Schould i mention it in tape_address.What others parmaeters i need to change in the initsid.sap file. Please help. Iam little bit confused.

[Former Member]

Hi -

---

pls refer to sapnote 13550

Initially pls share the disk & map it on your PC which is on other system.

Now create a <newfolder> on that disk.

in --- initsid.sap file

backup_root_dir = <newfolder>

stage_root_dir = E:\oracle\MBD\sapbackup --- this is sap directory which is by default where the backup logs are written.

if you are taking full offline DB backup change the compression mode to yes or think 70 will be enough sufficient.

check this parameter as well

1. compression flag [no | yes | hardware | only]

2. default: no

compress = yes

hope this helps you & also refer to the links posted by previous user

Rahul

[former_member657020]

Thank you for the useful information.

But iam getting the error : Please check below :

BR0051I BRBACKUP 7.00 (24)

BR0055I Start of database backup: bdxwjkgw.and 2008-05-08 14.36.10

BR0484I BRBACKUP log file: F:\oracle\KSM\sapbackup\bdxwjkgw.and

BR0252W Function remove() failed for 'E:\oracle\KSM\102\database\sap.ora' at location BrInitOraCopy-7

BR0253W errno 13: Permission denied

BR0166I Parameter 'control_files' not found in file E:\oracle\KSM\102\database\initKSM.ora - default assumed

BR0274W File 'E:\oracle\KSM\102\database\CTL1KSM.ORA' not found

BR0280I BRBACKUP time stamp: 2008-05-08 14.36.21

BR0319I Control file copy created: F:\oracle\KSM\sapbackup\CNTRLKSM.DBF 12664832

BR0101I Parameters

Name Value

oracle_sid KSM

oracle_home E:\oracle\KSM\102

oracle_profile E:\oracle\KSM\102\database\initKSM.ora

sapdata_home F:\oracle\KSM

sap_profile E:\oracle\KSM\102\database\initksm.sap

backup_mode ALL

backup_type online

backup_dev_type disk

backup_root_dir F:\oracle\KSM\sapbackup

compress no

disk_copy_cmd copy

cpio_disk_flags -pdcu

exec_parallel 0

system_info SAPServiceKSM KANCORSOL Windows 5.2 Build 3790 Service Pack 1 Intel

oracle_info KSM 10.2.0.2.0 8192 1164 9466541 KANCORSOL UTF8 UTF8

sap_info 700 SAPSR3 0002LK0003KSM0011N15961903230013NetWeaver_ORA

make_info NTintel OCI_10201_SHARE Apr 26 2007

command_line brbackup -u / -jid ALLOG20080508143556 -c force -t online -m all -p initksm.sap -a -c force -p initksm.sap -sd

BR0116I ARCHIVE LOG LIST before backup for database instance KSM

Parameter Value

Database log mode Archive Mode

Automatic archival Enabled

Archive destination F:\oracle\KSM\oraarch\KSMarch

Archive format ARC%S_%R.%T

Oldest online log sequence 1161

Next log sequence to archive 1164

Current log sequence 1164 SCN: 9466541

Database block size 8192 Thread: 1

Current system change number 9480855 ResetId: 646085778

BR0118I Tablespaces and data files

BR0616I Tablespaces in table TSORA for SAP owner SAPSR3:

PSAPSR3, PSAPSR3700, PSAPSR3USR

BR0227E Not enough disk space in F:\oracle\KSM\sapbackup for backup, missing at least 32032.775 MB

BR0056I End of database backup: bdxwjkgw.and 2008-05-08 14.36.23

BR0280I BRBACKUP time stamp: 2008-05-08 14.36.23

BR0054I BRBACKUP terminated with errors

BR0280I BRBACKUP time stamp: 2008-05-08 14.36.23

BR0291I BRARCHIVE will be started with options '-U -jid ALLOG20080508143556 -d disk -c force -p initksm.sap -sd'

BR0280I BRBACKUP time stamp: 2008-05-08 14.36.28

BR0292I Execution of BRARCHIVE finished with return code 1

Please check this and where did i do mistake.

thanks in advance.

[former_member185954]

Hello,

There seem to be two issues:

1) Control file location, is the initKSM.ora pointing to the correct location of the control file ?

BR0166I Parameter 'control_files' not found in file E:\oracle\KSM\102\database\initKSM.ora - default assumed

BR0274W File 'E:\oracle\KSM\102\database\CTL1KSM.ORA' not found

Please fix this.

2)

Is there enough space in your system ?

Check this error:

BR0227E Not enough disk space in F:\oracle\KSM\sapbackup for backup, missing at least 32032.775 MB

Regards,

Siddhesh

Edited by: Siddhesh Ghag on May 8, 2008 1:04 PM

[Former Member]

Check and if need change the path (F:\oracle\KSM\sapbackup ) for backup on another disk. Also the BR0252W Function remove() failed for 'E:\oracle\KSM\102\database\sap.ora' means this : the user SAPServiceSID not have permissions to write on folder E:\oracle\KSM\102\database,give him this permissions or include in group who is alredy have required authorization... Award if helpful. Regards.

[former_member657020]

Thank you very much Rahul.

Your solution helped me to achieve the backup part.

[former_member185954]

Hello,

In that case, please mark the question as answered.

Regards,

Siddhesh

[Former Member]

hi you can mark this thread as answered & im not shur you are aware of this point system.

[former_member657020]

Hi Rahul,

Sorry for the late reply. But my problem has not yet resolved.

I have put my external harddisk connected via USB to the other system ( g drive ) and mapped the drive to my PC. I have made a folder named sap bcakup folder in the external hard disk.After mapping i have a network drive on my system ( z drive ). So in initsid.sap file i have given the parameter

backup_dev_type = disk

backup_root_dir = Z:\sapbackup

stage_root_dir = F:\oracle\KSM\sapbackup ( default i did not make any changes in it)

Though i have read and write access on z folder yet in the back log it says me unable to find folder z:\sapbackup. Kindly suggest what can i do. thanks in advance.

[former_member657020]

i have one more doubt with me. can we take backup only for a specefic client.i have 100,110 and 120 client, but i need to take backup only for 110 client. Is it possible.

[Former Member]

Hi i really can't manage to analyze why drive is not being recognized.

If u have have 15 GB of free space in your internal harddisk

u can set the

1. compression flag [no | yes | hardware | only]

2. default: no

compress = yes

verification <yes>

u can start doing a back up to your local harddisk & then copy it into the location where u want to save it.

-rahul

[former_member657020]

i have a notification through a mail that you have provided the solution,but somehow i cannot see the solution. can you please resend....

[Former Member]

Hi. Read this documents:

http://help.sap.com/saphelp_nw70/helpdata/EN/03/101549e4617146a670dcc62991ada9/content.htm

http://help.sap.com/saphelp_nw70/helpdata/EN/0d/d308f14a0c11d182b80000e829fbfe/content.htm

http://help.sap.com/saphelp_nw70/helpdata/EN/0c/cd271365debc42bef96ac7fd907787/content.htm.

P.S. about db13 read

http://help.sap.com/saphelp_nw70/helpdata/EN/02/fb1c42128a5733e10000000a155106/frameset.htm

Regards. Do not forget award helpful answers.