Skip to Content
0
Former Member
Feb 10, 2009 at 03:41 AM

BR0301 and ORA 00942

328 Views

Hi,Guys

I did system copy from PRD to QAS and reset logs. Now I had problem of Oracle log backup. Can any one have any idea, how to solve it.

Thanks

BR0002I BRARCHIVE 7.00 (26)

BR0006I Start of offline redo log processing: adzwwtzs.svd 2009-02-10 11.09.44

BR0484I BRARCHIVE log file: /oracle/Q08/saparch/adzwwtzs.svd

BR0280I BRARCHIVE time stamp: 2009-02-10 11.09.44

BR0301W 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(CREATED, 'YYYYMMDDHH24MISS')), 0) FROM V$DATABASE WHERE ROWNUM = 1'

ORA-00942: table or view does not exist

BR0310W Connect to database instance Q08 failed

BR0280I BRARCHIVE time stamp: 2009-02-10 11.09.44

BR0301W 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(CREATED, 'YYYYMMDDHH24MISS')), 0) FROM V$DATABASE WHERE ROWNUM = 1'

ORA-00942: table or view does not exist

BR0310W Connect to database instance Q08 failed

BR0031I Probably the redo log sequence number of database instance Q08 was reset

BR0013W No offline redo log files found for processing

BR0280I BRARCHIVE time stamp: 2009-02-10 11.09.44

BR0301W 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(CREATED, 'YYYYMMDDHH24MISS')), 0) FROM V$DATABASE WHERE ROWNUM = 1'

ORA-00942: table or view does not exist

BR0310W Connect to database instance Q08 failed