BR0301 and ORA 00942

[Former Member]

Hi,Guys

I did system copy from PRD to QAS and reset logs. Now I had problem of Oracle log backup. Can any one have any idea, how to solve it.

Thanks

BR0002I BRARCHIVE 7.00 (26)

BR0006I Start of offline redo log processing: adzwwtzs.svd 2009-02-10 11.09.44

BR0484I BRARCHIVE log file: /oracle/Q08/saparch/adzwwtzs.svd

BR0280I BRARCHIVE time stamp: 2009-02-10 11.09.44

BR0301W SQL error -942 at location BrDbConnect-4, SQL statement:

'SELECT NAME, NVL(RESETLOGS_CHANGE#, 0), NVL(TO_NUMBER(TO_CHAR(RESETLOGS_TIME, 'YYYYMMDDHH24MISS')), 0), NVL(TO_NUMBER(TO_CHAR(CREATED, 'YYYYMMDDHH24MISS')), 0) FROM V$DATABASE WHERE ROWNUM = 1'

ORA-00942: table or view does not exist

BR0310W Connect to database instance Q08 failed

BR0280I BRARCHIVE time stamp: 2009-02-10 11.09.44

BR0301W SQL error -942 at location BrDbConnect-4, SQL statement:

'SELECT NAME, NVL(RESETLOGS_CHANGE#, 0), NVL(TO_NUMBER(TO_CHAR(RESETLOGS_TIME, 'YYYYMMDDHH24MISS')), 0), NVL(TO_NUMBER(TO_CHAR(CREATED, 'YYYYMMDDHH24MISS')), 0) FROM V$DATABASE WHERE ROWNUM = 1'

ORA-00942: table or view does not exist

BR0310W Connect to database instance Q08 failed

BR0031I Probably the redo log sequence number of database instance Q08 was reset

BR0013W No offline redo log files found for processing

BR0280I BRARCHIVE time stamp: 2009-02-10 11.09.44

BR0301W SQL error -942 at location BrDbConnect-4, SQL statement:

'SELECT NAME, NVL(RESETLOGS_CHANGE#, 0), NVL(TO_NUMBER(TO_CHAR(RESETLOGS_TIME, 'YYYYMMDDHH24MISS')), 0), NVL(TO_NUMBER(TO_CHAR(CREATED, 'YYYYMMDDHH24MISS')), 0) FROM V$DATABASE WHERE ROWNUM = 1'

ORA-00942: table or view does not exist

BR0310W Connect to database instance Q08 failed

[Former Member]

Hi,

Create OPS$ as per note 36164.

Regards,

Sachin Rane.

[former_member220071]

Hi ,

Please go through sapnote 134592

Abhijeet

[Former Member]

Thanks. I found the a note for this problem

The problem is I cannot extract the SAR file downloaded from SAP, can any body help test if it can be extracted. it's only 2KB.

CN-S-SAPQ08D:q08adm 24> sapcar -c -x /home/q08adm/sapdba_role_ora10.SAR

SAPCAR: error opening DEFAULT.SAR (error 6). No such file or directory

SAPCAR: 0 file(s) extracted

Note 134592 - Importing the SAPDBA role (sapdba_role.sql)

Note Language: Version: 28 Validity: valid since 25.08.2008

PDF Download Corrections Compare Versions SSCR

Go to SAP Note: Display

Content: Summary | Header Data | Releases | Related Notes | Attachments

Summary

Symptom

The database tools SAPDBA, BRBACKUP and BRARCHIVE are missing authorizations required to access the database.

SAPDBA fails with the following error messages. For example, in the log of "sapdba -u / -check" run:

SAPDBA [sdanl.c -- 4322]: SQL error occurred.

SAPDBA [sdanl.c -- 4331]: Error code: -942.

SAPDBA [sdanl.c -- 4341]: Cannot open cursor for statement:

SELECT TO_NUMBER(VALUE) FROM V$PARAMETER WHERE NAME = 'db_block_size'

...

SELECT TO_NUMBER(VALUE) FROM V$PARAMETER WHERE NAME = 'db_block_size'

ORA-00942: table or view does not exist

SAPDBA: Cannot insert main log info

into Table 'SAPR3.SDBAH'!

