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