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?
|
More Resources by
Google: |
|
|
|
|
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;
|