oracle-01194,ORA-01547,ORA-01194,ORA-01110

SQL> startup pfile=E:\ORANT\database\INITapr1.ORA nomount

ORACLE instance started.

Total System Global Area 135338868 bytes

Fixed Size 453492 bytes

Variable Size 109051904 bytes

Database Buffers 25165824 bytes

Redo Buffers 667648 bytes

SQL> alter database mount standby database

2 ;

Database altered.

SQL> alter database open read only;

alter database open read only

*

ERROR at line 1:

ORA-16004: backup database requires recovery

ORA-01194: file 1 needs more recovery to be consistent

ORA-01110: data file 1: 'E:\ORANT\ORADATA\APR1\SYSTEM01.DBF'

SQL> recover standby database

ORA-00279: change 7715809012 generated at 03/21/2008 13:29:58 needed for thread

1

ORA-00289: suggestion : J:\ORACLE\ORADATA\APR1\ARCHIVE\APR1T001S56785.ARC

ORA-00280: change 7715809012 for thread 1 is in sequence #56785

Specify log: {=suggested | filename | AUTO | CANCEL}

auto

ORA-00279: change 7715816627 generated at 03/21/2008 13:47:43 needed for thread

1

ORA-00289: suggestion : J:\ORACLE\ORADATA\APR1\ARCHIVE\APR1T001S56786.ARC

ORA-00280: change 7715816627 for thread 1 is in sequence #56786

ORA-00278: log file 'J:\ORACLE\ORADATA\APR1\ARCHIVE\APR1T001S56785.ARC' no

longer needed for this recovery

ORA-00279: change 7715816630 generated at 03/21/2008 13:47:46 needed for thread

1

ORA-00289: suggestion : J:\ORACLE\ORADATA\APR1\ARCHIVE\APR1T001S56787.ARC

ORA-00280: change 7715816630 for thread 1 is in sequence #56787

ORA-00278: log file 'J:\ORACLE\ORADATA\APR1\ARCHIVE\APR1T001S56786.ARC' no

longer needed for this recovery

ORA-00308: cannot open archived log

'J:\ORACLE\ORADATA\APR1\ARCHIVE\APR1T001S56787.ARC'

ORA-27041: unable to open file

OSD-04002: unable to open file

O/S-Error: (OS 2) The system cannot find the file specified.

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

ORA-01194: file 1 needs more recovery to be consistent

ORA-01110: data file 1: 'E:\ORANT\ORADATA\APR1\SYSTEM01.DBF'

SQL>