OraFAQ Forum: Backup & Recovery » ISSUE WITH shutting down database

Home » RDBMS Server » Backup & Recovery » ISSUE WITH shutting down database (ORACLE 11gr2 linux)

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

ISSUE WITH shutting down database [message #580951]

Sat, 30 March 2013 04:44

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

Report message to a moderator

Re: ISSUE WITH shutting down database [message #580952 is a reply to message #580951]

Sat, 30 March 2013 05:34

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

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

Report message to a moderator

Re: ISSUE WITH shutting down database [message #581477 is a reply to message #580952]

Sun, 07 April 2013 22:17

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.

Report message to a moderator

Previous Topic:	backup of controlfile on stdby node
Next Topic:	rman backup instance and tablespace

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Dec 17 20:13:26 CST 2024