cancel
Showing results for 
Search instead for 
Did you mean: 

SYstem Refresh Error in ECC

Former Member
0 Kudos

Hello Technology Experts,

I have refreshed Pre-Production server from Production server using HPDP tools. Directly restored the production database to pre-prod database by making a softlink. Every thing goes fine and now system is up and running. I havent touched initSID.SAP file and now we are facing error while running the backup from HPDP tool after refresh. We are getting below error. THough if I am running the below mentioned query directly on SQL prompt its running fine but while running backup from HPDP its giving error "ORA-00942: table or view does not exist" that I am not able to unerstand...

BR0051I BRBACKUP 7.20 (32)

BR0055I Start of database backup: berjvovq.anf 2015-09-13 15.30.02

BR0484I BRBACKUP log file: /oracle/SND/sapbackup/berjvovq.anf

BR0049W Last BRBACKUP run was probably killed

BR0280I BRBACKUP time stamp: 2015-09-13 15.30.02

BR0301E SQL error -942 at location BrDbConnect-6, SQL statement:

'SELECT NAME, DBID, NVL(RESETLOGS_CHANGE#, 0), NVL(TO_NUMBER(TO_CHAR(RESETLOGS_TIME, 'YYYYMMDDHH24MISS')), 0), NVL(TO_NUMBER(TO_CHAR(CREATED, 'YYYYMMDDHH24MISS')), 0), PLATFORM_NAME FROM V$DATABASE'

ORA-00942: table or view does not exist

BR0310E Connect to database instance SND failed

BR0280I BRBACKUP time stamp: 2015-09-13 15.30.03

BR0301E SQL error -942 at location BrDbConnect-6, SQL statement:

'SELECT NAME, DBID, NVL(RESETLOGS_CHANGE#, 0), NVL(TO_NUMBER(TO_CHAR(RESETLOGS_TIME, 'YYYYMMDDHH24MISS')), 0), NVL(TO_NUMBER(TO_CHAR(CREATED, 'YYYYMMDDHH24MISS')), 0), PLATFORM_NAME FROM V$DATABASE'

ORA-00942: table or view does not exist

BR0310E Connect to database instance SND failed

BR0056I End of database backup: berjvovq.anf 2015-09-13 15.30.02

BR0280I BRBACKUP time stamp: 2015-09-13 15.30.03

BR0054I BRBACKUP terminated with errors

[Major] From: OB2BAR_OMNISAP@eccsnd "OMNISAP"  Time: 09/13/15 15:30:03

  BRBACKUP /usr/sap/SND/SYS/exe/run/brbackup -t online -d util_file -c -m all -u / returned 3

BR0002I BRARCHIVE 7.20 (32)

BR0006I Start of offline redolog processing: aerjvovr.cds 2015-09-13 15.30.03

BR0484I BRARCHIVE log file: /oracle/SND/saparch/aerjvovr.cds

BR0280I BRARCHIVE time stamp: 2015-09-13 15.30.03

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

'SELECT NAME, DBID, NVL(RESETLOGS_CHANGE#, 0), NVL(TO_NUMBER(TO_CHAR(RESETLOGS_TIME, 'YYYYMMDDHH24MISS')), 0), NVL(TO_NUMBER(TO_CHAR(CREATED, 'YYYYMMDDHH24MISS')), 0), PLATFORM_NAME FROM V$DATABASE'

ORA-00942: table or view does not exist

BR0310W Connect to database instance SND failed

BR0280I BRARCHIVE time stamp: 2015-09-13 15.30.03

BR0301E SQL error -1012 at location BrRedoCurrGet-1, SQL statement:

'SELECT NVL(MIN(SEQUENCE#), 0), NVL(MIN(FIRST_CHANGE#), 0) FROM V$LOG WHERE THREAD# = 1 AND (STATUS = 'CURRENT' OR ARCHIVED = 'NO')'

ORA-01012: not logged on

BR0280I BRARCHIVE time stamp: 2015-09-13 15.30.04

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

'SELECT NAME, DBID, NVL(RESETLOGS_CHANGE#, 0), NVL(TO_NUMBER(TO_CHAR(RESETLOGS_TIME, 'YYYYMMDDHH24MISS')), 0), NVL(TO_NUMBER(TO_CHAR(CREATED, 'YYYYMMDDHH24MISS')), 0), PLATFORM_NAME FROM V$DATABASE'

