ORA-03113 error when Oracle database is shut down

Source: Internet
Author: User

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>

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.