Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 395
  • Last Modified:

Database Recovery - ORA-01033

Database Recovery - ORA-01033

We've had a complete NT server failure which has meant a new Windows 2000 machine been put in with a fresh install of Personal Oracle 8.1.6.

A new database has been created (called the same as before) and we've been able to recover the ORADATA files from the previous machine. What do we do now? Presume we can't just copy the old ORADATA files over on top of the new (tried this and it produces an error:
ORA-01033 ORACLE initialization or shutdown in progress.

Tried going into svrmgrl and connecting to the Database but get the same message.. Not a technical guru.. please help!


1 Solution
Guy Hengel [angelIII / a3]Billing EngineerCommented:
you might try to connect as INTERNAL or with SYSDBA to the oracle instance (not to the database, which is often source to confusion), and use SHUTDOWN ABORT, and the STARTUP to try to start the database.
To connect, use sqlplus (don't use svrmgrl anymore).
stop the oracle service

copy the oratada files over

start the service

If you can start the database (by checking if you can connect with an ordinary user) then it is OK.
But most probably you cannot start the database, then

1. in command promt
   oradim -delete -sid <your Oracle service name>
2. delete the file ora_home\database\ora<Sid>.pwd
3. oradim -new -sid <SID> -intpwd <internal password> -startmode a -pfile <your init ora file with full path>
4 .using sqlplus connect sys as sysdba (or internal) then start up the db.

ptompkinsonAuthor Commented:
Many thanks iozturk... worked a treat.

Featured Post

Get quick recovery of individual SharePoint items

Free tool – Veeam Explorer for Microsoft SharePoint, enables fast, easy restores of SharePoint sites, documents, libraries and lists — all with no agents to manage and no additional licenses to buy.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now