ORA-01157、ORA-01110之集群环境建立asm数据文件错误到本地处理

最新推荐文章于 2023-08-07 14:24:47 发布
最新推荐文章于 2023-08-07 14:24:47 发布
阅读量670 收藏 1
点赞数
分类专栏： 运维日常 文章标签： oracle 数据库 sql asm
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/weixin_41607523/article/details/120054797
版权

文章目录

前言

遇到好几次这样的问题，应用对Oracle rac数据库建表空间时出现了将表空间建到文件系统下而导致故障，数据库一旦重启将无法正常启动，且系统表中开始报错，要恢复的信息只能通过系统视图来获取

提示：以下是本篇文章正文内容，下面案例可供参考

一、背景环境介绍

本次为实际生产环境，数据库版本为19C，是其中小的pdb表空间发生问题
在这里插入图片描述

二、确认CDB信息以及本地数据文件位置

1.CDB是否开启归档

[oracle@dbm0dbadm01 ~]$ sqlplus / as sysdba

SQL*Plus: Release 19.0.0.0.0 - Production on Tue Aug 31 17:52:05 2021
Version 19.10.0.0.0

Copyright (c) 1982, 2020, Oracle.  All rights reserved.


Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.10.0.0.0

SQL> 
SQL> 
SQL> archive log list
Database log mode	       Archive Mode
Automatic archival	       Enabled
Archive destination	       USE_DB_RECOVERY_FILE_DEST
Oldest online log sequence     96
Next log sequence to archive   101
Current log sequence	       101
SQL> 
SQL> 
SQL> exit

确定本地文件系统位置

因为存在2个节点RAC模式下，需要确定数据文件被建立在了哪个节点下(本次按理数据文件在节点二)：

SQL> alter session set container=***;

Session altered.

SQL> 
SQL> @tbs
order by "USED_RATE(%)" desc
                           *
ERROR at line 35:
ORA-01157: cannot identify/lock data file 303 - see DBWR trace file
ORA-01110: data file 303: '/u01/app/oracle/product/19.0.0.0/dbhome_1/dbs/E:appAdministratororadataorclbsqycxl_data.dbf'
SQL> exit
Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.10.0.0.0
[oracle@dbm0dbadm01 ~]$ ssh dbm0dbadm02 
[oracle@dbm0dbadm02 ~]$ cd /u01/app/oracle/product/19.0.0.0/dbhome_1/dbs
[oracle@dbm0dbadm02 dbs]$ ll
total 22575188
-rw-r----- 1 oracle asmadmin 13631496192 Aug 31 18:22 E:appAdministratororadataorclbsadmin_data.dbf
-rw-r----- 1 oracle asmadmin  3145736192 Aug 31 18:22 E:appAdministratororadataorclbsemr_data.dbf
-rw-r----- 1 oracle asmadmin  1048584192 Aug 31 18:22 E:appAdministratororadataorclbsenr_data.dbf
-rw-r----- 1 oracle asmadmin  1048584192 Aug 31 18:22 E:appAdministratororadataorclbshss_data.dbf
-rw-r----- 1 oracle asmadmin  1048584192 Aug 31 18:22 E:appAdministratororadataorclbsmob_data.dbf
-rw-r----- 1 oracle asmadmin  1048584192 Aug 31 18:22 E:appAdministratororadataorclbsportal_data.dbf
-rw-r----- 1 oracle asmadmin  1048584192 Aug 31 11:48 E:appAdministratororadataorclbsqylis_data.dbf
-rw-r----- 1 oracle asmadmin  1048584192 Aug 31 18:22 E:appAdministratororadataorclbszdgx_data.dbf
-rw-rw---- 1 oracle asmadmin        1544 May 31 17:01 hc_db1db12.dat
-rw-rw---- 1 oracle asmadmin        1544 Aug 31 16:55 hc_******bg2.dat
-rw-rw---- 1 oracle asmadmin        1544 Aug 31 17:04 hc_******ts2.dat
-rw-rw---- 1 oracle asmadmin        1544 Aug 31 18:28 hc_******yl2.dat
-rw-r----- 1 oracle asmadmin     2097152 May 31 17:01 id_db1db12.dat
-rw-r----- 1 oracle asmadmin     2097152 Aug 31 18:40 id_******bg2.dat
-rw-r----- 1 oracle asmadmin     2097152 Aug 31 18:40 id_******ts2.dat
-rw-r----- 1 oracle asmadmin     2097152 Aug 31 18:40 id_******yl2.dat
-rw-r--r-- 1 oracle oinstall        3079 Apr 17 20:42 init.ora
-rw-r----- 1 oracle asmadmin    19906560 Jun 15 18:29 snapcf_******bg2.f
-rw-r----- 1 oracle asmadmin    19939328 Aug 31 18:22 snapcf_******yl2.f
[oracle@dbm0dbadm02 dbs]$

