| ora-01110: data file 10 [message #423785] |
Mon, 28 September 2009 04:08  |
janakors
Messages: 232
Registered: September 2009
|
Senior Member |
|
|
hi,
i have deleted datafile and now i am trying to recover
i don't have physical backup but do have user lvl export but i can't open my dtabase as i recevie the following error
ora-01110: data file 10
'/u01/app/oracle/oracle/product/10/2/0/db-1/oradata/user01.dbf'
ora-01115:IO error reading block from file 10(block#1)
ora-27069: attempt to do I/O beyond the range of the file
additional information :1
additional information :1
so i can't import
please anyone can help me to pen my db or how can i recover
regards
janakors
|
|
|
|
|
|
| Re: ora-01110: data file 10 [message #423790 is a reply to message #423785] |
Mon, 28 September 2009 04:57  |
janakors
Messages: 232
Registered: September 2009
|
Senior Member |
|
|
thanks for response
it is a test database so i am doing exercise on it and i have following solutions
1.take that tablespace offline to whom that lost data file belong and open the database but i don't know which tablespace he belongs to, so can u tell me how to know that
2.creat the same file at os lvl and do full database import
please help how can i open my db
regards
janakors
|
|
|
|
|
|
|
|
|
|
| Re: ora-01110: data file 10 [message #424231 is a reply to message #423785] |
Thu, 01 October 2009 00:15 |
janakors
Messages: 232
Registered: September 2009
|
Senior Member |
|
|
yes it worked
thank you sir and if u can guide me regarding the commands or select quries i can perform at MOUNT satge of database so i will update my knowledge. any links or document i can read i will be really thankfull.
regards
janakors
|
|
|
|
|
|
|
|
|
|
| Re: ora-01110: data file 10 [message #424391 is a reply to message #424286] |
Fri, 02 October 2009 01:21 |
janakors
Messages: 232
Registered: September 2009
|
Senior Member |
|
|
yes sir u are correct. not all views but i know only V$datafile so only these two views as u said in your previous post or more then that. i mean some list or few important views u can tell so i will update myself as i didn't find some good on it
thank you
regards
|
|
|
|
|
|
| Re: ora-01110: data file 10 [message #424395 is a reply to message #424391] |
Fri, 02 October 2009 01:45 |
 |
Michel Cadot
Messages: 68645
Registered: March 2007
Location: Nanterre, France, http://...
|
Senior Member
Account Moderator |
|
|
janakors wrote on Fri, 02 October 2009 08:21yes sir u are correct. not all views but i know only V$datafile so only these two views as u said in your previous post or more then that. i mean some list or few important views u can tell so i will update myself as i didn't find some good on it
thank you
regards
Do it yourself: get a list of all V$ views (query dba_views), put your database in mount state, and query all previously listed views, then you will know all those that are queryable (and can put the list here to help others).
Regards
Michel
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
