Primarydb: 9.2.0.1
standbydb:9.2.0.8
在standbydb中alert.log文件中出現大量的Restarting dead background process QMNn 信息
解決方案：
standbydb:
1、shutdown immediate
2、STARTUP NOMOUNT
3、ALTER DATABASE MOUNT STANDBY DATABASE;
4、ALTER DATABASE OPEN READ ONLY;
5、ALTER SYSTEM SET AQ_MT_PROCESSES=0;
6、RECOVER MANAGED STANDBY DATABASE DISCONNECT FROM SESSION;
##############################################################使数据库切换到恢复模式 recover managed standby database time out 15; ; P1 P! M6 ]- a
$ I" A3 W5 o8 R& {- Q- R3 b
4 G$ c4 W& e! z Y& w% _8 |1 H
: x$ h+ M0 l: |
如果超过15分钟没有传日志 Restarting dead background process QMN0 }1 y; p7 }8 P% i( ~+ S
"Restarting dead background process QMN" message can continually
Mappear in the alert log during startup in RAC environment. 4 Y2 G" _* U# X
4 I3 j0 ^- S* U8 _- H6 @
- a1 S: P! b9 }+ G, a8 G" v
Workaround:
Set aq_tm_processes=0 in the init.ora. + q/ Y8 ]$ h8 e
5 @! O' a i) J! v: s+ p H- g& U
It can be set to desired value through 4 R& r& J7 a% H
"alter system set aq_tm_processes=n" once the database is open completely. - O) Z' ]- i! a) l" W& p
; P2 X1 M6 Y4 u! @# i9 }) e" J7 S
9 N# [+ @ o3 A3 o% Q
alter database activate standby database;
$ I" A3 W5 o8 R& {- Q- R3 b
4 G$ c4 W& e! z Y& w% _8 |1 H
: x$ h+ M0 l: |
如果超过15分钟没有传日志 Restarting dead background process QMN0 }1 y; p7 }8 P% i( ~+ S
"Restarting dead background process QMN" message can continually
Mappear in the alert log during startup in RAC environment. 4 Y2 G" _* U# X
4 I3 j0 ^- S* U8 _- H6 @
- a1 S: P! b9 }+ G, a8 G" v
Workaround:
Set aq_tm_processes=0 in the init.ora. + q/ Y8 ]$ h8 e
5 @! O' a i) J! v: s+ p H- g& U
It can be set to desired value through 4 R& r& J7 a% H
"alter system set aq_tm_processes=n" once the database is open completely. - O) Z' ]- i! a) l" W& p
; P2 X1 M6 Y4 u! @# i9 }) e" J7 S
9 N# [+ @ o3 A3 o% Q
alter database activate standby database;
##############################################################
Tue Dec 11 15:47:55 2012
kccrsz: expanded controlfile section 11 from 55 to 69 records
requested to grow by 6 record(s); added 1 block(s) of records
Tue Dec 11 15:48:03 2012
Media Recovery Log D:\ORACLE\ORADATA\AGILE9\ARCHIVE\ARCHIVE_1_509.DBF
Media Recovery Log D:\ORACLE\ORADATA\AGILE9\ARCHIVE\ARCHIVE_1_510.DBF
Media Recovery Log D:\ORACLE\ORADATA\AGILE9\ARCHIVE\ARCHIVE_1_511.DBF
Media Recovery Log D:\ORACLE\ORADATA\AGILE9\ARCHIVE\ARCHIVE_1_512.DBF
Media Recovery Log D:\ORACLE\ORADATA\AGILE9\ARCHIVE\ARCHIVE_1_513.DBF
Media Recovery Waiting for thread 1 seq# 514
Tue Dec 11 15:48:54 2012
ALTER SYSTEM SET control_file_record_keep_time=15 SCOPE=BOTH;
Tue Dec 11 15:51:27 2012
Restarting dead background process QMN0
QMN0 started with pid=9, OS id=3620
Tue Dec 11 15:51:27 2012
Restarting dead background process QMN1
QMN1 started with pid=10, OS id=1448
Tue Dec 11 15:51:28 2012
Restarting dead background process QMN2
QMN2 started with pid=11, OS id=3848
Tue Dec 11 15:51:28 2012
Restarting dead background process QMN3
QMN3 started with pid=12, OS id=3356
Tue Dec 11 15:51:28 2012
Restarting dead background process QMN4
QMN4 started with pid=13, OS id=3872
Tue Dec 11 15:51:29 2012
Restarting dead background process QMN5
QMN5 started with pid=14, OS id=1736
Tue Dec 11 15:51:29 2012
Restarting dead background process QMN6
QMN6 started with pid=15, OS id=3012
Tue Dec 11 15:51:29 2012
Restarting dead background process QMN7
QMN7 started with pid=16, OS id=1436
Tue Dec 11 15:51:30 2012
Restarting dead background process QMN8
QMN8 started with pid=17, OS id=3784
Tue Dec 11 15:51:30 2012
Restarting dead background process QMN9
QMN9 started with pid=18, OS id=996
Tue Dec 11 15:56:30 2012
Restarting dead background process QMN0
QMN0 started with pid=9, OS id=1664
Tue Dec 11 15:56:30 2012
Restarting dead background process QMN1
QMN1 started with pid=10, OS id=2264
Tue Dec 11 15:56:31 2012
Restarting dead background process QMN2
QMN2 started with pid=11, OS id=2768
Tue Dec 11 15:56:31 2012
Restarting dead background process QMN3
QMN3 started with pid=12, OS id=3928
Tue Dec 11 15:56:31 2012
Restarting dead background process QMN4
QMN4 started with pid=13, OS id=2456
Tue Dec 11 15:56:32 2012
Restarting dead background process QMN5
QMN5 started with pid=14, OS id=764
Tue Dec 11 15:56:32 2012
Restarting dead background process QMN6
QMN6 started with pid=15, OS id=3516
Tue Dec 11 15:56:32 2012
Restarting dead background process QMN7
QMN7 started with pid=16, OS id=2216
Tue Dec 11 15:56:33 2012
Restarting dead background process QMN8
QMN8 started with pid=17, OS id=352
Tue Dec 11 15:56:33 2012
Restarting dead background process QMN9
QMN9 started with pid=18, OS id=3468
Tue Dec 11 16:01:33 2012
Restarting dead background process QMN0
QMN0 started with pid=9, OS id=3764
Tue Dec 11 16:01:33 2012
Restarting dead background process QMN1
QMN1 started with pid=10, OS id=3700
Tue Dec 11 16:01:34 2012
Restarting dead background process QMN2
QMN2 started with pid=11, OS id=3696
Tue Dec 11 16:01:34 2012
Restarting dead background process QMN3
QMN3 started with pid=12, OS id=1612
Tue Dec 11 16:01:34 2012
Restarting dead background process QMN4
QMN4 started with pid=13, OS id=3300
Tue Dec 11 16:01:35 2012
Restarting dead background process QMN5
QMN5 started with pid=14, OS id=3648
Tue Dec 11 16:01:35 2012
Restarting dead background process QMN6
QMN6 started with pid=15, OS id=3836
Tue Dec 11 16:01:35 2012
Restarting dead background process QMN7
QMN7 started with pid=16, OS id=3716
Tue Dec 11 16:01:36 2012
Restarting dead background process QMN8
QMN8 started with pid=17, OS id=4060
Tue Dec 11 16:01:36 2012
Restarting dead background process QMN9
QMN9 started with pid=18, OS id=2968
Tue Dec 11 16:05:33 2012
Shutting down instance: further logons disabled
Tue Dec 11 16:05:39 2012
MRP0: Background Media Recovery user canceled with status 16037
Recovery interrupted.
MRP0: Background Media Recovery process shutdown
Tue Dec 11 16:05:40 2012
Shutting down instance (immediate)
License high water mark = 14
Tue Dec 11 16:05:46 2012
ALTER DATABASE CLOSE NORMAL
ORA-1109 signalled during: ALTER DATABASE CLOSE NORMAL...
Tue Dec 11 16:05:46 2012
ALTER DATABASE DISMOUNT
Completed: ALTER DATABASE DISMOUNT
ARCH: Archiving is disabled
Shutting down archive processes
Archiving is disabled
Tue Dec 11 16:05:48 2012
ARCH shutting down
Tue Dec 11 16:05:48 2012
ARC0: Archival stopped
Tue Dec 11 16:05:49 2012
ARCH shutting down
Tue Dec 11 16:05:49 2012
ARC1: Archival stopped
Tue Dec 11 16:05:52 2012
ARCH: Archiving is disabled
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
Tue Dec 11 16:07:23 2012
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
SCN scheme 2
Using log_archive_dest parameter default value
LICENSE_MAX_USERS = 0
SYS auditing is disabled
Starting up ORACLE RDBMS Version: 9.2.0.8.0.
System parameters with non-default values:
processes = 250
timed_statistics = TRUE
shared_pool_size = 402653184
shared_pool_reserved_size= 30000000
large_pool_size = 58720256
java_pool_size = 150994944
pre_page_sga = TRUE
nls_length_semantics = CHAR
control_files = D:\oracle\oradata\agile9\CONTROL01.CTL, D:\oracle\oradata\agile9\CONTROL02.CTL, D:\oracle\oradata\agile9\CONTROL03.CTL
db_block_size = 8192
db_cache_size = 1233125376
compatible = 9.2.0.1
log_archive_start = TRUE
log_archive_dest_1 = LOCATION=D:\oracle\oradata\agile9\archive\
log_archive_dest_state_1 = ENABLE
log_archive_dest_state_2 = ENABLE
standby_archive_dest = D:\oracle\oradata\agile9\archive\
log_archive_format = archive_%t_%s.dbf
log_buffer = 1824768
log_checkpoint_interval = 0
log_checkpoint_timeout = 1800
db_files = 254
db_file_multiblock_read_count= 8
standby_file_management = auto
fast_start_mttr_target = 300
control_file_record_keep_time= 15
dml_locks = 1000
undo_management = AUTO
undo_tablespace = UNDOTBS1
undo_retention = 10800
max_enabled_roles = 40
remote_login_passwordfile= EXCLUSIVE
global_names = TRUE
instance_name = agile9
job_queue_processes = 10
parallel_max_servers = 5
background_dump_dest = D:\oracle\admin\agile9\bdump
user_dump_dest = D:\oracle\admin\agile9\udump
max_dump_file_size = 10240
oracle_trace_collection_name=
optimizer_features_enable= 9.2.0
sort_area_size = 20145728
sort_area_retained_size = 0
db_name = agile9
open_cursors = 500
sql_trace = FALSE
os_authent_prefix =
optimizer_mode = CHOOSE
_no_or_expansion = TRUE
optimizer_index_cost_adj = 50
_cost_equality_semi_join = FALSE
pga_aggregate_target = 400000000
aq_tm_processes = 10
PMON started with pid=2, OS id=3048
DBW0 started with pid=3, OS id=3380
LGWR started with pid=4, OS id=2232
CKPT started with pid=5, OS id=4052
SMON started with pid=6, OS id=3288
RECO started with pid=7, OS id=1044
CJQ0 started with pid=8, OS id=3472
QMN0 started with pid=9, OS id=220
QMN1 started with pid=10, OS id=3840
QMN2 started with pid=11, OS id=2744
QMN3 started with pid=12, OS id=3956
QMN4 started with pid=13, OS id=688
QMN5 started with pid=14, OS id=3660
QMN6 started with pid=15, OS id=944
QMN7 started with pid=16, OS id=3392
QMN8 started with pid=17, OS id=792
QMN9 started with pid=18, OS id=3324
Tue Dec 11 16:07:29 2012
ARCH: STARTING ARCH PROCESSES
ARC0 started with pid=19, OS id=800
ARC0: Archival started
ARC1 started with pid=20, OS id=3672
Tue Dec 11 16:07:29 2012
ARCH: STARTING ARCH PROCESSES COMPLETE
Tue Dec 11 16:07:29 2012
ARC0: Becoming the 'no FAL' ARCH
ARC0: Becoming the 'no FAL' ARCHARC0: Thread not mounted
Tue Dec 11 16:07:30 2012
ARC1: Archival started
Tue Dec 11 16:07:30 2012
ARC1: Becoming the heartbeat ARCH
ARC1: Becoming the heartbeat ARCHARC1: Thread not mounted
Tue Dec 11 16:08:29 2012
ARC1: Thread not mounted
Tue Dec 11 16:09:29 2012
ARC1: Thread not mounted
Tue Dec 11 16:10:16 2012
alter database mount standby database
Tue Dec 11 16:10:20 2012
Successful mount of redo thread 1, with mount id 580630056
Tue Dec 11 16:10:20 2012
Standby Database mounted.
Completed: alter database mount standby database
Tue Dec 11 16:10:28 2012
alter database open read only
Tue Dec 11 16:10:28 2012
SMON: enabling cache recovery
Tue Dec 11 16:10:28 2012
Database Characterset is UTF8
replication_dependency_tracking turned off (no async multimaster replication found)
Completed: alter database open read only
Tue Dec 11 16:10:36 2012
***Warning - Executing transaction without active Undo Tablespace
Tue Dec 11 16:10:36 2012
***Warning - Executing transaction without active Undo Tablespace
Tue Dec 11 16:10:37 2012
***Warning - Executing transaction without active Undo Tablespace
Tue Dec 11 16:10:37 2012
***Warning - Executing transaction without active Undo Tablespace
Tue Dec 11 16:10:37 2012
***Warning - Executing transaction without active Undo Tablespace
Tue Dec 11 16:10:38 2012
***Warning - Executing transaction without active Undo Tablespace
Tue Dec 11 16:10:38 2012
***Warning - Executing transaction without active Undo Tablespace
Tue Dec 11 16:10:38 2012
***Warning - Executing transaction without active Undo Tablespace
Tue Dec 11 16:10:39 2012
***Warning - Executing transaction without active Undo Tablespace
Tue Dec 11 16:10:39 2012
Restarting dead background process QMN0
QMN0 started with pid=9, OS id=4048
Tue Dec 11 16:10:39 2012
Restarting dead background process QMN1
QMN1 started with pid=10, OS id=684
Tue Dec 11 16:10:39 2012
Restarting dead background process QMN2
QMN2 started with pid=11, OS id=1616
Tue Dec 11 16:10:40 2012
Restarting dead background process QMN3
QMN3 started with pid=12, OS id=1464
Tue Dec 11 16:10:40 2012
Restarting dead background process QMN4
QMN4 started with pid=13, OS id=2328
Tue Dec 11 16:10:40 2012
Restarting dead background process QMN5
QMN5 started with pid=14, OS id=2376
Tue Dec 11 16:10:41 2012
Restarting dead background process QMN6
QMN6 started with pid=15, OS id=1092
Tue Dec 11 16:10:41 2012
Restarting dead background process QMN7
QMN7 started with pid=16, OS id=3236
Tue Dec 11 16:10:41 2012
Restarting dead background process QMN8
QMN8 started with pid=17, OS id=2272
Tue Dec 11 16:10:42 2012
Restarting dead background process QMN9
QMN9 started with pid=18, OS id=1584
Tue Dec 11 16:10:49 2012
***Warning - Executing transaction without active Undo Tablespace
Tue Dec 11 16:10:49 2012
***Warning - Executing transaction without active Undo Tablespace
Tue Dec 11 16:10:49 2012
***Warning - Executing transaction without active Undo Tablespace
Tue Dec 11 16:10:50 2012
***Warning - Executing transaction without active Undo Tablespace
Tue Dec 11 16:10:50 2012
***Warning - Executing transaction without active Undo Tablespace
Tue Dec 11 16:10:50 2012
***Warning - Executing transaction without active Undo Tablespace
Tue Dec 11 16:10:51 2012
***Warning - Executing transaction without active Undo Tablespace
Tue Dec 11 16:10:51 2012
***Warning - Executing transaction without active Undo Tablespace
Tue Dec 11 16:10:51 2012
***Warning - Executing transaction without active Undo Tablespace
Tue Dec 11 16:10:52 2012
***Warning - Executing transaction without active Undo Tablespace
Tue Dec 11 16:11:20 2012
ALTER SYSTEM SET aq_tm_processes=0 SCOPE=BOTH;
Tue Dec 11 16:11:30 2012
ALTER DATABASE RECOVER standby database
Tue Dec 11 16:11:30 2012
Active process 3472 user 'dbadmin' program 'ORACLE.EXE'
CLOSE: waiting for server sessions to complete.
CLOSE: all sessions shutdown successfully.
Tue Dec 11 16:11:31 2012
SMON: disabling cache recovery
Tue Dec 11 16:11:31 2012
Media Recovery Start
ORA-279 signalled during: ALTER DATABASE RECOVER standby database ...
Tue Dec 11 16:11:36 2012
ALTER DATABASE RECOVER CONTINUE DEFAULT
Tue Dec 11 16:11:36 2012
Media Recovery Log D:\ORACLE\ORADATA\AGILE9\ARCHIVE\ARCHIVE_1_514.DBF
Errors with log D:\ORACLE\ORADATA\AGILE9\ARCHIVE\ARCHIVE_1_514.DBF
ORA-308 signalled during: ALTER DATABASE RECOVER CONTINUE DEFAULT ...
Tue Dec 11 16:11:36 2012
ALTER DATABASE RECOVER CONTINUE DEFAULT
Tue Dec 11 16:11:36 2012
Media Recovery Log D:\ORACLE\ORADATA\AGILE9\ARCHIVE\ARCHIVE_1_514.DBF
Errors with log D:\ORACLE\ORADATA\AGILE9\ARCHIVE\ARCHIVE_1_514.DBF
ORA-308 signalled during: ALTER DATABASE RECOVER CONTINUE DEFAULT ...
Tue Dec 11 16:11:36 2012
ALTER DATABASE RECOVER CANCEL
Tue Dec 11 16:11:36 2012
Media Recovery Cancelled
Completed: ALTER DATABASE RECOVER CANCEL
Tue Dec 11 16:12:02 2012
ALTER DATABASE RECOVER managed standby database disconnect from session
Attempt to start background Managed Standby Recovery process
MRP0 started with pid=8, OS id=2804
MRP0: Background Managed Standby Recovery process started
Media Recovery Waiting for thread 1 seq# 514
Tue Dec 11 16:12:07 2012
Completed: ALTER DATABASE RECOVER managed standby database d
Tue Dec 11 16:13:22 2012
Media Recovery Log D:\ORACLE\ORADATA\AGILE9\ARCHIVE\ARCHIVE_1_514.DBF
Media Recovery Log D:\ORACLE\ORADATA\AGILE9\ARCHIVE\ARCHIVE_1_515.DBF
Media Recovery Log D:\ORACLE\ORADATA\AGILE9\ARCHIVE\ARCHIVE_1_516.DBF
Media Recovery Log D:\ORACLE\ORADATA\AGILE9\ARCHIVE\ARCHIVE_1_517.DBF
Media Recovery Log D:\ORACLE\ORADATA\AGILE9\ARCHIVE\ARCHIVE_1_518.DBF
Media Recovery Log D:\ORACLE\ORADATA\AGILE9\ARCHIVE\ARCHIVE_1_519.DBF
Media Recovery Log D:\ORACLE\ORADATA\AGILE9\ARCHIVE\ARCHIVE_1_520.DBF
Media Recovery Waiting for thread 1 seq# 521
kccrsz: expanded controlfile section 11 from 55 to 69 records
requested to grow by 6 record(s); added 1 block(s) of records
Tue Dec 11 15:48:03 2012
Media Recovery Log D:\ORACLE\ORADATA\AGILE9\ARCHIVE\ARCHIVE_1_509.DBF
Media Recovery Log D:\ORACLE\ORADATA\AGILE9\ARCHIVE\ARCHIVE_1_510.DBF
Media Recovery Log D:\ORACLE\ORADATA\AGILE9\ARCHIVE\ARCHIVE_1_511.DBF
Media Recovery Log D:\ORACLE\ORADATA\AGILE9\ARCHIVE\ARCHIVE_1_512.DBF
Media Recovery Log D:\ORACLE\ORADATA\AGILE9\ARCHIVE\ARCHIVE_1_513.DBF
Media Recovery Waiting for thread 1 seq# 514
Tue Dec 11 15:48:54 2012
ALTER SYSTEM SET control_file_record_keep_time=15 SCOPE=BOTH;
Tue Dec 11 15:51:27 2012
Restarting dead background process QMN0
QMN0 started with pid=9, OS id=3620
Tue Dec 11 15:51:27 2012
Restarting dead background process QMN1
QMN1 started with pid=10, OS id=1448
Tue Dec 11 15:51:28 2012
Restarting dead background process QMN2
QMN2 started with pid=11, OS id=3848
Tue Dec 11 15:51:28 2012
Restarting dead background process QMN3
QMN3 started with pid=12, OS id=3356
Tue Dec 11 15:51:28 2012
Restarting dead background process QMN4
QMN4 started with pid=13, OS id=3872
Tue Dec 11 15:51:29 2012
Restarting dead background process QMN5
QMN5 started with pid=14, OS id=1736
Tue Dec 11 15:51:29 2012
Restarting dead background process QMN6
QMN6 started with pid=15, OS id=3012
Tue Dec 11 15:51:29 2012
Restarting dead background process QMN7
QMN7 started with pid=16, OS id=1436
Tue Dec 11 15:51:30 2012
Restarting dead background process QMN8
QMN8 started with pid=17, OS id=3784
Tue Dec 11 15:51:30 2012
Restarting dead background process QMN9
QMN9 started with pid=18, OS id=996
Tue Dec 11 15:56:30 2012
Restarting dead background process QMN0
QMN0 started with pid=9, OS id=1664
Tue Dec 11 15:56:30 2012
Restarting dead background process QMN1
QMN1 started with pid=10, OS id=2264
Tue Dec 11 15:56:31 2012
Restarting dead background process QMN2
QMN2 started with pid=11, OS id=2768
Tue Dec 11 15:56:31 2012
Restarting dead background process QMN3
QMN3 started with pid=12, OS id=3928
Tue Dec 11 15:56:31 2012
Restarting dead background process QMN4
QMN4 started with pid=13, OS id=2456
Tue Dec 11 15:56:32 2012
Restarting dead background process QMN5
QMN5 started with pid=14, OS id=764
Tue Dec 11 15:56:32 2012
Restarting dead background process QMN6
QMN6 started with pid=15, OS id=3516
Tue Dec 11 15:56:32 2012
Restarting dead background process QMN7
QMN7 started with pid=16, OS id=2216
Tue Dec 11 15:56:33 2012
Restarting dead background process QMN8
QMN8 started with pid=17, OS id=352
Tue Dec 11 15:56:33 2012
Restarting dead background process QMN9
QMN9 started with pid=18, OS id=3468
Tue Dec 11 16:01:33 2012
Restarting dead background process QMN0
QMN0 started with pid=9, OS id=3764
Tue Dec 11 16:01:33 2012
Restarting dead background process QMN1
QMN1 started with pid=10, OS id=3700
Tue Dec 11 16:01:34 2012
Restarting dead background process QMN2
QMN2 started with pid=11, OS id=3696
Tue Dec 11 16:01:34 2012
Restarting dead background process QMN3
QMN3 started with pid=12, OS id=1612
Tue Dec 11 16:01:34 2012
Restarting dead background process QMN4
QMN4 started with pid=13, OS id=3300
Tue Dec 11 16:01:35 2012
Restarting dead background process QMN5
QMN5 started with pid=14, OS id=3648
Tue Dec 11 16:01:35 2012
Restarting dead background process QMN6
QMN6 started with pid=15, OS id=3836
Tue Dec 11 16:01:35 2012
Restarting dead background process QMN7
QMN7 started with pid=16, OS id=3716
Tue Dec 11 16:01:36 2012
Restarting dead background process QMN8
QMN8 started with pid=17, OS id=4060
Tue Dec 11 16:01:36 2012
Restarting dead background process QMN9
QMN9 started with pid=18, OS id=2968
Tue Dec 11 16:05:33 2012
Shutting down instance: further logons disabled
Tue Dec 11 16:05:39 2012
MRP0: Background Media Recovery user canceled with status 16037
Recovery interrupted.
MRP0: Background Media Recovery process shutdown
Tue Dec 11 16:05:40 2012
Shutting down instance (immediate)
License high water mark = 14
Tue Dec 11 16:05:46 2012
ALTER DATABASE CLOSE NORMAL
ORA-1109 signalled during: ALTER DATABASE CLOSE NORMAL...
Tue Dec 11 16:05:46 2012
ALTER DATABASE DISMOUNT
Completed: ALTER DATABASE DISMOUNT
ARCH: Archiving is disabled
Shutting down archive processes
Archiving is disabled
Tue Dec 11 16:05:48 2012
ARCH shutting down
Tue Dec 11 16:05:48 2012
ARC0: Archival stopped
Tue Dec 11 16:05:49 2012
ARCH shutting down
Tue Dec 11 16:05:49 2012
ARC1: Archival stopped
Tue Dec 11 16:05:52 2012
ARCH: Archiving is disabled
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
Tue Dec 11 16:07:23 2012
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
SCN scheme 2
Using log_archive_dest parameter default value
LICENSE_MAX_USERS = 0
SYS auditing is disabled
Starting up ORACLE RDBMS Version: 9.2.0.8.0.
System parameters with non-default values:
processes = 250
timed_statistics = TRUE
shared_pool_size = 402653184
shared_pool_reserved_size= 30000000
large_pool_size = 58720256
java_pool_size = 150994944
pre_page_sga = TRUE
nls_length_semantics = CHAR
control_files = D:\oracle\oradata\agile9\CONTROL01.CTL, D:\oracle\oradata\agile9\CONTROL02.CTL, D:\oracle\oradata\agile9\CONTROL03.CTL
db_block_size = 8192
db_cache_size = 1233125376
compatible = 9.2.0.1
log_archive_start = TRUE
log_archive_dest_1 = LOCATION=D:\oracle\oradata\agile9\archive\
log_archive_dest_state_1 = ENABLE
log_archive_dest_state_2 = ENABLE
standby_archive_dest = D:\oracle\oradata\agile9\archive\
log_archive_format = archive_%t_%s.dbf
log_buffer = 1824768
log_checkpoint_interval = 0
log_checkpoint_timeout = 1800
db_files = 254
db_file_multiblock_read_count= 8
standby_file_management = auto
fast_start_mttr_target = 300
control_file_record_keep_time= 15
dml_locks = 1000
undo_management = AUTO
undo_tablespace = UNDOTBS1
undo_retention = 10800
max_enabled_roles = 40
remote_login_passwordfile= EXCLUSIVE
global_names = TRUE
instance_name = agile9
job_queue_processes = 10
parallel_max_servers = 5
background_dump_dest = D:\oracle\admin\agile9\bdump
user_dump_dest = D:\oracle\admin\agile9\udump
max_dump_file_size = 10240
oracle_trace_collection_name=
optimizer_features_enable= 9.2.0
sort_area_size = 20145728
sort_area_retained_size = 0
db_name = agile9
open_cursors = 500
sql_trace = FALSE
os_authent_prefix =
optimizer_mode = CHOOSE
_no_or_expansion = TRUE
optimizer_index_cost_adj = 50
_cost_equality_semi_join = FALSE
pga_aggregate_target = 400000000
aq_tm_processes = 10
PMON started with pid=2, OS id=3048
DBW0 started with pid=3, OS id=3380
LGWR started with pid=4, OS id=2232
CKPT started with pid=5, OS id=4052
SMON started with pid=6, OS id=3288
RECO started with pid=7, OS id=1044
CJQ0 started with pid=8, OS id=3472
QMN0 started with pid=9, OS id=220
QMN1 started with pid=10, OS id=3840
QMN2 started with pid=11, OS id=2744
QMN3 started with pid=12, OS id=3956
QMN4 started with pid=13, OS id=688
QMN5 started with pid=14, OS id=3660
QMN6 started with pid=15, OS id=944
QMN7 started with pid=16, OS id=3392
QMN8 started with pid=17, OS id=792
QMN9 started with pid=18, OS id=3324
Tue Dec 11 16:07:29 2012
ARCH: STARTING ARCH PROCESSES
ARC0 started with pid=19, OS id=800
ARC0: Archival started
ARC1 started with pid=20, OS id=3672
Tue Dec 11 16:07:29 2012
ARCH: STARTING ARCH PROCESSES COMPLETE
Tue Dec 11 16:07:29 2012
ARC0: Becoming the 'no FAL' ARCH
ARC0: Becoming the 'no FAL' ARCHARC0: Thread not mounted
Tue Dec 11 16:07:30 2012
ARC1: Archival started
Tue Dec 11 16:07:30 2012
ARC1: Becoming the heartbeat ARCH
ARC1: Becoming the heartbeat ARCHARC1: Thread not mounted
Tue Dec 11 16:08:29 2012
ARC1: Thread not mounted
Tue Dec 11 16:09:29 2012
ARC1: Thread not mounted
Tue Dec 11 16:10:16 2012
alter database mount standby database
Tue Dec 11 16:10:20 2012
Successful mount of redo thread 1, with mount id 580630056
Tue Dec 11 16:10:20 2012
Standby Database mounted.
Completed: alter database mount standby database
Tue Dec 11 16:10:28 2012
alter database open read only
Tue Dec 11 16:10:28 2012
SMON: enabling cache recovery
Tue Dec 11 16:10:28 2012
Database Characterset is UTF8
replication_dependency_tracking turned off (no async multimaster replication found)
Completed: alter database open read only
Tue Dec 11 16:10:36 2012
***Warning - Executing transaction without active Undo Tablespace
Tue Dec 11 16:10:36 2012
***Warning - Executing transaction without active Undo Tablespace
Tue Dec 11 16:10:37 2012
***Warning - Executing transaction without active Undo Tablespace
Tue Dec 11 16:10:37 2012
***Warning - Executing transaction without active Undo Tablespace
Tue Dec 11 16:10:37 2012
***Warning - Executing transaction without active Undo Tablespace
Tue Dec 11 16:10:38 2012
***Warning - Executing transaction without active Undo Tablespace
Tue Dec 11 16:10:38 2012
***Warning - Executing transaction without active Undo Tablespace
Tue Dec 11 16:10:38 2012
***Warning - Executing transaction without active Undo Tablespace
Tue Dec 11 16:10:39 2012
***Warning - Executing transaction without active Undo Tablespace
Tue Dec 11 16:10:39 2012
Restarting dead background process QMN0
QMN0 started with pid=9, OS id=4048
Tue Dec 11 16:10:39 2012
Restarting dead background process QMN1
QMN1 started with pid=10, OS id=684
Tue Dec 11 16:10:39 2012
Restarting dead background process QMN2
QMN2 started with pid=11, OS id=1616
Tue Dec 11 16:10:40 2012
Restarting dead background process QMN3
QMN3 started with pid=12, OS id=1464
Tue Dec 11 16:10:40 2012
Restarting dead background process QMN4
QMN4 started with pid=13, OS id=2328
Tue Dec 11 16:10:40 2012
Restarting dead background process QMN5
QMN5 started with pid=14, OS id=2376
Tue Dec 11 16:10:41 2012
Restarting dead background process QMN6
QMN6 started with pid=15, OS id=1092
Tue Dec 11 16:10:41 2012
Restarting dead background process QMN7
QMN7 started with pid=16, OS id=3236
Tue Dec 11 16:10:41 2012
Restarting dead background process QMN8
QMN8 started with pid=17, OS id=2272
Tue Dec 11 16:10:42 2012
Restarting dead background process QMN9
QMN9 started with pid=18, OS id=1584
Tue Dec 11 16:10:49 2012
***Warning - Executing transaction without active Undo Tablespace
Tue Dec 11 16:10:49 2012
***Warning - Executing transaction without active Undo Tablespace
Tue Dec 11 16:10:49 2012
***Warning - Executing transaction without active Undo Tablespace
Tue Dec 11 16:10:50 2012
***Warning - Executing transaction without active Undo Tablespace
Tue Dec 11 16:10:50 2012
***Warning - Executing transaction without active Undo Tablespace
Tue Dec 11 16:10:50 2012
***Warning - Executing transaction without active Undo Tablespace
Tue Dec 11 16:10:51 2012
***Warning - Executing transaction without active Undo Tablespace
Tue Dec 11 16:10:51 2012
***Warning - Executing transaction without active Undo Tablespace
Tue Dec 11 16:10:51 2012
***Warning - Executing transaction without active Undo Tablespace
Tue Dec 11 16:10:52 2012
***Warning - Executing transaction without active Undo Tablespace
Tue Dec 11 16:11:20 2012
ALTER SYSTEM SET aq_tm_processes=0 SCOPE=BOTH;
Tue Dec 11 16:11:30 2012
ALTER DATABASE RECOVER standby database
Tue Dec 11 16:11:30 2012
Active process 3472 user 'dbadmin' program 'ORACLE.EXE'
CLOSE: waiting for server sessions to complete.
CLOSE: all sessions shutdown successfully.
Tue Dec 11 16:11:31 2012
SMON: disabling cache recovery
Tue Dec 11 16:11:31 2012
Media Recovery Start
ORA-279 signalled during: ALTER DATABASE RECOVER standby database ...
Tue Dec 11 16:11:36 2012
ALTER DATABASE RECOVER CONTINUE DEFAULT
Tue Dec 11 16:11:36 2012
Media Recovery Log D:\ORACLE\ORADATA\AGILE9\ARCHIVE\ARCHIVE_1_514.DBF
Errors with log D:\ORACLE\ORADATA\AGILE9\ARCHIVE\ARCHIVE_1_514.DBF
ORA-308 signalled during: ALTER DATABASE RECOVER CONTINUE DEFAULT ...
Tue Dec 11 16:11:36 2012
ALTER DATABASE RECOVER CONTINUE DEFAULT
Tue Dec 11 16:11:36 2012
Media Recovery Log D:\ORACLE\ORADATA\AGILE9\ARCHIVE\ARCHIVE_1_514.DBF
Errors with log D:\ORACLE\ORADATA\AGILE9\ARCHIVE\ARCHIVE_1_514.DBF
ORA-308 signalled during: ALTER DATABASE RECOVER CONTINUE DEFAULT ...
Tue Dec 11 16:11:36 2012
ALTER DATABASE RECOVER CANCEL
Tue Dec 11 16:11:36 2012
Media Recovery Cancelled
Completed: ALTER DATABASE RECOVER CANCEL
Tue Dec 11 16:12:02 2012
ALTER DATABASE RECOVER managed standby database disconnect from session
Attempt to start background Managed Standby Recovery process
MRP0 started with pid=8, OS id=2804
MRP0: Background Managed Standby Recovery process started
Media Recovery Waiting for thread 1 seq# 514
Tue Dec 11 16:12:07 2012
Completed: ALTER DATABASE RECOVER managed standby database d
Tue Dec 11 16:13:22 2012
Media Recovery Log D:\ORACLE\ORADATA\AGILE9\ARCHIVE\ARCHIVE_1_514.DBF
Media Recovery Log D:\ORACLE\ORADATA\AGILE9\ARCHIVE\ARCHIVE_1_515.DBF
Media Recovery Log D:\ORACLE\ORADATA\AGILE9\ARCHIVE\ARCHIVE_1_516.DBF
Media Recovery Log D:\ORACLE\ORADATA\AGILE9\ARCHIVE\ARCHIVE_1_517.DBF
Media Recovery Log D:\ORACLE\ORADATA\AGILE9\ARCHIVE\ARCHIVE_1_518.DBF
Media Recovery Log D:\ORACLE\ORADATA\AGILE9\ARCHIVE\ARCHIVE_1_519.DBF
Media Recovery Log D:\ORACLE\ORADATA\AGILE9\ARCHIVE\ARCHIVE_1_520.DBF
Media Recovery Waiting for thread 1 seq# 521