Laurent’s Blog

c:\>sqlplus /nolog

SQL*Plus: Release 10.2.0.2.0 – Production on Thu Apr 3 11:14:46 2008

Copyright (c) 1982, 2005, Oracle. All Rights Reserved.

SQL> connect sys/[PASSWORD]@[DB] as sysdba
Connected.

SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.

SQL> startup mount;
ORACLE instance started.

Total System Global Area 1694498816 bytes
Fixed Size 2054072 bytes
Variable Size 687867976 bytes
Database Buffers 989855744 bytes
Redo Buffers 14721024 bytes
Database mounted.

SQL> alter database noarchivelog;

Database altered.

SQL> alter database open;

Database altered.

SQL> archive log list;

Database log mode No Archive Mode
Automatic archival Disabled
Archive destination E:\oracle\QAS\oraarch\QASarch
Oldest online log sequence 939
Current log sequence 946

SQL> quit

Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 – 64
bit Production
With the Partitioning, OLAP and Data Mining options

If your are receiving the error

ORA-01033 oracle in initialization or shutdown in progress

You can try to manually start the tabase as described here under :

> sqlplus /nolog
SQL> connect / as sysdba
Connected
SQL> shutdown abort
Instance ORACLE stopped.
SQL> startup nomount
Instance ORACLE started.
SQL> alter database mount;
SQL> alter database open;

When you issue the command alter database open, you may receive the errors :

ORA-01113: file n needs media recovery
ORA-01110: data file n: 'full file name'

You can simply try to use the recover command and then retry to open the database :

SQL>Recover datafile ‘full-path-datafile-name’;
File recovered successfully
SQL> alter database open;

Good luck