三、rman 恢复数据文件

确认数据文件FILE编号

因系统表开始报错无法使用，我们只能用系统视图执行查询

SQL> desc v$datafile;
 Name									  Null?    Type
 ------------------------------------------------------------------------ -------- -------------------------------------------------
 FILE#										   NUMBER
 CREATION_CHANGE#								   NUMBER
 CREATION_TIME									   DATE
 TS#										   NUMBER
 RFILE# 									   NUMBER
 STATUS 									   VARCHAR2(7)
 ENABLED									   VARCHAR2(10)
 CHECKPOINT_CHANGE#								   NUMBER
 CHECKPOINT_TIME								   DATE
 UNRECOVERABLE_CHANGE#								   NUMBER
 UNRECOVERABLE_TIME								   DATE
 LAST_CHANGE#									   NUMBER
 LAST_TIME									   DATE
 OFFLINE_CHANGE#								   NUMBER
 ONLINE_CHANGE# 								   NUMBER
 ONLINE_TIME									   DATE
 BYTES										   NUMBER
 BLOCKS 									   NUMBER
 CREATE_BYTES									   NUMBER
 BLOCK_SIZE									   NUMBER
 NAME										   VARCHAR2(513)
 PLUGGED_IN									   NUMBER
 BLOCK1_OFFSET									   NUMBER
 AUX_NAME									   VARCHAR2(513)
 FIRST_NONLOGGED_SCN								   NUMBER
 FIRST_NONLOGGED_TIME								   DATE
 FOREIGN_DBID									   NUMBER
 FOREIGN_CREATION_CHANGE#							   NUMBER
 FOREIGN_CREATION_TIME								   DATE
 PLUGGED_READONLY								   VARCHAR2(3)
 PLUGIN_CHANGE# 								   NUMBER
 PLUGIN_RESETLOGS_CHANGE#							   NUMBER
 PLUGIN_RESETLOGS_TIME								   DATE
 CON_ID 									   NUMBER

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

     FILE#	  TS# NAME
