Problém 62:
Chybějící redo log skupina.
SQL> startupORACLE instance started.
Total System Global Area 899751936 bytesFixed Size 1348580 bytesVariable Size 570428444 bytesDatabase Buffers 322961408 bytesRedo Buffers 5013504 bytesDatabase mounted.ORA-03113: end-of-file on communication channelProcess ID: 1385Session ID: 1 Serial number: 5
Alert.log
ORA-00313: open failed for members of log group 1 of threadORA-00312: online log 1 thread 1: ‚+DATA/orcl/onlinelog/group_1.265.785676003’ORA-00312: online log 1 thread 1: ‚+FRA/orcl/onlinelog/group_1.257.785676005’USER (ospid: 1545): terminating the instance due to error 313
SQL> select group#,status,archived from v$log;
GROUP# STATUS ARC———- —————- —1 CURRENT NO3 UNUSED YES
2 UNUSED YES
Řešení:
SQL> alter database clear logfile group 1;alter database clear logfile group 1*ERROR at line 1:ORA-00350: log 1 of instance orcl (thread 1) needs to be archivedORA-00312: online log 1 thread 1: ‚+DATA/orcl/onlinelog/group_1.265.785676003’ORA-00312: online log 1 thread 1: ‚+FRA/orcl/onlinelog/group_1.257.785676005‘
SQL> alter database clear unarchived logfile group 1;
Database altered.
SQL> alter database open;
Database altered.