>startup

Total System Global Area 3340451840 bytesFixed Size                  2217952 bytesVariable Size            2499807264 bytesDatabase Buffers          822083584 bytesRedo Buffers               16343040 bytesDatabase mounted.ORA-03113: end-of-file on communication channelPRocess ID: 3917session ID: 96 Serial number: 3

解決思路(Oracle11G)：

查看orcle啟動日志，確定具體是什么原因引起的錯誤。

1、確定日志位置

操作日志：$ORACLE_HOME/startup.log

啟動日志：$ORACLE_BASE/diag/rdbms/ora11g/ora11g/trace/alert_ora11g.log (ora11g為SID值)

啟動日志如果查找不到，請到trace目錄下執(zhí)行 ls -alcr | grep alert (c時間排序、r倒序)

2、打開日志

tail -f -n 500 alert_ora11g.log  ，查看錯誤，截取片段如下

=========================================================================

Errors in file /data00/Oracle/app/oracle/diag/rdbms/ora11g/ora11g/trace/ora11g_m000_9340.trc:ORA-19815: WARNING: db_recovery_file_dest_size of 8589934592 bytes is 100.00% used, and has 0 remaining bytes available.************************************************************************You have following choices to free up space from recovery area:1. Consider changing RMAN RETENTION POLICY. If you are using Data Guard,   then consider changing RMAN ARCHIVELOG DELETION POLICY.2. Back up files to tertiary device such as tape using RMAN   BACKUP RECOVERY AREA command.Tue May 03 11:29:14 2011ALTER SYSTEM SET db_recovery_file_dest_size='8G' SCOPE=BOTH;3. Add disk space and increase db_recovery_file_dest_size parameter to   reflect the new space.4. Delete unnecessary files using RMAN DELETE command. If an Operating   system command was used to delete files, then use RMAN CROSSCHECK and   DELETE EXPIRED commands.************************************************************************==============================================================================

原因找到啦，歸檔日志滿了。

4、解決辦法有三個：

1.將歸檔設(shè)置到其他目錄，修改alter system set log_archive_dest = 其他路徑

2.轉(zhuǎn)移或者刪除閃回恢復區(qū)里的歸檔日志。

3.增大閃回恢復區(qū)。alter system set db_recovery_file_dest_size=8G;

5、用其他方式啟動數(shù)據(jù)庫

#sqlplus /nolog

 >conn / as sysdba;

 >shutdown immediate;

 >startup mount;(startup nomount只是啟動了實例而沒有啟動數(shù)據(jù)庫，startup mount啟動了實例，并加載了數(shù)據(jù)庫，但是數(shù)據(jù)庫沒有打開，startup是最全的，實例，數(shù)據(jù)庫加載，數(shù)據(jù)庫打開都完成。)

startup mount我這里可以成功啟動。

 >show parameter db_recovery_file_dest_size //顯示當前回復區(qū)大小

6、具體步驟。舉一個例子，刪除過期日志。

$RMAN

>connect target /

>crosscheck archvelog all;

>delete expired archivelog all;

>exit