Q
Problem solve Get help with specific problems with your technologies, process and projects.

Command to open database with missing datafile

Can you tell me the command(s) or procedure to open a database that has a missing datafile due to a media failure (external device)? The database is in noarchivelog mode, there's not any backup and the version is 10g Release 2. It doesn't matter if the data is lost or inaccesible, I just want at least to open the database.

Hello Brian, can you please tell me the command(s) or procedure (if there is one) to open a database that has a missing datafile due to a media failure (external device)? The database is in noarchivelog mode, there's not any backup and the version is 10g Release 2. It doesn't matter if the data is lost or inaccesible, but I just want at least to open the database. Thanks in advance.
You can open the database with the following:
startup mount
alter database datafile '/directory/filename' offline drop;
alter database open;
drop tablespace ts_name including contents and datafiles;
The last command will remove the tablespace from the database, but that is OK in your case since you are missing the datafile anyway.

After this is done, you might want to look at implementing a sound backup and recovery strategy.

Dig Deeper on Oracle database backup and recovery

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide.com

SearchDataCenter

SearchContentManagement

SearchHRSoftware

Close