지금 제가 투입되었던 사이트의 구축된 DB가 Startup한 후 3일이 지나면 자꾸 Down됩니다......T.T 현재 원인이 무엇인지를 자알 모르겠구요...... Alert Log 파일을 보면 ======내용=============================================== Thread 1 advanced to log sequence 559249 Current log# 14 seq# 559249 mem# 0: /RBS/oradata/OR8I/log14.ora Thread 1 advanced to log sequence 559250 Current log# 15 seq# 559250 mem# 0: /RBS/oradata/OR8I/log15.ora Fri Jan 18 03:26:45 2002 Thread 1 advanced to log sequence 559251 Current log# 9 seq# 559251 mem# 0: /RBS/oradata/OR8I/log9.ora Fri Jan 18 03:27:28 2002 DBW0: terminating instance due to error 27061 <= 이때죽은것같은데 Instance terminated by DBW0, pid = 24414 Fri Jan 18 10:42:01 2002 Starting ORACLE instance (normal) LICENSE_MAX_SESSION = 0 LICENSE_SESSIONS_WARNING = 0 LICENSE_MAX_USERS = 0 Starting up ORACLE RDBMS Version: 8.1.7.0.0. System parameters with non-default values: processes = 150 shared_pool_size = 800000000 large_pool_size = 614400 java_pool_size = 20971520 control_files = /RBS/oradata/OR8I/control01.ctl, /RBS/oradata/OR8I/control02.ctl, /RBS/oradata/OR8I/control03.ctl db_block_buffers = 80000 db_block_size = 8192 compatible = 8.1.0 log_buffer = 20480000 log_checkpoint_interval = 10000000 log_checkpoint_timeout = 1800 max_enabled_roles = 30 remote_login_passwordfile= EXCLUSIVE distributed_transactions = 10 instance_name = OR8I service_names = OR8I mts_dispatchers = (PROTOCOL=TCP)(PRE=oracle.aurora.server.SGiopServer) open_links = 4 sort_area_size = 2048000 sort_area_retained_size = 2048000 db_name = OR8I open_cursors = 300 os_authent_prefix = utl_file_dir = /work/db_back job_queue_processes = 4 job_queue_interval = 60 parallel_max_servers = 32 background_dump_dest = /oracle/app/oracle/admin/OR8I/bdump user_dump_dest = /oracle/app/oracle/admin/OR8I/udump max_dump_file_size = 10240000 core_dump_dest = /oracle/app/oracle/admin/OR8I/cdump ========================================================== 위와 같은 Log가 쌓여 있습니다.......^^;;; 하옇든 원인은 DBWO(백업프로세스)에서 문제가 있는것 같은데.. 그리고 다음 라인에 보면 PID가 24414로 되어 있어 확인해 본결과 아래와 같은 세션정보가 있습니다. ========================================================== oracle 24414 1 0 10:18:41 - 0:00 ora_dbw0_OR8I ========================================================== 하옇든 도와주십시요....^^ 그럼 자세한 내역이 필요하시면 메일로 보내시면 보내주겠습니다.. 그럼 수고들 하십시요,,,,^^