Home » RDBMS Server » Backup & Recovery » Error during Database OPEN (Oracle 10g)
Error during Database OPEN [message #386771] Mon, 16 February 2009 23:45 Go to next message
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?
Re: Error during Database OPEN [message #386772 is a reply to message #386771] Mon, 16 February 2009 23:50 Go to previous messageGo to next message
BlackSwan
Messages: 25039
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.
Re: Error during Database OPEN [message #386797 is a reply to message #386772] Tue, 17 February 2009 00:51 Go to previous messageGo to next message
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.
Re: Error during Database OPEN [message #386807 is a reply to message #386771] Tue, 17 February 2009 01:06 Go to previous message
Michel Cadot
Messages: 64119
Registered: March 2007
Location: Nanterre, France, http://...
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
Previous Topic: Restore compatibility
Next Topic: Rman Help (merged)
Goto Forum:
  


Current Time: Tue Dec 06 06:13:26 CST 2016

Total time taken to generate the page: 0.11730 seconds