It's Khayer, Bangladesh


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

About these ads

3 Comments so far
Leave a comment

Oh.It is so easy to solve. Great job for solving ORA-01207. Thanks for sharing.

Comment by Jack Nicholson

You are are right on the money; that worked for me. God bless you

Comment by Abu al-Sous

it was help full.
thanx.

Comment by SACHI




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



Follow

Get every new post delivered to your Inbox.

%d bloggers like this: