OraFAQ Forum: Server Administration

Home » RDBMS Server » Server Administration » ORA-1207 (8.1.7)

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

ORA-1207 (8.1.7) [message #135091]

Mon, 29 August 2005 19:47

fbeeharr
Messages: 1
Registered: August 2005
Location: Tahiti

Junior Member

While starting the databse i got the following message
ORA-01122: Echec de controle de verification pour fichier BdD 4
ORA-01110: fichier de donnees 4 : '/BSCS_DATA/oradata/BSCS/data/DATA_1.dbf'
ORA-01207: fichier plus recent que le fichier de controle - ancien fichier de controle

dbf file more recent that the control file !!

What should i do to make the database open correctly.

I restored dbf from another database to an other one.

Thanks in advance for your help

Regards

Report message to a moderator

Re: ORA-1207 (8.1.7) [message #135118 is a reply to message #135091]

Tue, 30 August 2005 00:30

girish.rohini
Messages: 744
Registered: April 2005
Location: Delhi (India)

Senior Member

Either you make a new control file, the current control & perform cancel based recovery
or

if you have created your control file backup using the following method:

alter database backup controlfile to <your_controlfile>

then
at mount point iissue command:
recover database
until cancel using backup controfile;

If backed up control file using the following method:
alter database backup controlfile to trace;
then
run the trace file to create the your control file.

Then you would need put your db is mount state and issue a "recover database
until cancel using backup controfile; command.

Regds
Girish

Report message to a moderator

Previous Topic:	Media Recovery (ORA-01113)
Next Topic:	ORA-01034 Error

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Feb 04 00:31:45 CST 2025