ORA-00942: table or view does not exist

BR0310W Connect to database instance SND failed

BR0280I BRARCHIVE time stamp: 2015-09-13 15.30.04

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

'SELECT NAME, DBID, NVL(RESETLOGS_CHANGE#, 0), NVL(TO_NUMBER(TO_CHAR(RESETLOGS_TIME, 'YYYYMMDDHH24MISS')), 0), NVL(TO_NUMBER(TO_CHAR(CREATED, 'YYYYMMDDHH24MISS')), 0), PLATFORM_NAME FROM V$DATABASE'

ORA-00942: table or view does not exist

BR0310W Connect to database instance SND failed

BR0007I End of offline redolog processing: aerjvovr.cds 2015-09-13 15.30.04

BR0280I BRARCHIVE time stamp: 2015-09-13 15.30.04

BR0005I BRARCHIVE terminated with errors

[Major] From: OB2BAR_OMNISAP@eccsnd "OMNISAP"  Time: 09/13/15 15:30:04

  BRARCHIVE /usr/sap/SND/SYS/exe/run/brarchive -d util_file -cds -c -u / returned 3

[Normal] From: BSM@eccbkp "SND_Online"  Time: 9/13/2015 3:30:05 PM

  OB2BAR application on "eccsnd" disconnected.

[Critical] From: BSM@eccbkp "SND_Online"  Time: 9/13/2015 3:30:05 PM

  None of the Disk Agents completed successfully.

  Session has failed.

Thanks

Dinesh

Accepted Solutions (0)

Answers (4)

Answers (4)

Former Member
0 Kudos

Hello Reagan,

System is up and running fine and we are working on it.As checked Update Stats is running, Verify DB is also running fine from DB13. The only issue we are facing is during backup from HP Data Protector tool.

Thanks

Vivek Arya

Former Member
0 Kudos

Hello Ramkrishna,

When I ran command ./brbackup -u /   I got below:-

eccsnd:orasnd 6> ./brbackup -u /

BR0051I BRBACKUP 7.20 (32)

BR0055I Start of database backup: berkjuhq.ant 2015-09-16 12.52.38

BR0484I BRBACKUP log file: /oracle/SND/sapbackup/berkjuhq.ant

BR0280I BRBACKUP time stamp: 2015-09-16 12.52.39

BR0301E SQL error -942 at location BrDbConnect-6, SQL statement:

'SELECT NAME, DBID, NVL(RESETLOGS_CHANGE#, 0), NVL(TO_NUMBER(TO_CHAR(RESETLOGS_TIME, 'YYYYMMDDHH24MISS')), 0), NVL(TO_NUMBER(TO_CHAR(CREATED, 'YYYYMMDDHH24MISS')), 0), PLATFORM_NAME FROM V$DATABASE'

ORA-00942: table or view does not exist

BR0310E Connect to database instance SND failed

BR0280I BRBACKUP time stamp: 2015-09-16 12.52.39

BR0301E SQL error -942 at location BrDbConnect-6, SQL statement:

'SELECT NAME, DBID, NVL(RESETLOGS_CHANGE#, 0), NVL(TO_NUMBER(TO_CHAR(RESETLOGS_TIME, 'YYYYMMDDHH24MISS')), 0), NVL(TO_NUMBER(TO_CHAR(CREATED, 'YYYYMMDDHH24MISS')), 0), PLATFORM_NAME FROM V$DATABASE'

ORA-00942: table or view does not exist

BR0310E Connect to database instance SND failed

BR0056I End of database backup: berkjuhq.ant 2015-09-16 12.52.39

BR0280I BRBACKUP time stamp: 2015-09-16 12.52.39

BR0054I BRBACKUP terminated with errors.

================================================================

When I ran command  ./brbackup -u system/jbond007   I got below:-


eccsnd:orasnd 7> ./brbackup -u system/jbond007

BR0051I BRBACKUP 7.20 (32)

BR0055I Start of database backup: berkjujh.ant 2015-09-16 12.53.21

BR0484I BRBACKUP log file: /oracle/SND/sapbackup/berkjujh.ant

BR0477I Oracle pfile /oracle/SND/112_64/dbs/initSND.ora created from spfile /oracle/SND/112_64/dbs/spfileSND.ora

BR0280I BRBACKUP time stamp: 2015-09-16 12.53.28

BR0319I Control file copy created: /oracle/SND/sapbackup/cntrlSND.dbf 39895040

