| Re: database cannot startup [message #52066] |
Mon, 01 July 2002 06:09 |
sai sreenivas jeedigunta
Messages: 370
Registered: November 2001
|
Senior Member |
|
|
heyy
the reason for this error is ..one of the datafile is damaged / lost... so do the following steps..
if u dont know which datafile is having the problem, better open the alert.log file in the bdump directory and get the datafile name and give the following commands
alter database datafile ' path of the Datfile & datafile name' offline;
alter database open;
and later create the datafile using the following command
alter database create datafile 'same path as above' ;
this would solve the problem..
**** but make sure that u dont do the above steps if the datafile lost is system datafile.. ***
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
