好險啊！從冷備份恢復後，數據庫不能起來，但是重開幾下就好了！

nedhljww

【如内容违法或虚假，请联系上述邮件删除】到現在都不知道是什麼問題. 過程如下： 把一切文件拷貝回去以後， $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了，經過檢查一切正常。 事不宜遲，馬上在做一次備份！(关注老榕树网络旗下“网络思维”微信公众号:wlsw360 (每天都有好文章)

 

                                                   本帖如有虚假或违法，请联系邮箱删除，本社区删贴不收任何费用，欢迎举报。老榕树社区属老榕树网络旗下网站，旨在为老榕树用户提供创业咨询、网站建设技术交流、源码下载、提供各种实用工具。如有部分帖子涉及违法、虚假，请你第一时间与社区联系，把需要删除的社区链接提供给我们，我们核实之后，第一时间删除。邮箱：125175998@qq.com