ORA-01157:ORA-01110数据库启动表空间问题解决

 

[oracle@csdb ~]$ lsnrctl start

LSNRCTL for Linux: Version 11.2.0.4.0 - Production on 08-JUL-2020 08:01:55

Copyright (c) 1991, 2013, Oracle. All rights reserved.

Starting /app/oracle/app/oracle/product/11.2.0/dbhome_1/bin/tnslsnr: please wait...

TNSLSNR for Linux: Version 11.2.0.4.0 - Production
System parameter file is /app/oracle/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora
Log messages written to /app/oracle/app/diag/tnslsnr/csdb/listener/alert/log.xml
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=csdb)(PORT=1521)))
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=csdb)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 11.2.0.4.0 - Production
Start Date 08-JUL-2020 08:01:55
Uptime 0 days 0 hr. 0 min. 0 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /app/oracle/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora
Listener Log File /app/oracle/app/diag/tnslsnr/csdb/listener/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=csdb)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
The listener supports no services
The command completed successfully
[oracle@csdb ~]$ sqlplus /nolog

SQL*Plus: Release 11.2.0.4.0 Production on Wed Jul 8 08:01:58 2020

Copyright (c) 1982, 2013, Oracle. All rights reserved.
" - rest of line ignored.
SQL> conn /as sysdba
Connected to an idle instance.
SQL> startup
ORACLE instance started.

Total System Global Area 8351150080 bytes
Fixed Size 2269872 bytes
Variable Size 1862274384 bytes
Database Buffers 6476005376 bytes
Redo Buffers 10600448 bytes
Database mounted.
ORA-01157: cannot identify/lock data file 5 - see DBWR trace file
ORA-01110: data file 5: '/app/oracle/app/oradata/bpmorayzy.dbf'

SQL> shutdown immediate
ORA-01109: database not open

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

Total System Global Area 8351150080 bytes
Fixed Size 2269872 bytes
Variable Size 1862274384 bytes
Database Buffers 6476005376 bytes
Redo Buffers 10600448 bytes
Database mounted.
SQL> alter database datafile 5 offline drop;

Database altered.

SQL> recover database;
Media recovery complete.
SQL> recover database;
ORA-00283: recovery session canceled due to errors
ORA-00264: no recovery required

SQL> alter database open;

Database altered.

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

Total System Global Area 8351150080 bytes
Fixed Size 2269872 bytes
Variable Size 1862274384 bytes
Database Buffers 6476005376 bytes
Redo Buffers 10600448 bytes
Database mounted.
Database opened.
SQL>