发布网友
共5个回答
懂视网
shutdown abort模式 丢失redo log 无法open数据库 通过告警报错ORA-00354: corrupt redo log block header 从该错误可以看出当前日志的redo block的header出现问题,导致oracle无法读取redo进行恢复。通过以下检查发现数据库文件头都一致,没有需要恢复的文件
shutdown abort模式SYS@orcl11g>alter database open resetlogs; alter database open resetlogs * ERROR at line 1: ORA-01139: RESETLOGS option only valid after an incomplete database recovery SYS@orcl11g>recover database; ORA-00283: recovery session canceled due to errors ORA-00313: open failed for members of log group 3 of thread 1 ORA-00312: online log 3 thread 1: '/opt/oracle/oradata/orcl11g/redo03.log' ORA-27046: file size is not a multiple of logical block size Additional information: 1 SYS@orcl11g>recover database until cancel; ORA-00279: change 5168496 generated at 10/29/2014 23:48:23 needed for thread 1 ORA-002: suggestion : /opt/oracle/flash_recovery_area/ORCL11G/archivelog/2014_10_29/o1_mf_1_159_%u_.arc ORA-00280: change 5168496 for thread 1 is in sequence #159 Specify log: {=suggested | filename | AUTO | CANCEL} ORA-00308: cannot open archived log '/opt/oracle/flash_recovery_area/ORCL11G/archivelog/2014_10_29/o1_mf_1_159_%u_.arc' ORA-27037: unable to obtain file status Linux-x86_ Error: 2: No such file or directory Additional information: 3 ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below ORA-01194: file 1 needs more recovery to be consistent ORA-01110: data file 1: '/opt/oracle/oradata/orcl11g/system01.dbf'
加入以下隐含参数: SYS@orcl11g>show parameter _allow NAME TYPE VALUE ------------------------------------ ---------------------- ------------------------------ _allow_error_simulation boolean TRUE _allow_resetlogs_corruption boolean TRUE这时候发现数据库时可以打开的
SYS@orcl11g> SYS@orcl11g> SYS@orcl11g>alter database open resetlogs; Database altered. SYS@orcl11g> 发现日志文件已经被重建: SYS@orcl11g>select group#,status from v$log; GROUP# STATUS ---------- ------------------------------------------------------------ 1 CURRENT 2 UNUSED 3 UNUSED SYS@orcl11g>alter system switch logfile; System altered. SYS@orcl11g>/ System altered. SYS@orcl11g>/ System altered. SYS@orcl11g>select group#,status from v$log; GROUP# STATUS ---------- ------------------------------------------------------------ 1 CURRENT 2 INACTIVE 3 ACTIVE
热心网友
shutdown的意思是:停业; 停工; 关闭; 倒闭; 停止运转,还以一种计算机系统关机命令。
例句:The shutdown is the latest in a series of painful budget measures。
翻译:此次关闭是一系列艰难预算措施中最新实施的一项。
Windows 系统自带一个名为Shutdown.exe的程序,可以用于关机操作。一般情况下Windows系统的关机都可以通过调用程序 shutdown.exe来实现的,同时该程序也可以用于终止正在计划中的关机操作。
shutdown操作命令详解:
1、shutdown-a 取消关机。
2、shutdown -s 关机。
3、shutdown -f 强行关闭应用程序。
4、shutdown -m 计算机名 控制远程计算机。
5、shutdown -i 显示“远程关机”图形用户界面,但必须是Shutdown的第一个参数。
扩展资料:
shutdown近义词:
1、closure(关闭) :
例句:The strike forced the closure of the factory.
翻译:罢工迫使该厂关闭。
2、cessation(终止 ):
例句:Death is simply the cessation of the dream in total.
翻译:死亡只是全数梦想的停止
3、closedown (倒闭):
例句:We would be known, How to make a sudden decision of closedown Qing Homedepot?
翻译:我们想知道,关闭青岛店的决定是如何做出的?
4、end (结束) :
例句:The battle finally brought the war to an end.
翻译:这一仗使这场战争终告结束。
参考资料来源:百度百科-shutdown
热心网友
full-shutdown
全部关闭
shutdown
[英][ˈʌtdaʊn][美][ˈʌtˌdaʊn]
n.关闭,倒闭; 关机; 停工,停业; 停播;
复数:shutdowns
例句:
1.
Could a similar internet shutdown take place in the united states?
美国是否也可能发生类似的互联网关闭事件呢?
热心网友
shutdown ['ʌtdaun]
n. 关门, 停工, 关机
Unable to abort the system shutdown because no shutdown was in progress.
因为没有任何进行中的关机过程,所以无法中断系统关机。
You must shutdown and restart the computer before changes take effect. Shutdown now?
在改动生效之前,您必须关闭并重启动计算机。现在要关闭吗?
"You must shutdown and restart the computer before changes take effect. Shutdown now?
"在改动生效之前,您必须关闭并重启动计算机。现在要关闭吗?
热心网友
终结。