Backup Offline Warning

[Former Member]

Hi GURU,

I have a problem, I have launch bck a offline force. The bck it finishes with this warning ""BR068W SAP system is running or SAP user is connected to database - database cannot be shut down"but I do not understand why. You can help me?

SAP R/3 470

DB Ora 9,2

S.O. Cluster Windows 2003

BCK is launch with this script:

c:\WINDOWS\system32\cluster.exe ***** resource *** world /offline

net start OracleService%ORACLE_SID%

z:\run_loc\brbackup - c - m all - t offline_force > z:\tsm\tsm_log\brbackup_offline.log

c:\WINDOWS\system32\cluster.exe ***** resource *** world /online

Reagards.

[Former Member]

Tread duplicated....sorry.

[JPReyes]

These means some process is still connected to the DB... if the System is down check that theres no other processes calling you DB instance, then try it again.

Also i would consider performing a offline backup when SAP is down and not use the offline_force option. You can create a small script to shutdown the SAP system before the offline backup is done and restart it afterwards.

Regards

Juan

[Former Member]

Can go well this script?

c:\WINDOWS\system32\cluster.exe ***01 resource ***.world /offline

c:\WINDOWS\system32\cluster.exe ***01 GROUP SAP-R/3 *** /Offline *****

net start OracleService%ORACLE_SID%

rem execute brbackup command

z:\run_loc\brbackup -c force -m all -t offline_force > z:\tsm\tsm_log\brbackup_offline.log

c:\WINDOWS\system32\cluster.exe ***01 GROUP SAP-R/3 *** /Online *****

c:\WINDOWS\system32\cluster.exe ***01 resource ***.world /online

Regards.

[Former Member]

I have found this script in the nota 114287. he is applicable to my situation? Me you can explain? THANKS!

@rem Save all parameters according to args, because it might happen

@rem that brbackup is called with more than 9 parameters.

@set args=

:shift_params

@if "%1"=="" goto goon

@set args=%args% %1

@shift

@goto shift_params

:goon

fscmd offlineresource <sid>.WORLD /user=<sid>adm /pwd=<password>

/cluster=<VirtualClusterName> /offline=immediate

@if not errorlevel 0 goto errorend

net start OracleService%ORACLE_SID%

echo connect internal; > startup.sql

echo startup; >> startup.sql

echo exit; >> startup.sql

svrmgr30 command=@startup.sql

del startup.sql

brbackup.exe %args%

echo connect internal; > shutdown.sql

echo shutdown immediate; >> shutdown.sql

svrmgr30 command=@shutdown.sql

del shutdown.sql

fscmd onlineresource <sid>.WORLD /user=<sid>adm /pwd=<password>

/cluster=<VirtualClusterName>

:errorend

[JPReyes]

I never tried the contents of that note but "there only one way to find out"... Don't do it on your production server tho

Regards

Juan

[Former Member]

And this:

c:\WINDOWS\system32\cluster.exe ***01 resource ***.world /offline

c:\WINDOWS\system32\cluster.exe ***01 GROUP SAP-R/3 *** /Offline *****

net start OracleService%ORACLE_SID%

rem execute brbackup command

z:\run_loc\brbackup -c force -m all -t offline_force > z:\tsm\tsm_log\brbackup_offline.log

c:\WINDOWS\system32\cluster.exe ***01 GROUP SAP-R/3 *** /Online *****

c:\WINDOWS\system32\cluster.exe ***01 resource ***.world /online

I must:

1)resource oracle offline

2)Shutdown SAP

3)Start Oracle service

4)Bck off.

5)Start SAP

6)resource oracle online

I would have need of one confirmation!!! Thanks.

Regards.

[JPReyes]

I can't confirm these as i don't have a clustered sandbox to play with... as i mentioned before the best was to learn is giving it a shot.... never do tests on your production environment, if you are not sure consult an expert in the area.

Regards

Juan

[Former Member]

Hi,

I have carried out this sequence of command:

c:\WINDOWS\system32\cluster.exe <SID>01 resource "SAP-R/3 <SID>" /offline

"c:\Program Files\Windows Resource Kits\Tools\sleep.exe" 30

c:\WINDOWS\system32\cluster.exe <SID>01 resource <SID>.world /offline

net start OracleService%ORACLE_SID%

rem execute brbackup command

z:\run_loc\brbackup -c -m all -t offline_force > z:\tsm\tsm_log\brbackup_offline.log

c:\WINDOWS\system32\cluster.exe <SID>01 resource <SID>.world /online

"c:\Program Files\Windows Resource Kits\Tools\sleep.exe" 30

c:\WINDOWS\system32\cluster.exe <SID>01 resource "SAP-R/3 <SID>" /online

But the warning always generates me and I do not understand why!

You can help me?

Thanks.