redo log import error on the standby database

[former_member449756]

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

[Former Member · Accepted solution]

Hi,

Database required :E:\ORACLE\QAS\ORAARCH\QASARCHARC00157_0721300027.001 file.

please check already this file is available on oraarch folder.

but you are trying to apply QASARCHARC00001

you can see clear error msg :

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

With Regards,

CSK

[former_member449756 · Accepted solution]

Hi,

Thank you for your answer.And I have the redo log "157" in directory,but still occoured the same error.

[Former Member]

it is asking you to roll forward .

[former_member449756]

thanks all , I have solved the problem.