"Go" Oracle login ora-01033:oracle is initializing or shutting down the workaround

Http://www.cnblogs.com/xnzhao/p/6114469.html

Open Sqlplus

Please enter user name: System/sys as Sysdba

Then (unload data) Enter:

sql> shutdown Normal

will appear:

ORA-01109: Database is not open

The database has been uninstalled.

The ORACLE routine has been closed.

Then (load data) Enter:

Sql> Startup Mount

The ORACLE routine has been started.

The database is loaded.

After:

Sql>alter database open;

An error occurred on line 1th:

ORA-01157: Unable to identify/lock data file 6-see DBWR trace file

ORA-01110: Data file 6: ' D:/oracle/product/10.1.0/oradata/railway/2008_1.dat '

sql> ALTER DATABASE create datafile 6;

The database has changed.

Sql>alter database open;

An error occurred on line 1th:

ORA-01113: File 6 requires media recovery

ORA-01110: Data file 6: ' D:/oracle/product/10.1.0/oradata/railway/2008_1.dat '

Sql> ALTER DATABASE datafile 6 offline drop;

The database has changed.

Go on

Sql>alter database open;

If the above error occurs, continue with the related operation, the above 6 will correspond to create and drop.

If

sql> ALTER DATABASE open;

Came up:

The database has changed.

was successful.

You can then use PL/SQL and other client tools, log on to the Operation database.

Z

"Go" Oracle login ora-01033:oracle is initializing or shutting down the workaround