Backup Not Starting for 'Whole database offline + redo log backup' @ DB13

[Former Member]

Hi Experts,

I am not able to perform 'Whole database offline + redo log backup' by DB13.

I have recently configured my 'init<SID>.sap' to take 'Whole database online + redo log backup' and its working perfectly fine.

I tried taking test backup for 'Whole database offline + redo log backup' but it didn't even started.

Thus I created another profile with name init<SID>back.sap and changed the Parameter

from 'backup_type = online' to 'backup_type = offline' and also tried by 'backup_type = offline_force'

rest all parameters being same as the profile init<SID>.sap

Kindly Suggest as I need to take set the backup Strategy as Mon-Fri -> 'Whole database offline + redo log backup' and Sat -> 'Whole database offline + redo log backup'

One more Query : While taking the redo log backup by DB13 why is it that some times it only saves the Files and some time it

saves and delete the files from the '/oracle/<SID>/oraarch' location. Please throw some light over this matter also.

Thanks,

Jitesh

[Former Member · Accepted solution]

Hi,

Check the job log for offlne backup , you should get some error to troubleshoot , if online backup is working fine offline should also work without changing any parameter .Also you may try only offline backup.

For BRARCHIVE there are multiple option to copy/save/delete go through below link

http://help.sap.com/saphelp_nw04/helpdata/en/0d/d30d544a0c11d182b80000e829fbfe/content.htm

Regards,

[Former Member · Accepted solution]

Hi Expert,

No Action Log is even getting created here. Thats why I am not able to identify the Reason. If I click on the

Action log it shows 'No action log found for this action'

and the Job Log Shows :

'

Job started

Step 001 started (program RSDBAJOB, variant &0000000000175, user ID JMP_BASIS)

Execute logical command BRBACKUP On host sapdev

Parameters:-u / -jid ALGOF20101105210300 -c force -t offline_force -m all -p initJMDback.sap -a -c force -p ini

tJMDback.sap -cds

Job finished

'

The Job Last for just matter of seconds.

and yes I have tried with both backup_type = offline and backup_type = offline_force

and thanks for the BRArchive link.

Please Suggest,

Jitesh.

Edited by: njitesh17 on Nov 6, 2010 7:06 AM

Edited by: njitesh17 on Nov 6, 2010 7:06 AM

[Former Member · Accepted solution]

Hi,

Executng backup using brtools will help you out.

Start brtools manually and start offline backup with offline_force it will show you the proper error in command prompt.

Paste those error here.

Regards,

[volker_borowski2 · Accepted solution]

Hi,

guessing you are on Windows and your Service-User lacks dba permission to shut down the DB.

The Service User has to be in either ORA_DBA or ORA_SID_DBA OS group to be able to schut down the db.

OPS connect should be ok, because online backup works.

Volker

[former_member524429 · Accepted solution]

Hi,

Along with the above suggestions, Also Check at alert<dbsid>.log file to get more information after/while execution of Whole database offline + redo log backup using DB13.

