oracle upgrade and backup failure issue.

[Former Member]

Hi Friends,

oracle upgrade on One of my system is performed. It's all gone well. There is one scheduled offline backup in my system. But it got failed. The backup writes on to the tivoli server. The error is initialization failed, other than this i am unable to see any more logs. Does i need to do any more changes or does i need to point these new file to tivoli.

Could you kindly suggest on this.

Thank you,

Chowdary,

[Former Member]

Hi chowdary,

u need to create soft link and need to  point tivoli files (backint and backfm) in kernel directory..

check it..

cheers,

R.Ramkumar

[sandeep_kumar60]

HI ram

How can we do this . ? could you pls tell us the procedure

[Former Member]

Hi kumar,

In kernal directory execute this command,

ln -s /usr/tivoli(mention tivoli path were backint and backfm located) backfm

ln -s /usr/tivoli(mention tivoli path were backint and backfm located) backint

it should be like this,

ln -s /usr/tivoli/tsm/tdp/ora  backfm

ln -s /usr/tivoli/tsm/tdp/ora  backint

Cheers,

Ramkumar..

[Former Member]

Please attach full log file or output from command.

[sandeep_kumar60]

HI roman ,

there is no logfile generated in the backup folder.?

is there any other location to find the logs?

[Former Member]

What method you use to perform backup?

[Former Member]

Hi,

It is scheduled through DB13 and it configured to tivoli server to save the backup.

Thank you,

Chowdary.

[Former Member]

Check DB13 task log for more info or provide screenshots here.

[Former Member]

Hi Roman,

The backup is not giving any logs it geting failed at intialization state only. PFA for the same.

[Former Member]

Press 'Show Action/Detail Log' for BRBACKUP and check for errors or attach log file Logfile here.

[former_member206552]

hi

try running an archive job from the OS to see if the backup interface works

dsmc archive -description=TESTARCH "/oracle/SID/saparch/*" > /tmp/ora.archive.log

best regards

marius

[former_member188883]

Hi Chowdary,

After Oracle upgrade you need to update the brtools. Minimum required is 7.10 .

Recommended is 7.20 or higher.

Check whether you can take backup using brtools on disk. If this works, then issue could be some configuration changes at the Tivoli server.

Hope this helps.

Regards,

Deepak Kori

[Former Member]

Hi deepak,

As my current version or kernel is 701_REL. i want to just upgrade the brtools. But here i can able to see EXT unicode files and unicode one. which one shell i consider to avoid any issues after words.

Thank you,

Chowdary.

[sandeep_kumar60]

Hi Deepak ,

Instead of doing complete kernel upgrade (which we planned to do later it later) can we update only Brtools related files?

if yes,  i think i need to download the file similar as DBATL....sar

and one more thing is do i need to downaload it from kernel 720 or 720_EXt?

pls guide me

[former_member188883]

Hi,

You need to download DBATools.SAR file from SAP service marketplace.

For your query on SAP kernel refer these notes

Note 1553301 - 7.20 EXT Kernel - Usage

Note 1629598 - SAP Kernel 720 will replace older kernel versions

Based on your SAP release you may decided to apply relevant kernel patch.

Regards,

Deepak Kori

[sandeep_kumar60]

Hi Deepak

We are using Solution manager system which is dual stack system.

apart from copying the files to  /usr/sap/sid/sys/exe/run folder do i need to place it some where else also?

actually i had tried this earlier in a test system which doesn't succeed

while extartcying the  DBATL720O10_30-20006700.SAR i got all the below files ,i think i need to copy all the belwo files

-rw-r--r--	1 ehpadm   sapsys	9187 Feb 02 12:43 sapuprof_profile.sql
-rw-r--r--	1 ehpadm   sapsys	5129 Feb 02 12:43 sapdba_role.sql
-rw-r--r--	1 ehpadm   sapsys	1909 Feb 02 12:43 sapconn_role.sql
-rw-r--r--	1 ehpadm   sapsys	27532 Feb 02 12:43 initSID.sap
-rwxr-xr-x	1 ehpadm   sapsys	2637560 Feb 04 18:20 libsbt.o
-rwxr-xr-x	1 ehpadm   sapsys	12535630 Feb 04 20:39 brarchive
-rwxr-xr-x	1 ehpadm   sapsys	12758284 Feb 04 20:42 brbackup
-rwxr-xr-x	1 ehpadm   sapsys	15256140 Feb 04 20:56 brconnect
-rwxr-xr-x	1 ehpadm   sapsys	13436318 Feb 04 20:59 brrecover
-rwxr-xr-x	1 ehpadm   sapsys	5384263 Feb 04 21:00 brrestore
-rwxr-xr-x	1 ehpadm   sapsys	15924191 Feb 04 21:13 brspace
-rw-r--r--	1 ehpadm   sapsys	392 Feb 04 21:15 dbatoolsora.mf
-rw-r--r--	1 ehpadm   sapsys	171 Feb 04 21:15 dbatoolsora.lst
-rwxr-xr-x	1 ehpadm   sapsys	6265797 Feb 04 21:15 brtools
-rw-------	1 ehpadm   sapsys	5919 Feb 06 08:13 SIGNATURE.SMF

Kindly advice me

[former_member188883]

Hi Chowdary,

Based on the SAP release you have you need to select the respective kernel.

Check the SAP notes which I shared in my response below.

Regards,

Deepak Kori

[Former Member]

Hi Kumar,

after upgrade did u run this script ./saproot.sh SID in /sapmnt/SID/exe directory?????

after running ./saproot.sh SID script the below files owner will be changed, if not, change the owner manually to oraehp to all 3 below mentioned files..

-rwxr-xr-x	1 ehpadm   sapsys	12535630 Feb 04 20:39 brarchive
-rwxr-xr-x	1 ehpadm   sapsys	12758284 Feb 04 20:42 brbackup
-rwxr-xr-x	1 ehpadm   sapsys	15256140 Feb 04 20:56 brconnect

these files should be in this group like this and if required u can change the permission also to 777.

-rwxr-xr-x	1 oraehp   sapsys	12535630 Feb 04 20:39 brarchive
-rwxr-xr-x	1 oraehp   sapsys	12758284 Feb 04 20:42 brbackup
-rwxr-xr-x	1 oraehp   sapsys	15256140 Feb 04 20:56 brconnect

cheers,

R.Ramkumar