老榕树社区

标题: 好險啊！從冷備份恢復後，數據庫不能起來，但是重開幾下就好了！ [打印本页]

作者: nedhljww 时间: 2014-10-5 13:52
标题: 好險啊！從冷備份恢復後，數據庫不能起來，但是重開幾下就好了！
到現在都不知道是什麼問題. 過程如下：把所有文件拷貝回去以後， $sqlplus internal SQL*Plus: Release 8.1.7.0.0 - Production on Wed Dec 22 14:44:01 2004 (c) Copyright 2000 Oracle Corporation. All rights reserved. Connected to: Oracle8i Enterprise Edition Release 8.1.7.4.0 - 64bit Production With the Partitioning option JServer Release 8.1.7.4.0 - 64bit Production SQL> archive log list ORA-00600: internal error code, arguments: [kccchb_1], [3367], [3346], [0], [334 6], [0], [], [] 發現錯誤，於是嚐試關oracle SQL> shutdown immediate ORA-00600: internal error code, arguments: [kccchb_1], [3367], [3346], [0], [334 6], [0], [], [] SQL> startup ORA-01081: cannot start already-running ORACLE - shut it down first SQL> startup ORA-01081: cannot start already-running ORACLE - shut it down first 這下是關又不行，開又不行.(嚐試開數據庫只是隨便試試 ) SQL> shutdown abort ORACLE instance shut down. 這下成功關了 SQL> startup ORACLE instance started. Total System Global Area 252336616 bytes Fixed Size 104936 bytes Variable Size 163094528 bytes Database Buffers 83886080 bytes Redo Buffers 5251072 bytes Database mounted. ORA-01092: ORACLE instance terminated. Disconnection forced 但是開的時候又報上面的錯誤，不能open SQL> archive log list ORA-24323: value not allowed ORA-03114: not connected to ORACLE SQL> exit 退出sqlplus Disconnected from Oracle8i Enterprise Edition Release 8.1.7.4.0 - 64bit Producti on With the Partitioning option JServer Release 8.1.7.4.0 - 64bit Production $sqlplus internal 重新進入sqlplus SQL*Plus: Release 8.1.7.0.0 - Production on Wed Dec 22 14:46:39 2004 (c) Copyright 2000 Oracle Corporation. All rights reserved. Connected to an idle instance. SQL> startup ORACLE instance started. Total System Global Area 252336616 bytes Fixed Size 104936 bytes Variable Size 163094528 bytes Database Buffers 83886080 bytes Redo Buffers 5251072 bytes Database mounted. Database opened. SQL> archive log list Database log mode Archive Mode Automatic archival Enabled Archive destination /oradb4/oradata/whlf/arch/arch Oldest online log sequence 32 Next log sequence to archive 36 Current log sequence 36 SQL> 這下終於成功開oracle了，經過檢查一切正常。事不宜遲，馬上在做一次備份！

欢迎光临老榕树社区 (http://club.lrswl.com/)