Home » RDBMS Server » Backup & Recovery » ISSUE WITH shutting down database (ORACLE 11gr2 linux)
ISSUE WITH shutting down database [message #580951] Sat, 30 March 2013 04:44 Go to next message
sakamboh
Messages: 24
Registered: March 2013
Location: oman
Junior Member
Hellow all,

I am facing below issue while shutting down my database, can anyone assist me with this ?

SQL> shutdown immediate
ORA-01122: database file 5 failed verification check
ORA-01110: data file 5: '/u02/oradata/MYDB/mydb.ora'
ORA-01203: wrong incarnation of this file - wrong creation SCN



Re: ISSUE WITH shutting down database [message #580952 is a reply to message #580951] Sat, 30 March 2013 05:34 Go to previous messageGo to next message
Michel Cadot
Messages: 60063
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
ORA-01203: wrong incarnation of this file - wrong creation SCN
 *Cause:  The creation SCN in the file header is not the same as the
         creation SCN in the control file. This is probably a copy of a
         file that was dropped.
 *Action: Restore a current copy of the data file and do recovery as needed.

Regards
Michel
Re: ISSUE WITH shutting down database [message #581477 is a reply to message #580952] Sun, 07 April 2013 22:17 Go to previous message
dia.william923@gmail.com
Messages: 5
Registered: February 2013
Junior Member
ORA-01122 database file string failed verification check
Cause: The information in this file is inconsistent with information from the control file. See accompanying message for reason.
Action: Make certain that the database files and control files are the correct files for this database.
Previous Topic: backup of controlfile on stdby node
Next Topic: rman backup instance and tablespace
Goto Forum:
  


Current Time: Sun Dec 28 22:41:03 CST 2014

Total time taken to generate the page: 0.09183 seconds