OraFAQ Forum: Server Administration

Home » RDBMS Server » Server Administration » ora-01110 (oracle 10.2.0.3)

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

ora-01110 [message #459493]

Sun, 06 June 2010 03:04

sunilp.urs
Messages: 2
Registered: June 2010
Location: hyderabad

Junior Member

Hi all,

I have recreated my controlfile and missed one datafile to include in controlfile and opend database with reset logs options.
Now when i m trying to select data from missing file i m getting below error .

ORA-00376: file 12 cannot be read at this time
ORA-01111: name for data file 12 is unknown - rename to correct file
ORA-01110: data file 12: '/oracle/product/8.1.6/dbs/MISSING00012'

Please help me to over come this.

1) Can we recover this file as i have opened my database with open resetlogs.

2) If yes please let me know how to do theat

Report message to a moderator

Re: ora-01110 [message #459495 is a reply to message #459493]

Sun, 06 June 2010 03:35

Michel Cadot
Messages: 68653
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

1) Do you have the file?
2) In which place
3) Investigate to rename the file from MISSING... to the actual file name use ALTER DATABASE RENAME DATAFILE
4) Post details of what you have and did EXACTLY

Regards
Michel

Report message to a moderator

Re: ora-01110 [message #459497 is a reply to message #459495]

Sun, 06 June 2010 04:07

sunilp.urs
Messages: 2
Registered: June 2010
Location: hyderabad

Junior Member

Hi Michel,

Thanks for your support.

1) Yes: I have the file.
2) /oradata/db/user01.dbf this is the location of the file

I tried to create new database from production . while creating the controlfile i missed to include one datafile.
and after that i tried to recover the database that time i have given open resetlogs.
So its allowed me to open the database .. after that when i tried to select some database from missing datafile i m getting the below error

ORA-00376: file 12 cannot be read at this time
ORA-01111: name for data file 12 is unknown - rename to correct file
ORA-01110: data file 12: '/oracle/product/8.1.6/dbs/MISSING00012'

Please help me to overcome this.

Regards,
Sunil

Report message to a moderator

Re: ora-01110 [message #459504 is a reply to message #459497]

Sun, 06 June 2010 06:07

Michel Cadot
Messages: 68653
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Quote:

3) Investigate to rename the file from MISSING... to the actual file name: use ALTER DATABASE RENAME DATAFILE

Do that.

Regards
Michel

Report message to a moderator

Previous Topic:	How many databases
Next Topic:	I've got error ORA-01422 with gather_stats_job

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun May 19 18:10:47 CDT 2024