BR error BR0301W SQL error -980 at location BrDbfInfoGet-33 , ORA-00980

[Former Member]

Hi <br/>

i get this error by all kind backup and by checkdb, verify db<br/>

<br/>

Oracle 10.2.0.4, RHEL 4 32bit, <br/>

Netweaver 2004s (7)<br/>

<br/>

I have one Oracle NW7 for Netweaver PI (NW7) and Portal (EP7)<br/>

<br/>

<br/>

###############################################################################

<br/>

BR0051I BRBACKUP 7.00 (18)<br/>

BR0055I Start of database backup: bedxcwak.afd 2010-08-15 12.21.54<br/>

BR0477I Oracle pfile /oracle/NW7/102_32/dbs/initNW7.ora created from spfile /oracle/NW7/102_32/dbs/spfileNW7.ora<br/>

<br/>

BR0925I Public synonym SAP_SDBAH created successfully for table SAPSR9DB.SDBAH<br/>

BR0925I Public synonym SAP_SDBAD created successfully for table SAPSR9DB.SDBAD<br/>

BR0925I Public synonym SAP_MLICHECK created successfully for table SAPSR9DB.MLICHECK<br/>

BR0925I Public synonym SAP_SAPLIKEY created successfully for table SAPSR9DB.SAPLIKEY<br/>

BR0280I BRBACKUP time stamp: 2010-08-15 12.21.55<br/>

BR0301W SQL error -980 at location BrbDbLogOpen-5, SQL statement:<br/>

'INSERT INTO SAP_SDBAH (BEG, FUNCT, SYSID, OBJ, RC, ENDE, ACTID, LINE) VALUES ('20100815122154', 'afd', 'NW7', ' ', '9999', ' ', 'bedxcwak', ' ')'<br/>

ORA-00980: synonym translation is no longer valid<br/>

BR0324W Insertion of database log header failed<br/>

BR0280I BRBACKUP time stamp: 2010-08-15 12.21.56<br/>

BR0301W SQL error -980 at location BrDbfInfoGet-32, SQL statement:<br/>

'DELETE FROM SAP_SDBAH WHERE BEG > '10000000000000' AND BEG < '20090711000000''<br/>

ORA-00980: synonym translation is no longer valid<br/>

BR0280I BRBACKUP time stamp: 2010-08-15 12.21.56<br/>

BR0301W SQL error -980 at location BrDbfInfoGet-33, SQL statement:<br/>

'DELETE FROM SAP_SDBAD WHERE BEG > '10000000000000' AND BEG < '20090711000000''<br/>

ORA-00980: synonym translation is no longer valid<br/>

BR0280I BRBACKUP time stamp: 2010-08-15 12.21.56<br/>

BR0301E SQL error -980 at location BrComprDurGet-1, SQL statement:<br/>

'OPEN curs_6 CURSOR FOR'<br/>

'SELECT FUNCT, POS, LINE FROM SAP_SDBAD WHERE BEG = '00000000000001' AND (FUNCT = 'CMP' OR FUNCT = 'CMP' OR FUNCT = 'DUS' OR FUNCT = 'DUM') ORDER BY FUNCT'<br/>

ORA-00980: synonym translation is no longer valid<br/>

BR0314E Collection of information on database files failed<br/>

BR0280I BRBACKUP time stamp: 2010-08-15 12.21.56<br/>

BR0301W SQL error -980 at location BrbDbLogOpen-5, SQL statement:<br/>

'INSERT INTO SAP_SDBAH (BEG, FUNCT, SYSID, OBJ, RC, ENDE, ACTID, LINE) VALUES ('20100815122154', 'afd', 'NW7', ' ', '9999', ' ', 'bedxcwak', ' ')'

ORA-00980: synonym translation is no longer valid<br/>

BR0324W Insertion of database log header failed<br/>

<br/>

BR0056I End of database backup: bedxcwak.afd 2010-08-15 12.21.56<br/>

BR0280I BRBACKUP time stamp: 2010-08-15 12.21.56<br/>

BR0054I BRBACKUP terminated with errors<br/>

<br/>

###############################################################################<br/>

<br/>

<br/>

Please help<br/>

<br/>

BR <br/>

Dawid<br/>

[paul_power]

Hi Dawid,

The problem here is missing tables SAP<SID>DB.SDBAH and SDBAD - they

are not created. These tables are br*tools log tables and must be

present, other tables used by Br*tools on abap stack install are not

needed, but these two are.

It seems you need the sapdba_additional.sql script to create the needed

SDBAH and SDBAD tables.

Fortunately the script is contained in note :

#668604 - SAP Web AS 6.40 ABAB/Java Installation on UNIX:Oracle

You find the script in the attachment of the note.

After you donwloaded and unpacked it, please run the script with the

following syntax:

sqlplus "/ as sysdba" @sapdba_additional.sql SAPSR3DB UNIX x

Regards,

Paul

[Former Member]

after aply this Snote i get this by trying backup my DB <b/>

Job log

-

---

Job started

Step 001 started (program RSDBAJOB, variant &0000000000029, user ID GLOMBDAW)

Execute logical command BRBACKUP On host nw2004s

Parameters:-u / -jid ALL__20100815175009 -c force -t online -m all -p initNW7.sap

BR0051I BRBACKUP 7.00 (18)

BR0055I Start of database backup: bedxdzeb.and 2010-08-15 17.50.13

BR0280I BRBACKUP time stamp: 2010-08-15 17.50.13

BR0301E 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(C

ORA-00942: table or view does not exist

BR0310E Connect to database instance NW7 failed

BR0280I BRBACKUP time stamp: 2010-08-15 17.50.13

BR0301E 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(C

ORA-00942: table or view does not exist

BR0310E Connect to database instance NW7 failed

BR0056I End of database backup: bedxdzeb.and 2010-08-15 17.50.13

BR0280I BRBACKUP time stamp: 2010-08-15 17.50.13

BR0054I BRBACKUP terminated with errors

External program terminated with exit code 3

BRBACKUP returned error status E

Job finished