oracle数据库无法关闭,当时用shutdown abort关闭后恢复启动命令

我做了个实验,破环了在线当前日志组,实例崩溃。我在网上查了半天,最后决定先退出sqlplus环境再重新启动sqlplus。结果问题解决了。


SQL> startup
ORA-24324: service handle not initialized
ORA-01041: internal error. hostdef extension doesn't exist
SQL> exit
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
[oracle@cuiyan ~]$ sqlplus / as sysdba


SQL*Plus: Release 10.2.0.1.0 - Production on Fri Apr 24 14:58:20 2015


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


Connected to an idle instance.


SQL> startup mount
ORACLE instance started.


Total System Global Area  608174080 bytes
Fixed Size                  1220844 bytes
Variable Size             201330452 bytes
Database Buffers          402653184 bytes
Redo Buffers                2969600 bytes
Database mounted.
SQL> recover database until cancel;
ORA-00279: change 488525 generated at 04/24/2015 12:58:35 needed for thread 1
ORA-00289: suggestion : /home/oracle/arch/1_1_877869001.dbf
ORA-00280: change 488525 for thread 1 is in sequence #1




Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
cancel
Media recovery cancelled.
SQL> alter database open resetlogs;


Database altered.



  • 1
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

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

余额充值