Oracle数据库启动时出现ORA-01157和ORA-01110问题
出现问题:
SQL> startup;
ORACLE instance started.
Total System Global Area 2371719168 bytes
Fixed Size 2215624 bytes
Variable Size 1342177592 bytes
Database Buffers 1023410176 bytes
Redo Buffers 3915776 bytes
Database mounted.
ORA-01157: cannot identify/lock data file 6 - see DBWR trace file
ORA-01110: data file 6: '/opt/oracle/oradata/orcl/class="lazy" data-srcmsg.dbf'
解决办法:
1.关库
SQL> shutdown immediate;
- alter database open
ORA-01157: cannot identify/lock data file 10 - see DBWR trace file
ORA-01110: data file 12: '/oradata/orcldata/sacproduce02.dbf'
报错信息为不能进行读写操作,挂载的硬盘不能进行读写操作了。要打开数据库,只能将该文件进行离线操作了。 - SQL> archive log list; //查一下数据库的归档模式,
Database log mode No Archive Mode //非归档模式
Automatic archival Disabled
Archive destination USE_DB_RECOVERY_FILE_DEST
Oldest online log sequence 4
Current log sequence 6
若归档模式下,则:
alter database datafile '/oradata/orcldata/sacproduce02.dbf' offline
非归档模式下(现在情况)
alter database datafile '/oradata/orcldata/sacproduce02.dbf'offline drop
SQL> alter database datafile '/opt/oracle/oradata/orcl/class="lazy" data-srcmsg.dbf' offline drop;
Database altered.
SQL> alter database datafile '/opt/oracle/oradata/orcl/class="lazy" data-srcmsg.dbf' offline;
Database altered.
最后打开数据库就可以了
免责声明:
① 本站未注明“稿件来源”的信息均来自网络整理。其文字、图片和音视频稿件的所属权归原作者所有。本站收集整理出于非商业性的教育和科研之目的,并不意味着本站赞同其观点或证实其内容的真实性。仅作为临时的测试数据,供内部测试之用。本站并未授权任何人以任何方式主动获取本站任何信息。
② 本站未注明“稿件来源”的临时测试数据将在测试完成后最终做删除处理。有问题或投稿请发送至: 邮箱/279061341@qq.com QQ/279061341