Skip to Content
0
Former Member
Sep 20, 2010 at 12:10 PM

Unable to backup Restored system

23 Views

Hi,

We have recently restored our prod system and did some testing on that.

We are not able to take backup of this system from db13

Job log for archive log

BR0002I BRARCHIVE 7.00 (40)

BR0006I Start of offline redo log processing: aeedyccb.sve 2010-09-20 17.09.25

BR0484I BRARCHIVE log file: K:\oracle\PRD\saparch\aeedyccb.sve

BR0280I BRARCHIVE time stamp: 2010-09-20 17.09.25

BR0301W SQL error -942 at location BrDbConnect-5, 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 PRD failed

BR0280I BRARCHIVE time stamp: 2010-09-20 17.09.25

BR0301E SQL error -1012 at location BrCurrRedoGet-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: 2010-09-20 17.09.26

BR0301W SQL error -942 at location BrDbConnect-5, 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 PRD failed

BR0280I BRARCHIVE time stamp: 2010-09-20 17.09.26

BR0301W SQL error -942 at location BrDbConnect-5, 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 PRD failed

BR0007I End of offline redo log processing: aeedyccb.sve 2010-09-20 17.09.26

BR0280I BRARCHIVE time stamp: 2010-09-20 17.09.26

BR0005I BRARCHIVE terminated with errors

SAP ECC6.0, W2K3, Oracle 10.2.0.2

Regards