what are the minimum files which are required to open the db ? [message #573323] |
Wed, 26 December 2012 14:29 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.gravatar.com/avatar/d12cd5a0688c38a7bb8f253b0611fdb2?s=64&d=mm&r=g) |
maninderkrb
Messages: 41 Registered: August 2012 Location: India
|
Member |
|
|
what are the minimum files which are required to open the db ?
take it as this
I have oracle installed in c drive
I have placed 3 datafile related to one tablespace say test: two in D and one in E
I have plaace 3 datafile related to tablespace say orcl : two in D and one in E
my undo is in E
scenario is that my E drive crashed
db is in no archive mode
no backup is there.
to be more worst db shuts down abnormoly.
I want my db open with data of c drive and D drive.
Is it possible to open it?
|
|
|
|
|
|