"The
soul should always stand ajar. Ready to welcome the ecstatic
experience."
-Emily
Dickinson (1830-1886)
|
When I startup my
database, I get an error and tells me that one of my datafile is
missing. How can I bypass that error and start my database?
You need to offline your
datafile in order to startup your database:
First start your database with mount option.
SQL> CONNECT / AS SYSDBA
SQL> STARTUP MOUNT
Then offline the missing datafile. You should know the file#. The
oracle error message tells you about that file number.
SQL> ALTER DATABASE DATAFILE nn OFFLINE;
Now, you should be able to open your database.
SQL> ALTER DATABASE OPEN;
|