Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

SYstem Refresh Error in ECC

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

Tags:
Not what you were looking for? View more on this topic or Ask a question