Tuesday, June 17, 2008

Oracle Deleted DAT File
Failed Server Startup

It makes perfect sense...right? If you are a Database Server and you can't find a .DAT file, don't start the server. Make me jump through hoops to get the server back up and running. Here's the error message:

Errors in file d:\oracle\product\10.1.0\admin\server\bdump\server_dbw0_352.trc:ORA-01157: cannot identify/lock data file 21 - see DBWR trace fileORA-01110: data file 21: 'D:\ORACLE\PRODUCT\10.1.0\ORADATA\SERVER\DATABASE_NAME'ORA-27041: unable to open fileOSD-04002: unable to open fileO/S-Error: (OS 2) The system cannot find the file specified.

Here's the solution:

http://www.mydigitallife.info/2007/08/04/how-drop-tablespace-and-recover-oracle-database-when-accidentally-delete-datafile/

Tips for Connecting
  1. Launch SQL Plus using '/nolog' in the command line. You can also right-click on the SQL Plus shortcut and add ' /nolog' to the executable path.
  2. Type: 'conn sys as sysdba'
  3. Enter your password

No comments:

Check This Out!

More Links to Good Information