this is the error I have Specify log: {<RET>=suggested | filename | AUTO | CANCEL} ORA-00283: recovery session canceled due to errors ORA-00354: corrupt redo log block header ORA-00353: log corruption near block 215 change 4440998281220 time 05/25/2005 00 :04:41 ORA-00334: archived log: 'C:\ORACLE\ORADATA\CANADA\ARCHIVE\ARC01654.001' ORA-01112: media recovery not started -----Original Message----- From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of Oracle Sent: Wednesday, May 25, 2005 1:13 AM To: oracle-l@xxxxxxxxxxxxx Subject: Weird recovery, need help please Hi, I practice backup and recovery and experience weird result, oh may Oracle bug or may be my method is incorrect. Here is what I have Fact: Time 1 -> Cold backup Time 2 -> Create table Time 2.1 -> insert few records Time 2.2 -> alter system switch logfile; (5 times) Recovery: I try to recover database with Time 1 cold backup (including the control file) and Time 2 archive redolog. Step: 1. Restore Cold Backup 2. Startup mount (started) 3. recover database until cancel using backup control file; step 3 give me error SYS@[Canada] SQL+> recover database until cancel using backup controlfile; ORA-00279: change 3880315 generated at 05/25/2005 00:16:29 needed for thread 1 ORA-00289: suggestion : C:\ORACLE\ORADATA\CANADA\ARCHIVE\ARC01654.001 ORA-00280: change 3880315 for thread 1 is in sequence #1654 I don't understand why I can't roll forward using cold backup, Oracle said "USING BACKUP CONTROLFILE" will ignore the SCN. Please help. Regards, Sin -- //www.freelists.org/webpage/oracle-l -- //www.freelists.org/webpage/oracle-l