OraFAQ Forum: Backup & Recovery » Error during Database OPEN

Home » RDBMS Server » Backup & Recovery » Error during Database OPEN (Oracle 10g)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Error during Database OPEN [message #386771]

Mon, 16 February 2009 23:45

rumman
Messages: 48
Registered: June 2007
Location: Bangladesh

Member

When I am using

ALTER DATABASE OPEN

I am getting the following error:

ERROR at line 1:
ORA-01122: database file 1 failed verification check
ORA-01110: data file 1: '/oradata/pblprod/system01.dbf'
ORA-01207: file is more recent than control file - old control file

What should I do now?

Report message to a moderator

Re: Error during Database OPEN [message #386772 is a reply to message #386771]

Mon, 16 February 2009 23:50

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

You need to help us by following the Posting Guidelines as stated below.
http://www.orafaq.com/forum/t/88153/0/
So we can help you.

How did you arrive at this situation?

I hope you have good backups & documented restoration procedure.

Restore from your most recent backup.

Report message to a moderator

Re: Error during Database OPEN [message #386797 is a reply to message #386772]

Tue, 17 February 2009 00:51

rumman
Messages: 48
Registered: June 2007
Location: Bangladesh

Member

Hi,

Apology for not following posting guidelines.

But I need an urgent solution.

I took snapshot of DB in my disaster recovery site. At that time database was running with replication.

But now I stopped the replication as I need to restore DB in DR.
Pls provide some suggestion.

Report message to a moderator

Re: Error during Database OPEN [message #386807 is a reply to message #386771]

Tue, 17 February 2009 01:06

Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

ORA-01207: file is more recent than control file - old control file
 *Cause:  The control file change sequence number in the data file is
         greater than the number in the control file. This implies that
         the wrong control file is being used. Note that repeatedly causing
         this error can make it stop happening without correcting the real
         problem. Every attempt to open the database will advance the
         control file change sequence number until it is great enough.
 *Action: Use the current control file or do backup control file recovery to
         make the control file current. Be sure to follow all restrictions
         on doing a backup control file recovery.

Regards
Michel

Report message to a moderator

Previous Topic:	Restore compatibility
Next Topic:	Rman Help (merged)

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Nov 22 08:27:49 CST 2024