sap backup using oracle database in DB13

[Former Member]

Hi,

We have recently installed the SAP Server in Solaris, with oracle Database, and need to take backup.

kindly provide me the steps to take backup using DB13 and also what parameters i need to maintain in initSID.sap file .

i have to take bakcup on local disk.

pls provide,

Regards,

Irfan

[Former Member]

thank you

[Former Member]

Did you try this?

grant sysdba to NAJEEB;

and

grant sapdba to NAJEEB;

then schedule a backup......it should work.

Regards,

Nick Loy

[Former Member]

Hi,

If you want to take backup from DB13 you need to change below parameters in init<SID>.sap

For Backup on Disk:

backup_type = offline / online
backup_dev_type = disk
backup_root_dir = /path_to_backup_dir

For Backup on Tape:

backup_type = offline / online
backup_dev_type = tape
backup_root_dir = /oracle/<SID>/sapbackup

Regards.

Rajesh Narkhede

[Former Member]

Thank you for your reply, i will try today and will let you know the status.

Regards,

Irfan

[Former Member]

Hi,

I selected

backup_type - online

backup_dev_typr - disk

backup_root_dir - /oracle/SOL/tstbkp

first i am trying to take the bakcup of Redolog files.

In DB13 i selected Redo log backup

and clicked on start immediately, soon after status turned to Red.

ended with error,

is there any other thing that i need to maintain in DB13, under generic tape selection i did not put anything.

pls adivse.

Thanks.

[Former Member]

Hi,

Could you paste the backup log of failed backup ?

For redo log backup on disk you also need to set the below parameter in init<SID>.sap.

archive_copy_dir = /sapbackup

In DB13 job setting set the below options:

1. Job Action = Redo log backup

2. In Action Parameter, Function = -sd

Then try taking Redo Log backup.

You can also First try database backup then redo log backup.

I would suggest take the backup on the disk where you have sufficient free space. Means other than /oracle/<SID> location.

For example:

backup_root_dir = /sapbackup

Regards.

Rajesh Narkhede

Edited by: Rajesh Narkhede on May 31, 2010 4:28 PM

[Former Member]

hi,

This time i am getting the following error.

Job started

Step 001 started (program RSDBAJOB, variant &0000000000007, user ID NAJEEB)

Execute logical command BRARCHIVE On host solmgr

Parameters:-u / -jid LOG__20100531140758 -c force -p initSOL.sap -s

BR0002I BRARCHIVE 7.00 (40)

BR0006I Start of offline redo log processing: aeditkmx.sve 2010-05-31 14.07.59

BR0484I BRARCHIVE log file: /oracle/SOL/saparch/aeditkmx.sve

BR0477I Oracle pfile /oracle/SOL/102_64/dbs/initSOL.ora created from spfile /oracle/SOL/102_64/dbs/spfileSOL.ora

BR1301W Error message from likeywlib: likey_init:Couldn't open verify PSE file ("/oracle/SOL/LASVerify.pse") for writing, errno

BR1302W Initialization of license key library likeywlib failed, return code 1

BR1304W Checking SAP license failed at location BrLicCheck-108

BR0602W No valid SAP license found - please contact SAP

BR0252E Function fopen() failed for '/oracle/SOL/sapreorg/spaceSOL.log' at location BrInitLogTouch-1

BR0253E errno 13: Permission denied

BR0007I End of offline redo log processing: aeditkmx.sve 2010-05-31 14.08.00

BR0280I BRARCHIVE time stamp: 2010-05-31 14.08.00

BR0005I BRARCHIVE terminated with errors

External program terminated with exit code 3

BRARCHIVE returned error status E

Job finished

[Former Member]

Hi,

BR0252E Function fopen() failed for '/oracle/SOL/sapreorg/spaceSOL.log' at location BrInitLogTouch-1

Make sure that above directory is writable for user ora<sid>

or change the permissions as below:

chmod -R 755 /oracle/SOL/sapreorg
chown -R orasol:dba /oracle/SOL/sapreorg

Also check if the below file is exist and has the correct permission (666) as below:

-rw-rw-rw-    orasol     dba    LASVerify.pse

OR use below command to correct it...

chmod 666 /oracle/SOL/LASVerify.pse
chown orasol:dba /oracle/SOL/LASVerify.pse

Then again check backup

Regards.

Rajesh Narkhede

[Former Member]

Hi,

Thanks for your reply,

i could not find the file LASVerify.pse at the below location

/oracle/SOL

1. pwd

/oracle/SOL

1. ls

102_64 oraarch saparch sapdata1 sapdata4 startdb

mirrlogA origlogA sapbackup sapdata2 sapreorg stopdb

mirrlogB origlogB sapcheck sapdata3 saptrace tstbkp

Thanks

[Former Member]

Hi,

Do you have permanent license installed ?

Or only temp license in installed in the system... Just check in SLICENSE tcode

Regards.

Rajesh Narkhede

[Former Member]

yes license is installed permanently,

In Tcode Slicense when i click on New license i see the permanent license installed.

Regards,

Irfan

[Former Member]

Hi,

I performed backup on other server it went fine.

thanks for your information,

In DB13 i selected the first option WHOLE DATABASE OFFLINE + REDO LOG BACKUP

and Under functions i selected ( -S Create the first copy of offline redo log files )

please advise is this the correct selection .

Thanks

Irfan

[Former Member]

Hi

and Under functions i selected ( -S Create the first copy of offline redo log files )

If you don't want to remove archive logs from original location after backup "-s" would be fine..

Otherwise use -"sd" means (Save and delete)

Regards.

Rajesh Narkhede

[former_member289039]

Hi Irfan,

In init<sid>.sap file set backup_dev_type = disk.

This will backup your database in sapbackup directory.

You can start the backup via Db13 or Brtools.

Regards,

prakash