SAPDBA: Warning - could not save start info about sapdba -check run.

SAPDBA: Error - checking for table 'SAPR3.DBCHECKORA'.

ORA-00942: table or view does not exist

BRBACKUP fails with the following error messages, for example:

BR051I BRBACKUP 4.6D (20)

BR055I Start of database backup: bddzbuxf.ant 2000-11-10 10.12.35

BR280I Time stamp 2000-11-10 10.12.36

BR301W SQL error -1031 at location BrLicCheck-7

ORA-01031: insufficient privileges

BR301W SQL error -942 at location BrbDbLogOpen-1

ORA-00942: table or view does not exist

BR324W Insertion of database log header failed

BR280I Time stamp 2000-11-10 10.12.37

BR301E SQL error -1031 at location BrCntrlCopy-1

ORA-01031: insufficient privileges

BR320E Copying of control file to ... failed

BR314E Collection of information on database files failed

BR056I End of database backup: bddzbuxf.ant 2000-11-10 10.12.37

BR280I Time stamp 2000-11-10 10.12.37

BR054I BRBACKUP terminated with errors

Other terms

SAPDBA role

Reason and Prerequisites

1. You did not create the SAPDBA role during an SAP/Oracle upgrade, as outlined in the upgrade instructions.

2. You use one of the tools mentioned above in a lower SAP release and the database authorizations have not been adjusted.

3. The database grants were deleted.

Solution

Download the SQL script for creating the SAPDBA role from the attachment to this note (for Oracle 8.1: sapdba_role_ora8, for Oracle 9.2: sapdba_role_ora9, for Oracle 10g: sapdba_role_ora10). Execute this script as follows (sapdba_role.sql in the current directory):

Unix Oracle 8.1: sqlplus internal @sapdba_role <SAPSCHEMA_ID> UNIX

Windows Oracle 8.1: sqlplus internal @sapdba_role <SAPSCHEMA_ID> NT

Oracle 9.2: sqlplus /nolog @sapdba_role <SAPSCHEMA_ID>

Oracle 10g: sqlplus /nolog @sapdba_role <SAPSCHEMA_ID>

Where <SAPSCHEMA_ID> is the schema ID of the SAP database user:

- for User SAPR3: R3

- for User SAP<SID>: <SID>

- for User SAP<SID>DB: <SID>DB

Sample call for a standard installation with the schema SAPSR3:

sqlplus /nolog @sapdba_role SR3

and with the schema SAPR3:

sqlplus /nolog @sapdba_role R3

The log file sapdba_role.log is created in the current directory.

Note 1:

-

---

The schema ID is not to be confused with the schema name. Therefore, the following call is incorrect:

sqlplus /nolog @sapdba_role SAPSR3

Note 2:

-

---

Since non-ABAP systems/schemas (a pure SAP J2EE database, for example) do not contain all of the tables mentioned in the SAPDBA role, the log file will contain error messages, for example:

grant ALL on SAPSR3DB.DBAML to sapdba

*

ERROR at line 1:

ORA-00942: table or view does not exist

Ignore these error messages.

Header Data

Release Status:

Released on: 25.08.2008 10:12:44

Master Language: 德语

Priority:

Category:

Primary Component: BC-DB-ORA-DBA

Secondary Components: BC-DB-ORA-CCM

[Former Member]

sapcar -c -x /home/q08adm/sapdba_role_ora10.SAR

You cannot use -c and -x at the same time.

-c is for copy files into CAR file.

-x is for extract files from CAR file.

So you probably want -x only.

And by the way, I can't see any sense in pasting a SAP note here.

hope this helps

Edited by: Joe Bo. on Feb 13, 2009 8:21 AM

Try this:

sapcar -xvf /home/q08adm/sapdba_role_ora10.SAR

[Former Member]

Hello,

this looks more like an authorization problem to me. You should check whether the role mentioned in note #736313 is granted to the relevant users.

Besides, which user do you actually use for the archive run (brarchive -u /, brarchive -u <username>/<pw>)?

Best regards,

Michael

[former_member603052]

Hi,

Once u had opened database in resetlogs mode.....you cannot use old oracle backup since the log file numbers will be changed to 0 and 1 when u open DB in resetlogs mode.

Regards,

Kalyan