on 08-30-2010 3:29 AM
BR0051I BRBACKUP 7.00 (36)
BR0055I Start of database backup: bedzwxfp.pnf 2010-08-30 12.06.37
BR0484I BRBACKUP log file: /cs/oracer/CER/sapbackup/bedzwxfp.pnf
BR0925I Public synonym SAP_SDBAH created successfully for table SAPCER.SDBAH
BR0925I Public synonym SAP_SDBAD created successfully for table SAPCER.SDBAD
BR0925I Public synonym SAP_DBSTATC created successfully for table SAPCER.DBSTATC
BR0925I Public synonym SAP_DBSTATTORA created successfully for table SAPCER.DBSTATTORA
BR0925I Public synonym SAP_DBSTATIORA created successfully for table SAPCER.DBSTATIORA
BR0925I Public synonym SAP_DBSTATHORA created successfully for table SAPCER.DBSTATHORA
BR0925I Public synonym SAP_DBSTAIHORA created successfully for table SAPCER.DBSTAIHORA
BR0925I Public synonym SAP_DBCHECKORA created successfully for table SAPCER.DBCHECKORA
BR0925I Public synonym SAP_DBMSGORA created successfully for table SAPCER.DBMSGORA
BR0280I BRBACKUP time stamp: 2010-08-30 12.06.39
BR0319I Control file copy created: /cs/oracer/CER/sapbackup/cntrlCER.dbf 9093120
BR0280I BRBACKUP time stamp: 2010-08-30 12.06.39
BR0301W SQL error -980 at location BrDbfInfoGet-32, SQL statement:
'DELETE FROM SAP_SDBAH WHERE BEG > '10000000000000' AND BEG < '20090726000000''
ORA-00980: synonym translation is no longer valid
BR0280I BRBACKUP time stamp: 2010-08-30 12.06.39
BR0301W SQL error -980 at location BrDbfInfoGet-33, SQL statement:
'DELETE FROM SAP_SDBAD WHERE BEG > '10000000000000' AND BEG < '20090726000000''
ORA-00980: synonym translation is no longer valid
BR0280I BRBACKUP time stamp: 2010-08-30 12.06.39
BR0301E SQL error -980 at location BrComprDurGet-1, SQL statement:
'OPEN curs_11 CURSOR FOR'
'SELECT FUNCT, POS, LINE FROM SAP_SDBAD WHERE BEG = '00000000000001' AND FUNCT IN ('CMP', ' ', ' ', 'DUR', 'DUL') ORDER BY FUNCT, POS'
ORA-00980: synonym translation is no longer valid
BR0314E Collection of information on database files failed
BR0280I BRBACKUP time stamp: 2010-08-30 12.06.39
BR0301W SQL error -980 at location BrbDbLogOpen-5, SQL statement:
'INSERT INTO SAP_SDBAH (BEG, FUNCT, SYSID, OBJ, RC, ENDE, ACTID, LINE) VALUES ('20100830120637', 'pnf', 'CER', ' ', '9999', ' ', 'bedzwxfp', '7.00 (36)')'
ORA-00980: synonym translation is no longer valid
BR0324W Insertion of database log header failed
BR0056I End of database backup: bedzwxfp.pnf 2010-08-30 12.06.39
BR0280I BRBACKUP time stamp: 2010-08-30 12.06.39
BR0054I BRBACKUP terminated with errors
$
Upgraded ,still getting the same failures...
BR0051I BRBACKUP 7.00 (36)
BR0055I Start of database backup: beebjujx.pft 2010-09-07 09.59.05
BR0484I BRBACKUP log file: /cs/oracer/CER/sapbackup/beebjujx.pft
BR0925I Public synonym SAP_SDBAH created successfully for table SAPCER.SDBAH
BR0925I Public synonym SAP_SDBAD created successfully for table SAPCER.SDBAD
BR0925I Public synonym SAP_DBSTATC created successfully for table SAPCER.DBSTATC
BR0925I Public synonym SAP_DBSTATTORA created successfully for table SAPCER.DBSTATTORA
BR0925I Public synonym SAP_DBSTATIORA created successfully for table SAPCER.DBSTATIORA
BR0925I Public synonym SAP_DBSTATHORA created successfully for table SAPCER.DBSTATHORA
BR0925I Public synonym SAP_DBSTAIHORA created successfully for table SAPCER.DBSTAIHORA
BR0925I Public synonym SAP_DBCHECKORA created successfully for table SAPCER.DBCHECKORA
BR0925I Public synonym SAP_DBMSGORA created successfully for table SAPCER.DBMSGORA
BR0280I BRBACKUP time stamp: 2010-09-07 09.59.06
BR0301W SQL error -980 at location BrDbfInfoGet-32, SQL statement:
'DELETE FROM SAP_SDBAH WHERE BEG > '10000000000000' AND BEG < '20090803000000''
ORA-00980: synonym translation is no longer valid
BR0280I BRBACKUP time stamp: 2010-09-07 09.59.06
BR0301W SQL error -980 at location BrDbfInfoGet-33, SQL statement:
'DELETE FROM SAP_SDBAD WHERE BEG > '10000000000000' AND BEG < '20090803000000''
ORA-00980: synonym translation is no longer valid
BR0280I BRBACKUP time stamp: 2010-09-07 09.59.06
BR0301E SQL error -980 at location BrComprDurGet-1, SQL statement:
'OPEN curs_11 CURSOR FOR'
'SELECT FUNCT, POS, LINE FROM SAP_SDBAD WHERE BEG = '00000000000001' AND FUNCT IN ('CMP', ' ', ' ', 'DUR', 'DUL') ORDER BY FUNCT, POS'
ORA-00980: synonym translation is no longer valid
BR0314E Collection of information on database files failed
BR0280I BRBACKUP time stamp: 2010-09-07 09.59.06
BR0301W SQL error -980 at location BrbDbLogOpen-5, SQL statement:
'INSERT INTO SAP_SDBAH (BEG, FUNCT, SYSID, OBJ, RC, ENDE, ACTID, LINE) VALUES ('20100907095905', 'pft', 'CER', ' ', '9999', ' ', 'beebjujx', '7.00 (36)')'
ORA-00980: synonym translation is no longer valid
BR0324W Insertion of database log header failed
BR0056I End of database backup: beebjujx.pft 2010-09-07 09.59.06
BR0280I BRBACKUP time stamp: 2010-09-07 09.59.06
BR0054I BRBACKUP terminated with errors
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Greetings,
ORA-00980: synonym translation is no longer valid" is a common error encountered in a development environment. This can happen for many reasons. Some of them are
1. You created a synonym on non-existing object by mistake. For example, you created a synonym on ABC.XYZ where either the ABS schema in not present or the XYZ table is missing.
2. You dropped an object but you did not drop the synonyms referencing the object or
3. You dropped a user, but you did not drop synonyms referencing the objects owned by that user.
Pls read the below SDN post and SAPnote Note 650796 - Composite Note: ORA-00980 and I am sure your issue will be resolved.
All the best !
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Thanks Manoj/Prateek,
I have 2 similar environements one is running on Linux 32 bit with oracle 10.2.0.1 and Brtools 7 which works fine.Failure is happening on the second environment with HP-UX ia64 with same version of oracle /Brtools. So i am bit confused why it faills only on HP.
I have read that i need to Upgrade Oracle to 10.2.0.4 to fix this which am not sure.
Regarding the tech note mentioned by Manoj, i dont have access to it. please post it in this forum.
Cheers
Is this a non-ABAP system?
Can you check Note 651812 - FAQ: BR*TOOLS and SAPDBA (16) as mentioned in note 650796
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
81 | |
24 | |
11 | |
9 | |
7 | |
5 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.