Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

rman recovery error

user11974259Dec 18 2009 — edited Jul 1 2010
hi all,

this error is while i'm running point in time recovery. First i did restore it worked fine but whem i'm trying to recover the database it is thowing these errors. Pls help me out


RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 12/18/2009 16:13:29
ORA-00283: recovery session canceled due to errors
RMAN-11003: failure during parse/execution of SQL statement: alter database recover logfile '+FLASH01/test/archivelog/2009_12_18/thread_1_seq_12746.273.705945815'
ORA-00283: recovery session canceled due to errors
ORA-00333: redo log read error block 180226 count 8192












WARNING: IO Failed. subsys:/opt/oracle/extapi/64/asm/orcl/1/libasm.so dg:2, diskname:ORCL:FLASH01 disk:0x0.0xe9680c07 au:18254
iop:0x2a96bc8700 bufp:0x2a99b71e00 offset(bytes):19140707328 iosz:262144 operation:1(Read) synchronous:0
result: 4 osderr:0x3 osderr1:0x2e pid:26809
WARNING: IO Failed. subsys:/opt/oracle/extapi/64/asm/orcl/1/libasm.so dg:2, diskname:ORCL:FLASH01 disk:0x0.0xe9680c07 au:18254
iop:0x2a96bc81b0 bufp:0x2a99bb1e00 offset(bytes):19140969472 iosz:262144 operation:1(Read) synchronous:0
result: 4 osderr:0x3 osderr1:0x2e pid:26809
WARNING: failed to read mirror side 1 of virtual extent 88 logical extent 0 of file 273 in group 2 from disk 0 allocation unit 18254; if possible, will try another mirror side
Errors in file /opt/oracle/diag/rdbms/test/TEST/trace/TEST_ora_26809.trc:
ORA-15080: synchronous I/O operation to a disk failed
WARNING: failed to write mirror side 1 of virtual extent 88 logical extent 0 of file 273 in group 2 on disk 0 allocation unit 18254
Errors in file /opt/oracle/diag/rdbms/test/TEST/trace/TEST_ora_26809.trc:
ORA-00333: redo log read error block 180226 count 8192
ORA-00334: archived log: '+FLASH01/test/archivelog/2009_12_18/thread_1_seq_12746.273.705945815'
ORA-15081: failed to submit an I/O operation to a disk
ORA-15081: failed to submit an I/O operation to a disk
Fri Dec 18 16:11:38 2009
WARNING: IO Failed. subsys:/opt/oracle/extapi/64/asm/orcl/1/libasm.so dg:2, diskname:ORCL:FLASH01 disk:0x0.0xe9680c07 au:18254
iop:0x2a96bca190 bufp:0x2a99b71e00 offset(bytes):19140707328 iosz:262144 operation:1(Read) synchronous:1
result: 4 osderr:0x3 osderr1:0x2e pid:26809
WARNING: IO Failed. subsys:/opt/oracle/extapi/64/asm/orcl/1/libasm.so dg:2, diskname:ORCL:FLASH01 disk:0x0.0xe9680c07 au:18254
iop:0x2a96bc3ec0 bufp:0x2a99bb1e00 offset(bytes):19140969472 iosz:262144 operation:1(Read) synchronous:1
result: 4 osderr:0x3 osderr1:0x2e pid:26809
WARNING: failed to read mirror side 1 of virtual extent 88 logical extent 0 of file 273 in group 2 from disk 0 allocation unit 18254; if possible, will try another mirror side
Errors in file /opt/oracle/diag/rdbms/test/TEST/trace/TEST_ora_26809.trc:
ORA-15080: synchronous I/O operation to a disk failed
WARNING: failed to write mirror side 1 of virtual extent 88 logical extent 0 of file 273 in group 2 on disk 0 allocation unit 18254
Errors in file /opt/oracle/diag/rdbms/test/TEST/trace/TEST_ora_26809.trc:
ORA-00333: redo log read error block 180226 count 8192
ORA-00334: archived log: '+FLASH01/test/archivelog/2009_12_18/thread_1_seq_12746.273.705945815'
ORA-15081: failed to submit an I/O operation to a disk
Errors with log +FLASH01/test/archivelog/2009_12_18/thread_1_seq_12746.273.705945815
Recovery interrupted!
Fri Dec 18 16:13:26 2009
WARNING: IO Failed. subsys:/opt/oracle/extapi/64/asm/orcl/1/libasm.so dg:2, diskname:ORCL:FLASH01 disk:0x0.0xe9680c07 au:18254
iop:0x2a96bc41f0 bufp:0x2a98b71e00 offset(bytes):19140707328 iosz:262144 operation:1(Read) synchronous:0
result: 4 osderr:0x3 osderr1:0x2e pid:26809
WARNING: IO Failed. subsys:/opt/oracle/extapi/64/asm/orcl/1/libasm.so dg:2, diskname:ORCL:FLASH01 disk:0x0.0xe9680c07 au:18254
iop:0x2a96bc5950 bufp:0x2a98bb1e00 offset(bytes):19140969472 iosz:262144 operation:1(Read) synchronous:0
result: 4 osderr:0x3 osderr1:0x2e pid:26809
WARNING: failed to read mirror side 1 of virtual extent 88 logical extent 0 of file 273 in group 2 from disk 0 allocation unit 18254; if possible, will try another mirror side
Errors in file /opt/oracle/diag/rdbms/testTEST/trace/test_ora_26809.trc:
ORA-15080: synchronous I/O operation to a disk failed
ORA-00333: redo log read error block 180226 count 8192
WARNING: failed to write mirror side 1 of virtual extent 88 logical extent 0 of file 273 in group 2 on disk 0 allocation unit 18254
Recovered data files to a consistent state at change 6436843585
Media Recovery failed with error 333
ORA-283 signalled during: alter database recover logfile '+FLASH01/TEST/archivelog/2009_12_18/thread_1_seq_12746.273.705945815'.

Edited by: user11974259 on Dec 18, 2009 2:58 PM
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 29 2010
Added on Dec 18 2009
5 comments
3,659 views