Offline backup on cluster

[Former Member]

dear experts

im facing this issue when i started to take offline backup or ECC6 on win2008 and ora 10g , im working on HA Clusetr enviroment,

BR0280I BRBACKUP time stamp: 2010-04-06 13.00.13

BR0307I Shutting down database instance PRD ...

BR0278E Command output of 'FSCMD OFFLINERESOURCE PRD /CLUSTER=ORACLUST /OFFLINE=IMMEDIATE /USER=oraofs /DOMAIN=HamzaGroup':

Invalid syntax: no password.

For help, type "fscmd ?".

BR0280I BRBACKUP time stamp: 2010-04-06 13.00.13

BR0279E Return code from 'FSCMD OFFLINERESOURCE PRD /CLUSTER=ORACLUST /OFFLINE=IMMEDIATE /USER=oraofs /DOMAIN=HamzaGroup': 160

BR0309E Shutdown of database instance PRD failed

how can i correct this command to shut down the DB correctly

[Former Member]

hi guys

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

/cluster=<VirtualClusterName> /offline=Immediate

i know the password is missing thats what i need to know how to fix, so please any advice

You have to set the parameters as mentioned as per note SAP Note 378648 -

Offline backup support with Oracle Fail .

yes i set the parameters for ora FS per the note, and it should start from DB13

please if there anyone know how to fix this??

[Former Member]

Have u set BR_OFS_PWD=<password> in user environment.

Joel

[Former Member]

Yes i did the password included in the enviroment variables, the issue now is that i cant connect to the brtools OS level

C:\Users\prdadm>brbackup

BR0051I BRBACKUP 7.00 (46)

BR0055I Start of database backup: becypdfx.and 2010-04-07 18.51.41

BR0484I BRBACKUP log file: E:\oracle\PRD\sapbackup\becypdfx.and

BR0280I BRBACKUP time stamp: 2010-04-07 18.51.42

BR0301E SQL error -28000 at location BrDbConnect-2, SQL statement:

'CONNECT system/*******'

ORA-28000: the account is locked

BR0310E Connect to database instance PRD failed

BR0280I BRBACKUP time stamp: 2010-04-07 18.51.43

BR0301E SQL error -28000 at location BrDbConnect-2, SQL statement:

'CONNECT system/*******'

ORA-28000: the account is locked

BR0310E Connect to database instance PRD failed

BR0056I End of database backup: becypdfx.and 2010-04-07 18.51.42

BR0280I BRBACKUP time stamp: 2010-04-07 18.51.43

BR0054I BRBACKUP terminated with errors

so seems that system user lock, any idea how can i unlock it.

[former_member204746]

oh please...

help your self ans search SAP notes with keyword ORA-28000

you will find a solution quickly yourself. it will be much quicker than waiting for someone to spoon-feed you.

[Former Member]

select username, account_status from dba_users;

alter user <USERID> account unlock;

- Joel

[Former Member]

if i understand correctly your question is where to set this fscmd command? there are a few ways to do this, but normally in MS cluster environment it should be register in the Services. Why dont you check out the Services SAP<SID>_<system number> or something similar that used to start SAP.

cheers

[Former Member]

Yes exactly that is my question, i will check that solution and let you know,

thanks all for the help , hope i can solve this issue

[Former Member]

You may have to install a standalone gateway if you are scheduling thro DB13

follow Note 657999 - Installing a Standalone Gateway in an MSCS Environment

[Former Member]

Hi

You have to set the parameters as mentioned as per note SAP Note 378648 -

Offline backup support with Oracle Fail .

Regards,

Joel.

[Former Member]

Hi Sameh,

I think you are missing the password for the user to shutdown the oracle.

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

/cluster=<VirtualClusterName> /offline=Immediate

Check out SAP Notes 145666 Start and stop of R/3 in MSCS environment

Edited by: Ai Khian Liang Hing on Apr 7, 2010 7:46 AM