| Datafile missing [message #271547] |
Tue, 02 October 2007 00:41  |
win3vin
Messages: 35
Registered: April 2007
Location: Malaysia
|
Member |
|
|
Hi
one of the datafile was accidentally deleted physically in OS by someone. The datafile was recently added and is in recover state(offline).
How do I remove it from our database and dictionary? Can I add back after I drop it?
Environment:
Oracle 9.2.0.7 under Win2003. The DB backup is using export/import method
|
|
|
|
|
|
|
|
| Re: Datafile missing [message #271566 is a reply to message #271547] |
Tue, 02 October 2007 01:11  |
win3vin
Messages: 35
Registered: April 2007
Location: Malaysia
|
Member |
|
|
Could I use this method to recreate the files?
1)Recreate the datafile.
> alter database create datafile '/tmp/sample.dbf' as '/tmp/sample.dbf' size 10240 reuse.
2)Bring the file online.
> alter database datafile '/tmp/sample.dbf' online;
3)Recover the datafile.
> Recover database;
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
