Skip to Content
0
Jul 01, 2010 at 01:44 AM

redo log import error on the standby database

103 Views

Dear Experts

I have used brarchive to transfer the redo logs to standby database and it works perfectly.When I used brarchive to import redo logs in standby database,it was a error.In the standby database,there is the log of brarchive.

SQL> Connected.

SQL>

SQL> SQL> ORA-00279: change 4505924425 generated at 06/30/2010 11:12:29 needed for thread

1

ORA-00289: suggestion : E:\ORACLE\QAS\ORAARCH\QASARCHARC00157_0721300027.001

ORA-00280: change 4505924425 for thread 1 is in sequence #157

Specify log: {<RET>=suggested | filename | AUTO | CANCEL}

ORA-00310: archived log contains sequence 1; sequence 157 required

ORA-00334: archived log: 'E:\ORACLE\QAS\ORAARCH\QASARCHARC00001_0721300027.001'

ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below

ORA-01152: file 1 was not restored from a sufficiently old backup

ORA-01110: data file 1: 'E:\ORACLE\QAS\SAPDATA1\SYSTEM_1\SYSTEM.DATA1'

SQL> SP2-0734: unknown command beginning "E:\oracle\..." - rest of line ignored.

SQL> SP2-0734: unknown command beginning "E:\oracle\..." - rest of line ignored.

SQL> SP2-0734: unknown command beginning "E:\oracle\..." - rest of line ignored.

SQL> SP2-0734: unknown command beginning "E:\oracle\..." - rest of line ignored.

SP2-0044: For a list of known commands enter HELP

and to leave enter EXIT.

SQL> SP2-0734: unknown command beginning "E:\oracle\..." - rest of line ignored.

SQL> SP2-0734: unknown command beginning "E:\oracle\..." - rest of line ignored.

SQL> SP2-0734: unknown command beginning "E:\oracle\..." - rest of line ignored.

SQL> SP2-0734: unknown command beginning "E:\oracle\..." - rest of line ignored.

SP2-0044: For a list of known commands enter HELP

and to leave enter EXIT.

SQL> SP2-0734: unknown command beginning "E:\oracle\..." - rest of line ignored.

SQL> SP2-0734: unknown command beginning "E:\oracle\..." - rest of line ignored.

SQL> SP2-0734: unknown command beginning "E:\oracle\..." - rest of line ignored.

SQL> SP2-0734: unknown command beginning "E:\oracle\..." - rest of line ignored.

SP2-0044: For a list of known commands enter HELP

and to leave enter EXIT.

SQL> SP2-0734: unknown command beginning "E:\oracle\..." - rest of line ignored.

SQL> SP2-0734: unknown command beginning "E:\oracle\..." - rest of line ignored.

SQL> SP2-0734: unknown command beginning "E:\oracle\..." - rest of line ignored.

SQL> SP2-0734: unknown command beginning "E:\oracle\..." - rest of line