刚接手生产数据库就宕机alert.log
Checkpoint not complete
Current log# 3 seq# 24222 mem# 0: /u01/app/oracle/oradata/scv/redo03.log
Thread 1 advanced to log sequence 24223
Current log# 1 seq# 24223 mem# 0: /u01/app/oracle/oradata/scv/redo01.log
Thread 1 cannot allocate new log, sequence 24224
Checkpoint not complete
Current log# 1 seq# 24223 mem# 0: /u01/app/oracle/oradata/scv/redo01.log
Thread 1 advanced to log sequence 24224
Current log# 2 seq# 24224 mem# 0: /u01/app/oracle/oradata/scv/redo02.log
Thread 1 advanced to log sequence 24225
ERROR:
ORA-00604: error occurred at recursive SQL level 2
ORA-04031: unable to allocate 4200 bytes of shared memory ("shared
pool","TRIGGER$","sga heap","state objects"
ORA-00604: error occurred at recursive SQL level 1
ORA-04031: unable to allocate 4200 bytes of shared memory ("shared
pool","unknown object","sga heap","state objects"
Starting up ORACLE RDBMS Version: 8.1.7.0.1.
System parameters with non-default values:
shared_pool_size = 524288000
large_pool_size = 6144000
java_pool_size = 20971520
db_block_buffers = 69048
db_block_size = 8192
|