Home » RDBMS Server » Backup & Recovery » what are the minimum files which are required to open the db ? (any)
what are the minimum files which are required to open the db ? [message #573323] Wed, 26 December 2012 14:29 Go to next message
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?

Report message to a moderator

Re: what are the minimum files which are required to open the db ? [message #573324 is a reply to message #573323] Wed, 26 December 2012 14:31 Go to previous messageGo to next message
Michel Cadot
Messages: 68728
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
No... unless you are very very very lucky (and db was idle).

Regards
Michel

[Updated on: Wed, 26 December 2012 14:32]

Report message to a moderator

Re: what are the minimum files which are required to open the db ? [message #573325 is a reply to message #573324] Wed, 26 December 2012 14:34 Go to previous messageGo to next message
maninderkrb
Messages: 41
Registered: August 2012
Location: India
Member
so dear sir what is the answer to my question?

what are the minimum files which are required to open the db ?

Report message to a moderator

Re: what are the minimum files which are required to open the db ? [message #573329 is a reply to message #573325] Wed, 26 December 2012 15:12 Go to previous message
Michel Cadot
Messages: 68728
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
SYSTEM SYSAUX UNDO... but this does not mean you can open with (only) them (not even if you have ALL files).

Regards
Michel

[Updated on: Wed, 26 December 2012 15:13]

Report message to a moderator

Previous Topic: ORA-01655 on CREATE USER (splitted from RMAN backup error)
Next Topic: synchronize ctl and data files
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Tue Dec 17 20:15:38 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.