First, why do you need to open the database resetlogs with a COLD backup? Can you restore you COLD backup and just OPEN the database? Second, you need to include more information in you post. Just saying you go an ORA-600 error is like saying like say the sky was blue when you database crashed...no much to go on. Include or Explain your backup commands/method...RMAN, OS copy, what? Include your command output and errors. Include your alert log errors. What does you init parameter file look like?...You using _disable_logging parameter? Are you getting ORA-600 [2662] errors? Are you in archive log mode? Are restoring the archive logs as part of you restore? Chris Marquez Oracle DBA -----Original Message----- From: oracle-l-bounce@xxxxxxxxxxxxx on behalf of Oracle Sent: Wed 5/25/2005 11:16 PM To: vitalisman@xxxxxxxxx Cc: oracle-l@xxxxxxxxxxxxx Subject: Re: Weird recovery, need help please I can reproduce the error by repeating my test. I don't think everytime the archived redolog created are corrupted. I have one good copy of cold backup, I open resetlogs then bounce the db. Then I perform the test, now the db give me ORA-600 ----- Original Message ----- From: "Vitalis Jerome" <vitalisman@xxxxxxxxx> To: <all_about_oracle@xxxxxxxxxx> Cc: <oracle-l@xxxxxxxxxxxxx> Sent: Wednesday, May 25, 2005 7:42 PM Subject: Re: Weird recovery, need help please > On 5/24/05, Oracle <all_about_oracle@xxxxxxxxxx> wrote: > > this is the error I have > >=20 > > Specify log: {<RET>=3Dsuggested | filename | AUTO | CANCEL} > >=20 > > 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' > >=20 > >=20 > > ORA-01112: media recovery not started > > Hi, > > ORA 353 is clear about the cause of your problem. See the detailed > explanation for it: > > // *Cause: Some type of redo log corruption has been discovered. This erro= > r > // describes the location of the corruption. Accompanying errors > // describe the type of corruption. > // *Action: Do recovery with a good version of the log or do incomplete > // recovery up to the indicated change or time. > > HTH > Jerome > -- > //www.freelists.org/webpage/oracle-l -- //www.freelists.org/webpage/oracle-l -- //www.freelists.org/webpage/oracle-l