Link to home
Start Free TrialLog in
Avatar of bdrmki
bdrmki

asked on

ORACLE initialization or shutdown, in progress

Hi,  I have small program(using Developer 6i and oracle 9i on windows xp) run on one pc for about one year without any problem, suddenly I faced this error: ORA-01033 ORACLE initialization or shutdown, in progress, I did these steps:
- connect as sysdba
- startup force
ORA-00214: controlfile 'D:\oracle\oradata\data\control01.ctl' version 18229 Inconsistent with file 'D:\oracle\oradata\data\control02.ctl' version 18223
after I saw this error I made copy from control01,control02, control03 and save it away
and tried to use three copy from each file after rename the copy to control01,control02, control03, when I tried to start with the three copy of each file I faced this error:  
ORA-01122: database file 21 failed verification check
ORA-01110: data file 21: 'File Path +File Name'
ORA-01207: file is more recent than controlfile - old controlfile
Pleas help to solve this problem
ASKER CERTIFIED SOLUTION
Avatar of YANN0S
YANN0S

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Avatar of johnsone
johnsone
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
'D:\oracle\oradata\data\control01.ctl' version 18229
'D:\oracle\oradata\data\control02.ctl' version 18223

Wouldn't that say that control02.ctl is the bad file?
Avatar of leenus2b
leenus2b

ctrl01 is currupted and the SCN numbers are not syncronized with in the remaining ctrl files and dbf's.Before mounting the DB oracle will check for sync between ctrl files then ctrl files and dbf files.
Jus 2 days back all my instances in my server crashed and we faced the same problem.all are in no archive mode.we brought up 2 using single ctrl file and once they were up we multiplexed again.
for one instance we recreated ctrl file,and open the db during time as redo were not over written,we able to recover and the remaining was crashed bcoz ctrl01 is corrupted and there in no SYNCH between remaining ctrl and dbf headers...Hope i am clear
Regards
leenus
So, you are saying that Oracle with arbitrarily put a SCN in the future in a control file?  The SCN in control01.ctl is higher than in control02.ctl.
latest SCN will be first updated in datafile headers and then ctrl file is updated with latest scn,all ctrl files will be updated ,all these will be happen in fraction of timeU can see metalink document 1014751.6,and related documents
But what you are saying is that control02 was updated and not control01.  Then how can control01 have a SCN higher than control02?

Oracle writes to all the control files, but on startup it only reads the first one in the control file list.  It does consistency checking on all of them, but only reads the first one.
I believe that johnsone is right, and that leenus2b did not notice the detail in the error message:

ORA-00214: controlfile 'D:\oracle\oradata\data\control01.ctl' version 18229 Inconsistent with file 'D:\oracle\oradata\data\control02.ctl' version 18223

control01.ctl' version 18229
control02.ctl' version 18223

johnsone: My first question was "Which file did you use to copy as control01,control02, control03?"

But when I read again the question

" tried to use three copy from each file after rename the copy to control01,control02, control03, when I tried to start with the three copy of each file I faced this error"

I understand that bdrmki tried to startup the db with all possibilities.

If I'm correct bdrmki does not have any recent control file.
YANNOS, I saw that but was not completely sure that all possibilities were covered, but I thought that your post covered that.

That is the reason I gave the solution I did, but wanted to be sure that it should be used as a last resort.  Backup is the most important thing.  If only the control files are damaged, then no resetlogs should be required.  However if a resetlogs is required a backup immediately following the resetlogs should be done.
Yannos,
I didn't noticed the latest version,all i want to say is bring up the instance with latest ctrl file and multiplex it.and i gave small lite on various scenarios that may face while recovering,if u r in archive or no-archive..
definately there r chances even u have latest ctrl file, (having latest SCN) got corrupted during hardware crash.at that time if ur redo weren't over written we can recover.........Am I Right..(No Arch)
This should be a instance recovery scenario and not a media recovery scenario.  There should be no need for archives.  Unless we don't have the full story.
Avatar of bdrmki

ASKER

Sorry I went for emergency vacation, Yannos you are right I  tried to startup the db with all possibilities  after I KEPT COPIES OF ALL THE FILES a way, of course.    I tried to follow Johnsone steps:startup mount
recover database until cancel using backup controlfile;
cancel
After This I got:
ORA-01547 Warning Recover succeeded but open Resetlogs would get error below
ORA-01152: File 1 was not restored from a sufficiently old backup.
ORA-01110: Data File 1: 'D:\Oracle\Oradata\DATA\System01.DBF'
ORA-01112: Media Recovery not started
then, I issued:
alter database open;
after the last command I got something like this:must use RESETLOGS or NORESETLOGS option for database open
then I wrote:alter database open resetlogs;
I got this error :
Error at line 1 :
ORA-01152: File 1 was not restored from a sufficiently old backup.
ORA-01110: Data File 1: 'D:\Oracle\Oradata\DATA\System01.DBF'
My db was not in a rchive mode, and .. unfortunately I have no any backup or even dump

I think you may have a bigger problem than out of sync control files.  Now that you are ignoring the out of sync control files by doing the recover database, it appears that your data files are also out of sync.
Avatar of bdrmki

ASKER

Hiiii ,
please help!