BR0083W Compression rates out of date - run BRBACKUP with option '-k only'

BR0280I BRBACKUP time stamp: 2015-09-16 12.53.29

BR0057I Backup of database: SND

BR0058I BRBACKUP action ID: berkjujh

BR0059I BRBACKUP function ID: ant

BR0110I Backup mode: ALL

BR0077I Database file for backup: /oracle/SND/sapbackup/cntrlSND.dbf

BR0061I 131 files found for backup, total size 2190972.062 MB

BR0143I Backup type: online

BR0113I Files will be compressed by hardware

BR0130I Backup device type: tape

BR0102I Following backup device will be used: /dev/rmt/2mn

BR0103I Following backup volume will be used: SNDB01

BR0280I BRBACKUP time stamp: 2015-09-16 12.53.29

BR0256I Enter 'c[ont]' to continue, 's[top]' to cancel BRBACKUP:

sorry but cannot proceed after this as its not in my hand.

Authorizations granted to system user is in attachment.

Thanks

Dinesh

Reagan
Advisor
Advisor
0 Kudos

After recreating the OPS$ users, have you started SAP?

Can you run R3trans -d and supply the output?

If the output is not 0000 then recreate OPS$ users using the SAP provided script.

Former Member
0 Kudos

Hello

Mr. Reagan yes you are correct. After restore ans recovery we have ran the below commands:-

SQL> create user OPS$SNDADM IDENTIFIED EXTERNALLY;

SQL> create user OPS$ORASND IDENTIFIED EXTERNALLY;

SQL> grant all privileges to OPS$SNDADM,OPS$ORASND;

SQL> CREATE TABLE "OPS$SNDADM".SAPUSER (USERID VARCHAR2(256), PASSWD VARCHAR2(256));

SQL> INSERT INTO "OPS$SNDADM".SAPUSER VALUES ('SAPSR3','jbond007');

SQL> drop table OPS$ECPADM.SAPUSER;

SQL> ALTER USER system ACCOUNT UNLOCK;

After doing this I have kept the system in NO ARCHIVE (that has been changed after post steps).

And after that DB and system has been started.

We have performed the same refresh steps on same system one month before also but havent faced this issue that time.

==============================================================

Hello Mr Ramkrishna,

I cannot try direct online backup command as the backup is with third party to client and I am also in support team. So needs to make many changes in initSID.SAP file for the same.

I have tried to run other mentioned commands and the result is below.

SQL> connect /

Connected.

SQL> connect BSM@eccsnd

Enter password:

ERROR:

ORA-12541: TNS:no listener

Warning: You are no longer connected to ORACLE.

Thanks

Dinesh

Former Member
0 Kudos

Hi Dinesh,

Can you please try to run below command to see if the user credentials are good.

BRBACKUP -u /

also is possible

BRBACKUP -u system/<system password>

Also are you using system user or any specific DB user for this backup do check its status and priviligies for connect,resource and dba.

Regards,

Ram

Reagan
Advisor
Advisor
0 Kudos

Assuming that you have recreated the OPS$ users or SSFS configured correctly after the system copy, in that case try updating the BR*Tools to the latest patch level.

Former Member
0 Kudos

Hi Dinesh,

The issue is clearly with brtools not able to connect to Oracle. So have you performed the checks what reagan has mentioned.

also can you give us the version of DB & brtools in 32 as we can see it.


BR0310W Connect to database instance SND failed

BR0280I BRARCHIVE time stamp: 2015-09-13 15.30.04

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

ORA-00942: table or view does not exist

BR0310E Connect to database instance SND failed

  BR0056I End of database backup: berjvovq.anf 2015-09-13 15.30.02

BR0280I BRBACKUP time stamp: 2015-09-13 15.30.03

BR0054I BRBACKUP terminated with errors

[Major] From: OB2BAR_OMNISAP@eccsnd "OMNISAP"  Time: 09/13/15 15:30:03

  BRBACKUP /usr/sap/SND/SYS/exe/run/brbackup -t online -d util_file -c -m all -u / returned 3

And can you try to run the command manually /usr/sap/SND/SYS/exe/run/brbackup -t online -d util_file -c -m all -u / to check if it works.

And do try to connect to DB directly through sql to confirm same.

sqlplus "/as sysdba"

Connect /

Connect BSM@eccsnd.

If it works then we need to further check on same. Let us know the details.

Regards,

Ram