alter.log
QMNC started with pid=17, OS id=29541
Mon Dec 14 19:22:14 2009
Errors in file /oracle/10g/admin/orcl/udump/orcl_ora_29537.trc:
ORA-00604: ȯ SQL 1 ߽ϴ
ORA-12663: Ŭ̾Ʈ û ϴ
ORA-36961: Oracle OLAP ϴ.
ORA-06512: "SYS.OLAPIHISTORYRETENTION", 1
ORA-06512: 15
Mon Dec 14 19:22:14 2009
db_recovery_file_dest_size of 2048 MB is 0.00% used. This is a
user-specified limit on the amount of space that will be used by this
database for recovery-related files, and does not reflect the amount of
space available in the underlying filesystem or ASM diskgroup.
Mon Dec 14 19:22:14 2009
Completed: ALTER DATABASE OPEN
============================================================
SQL> startup
ORACLE νϽ ۵Ǿϴ.
Total System Global Area 2147483648 bytes
Fixed Size 1268508 bytes
Variable Size 503317732 bytes
Database Buffers 1627389952 bytes
Redo Buffers 15507456 bytes
ͺ̽ ƮǾϴ.
ͺ̽ Ƚϴ.
SQL> ALTER TRIGGER OLAPISTARTUPTRIGGER DISABLE; =>
ƮŰ Ǿϴ.
SQL> ALTER TRIGGER OLAPISHUTDOWNTRIGGER DISABLE; =>
ƮŰ Ǿϴ.
SQL> shutdown immediate;
ͺ̽ ϴ.
ͺ̽ Ʈ Ǿϴ.
ORACLE νϽ Ǿϴ.
SQL> startup
ORACLE νϽ ۵Ǿϴ.
Total System Global Area 2147483648 bytes
Fixed Size 1268508 bytes
Variable Size 503317732 bytes
Database Buffers 1627389952 bytes
Redo Buffers 15507456 bytes
ͺ̽ ƮǾϴ.
ͺ̽ Ƚϴ.
SQL>
===========================================================
alter.log
Tue Dec 15 08:11:18 2009
Thread 1 opened at log sequence 27
Current log# 2 seq# 27 mem# 0: /oradata/orcl/redo02.log
Successful open of redo thread 1
Tue Dec 15 08:11:18 2009
SMON: enabling cache recovery
Tue Dec 15 08:11:18 2009
Successfully onlined Undo Tablespace 1.
Tue Dec 15 08:11:18 2009
SMON: enabling tx recovery
Tue Dec 15 08:11:18 2009
Database Characterset is KO16KSC5601
replication_dependency_tracking turned off (no async multimaster replication found)
Starting background process QMNC
QMNC started with pid=16, OS id=29461
Tue Dec 15 08:11:19 2009
Completed: ALTER DATABASE OPEN
Tue Dec 15 08:11:19 2009