---------- ---------- --------------------------------------------------------------------------------------------------------------
       154	    0 +DATAC1/******YL/C8A3A2DFCCFD9096E053E1FEA00AA686/DATAFILE/system.965.1079623727
       155	    0 +DATAC1/******YL/C8A3A2DFCCFD9096E053E1FEA00AA686/DATAFILE/system.967.1079623727
       156	    0 +DATAC1/******YL/C8A3A2DFCCFD9096E053E1FEA00AA686/DATAFILE/system.968.1079623727
       157	    0 +DATAC1/******YL/C8A3A2DFCCFD9096E053E1FEA00AA686/DATAFILE/system.969.1079623727
       158	    1 +DATAC1/******YL/C8A3A2DFCCFD9096E053E1FEA00AA686/DATAFILE/sysaux.966.1079623727
       159	    1 +DATAC1/******YL/C8A3A2DFCCFD9096E053E1FEA00AA686/DATAFILE/sysaux.970.1079623727
       160	    1 +DATAC1/******YL/C8A3A2DFCCFD9096E053E1FEA00AA686/DATAFILE/sysaux.971.1079623727
       161	    1 +DATAC1/******YL/C8A3A2DFCCFD9096E053E1FEA00AA686/DATAFILE/sysaux.972.1079623727
       162	    2 +DATAC1/******YL/C8A3A2DFCCFD9096E053E1FEA00AA686/DATAFILE/undotbs1.964.1079623727
       163	    2 +DATAC1/******YL/C8A3A2DFCCFD9096E053E1FEA00AA686/DATAFILE/undotbs1.973.1079623727
       164	    5 +DATAC1/******YL/C8A3A2DFCCFD9096E053E1FEA00AA686/DATAFILE/undo_2.963.1079623727

     FILE#	  TS# NAME
---------- ---------- --------------------------------------------------------------------------------------------------------------
       165	    5 +DATAC1/******YL/C8A3A2DFCCFD9096E053E1FEA00AA686/DATAFILE/undo_2.974.1079623727
       166	    6 +DATAC1/******YL/C8A3A2DFCCFD9096E053E1FEA00AA686/DATAFILE/users.962.1079623727
       221	    7 /u01/app/oracle/product/19.0.0.0/dbhome_1/dbs/E:appAdministratororadataorclbsportal_data.dbf
       222	    8 /u01/app/oracle/product/19.0.0.0/dbhome_1/dbs/E:appAdministratororadataorclbsadmin_data.dbf
       223	    9 /u01/app/oracle/product/19.0.0.0/dbhome_1/dbs/E:appAdministratororadataorclbsemr_data.dbf
       224	   10 /u01/app/oracle/product/19.0.0.0/dbhome_1/dbs/E:appAdministratororadataorclbsmob_data.dbf
       225	   11 /u01/app/oracle/product/19.0.0.0/dbhome_1/dbs/E:appAdministratororadataorclbsenr_data.dbf
       226	   12 /u01/app/oracle/product/19.0.0.0/dbhome_1/dbs/E:appAdministratororadataorclbshss_data.dbf
       227	   13 /u01/app/oracle/product/19.0.0.0/dbhome_1/dbs/E:appAdministratororadataorclbszdgx_data.dbf

20 rows selected.

我们发现221~227数据文件是全部建立错误的！

rman copy datafile

[oracle@dbm0dbadm02 dbs]$ rman target /

Recovery Manager: Release 19.0.0.0.0 - Production on Tue Aug 31 18:20:15 2021
Version 19.10.0.0.0

Copyright (c) 1982, 2019, Oracle and/or its affiliates.  All rights reserved.

connected to target database: XXXXXXX (DBID=1578450313)

RMAN> 

RMAN> backup as copy datafile 221,222,223,224,225,226,227 format '+DATAC1';

Starting backup at 31-AUG-21
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=4247 instance=umcareyl2 device type=DISK
channel ORA_DISK_1: starting datafile copy
input datafile file number=00222 name=/u01/app/oracle/product/19.0.0.0/dbhome_1/dbs/E:appAdministratororadataorclbsadmin_data.dbf
output file name=+DATAC1/******YL/C8A3A2DFCCFD9096E053E1FEA00AA686/DATAFILE/bsadmin_data.1118.1082053343 tag=TAG20210831T182222 RECID=4 STAMP=1082053349
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:15
channel ORA_DISK_1: starting datafile copy
input datafile file number=00223 name=/u01/app/oracle/product/19.0.0.0/dbhome_1/dbs/E:appAdministratororadataorclbsemr_data.dbf
output file name=+DATAC1/******YL/C8A3A2DFCCFD9096E053E1FEA00AA686/DATAFILE/bsemr_data.1119.1082053359 tag=TAG20210831T182222 RECID=5 STAMP=1082053360
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:03
channel ORA_DISK_1: starting datafile copy
input datafile file number=00221 name=/u01/app/oracle/product/19.0.0.0/dbhome_1/dbs/E:appAdministratororadataorclbsportal_data.dbf
output file name=+DATAC1/******YL/C8A3A2DFCCFD9096E053E1FEA00AA686/DATAFILE/bsportal_data.1120.1082053361 tag=TAG20210831T182222 RECID=6 STAMP=1082053361
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:01
channel ORA_DISK_1: starting datafile copy
input datafile file number=00224 name=/u01/app/oracle/product/19.0.0.0/dbhome_1/dbs/E:appAdministratororadataorclbsmob_data.dbf
output file name=+DATAC1/******YL/C8A3A2DFCCFD9096E053E1FEA00AA686/DATAFILE/bsmob_data.1121.1082053361 tag=TAG20210831T182222 RECID=7 STAMP=1082053362
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:01
channel ORA_DISK_1: starting datafile copy
input datafile file number=00225 name=/u01/app/oracle/product/19.0.0.0/dbhome_1/dbs/E:appAdministratororadataorclbsenr_data.dbf
output file name=+DATAC1/******YL/C8A3A2DFCCFD9096E053E1FEA00AA686/DATAFILE/bsenr_data.1122.1082053363 tag=TAG20210831T182222 RECID=8 STAMP=1082053363
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:01
channel ORA_DISK_1: starting datafile copy
input datafile file number=00226 name=/u01/app/oracle/product/19.0.0.0/dbhome_1/dbs/E:appAdministratororadataorclbshss_data.dbf
output file name=+DATAC1/******YL/C8A3A2DFCCFD9096E053E1FEA00AA686/DATAFILE/bshss_data.1123.1082053365 tag=TAG20210831T182222 RECID=9 STAMP=1082053364
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:01
channel ORA_DISK_1: starting datafile copy
input datafile file number=00227 name=/u01/app/oracle/product/19.0.0.0/dbhome_1/dbs/E:appAdministratororadataorclbszdgx_data.dbf
output file name=+DATAC1/******YL/C8A3A2DFCCFD9096E053E1FEA00AA686/DATAFILE/bszdgx_data.1124.1082053365 tag=TAG20210831T182222 RECID=10 STAMP=1082053365
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:01
Finished backup at 31-AUG-21

Starting Control File and SPFILE Autobackup at 31-AUG-21
piece handle=+RECOC1/******YL/AUTOBACKUP/2021_08_31/s_1082053366.626.1082053367 comment=NONE
Finished Control File and SPFILE Autobackup at 31-AUG-21

RMAN>

pdb下将数据文件offline

[oracle@dbm0dbadm01 ~]$ sqlplus / as sysdba

SQL*Plus: Release 19.0.0.0.0 - Production on Tue Aug 31 17:52:05 2021
Version 19.10.0.0.0

Copyright (c) 1982, 2020, Oracle.  All rights reserved.


Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.10.0.0.0

SQL> 
SQL> alter database datafile 221,222,223,224,225,226,227 offline;

switch datafile&recover datafile

RMAN> 

RMAN> switch datafile 221,222,223,224,225,226,227 to copy;

datafile 221 switched to datafile copy "+DATAC1/******EYL/C8A3A2DFCCFD9096E053E1FEA00AA686/DATAFILE/bsportal_data.1120.1082053361"
datafile 222 switched to datafile copy "+DATAC1/******YL/C8A3A2DFCCFD9096E053E1FEA00AA686/DATAFILE/bsadmin_data.1118.1082053343"
datafile 223 switched to datafile copy "+DATAC1/******YL/C8A3A2DFCCFD9096E053E1FEA00AA686/DATAFILE/bsemr_data.1119.1082053359"
datafile 224 switched to datafile copy "+DATAC1/******YL/C8A3A2DFCCFD9096E053E1FEA00AA686/DATAFILE/bsmob_data.1121.1082053361"
datafile 225 switched to datafile copy "+DATAC1/******YL/C8A3A2DFCCFD9096E053E1FEA00AA686/DATAFILE/bsenr_data.1122.1082053363"
datafile 226 switched to datafile copy "+DATAC1/******YL/C8A3A2DFCCFD9096E053E1FEA00AA686/DATAFILE/bshss_data.1123.1082053365"
datafile 227 switched to datafile copy "+DATAC1/******YL/C8A3A2DFCCFD9096E053E1FEA00AA686/DATAFILE/bszdgx_data.1124.1082053365"

RMAN> recover datafile 221,222,223,224,225,226,227;

Starting recover at 31-AUG-21
using channel ORA_DISK_1

starting media recovery
media recovery complete, elapsed time: 00:00:01

Finished recover at 31-AUG-21

RMAN> 
RMAN> exit

Recovery Manager complete.

pdb下将数据文件online

SQL> alter database datafile 221,222,223,224,225,226,227 online;

删除本地文件

[oracle@dbm0dbadm02 dbs]$ rm E:appadmin*

四、结果确认

在这里插入图片描述

附：其他处理方法-删库

正好也是有环境可以进行测试删库操作，如下：
dbca去管理pdb，选择删除pdb，发现出现错误提示，但还可以继续，最终显示pdb删除成功
在这里插入图片描述
在这里插入图片描述
在这里插入图片描述
登录数据库进行验证发现此库只是mounted状态！
在这里插入图片描述
尝试用命令删除：

SQL> drop pluggable database *** including datafiles;
drop pluggable database *** including datafiles
*
ERROR at line 1:
ORA-01157: cannot identify/lock data file 303 - see DBWR trace file
ORA-01110: data file 303:
'/u01/app/oracle/product/19.0.0.0/dbhome_1/dbs/E:appAdministratororadataorclbsqy
***_data.dbf'


SQL> exit
Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.10.0.0.0

想不出其他办法，只能问问大哥了:

在这里插入图片描述

SQL> 
SQL> alter session set container=***;

Session altered.

SQL> 
SQL> 
SQL> alter pluggable database datafile 303 offline drop;

Pluggable database altered.

SQL> conn / as sysdba
Connected.
SQL> drop pluggable database *** including datafiles;

Pluggable database dropped.

SQL>

总结

老奶奶擤鼻涕，手拿把掐

DBA狗剩儿
关注
  • 0
    点赞
  • 踩
  • 1
    收藏
    觉得还不错? 一键收藏
  • 打赏
    打赏
  • 0
    评论
专栏目录
ora-01157处理
10-22
ora-01157处理方案，亲测可用！ ora-01157处理方案，亲测可用！
数据库报：ORA-01196(ORA-10458/ORA-01110)错误的解决方法
09-09
主要给大家介绍了关于数据库报：ORA-01196(ORA-10458/ORA-01110)错误的解决方法，文中通过示例代码介绍的非常详细，对大家学习或者使用数据库具有一定的参考学习价值，需要的朋友们下面来一起学习学习吧
oracle 实例启动时报 ORA-01157，ORA-01110解决
Jaysanshi的专栏
01-08 711
  startup启动数据库提示   ORA-01157:无法标识/锁定数据文件 -请参阅 DBWR跟踪文件  ORA-01110:数据文件 ：'D:\app\T...\....dbf'  解决方案： 1、shoutdown immediate ora-01109:数据库未打开 已经卸载数据库 ORACLE例程已关闭 2、startup
ORA-01157错误解决(zt)
cuixie2370的博客
12-17 410
ORA-1157错误解决手册一．错误描述ORA-1157, "cannot identify/lock data file %s - see DBWR trace file"引起的原因： 因为数据文件已经...
ORA-01157: 无法标识/锁定数据文件
wang77777的博客
12-14 337
现象： 启动数据库时出现如下错误： SQL> startup ORACLE 例程已经启动。 Total System Global Area 612368384 bytes Fixed Size 1250428 bytes Variable Size 167775108 bytes Database Buffers ...
ORA-01157: cannot identify/lock data file 6 - see DBWR trace file oracle数据库文件删除后 无法启动数据库
zbq1017的博客
06-13 777
数据库文件被误删，数据库无法启动
ORACLE ORA-01157: 无法标识/锁定数据文件
04-14 4431
create undo tablespace MOZI datafile 'E:\oracle\product\10.2.0\oradata\orcl\MOZI.DBF' size 2048M extent management local; alter system set undo_tablespace=MOZI; WINDOW下面的ORCL数据库提示:数据库未打开: 仅允许在固定表/视图
ORA-01157: 无法标识/锁定数据文件故障恢复
最新发布
六月闻君
08-07 2837
数据库表空间数据文件损坏，ORA-01157:无法标识/锁定数据文件，无法启动数据库，进行数据恢复。
ORA-01157 与 ORA-01110 的报错解决方案
CSDN 记录 “ 美好生活 ”
06-10 9154
问题描述： ORA-01157: 无法标识/锁定数据文件 17 - 请参阅 DBWR 跟踪文件 ORA-01110: 数据文件 17: ‘E:\TFS外网\FAYUANLAOGANBUBIAOKONGJIAN\RSGL2.DBF’我个人本地原因由于删除表空间对应的文件不当引起的。解决方案： 提示：数据库已更改。 提示：数据库已经关闭。已经卸载数据库。ORACLE 例程已经关闭。 提示：ORACLE 例程已经启动。操作完如上，重启连接数据库即可。...
Oracle无法标识锁定数据文件,启动错误ORA-01157: 无法标识/锁定数据文件 解决方案...
weixin_35767180的博客
04-10 9214
问题描述启动oracle出现错误：Oracle ORA-01033: ORACLE initialization or shutdown in progress 提示文件锁定第1 行出现错误: ORA-01157: 无法标识/锁定数据文件2 - 请参阅DBWR 跟踪文件ORA-01110: 数据文件2 ''''C:\oracle\oradata\oradb\XBC.DBF''一般是由于删除表空间对...
ORA-01157&ORA-01110 问题解决
Raymond的博客
08-10 3960
我的问题原因是服务器重启，导致数据文件丢失。Oracle启动无法找到文件报错 1、进入dba sqlplus / as sysdba 2、启动数据库，并找到有问题的数据文件 startup ORA-01157: cannot identify/lock data file 9 - see DBWR trace file ORA-01110: data file 9: \'/tmp/oradata/xx/rpx.dbf\' 3、启动数据库，无挂载 startup nomount alter database
ORA-01157解决方案.txt
11-18
ORA-01157解决方案
ORA-01654处理表空间不足问题.pdf
06-12
使用过程Oracle 表空间不足时，详细处理办法
oracle报错（ORA-00600）问题处理
09-10
最近在做一个项目，使用的是Oracle数据库，近两天不知道怎么回事，告警日志里总是显示这个错误（ORA-00600:internalerrorcode,arguments:[kcblasm_1],[103],[],[],[],[],[],[]）度娘了一下，终于找到解决方式，分享...
ORA-01157报错"cannot identify/lock data file"
weixin_30615767的博客
06-05 390
sqlplus以管理员方式接入数据库，启动时出现报错，如下： > sqlplus "/as sysdba" SQL> startup ...... ORA-01157: cannot identify/lock data file 8 - see DBWR trace fileORA-01110: data file 8: '/tmp/test.dbf' 查看数据库日志...
【ORACLE】ORA-01157错误解决
Ask Self，Ask Tomorrow
03-02 2813
ORA-01157错误解决(zt) ORA-1157错误解决手册 一．错误描述 ORA-1157, "cannot identify/lock data file %s - see DBWR trace file" 引起的原因： 因为数据文件已经在被使用了从而导致数据库的后台进程不能找到相应的数据文件或者不能锁定相应的数据文件，这样数据库将禁止访问这些数据文件而其他的数据文件则没有影响。伴随这个错
表空间报错ORA-01157,ORA-01110
cmbzwa6940的博客
06-22 836
今天同事添加表空间误将数据文件添加到本地，写成了/oracle/app/oracle/product/11.2.0/db_1/dbs/=DATA，进入到数据中查询表空间的时候报以下错误 ERROR: O...
linux环境下oracle数据库启动报错：ORA-01157，ORA-01110
u014661644的博客
06-08 591
linux环境下oracle数据库启动报错：ORA-01157，ORA-01110
ORA-01157: cannot identify/lock data file 6 - see DBWR trace file
weixin_43475880的博客
12-17 919
转载于：ORA-01157: cannot identify/lock data file 6 - see DBWR trace file ORA-01110: 解决方法 (gxlcms.com) ORA-01157: cannot identify/lock data file 6 - see DBWR trace file ORA-01110: 解决方法 时间：2021-07-01 10:21:17帮助过：217人阅读 SQL> select open_mode from v$data.
ORA-01157&ORA-01110故障解决
06-10
ORA-01157和ORA-01110是Oracle数据库中的两个常见故障，通常与数据文件或表空间有关。下面是它们的解决方法： 1. ORA-01157错误表示无法标识数据库文件。这通常是因为文件已经被删除或移动，或者它所在的磁盘已经...

“相关推荐”对你有帮助么？

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包

打赏作者

DBA狗剩儿

你的鼓励将是我创作的最大动力

¥1 ¥2 ¥4 ¥6 ¥10 ¥20
扫码支付：¥1
获取中
扫码支付

您的余额不足，请更换扫码支付或充值

打赏作者

实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值