RE: Weird recovery, need help please

From: Oracle <all_about_oracle_at_hotpop.com>
Date: Wed, 25 May 2005 01:17:50 +0800
Message-ID: <KPEHKOIPDDAJJHPMFNMMEEPMCGAA.all_about_oracle@hotpop.com>

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_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Oracle
Sent: Wednesday, May 25, 2005 1:13 AM
To: oracle-l_at_freelists.org
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

--

http://www.freelists.org/webpage/oracle-l

--

http://www.freelists.org/webpage/oracle-l Received on Tue May 24 2005 - 13:26:27 CDT