删除数据库文件之后出现的错误

最新推荐文章于 2022-02-10 15:47:23 发布

逆水行

最新推荐文章于 2022-02-10 15:47:23 发布

阅读量525

点赞数

分类专栏： hpux oracle linux 文章标签： hp-ux unix oracle11g oracle

linux 同时被 3 个专栏收录

19 篇文章 0 订阅

订阅专栏

oracle

4 篇文章 0 订阅

订阅专栏

hpux

0 篇文章 0 订阅

订阅专栏

直接用rm命令删除了数据库文件。

重新启动数据库服务时

SQL> startup;

ORACLE instance started.

Total System Global Area 1703624704 bytes

Fixed Size 2170464 bytes

Variable Size 1056965024 bytes

Database Buffers 637534208 bytes

Redo Buffers 6955008 bytes

Database mounted.

ORA-01157: cannot identify/lock data file 5 - see DBWR trace file

ORA-01110: data file 5: '/opt/oracle/oradata/orcl/CSG_EHVGZ.dbf'

解决方法：

SQL> alter database datafile 5 offline drop;

Database altered.

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


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

Total System Global Area 1703624704 bytes
Fixed Size                  2170464 bytes
Variable Size            1056965024 bytes
Database Buffers          637534208 bytes
Redo Buffers                6955008 bytes
Database mounted.
Database opened.