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 (See ORA-600.ora-code.com) 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 (See ORA-600.ora-code.com) [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@(protected) on behalf of Oracle Sent: Wed 5/25/2005 11:16 PM To: vitalisman@(protected) Cc: oracle-l@(protected) 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 (See ORA-600.ora-code.com)
-- -- Original Message -- -- From: "Vitalis Jerome" <vitalisman@(protected)> To: <all_about_oracle@(protected)> Cc: <oracle-l@(protected)> Sent: Wednesday, May 25, 2005 7:42 PM Subject: Re: Weird recovery, need help please
> On 5/24/05, Oracle <all_about_oracle@(protected)> wrote: > > this is the error I have > >=20 > > Specify log: {<RET>=3Dsuggested | filename | AUTO | CANCEL} > >=20 > > ORA-00283 (See ORA-00283.ora-code.com): recovery session canceled due to errors > > ORA-00354 (See ORA-00354.ora-code.com): corrupt redo log block header > > ORA-00353 (See ORA-00353.ora-code.com): log corruption near block 215 change 4440998281220 time > > 05/25/2005 00 > > :04:41 > > ORA-00334 (See ORA-00334.ora-code.com): archived log: 'C:\ORACLE\ORADATA\CANADA\ARCHIVE\ARC01654.001' > >=20 > >=20 > > ORA-01112 (See ORA-01112.ora-code.com): 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 > -- > http://www.freelists.org/webpage/oracle-l
