ORA-03113 error when Oracle database is shut down

ORA-03113 error occurs when Oracle database is shut down:

SQL> shutdown immediate
ORA-03113: end-of-file on communication channel
Process ID: 3437
The Session ID is 125 Serial number: 5.

SQL> startup
The ORA-24324: service handle not initialized.
ORA-01041: internal error. hostdef extension doesn't exist
SQL>
SQL>
SQL> startup nomount
The ORA-24324: service handle not initialized.
ORA-01041: internal error. hostdef extension doesn't exist
SQL>
SQL>
SQL> startup mount
The ORA-24324: service handle not initialized.
ORA-01041: internal error. hostdef extension doesn't exist
SQL>
SQL> alter datafile '/bk/ts5.2.dbf' offline
2;
ERROR:
ORA-03114: not connected to ORACLE

 

View log files:
/U01/app/diag/rdbms/orcl/trace/alert_orcl.log

16416 Errors in file/u01/app/diag/rdbms/orcl/trace/orcl_dbw0_4055.trc:
16417 ORA-01157: cannot identify/lock data file 6-see DBWR trace file
16418 ORA-01110: data file 6: '/bk/ts5.2.dbf'
16419 ORA-27037: unable to obtain file status
16420 Linux Error: 2: No such file or directory
16421 Additional information: 3
16422 Errors in file/u01/app/diag/rdbms/orcl/trace/orcl_ora_4097.trc:
16423 ORA-01157: cannot identify/lock data file 6-see DBWR trace file
16424 ORA-01110: data file 6: '/bk/ts5.2.dbf'
16425 ORA-1157 signalled during: alter database open...
16426 Mon Oct 21 20:53:43 2013
16427 Checker run found 1 new persistent data failures
16428 Mon Oct 21 20:54:53 2013

It is found that the tablespace file you just created is lost.
Start restoring tablespace files.

Solution:
SQL> shutdown abort
ORACLE instance shut down.
SQL>
SQL>
SQL>
SQL> startup
ORACLE instance started.

Total System Global Area 422670336 bytes
Fixed Size 1336960 bytes
Variable Size 314575232 bytes
Database Buffers 100663296 bytes
Redo Buffers 6094848 bytes
Database mounted.
ORA-01157: cannot identify/lock data file 6-see DBWR trace file
ORA-01110: data file 6: '/bk/ts5.2.dbf'

SQL> alter database datafile '/bk/ts5.2.dbf' offline drop;

Database altered.

SQL>
SQL>
SQL> startup
ORA-01081: cannot start already-running ORACLE-shut it down first
SQL> shutdown
ORA-01109: database not open

Database dismounted.
ORACLE instance shut down.
SQL> startup
ORACLE instance started.

Total System Global Area 422670336 bytes
Fixed Size 1336960 bytes
Variable Size 314575232 bytes
Database Buffers 100663296 bytes
Redo Buffers 6094848 bytes
Database mounted.
Database opened.
SQL>

 

Because the tablespace file is lost, check the tablespace at last:
SQL>
SQL> select tablespace_name, file_name from dba_data_files;

TABLESPACE_NAME FILE_NAME
------------------------------------------------------------
EXAMPLE/u01/app/oradata/orcl/example01.dbf
UNDOTBS1/u01/app/oradata/orcl/undotbs01.dbf
SYSAUX/u01/app/oradata/orcl/sysaux01.dbf
SYSTEM/u01/app/oradata/orcl/system01.dbf
USERS/u01/app/oradata/orcl/users01.dbf
TS5/bk/ts5.2.dbf
TS5/bk/ts5.dbf

7 rows selected.

SQL> select file #, name, status from v $ datafile;

FILE # NAME STATUS
---------------------------------------------------------
1/u01/app/oradata/orcl/system01.dbf SYSTEM
2/u01/app/oradata/orcl/sysaux01.dbf ONLINE
3/u01/app/oradata/orcl/undotbs01.dbf ONLINE
4/u01/app/oradata/orcl/users01.dbf ONLINE
5/u01/app/oradata/orcl/example01.dbf ONLINE
6/bk/ts5.2.dbf RECOVER
7/bk/ts5.dbf ONLINE

7 rows selected.

SQL>