"Case" in the process of restarting the database;
Sql> Startup ORACLE instance started. Total System Global area 1.0489E+10 bytes Fixed Size 2216224 bytes Variable Size 1677725408 bytes Database buffers 8791261184 bytes Redo buffers 17842176 bytes Database mounted. Ora-03113:end-of-file on communication channel Process id:29821 Session id:24 Serial Number:3 |
Oracle boot error, specific reason to check the alarm log
2015-09-21 15:30:40.856
SESSION ID: (24.3) 2015-09-21 15:30:40.856
CLIENT ID: () 2015-09-21 15:30:40.856
SERVICE NAME: () 2015-09-21 15:30:40.856
MODULE NAME: ([email protected]_205.easou.com (TNS v1-v3)) 2015-09-21 15:30:40.856
ACTION NAME: () 2015-09-21 15:30:40.856
DDE rules only execution For:ora 312
-----START Event Driven Actions Dump----
----END Event driven Actions Dump----
-----START DDE Actions Dump-----
Executing SYNC actions
-----START DDE Action: ' Db_structure_integrity_check ' (Async)-----
Successfully dispatched
-----END DDE Action: ' Db_structure_integrity_check ' (SUCCESS, 0 CSEC)-----
Executing ASYNC actions
-----END DDE Actions Dump (total 0 CSEC)-----
Dde:problem Key ' ORA 312 ' was flood controlled (0x1) (no incident)
Ora-00312:online Log 1 Thread 1: ' +hz_dg1/hz/onlinelog/group_1.261.787682297 '
Ora-00312:online Log 1 Thread 1: ' +hz_dg1/hz_dg1/onlinelog/group_1.273.788525363 '
Ora-16014:log 1 sequence# 18130 not archived, no available destinations
Ora-00312:online Log 1 Thread 1: ' +hz_dg1/hz/onlinelog/group_1.261.787682297 '
Ora-00312:online Log 1 Thread 1: ' +hz_dg1/hz_dg1/onlinelog/group_1.273.788525363 '
2015-09-21 15:30:40.856 SESSION ID: (24.3) 2015-09-21 15:30:40.856 CLIENT ID: () 2015-09-21 15:30:40.856 SERVICE NAME: () 2015-09-21 15:30:40.856 MODULE NAME: ([email protected]_205.easou.com (TNS v1-v3)) 2015-09-21 15:30:40.856 ACTION NAME: () 2015-09-21 15:30:40.856
DDE rules only execution For:ora 312 -----START Event Driven Actions Dump---- ----END Event driven Actions Dump---- -----START DDE Actions Dump----- Executing SYNC actions -----START DDE Action: ' Db_structure_integrity_check ' (Async)----- Successfully dispatched -----END DDE Action: ' Db_structure_integrity_check ' (SUCCESS, 0 CSEC)----- Executing ASYNC actions -----END DDE Actions Dump (total 0 CSEC)----- Dde:problem Key ' ORA 312 ' was flood controlled (0x1) (no incident) Ora-00312:online Log 1 Thread 1: ' +hz_dg1/hz/onlinelog/group_1.261.787682297 ' Ora-00312:online Log 1 Thread 1: ' +hz_dg1/hz_dg1/onlinelog/group_1.273.788525363 ' Ora-16014:log 1 sequence# 18130 not archived, no available destinations Ora-00312:online Log 1 Thread 1: ' +hz_dg1/hz/onlinelog/group_1.261.787682297 ' Ora-00312:online Log 1 Thread 1: ' +hz_dg1/hz_dg1/onlinelog/group_1.273.788525363 ' |
A problem was found in log Group 1; View data online
sql> shutdown immediate; Ora-01034:oracle Not available Ora-27101:shared Memory realm does not exist linux-x86_64 error:2: No such file or directory Sql> Startup Mount ORACLE instance started. Total System Global area 1.0489E+10 bytes Fixed Size 2216224 bytes Variable Size 1677725408 bytes Database buffers 8791261184 bytes Redo buffers 17842176 bytes Database mounted. Sql> ALTER DATABASE Clear unarchived logfile Group 1; Database altered. sql> shutdown immediate; Ora-01109:database not open Database dismounted. ORACLE instance shut down. Sql> Startup ORACLE instance started. Total System Global area 1.0489E+10 bytes Fixed Size 2216224 bytes Variable Size 1677725408 bytes Database buffers 8791261184 bytes Redo buffers 17842176 bytes Database mounted. Database opened. Sql> exit |
Oracle Launch report ORA-03113;