Problem ORACLE 9i: file is more recent than controlfile – old controlfile


When I am practicing oracle 9i fundamental one, I execute Database base control file location change operation. But unfortunately I have performed this operation in database open state. This cause problem when next time I try to open my database. Oracle has prompted messages “file is more recent than controlfile – old controlfile”.

I am new in oracle. This problem creates in big trouble to me. After exploring in Google at least two hour at last I can resolve this problem.

Solution:
I have executed recovery operation. Here i follow incomplete user managed backup procedure. Before that I have backup my entire important file of the database. The follow below steps,

1. Open database at mount state
sql> startup mount

2. Identified the current Redo file
sql>select l.status, member from v$logfile inner join v$log l using (group#);
INACTIVE C:/oracle/MYDB/ctl/redo01.log
CURRENT C:/oracle/MYDB/ctl/redo02.log
INACTIVE C:/oracle/MYDB/ctl/redo03.log

OR
Sql> select * from v$log;

3. Start database recovery
SQL>recover database using backup controlfile until cancel;

Input the current redo log file dirrectory and press enter
C:/oracle/MYDB/ctl/redo02.log

4. Open Database using reset log
sql> alter database open resetlogs;

Thanks GOD!!!

Ref: Here

3 thoughts on “Problem ORACLE 9i: file is more recent than controlfile – old controlfile

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s