Your SAP system setup is integrated with MSCS cluster environment ?? If its the case refer [SAP Note 378648|https://service.sap.com/sap/support/notes/378648].

While taking the redo log backup by DB13 why is it that some times it only saves the Files 
and some time it saves and delete the files from the '/oracle/<SID>/oraarch' location.

Its due to -cds (copy+delete && save) option of Archive backup which is passed as in command -u / -jid ALGOF20101105210300 -c force -t offline_force -m all -p initJMDback.sap -a -c force -p initJMDback.sap -cds.

During copy+delete && save archive backup run,

while Copy+Delete action, old archive files which are already archived by brarchive in last archive backup

&&

while save action, all the archive log files which are still not backed up and are fresh in the Archvie backup run will be saved to Tape by brarchive.

Regards,

Bhavik G. Shroff

[Former Member · Accepted solution]

Dear Mr Volker,

I am on HP-Unix .

[former_member524429 · Accepted solution]

Hi,

SAP BASIS Patch Level ?

Brtools version ? Ensure that latest brtools programs are in use.

alert<dbsid>.log file (located at /oracle/<SID>/saptrace/background/)is complaining anything while you are executing this action ?

Have you tried to execute such Offline+REdo log backups using brback command at command level ? (try to run it under <sid>adm user and under ora<sid> user)

Also post the output of the following select queries only for SAPSR3/SAPSR3DB and OPS$ database users.

select grantee, granted_role from dba_role_privs;

Regards,

Bhavik G. Shroff

[Former Member · Accepted solution]

Hi Mr Bhavik,

Thanks for your reply.. Here are the details you have asked for.

1.My SAP BASIS Patch Level is : 10. ( We shall be updating it by the end of this Year)

2. Br*tools version is :

BRTOOLS 7.00 (11)

kernel release 700

patch level 11

3. I don't have any file with name alert<dbsid>.log file (located at /oracle/<SID>/saptrace/background/) but i do have alert_<SID>.log

I execute the command more -p G alert_JMD.log

after my 'Whole database offline + redo log backup' again failed at DB13 but I was not able to see any specific complains while executing the above action.

I got the Error Detailed Log in DB13 as :

Detail log: beeneedv.aft

BR0051I BRBACKUP 7.00 (20)

BR0055I Start of database backup: beeneedv.aft 2010-11-08 13.16.43

BR0484I BRBACKUP log file: /oracle/JMD/sapbackup/beeneedv.aft

BR0280I BRBACKUP time stamp: 2010-11-08 13.16.43

BR0261E BRBACKUP cancelled by signal 13

BR0056I End of database backup: beeneedv.aft 2010-11-08 13.16.44

BR0280I BRBACKUP time stamp: 2010-11-08 13.16.45

BR0054I BRBACKUP terminated with errors

4. No I have not yet Tried 'execute such Offline+REdo log backups using brback command', will Try and post it Definately

5. Query : select grantee, granted_role from dba_role_privs;

result :

SQL> select grantee, granted_role from dba_role_privs;

GRANTEE GRANTED_ROLE

-

---

-

---

SYS SAPDBA

SYS EXP_FULL_DATABASE

SYS CONNECT

IMP_FULL_DATABASE SELECT_CATALOG_ROLE

DBSNMP OEM_MONITOR

SAPSR3 CONNECT

OPS$SAPSERVICEJMD SAPDBA

SYS SELECT_CATALOG_ROLE

DBA DELETE_CATALOG_ROLE

DBA EXECUTE_CATALOG_ROLE

SYSTEM DBA

GRANTEE GRANTED_ROLE

-

---

-

---

OPS$ORAJMD SAPDBA

SAPDBA GATHER_SYSTEM_STATISTICS

SYS SCHEDULER_ADMIN

SYS AQ_USER_ROLE

SYS GATHER_SYSTEM_STATISTICS

SYS DELETE_CATALOG_ROLE

DBA GATHER_SYSTEM_STATISTICS

DBA IMP_FULL_DATABASE

EXECUTE_CATALOG_ROLE HS_ADMIN_ROLE

IMP_FULL_DATABASE EXECUTE_CATALOG_ROLE

OPS$JMDADM CONNECT

GRANTEE GRANTED_ROLE

-

---

-

---

SYS LOGSTDBY_ADMINISTRATOR

SYS EXECUTE_CATALOG_ROLE

SYS RESOURCE

DBA SCHEDULER_ADMIN

DBA SELECT_CATALOG_ROLE

EXP_FULL_DATABASE EXECUTE_CATALOG_ROLE

SAPDBA SELECT_CATALOG_ROLE

SYS SAPCONN

SYS OEM_ADVISOR

SYS IMP_FULL_DATABASE

SELECT_CATALOG_ROLE HS_ADMIN_ROLE

GRANTEE GRANTED_ROLE

-

---

-

---

OUTLN RESOURCE

LOGSTDBY_ADMINISTRATOR RESOURCE

SAPSR3 RESOURCE

OPS$SAPSERVICEJMD RESOURCE

SYS RECOVERY_CATALOG_OWNER

DBA EXP_FULL_DATABASE

EXP_FULL_DATABASE SELECT_CATALOG_ROLE

TSMSYS RESOURCE

OPS$ORAJMD RESOURCE

SAPCONN SELECT_CATALOG_ROLE

SYS OEM_MONITOR

GRANTEE GRANTED_ROLE

-

---

-

---

SYS AQ_ADMINISTRATOR_ROLE

SYS DBA

SYSTEM AQ_ADMINISTRATOR_ROLE

OPS$ORAJMD CONNECT

OPS$JMDADM SAPDBA

OPS$JMDADM RESOURCE

SAPSR3 SAPCONN

SYS HS_ADMIN_ROLE

SYSTEM SAPDBA

OPS$SAPSERVICEJMD CONNECT

[former_member524429 · Accepted solution]

Hi,

Database level roles are looking Ok.

But, SAP BASIS Patch, Kernel 700 patch level , Br*tools patches are at very low level. Please upgrade them by applying entire SUport Pckage Stack to avoid such issues.

Wht about Oracle release ?

Also look at this [SAP Note 988038|https://service.sap.com/sap/support/notes/988038] and apply it if it is required or If you are not planning for immediate upgrades. But atleast apply New SAP Kernel patches and br*tools.

Regards,

Bhavik G. Shroff

[Former Member]

Hi Jitesh,

Could you please tell us if you can execute the "brconnect -f check" successfully?

If not, may be there is a problem with your user OPS$ or maybe the user SAP<SID> is locked.

To check if the user is locked, execute the following request SQL:

SQL> select username, lock_date from dba_users;

Best regards,

Son

[Former Member]

Dear Son,

This is what i get when i run the check:

sapdev:jmdadm 21> brconnect -f check

BR0801I BRCONNECT 7.00 (20)

BR0805I Start of BRCONNECT processing: ceenerbu.chk 2010-11-08 15.42.18

BR0484I BRCONNECT log file: /oracle/JMD/sapcheck/ceenerbu.chk

BR0280I BRCONNECT time stamp: 2010-11-08 15.42.19

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

'CONNECT system/*****'

ORA-28000: the account is locked

BR0310E Connect to database instance JMD failed

BR0280I BRCONNECT time stamp: 2010-11-08 15.42.19

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

'CONNECT system/*****'

ORA-28000: the account is locked

BR0310E Connect to database instance JMD failed

BR0806I End of BRCONNECT processing: ceenerbu.chk 2010-11-08 15.42.19

BR0280I BRCONNECT time stamp: 2010-11-08 15.42.19

BR0804I BRCONNECT terminated with errors

-

---

To check if the user is locked, execute the following request SQL:

SQL> select username, lock_date from dba_users;

I get the following result :

SQL> select username, lock_date from dba_users;

USERNAME LOCK_DATE

----

---

-

---

OPS$SAPSERVICEJMD

OPS$JMDADM

OPS$ORAJMD

SYS

SAPSR3

SYSTEM 10-JUL-09

OUTLN 01-NOV-06

TSMSYS 31-OCT-06

DIP 31-OCT-06

DBSNMP 01-NOV-06

10 rows selected.

Do Suggest .

-Jitesh

Edited by: njitesh17 on Nov 8, 2010 11:23 AM

[Former Member]

Hi Jitesh,

So you have first to unlock the user system with the following command SQL

SQL> alter user system account unock;

But verify that the password you used in the command brarchive is correct.

Normally, if your user OPS$ is correct, it's better to user OPS$ . You can do with "connect /" and this let you connect with the user OPS$.

Hope it helps

Best regards,

Son

[Former Member]

Hi ,

As now error is clear you can try to find solution your self and can close the thread

[GOOGLE|http://www.google.co.in/search?hl=en&rls=com.microsoft%3Aen-us&rlz=1I7SKPB_en&q=ORA-28000%3Atheaccountislocked+sdn&aq=f&aqi=g1g-c2g1g-c1g5&aql=&oq=&gs_rfai=]

Regards,

[Former Member]

Hi Experts,

Thanks for all your suggestions.

Yes my Query was solved after upgrading the Basis Patch of My System which was quite low.