백업을 위해서 디비를 내렸다가 서버 리부팅을 했구요.
장애가 발생하고 다음과 같은 로그가 남았습니다.
일단 리커버리는 했는데 무슨 원인으로 장애가 발생했는지를 모르겠습니다.
고수님들의 조언을 부탁드립니다.
Sat Mar 1 12:10:38 2008
Shutting down instance: further logons disabled
Sat Mar 1 12:10:43 2008
Error 2068 trapped in 2PC on transaction 2.0.72012. Cleaning up.
Error stack returned to user:
ORA-02068: following severe error from ACSBU
ORA-01089: immediate shutdown in progress - no operations are permitted
Sat Mar 1 13:55:56 2008
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
SCN scheme 3
LICENSE_MAX_USERS = 0
SYS auditing is disabled
Starting up ORACLE RDBMS Version: 9.2.0.4.0.
System parameters with non-default values:
processes = 800
timed_statistics = TRUE
shared_pool_size = 536870912
large_pool_size = 67108864
control_files = /orapk0/oradata/PK/ctrl01.ctl, /orapk0/oradata/PK/ctrl02.ctl, /orapk0/oradata
/PK/ctrl03.ctl
db_block_size = 8192
db_cache_size = 1056964608
compatible = 9.2.0.0.0
log_archive_start = TRUE
log_archive_dest = /kingarch/PK
log_archive_format = arch_%s.log
log_buffer = 1572864
db_file_multiblock_read_count= 16
fast_start_mttr_target = 300
undo_management = AUTO
undo_tablespace = UNDOTBS1
undo_suppress_errors = TRUE
undo_retention = 10800
remote_login_passwordfile= EXCLUSIVE
db_domain =
instance_name = PK
dispatchers = (PROTOCOL=TCP) (SERVICE=PKXDB)
utl_file_dir = /kingpgm/aitasdw/work/sam
hash_join_enabled = TRUE
background_dump_dest = /orapk0/app/oracle/admin/PK/bdump
user_dump_dest = /orapk0/app/oracle/admin/PK/udump
core_dump_dest = /orapk0/app/oracle/admin/PK/cdump
open_links = 200
open_links_per_instance = 50
sort_area_size = 524288
db_name = PK
open_cursors = 1000
star_transformation_enabled= FALSE
query_rewrite_enabled = FALSE
pga_aggregate_target = 25165824
PMON started with pid=2
DBW0 started with pid=3
LGWR started with pid=4
CKPT started with pid=5
SMON started with pid=6
RECO started with pid=7
Sat Mar 1 13:55:58 2008
starting up 1 shared server(s) ...
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
ARCH: STARTING ARCH PROCESSES
ARC0 started with pid=10
ARC0: Archival started
ARC1 started with pid=11
ARC1: Archival started
Sat Mar 1 13:55:58 2008
ARCH: STARTING ARCH PROCESSES COMPLETE
Sat Mar 1 13:55:58 2008
ARC1: Thread not mounted
Sat Mar 1 13:55:58 2008
ARC0: Thread not mounted
Sat Mar 1 13:55:59 2008
ALTER DATABASE MOUNT
Sat Mar 1 13:56:04 2008
Successful mount of redo thread 1, with mount id 1983032111.
Sat Mar 1 13:56:04 2008
Database mounted in Exclusive Mode.
Completed: ALTER DATABASE MOUNT
Sat Mar 1 13:56:04 2008
ALTER DATABASE OPEN
ORA-1113 signalled during: ALTER DATABASE OPEN...
Shutting down instance: further logons disabled
Shutting down instance (immediate)
License high water mark = 3
Waiting for dispatcher 'D000' to shutdown
All dispatchers and shared servers shutdown
|