免费注册 查看新帖 |

Chinaunix

  平台 论坛 博客 文库
› 论坛 › 数据库技术 › Oracle › 帮我看看数据库为什么自动关闭,不好意思,日志很长
最近访问板块 发新帖
查看: 5136 | 回复: 5
打印 上一主题 下一主题

帮我看看数据库为什么自动关闭,不好意思,日志很长 [复制链接]

happytgrape

论坛徽章:
0
跳转到指定楼层
1楼 [收藏(0)] [报告]
发表于 2007-02-12 11:24 |只看该作者 |倒序浏览
我有两台服务器做的双机热备,在2/8中午12:48的时候,不知道为什么主机上的数据库实例自动关闭,从机的数据库实例起来,后来我们又手动启动主机上,下边是主机的日志,请帮忙看看,能不能发现什么蛛丝马迹啊.
  1. *Thu Feb  8 12:44:43 2007
  2. ARC1: Evaluating archive   log 1 thread 1 sequence 54604
  3. ARC1: Beginning to archive log 1 thread 1 sequence 54604
  4. Creating archive destination LOG_ARCHIVE_DEST_1: '/u03/oradata/wyjsora/archive/1_54604.dbf'
  5. ARC1: Completed archiving  log 1 thread 1 sequence 54604
  6. Thu Feb  8 12:48:07 2007
  7. Shutting down instance: further logons disabled
  8. Shutting down instance (immediate)
  9. License high water mark = 108
  10. Waiting for dispatcher 'D000' to shutdown
  11. All dispatchers and shared servers shutdown
  12. Thu Feb  8 12:48:12 2007
  13. ALTER DATABASE CLOSE NORMAL
  14. Thu Feb  8 12:48:12 2007
  15. SMON: disabling tx recovery
  16. SMON: disabling cache recovery
  17. Thu Feb  8 12:48:12 2007
  18. Shutting down archive processes
  19. Archiving is disabled
  20. Thu Feb  8 12:48:12 2007
  21. ARCH shutting down
  22. Thu Feb  8 12:48:12 2007
  23. ARCH shutting down
  24. Thu Feb  8 12:48:12 2007
  25. ARC0: Archival stopped
  26. Thu Feb  8 12:48:12 2007
  27. ARC1: Archival stopped
  28. Thu Feb  8 12:48:16 2007
  29. Thread 1 closed at log sequence 54605
  30. Successful close of redo thread 1.
  31. Thu Feb  8 12:48:18 2007
  32. Completed: ALTER DATABASE CLOSE NORMAL
  33. Thu Feb  8 12:48:18 2007
  34. ALTER DATABASE DISMOUNT
  35. Completed: ALTER DATABASE DISMOUNT
  36. ARCH: Archiving is disabled
  37. Shutting down archive processes
  38. Archiving is disabled
  39. Archive process shutdown avoided: 0 active
  40. ARCH: Archiving is disabled
  41. Shutting down archive processes
  42. Archiving is disabled
  43. Archive process shutdown avoided: 0 active
  44. Thu Feb  8 13:02:13 2007
  45. Starting ORACLE instance (normal)
  46. LICENSE_MAX_SESSION = 0
  47. LICENSE_SESSIONS_WARNING = 0
  48. SCN scheme 3
  49. Using log_archive_dest parameter default value
  50. Thu Feb  8 13:02:37 2007
  51. LICENSE_MAX_USERS = 0
  52. SYS auditing is disabled
  53. Starting up ORACLE RDBMS Version: 9.2.0.4.0.
  54. System parameters with non-default values:
  55.   processes                = 150
  56.   timed_statistics         = TRUE
  57.   shared_pool_size         = 536870912
  58.   large_pool_size          = 117440512
  59.   java_pool_size           = 218103808
  60.   control_files            = /u02/oradata/wyjsora/control01.ctl, /u03/oradata/wyjsora/control02.ctl,
  61. /u05/oradata/wyjsora/control03.ctl
  62.   db_block_size            = 8192
  63.   db_cache_size            = 5251268608
  64.   compatible               = 9.2.0.0.0
  65.   log_archive_start        = TRUE
  66.   log_archive_dest_1       = LOCATION=/u03/oradata/wyjsora/archive
  67.   log_archive_format       = %t_%s.dbf
  68.   db_file_multiblock_read_count= 16
  69.   fast_start_mttr_target   = 300
  70.   undo_management          = AUTO
  71.   undo_tablespace          = UNDOTBS1
  72.   undo_retention           = 10800
  73.   remote_login_passwordfile= EXCLUSIVE
  74.   db_domain                =
  75.   instance_name            = wyjsora
  76.   dispatchers              = (PROTOCOL=TCP) (SERVICE=wyjsoraXDB)
  77.   hash_join_enabled        = TRUE
  78.   background_dump_dest     = /u01/app/oracle/admin/wyjsora/bdump
  79.   user_dump_dest           = /u01/app/oracle/admin/wyjsora/udump
  80.   core_dump_dest           = /u01/app/oracle/admin/wyjsora/cdump
  81.   sort_area_size           = 524288
  82.   db_name                  = wyjsora
  83.   open_cursors             = 300
  84.   star_transformation_enabled= FALSE
  85.   query_rewrite_enabled    = FALSE
  86.   pga_aggregate_target     = 83886080
  87. PMON started with pid=2
  88. DBW0 started with pid=3
  89. LGWR started with pid=4
  90. CKPT started with pid=5
  91. SMON started with pid=6
  92. RECO started with pid=7
  93. Thu Feb  8 13:02:38 2007
  94. starting up 1 shared server(s) ...
  95. starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
  96. ARCH: STARTING ARCH PROCESSES
  97. ARC0 started with pid=10
  98. ARC0: Archival started
  99. ARC1 started with pid=11
  100. Thu Feb  8 13:02:38 2007
  101. ARCH: STARTING ARCH PROCESSES COMPLETE
  102. Thu Feb  8 13:02:38 2007
  103. ARC0: Thread not mounted
  104. Thu Feb  8 13:02:38 2007
  105. ARC1: Archival started
  106. ARC1: Thread not mounted
  107. Thu Feb  8 13:02:38 2007
  108. ALTER DATABASE   MOUNT
  109. Thu Feb  8 13:02:40 2007
  110. Shutting down instance: further logons disabled
  111. Shutting down instance (immediate)
  112. License high water mark = 2
  113. Thu Feb  8 13:02:40 2007
  114. ORA-1089 signalled during: ALTER DATABASE   MOUNT...
  115. Thu Feb  8 13:02:40 2007
  116. Waiting for dispatcher 'D000' to shutdown
  117. All dispatchers and shared servers shutdown
  118. Thu Feb  8 13:02:42 2007
  119. ALTER DATABASE CLOSE NORMAL
  120. ORA-1507 signalled during: ALTER DATABASE CLOSE NORMAL...
  121. ARCH: Archiving is disabled
  122. Shutting down archive processes
  123. Archiving is disabled
  124. Thu Feb  8 13:02:42 2007
  125. ARCH shutting down
  126. Thu Feb  8 13:02:42 2007
  127. ARCH shutting down
  128. Thu Feb  8 13:02:42 2007
  129. ARC0: Archival stoppedThu Feb  8 12:44:43 2007
  130. ARC1: Evaluating archive   log 1 thread 1 sequence 54604
  131. ARC1: Beginning to archive log 1 thread 1 sequence 54604
  132. Creating archive destination LOG_ARCHIVE_DEST_1: '/u03/oradata/wyjsora/archive/1_54604.dbf'
  133. ARC1: Completed archiving  log 1 thread 1 sequence 54604
  134. Thu Feb  8 12:48:07 2007
  135. Shutting down instance: further logons disabled
  136. Shutting down instance (immediate)
  137. License high water mark = 108
  138. Waiting for dispatcher 'D000' to shutdown
  139. All dispatchers and shared servers shutdown
  140. Thu Feb  8 12:48:12 2007
  141. ALTER DATABASE CLOSE NORMAL
  142. Thu Feb  8 12:48:12 2007
  143. SMON: disabling tx recovery
  144. SMON: disabling cache recovery
  145. Thu Feb  8 12:48:12 2007
  146. Shutting down archive processes
  147. Archiving is disabled
  148. Thu Feb  8 12:48:12 2007
  149. ARCH shutting down
  150. Thu Feb  8 12:48:12 2007
  151. ARCH shutting down
  152. Thu Feb  8 12:48:12 2007
  153. ARC0: Archival stopped
  154. Thu Feb  8 12:48:12 2007
  155. ARC1: Archival stopped
  156. Thu Feb  8 12:48:16 2007
  157. Thread 1 closed at log sequence 54605
  158. Successful close of redo thread 1.
  159. Thu Feb  8 12:48:18 2007
  160. Completed: ALTER DATABASE CLOSE NORMAL
  161. Thu Feb  8 12:48:18 2007
  162. ALTER DATABASE DISMOUNT
  163. Completed: ALTER DATABASE DISMOUNT
  164. ARCH: Archiving is disabled
  165. Shutting down archive processes
  166. Archiving is disabled
  167. Archive process shutdown avoided: 0 active
  168. ARCH: Archiving is disabled
  169. Shutting down archive processes
  170. Archiving is disabled
  171. Archive process shutdown avoided: 0 active
  172. Thu Feb  8 13:02:13 2007
  173. Starting ORACLE instance (normal)
  174. LICENSE_MAX_SESSION = 0
  175. LICENSE_SESSIONS_WARNING = 0
  176. SCN scheme 3
  177. Using log_archive_dest parameter default value
  178. Thu Feb  8 13:02:37 2007
  179. LICENSE_MAX_USERS = 0
  180. SYS auditing is disabled
  181. Starting up ORACLE RDBMS Version: 9.2.0.4.0.
  182. System parameters with non-default values:
  183.   processes                = 150
  184.   timed_statistics         = TRUE
  185.   shared_pool_size         = 536870912
  186.   large_pool_size          = 117440512
  187.   java_pool_size           = 218103808
  188.   control_files            = /u02/oradata/wyjsora/control01.ctl, /u03/oradata/wyjsora/control02.ctl,
  189. /u05/oradata/wyjsora/control03.ctl
  190.   db_block_size            = 8192
  191.   db_cache_size            = 5251268608
  192.   compatible               = 9.2.0.0.0
  193.   log_archive_start        = TRUE
  194.   log_archive_dest_1       = LOCATION=/u03/oradata/wyjsora/archive
  195.   log_archive_format       = %t_%s.dbf
  196.   db_file_multiblock_read_count= 16
  197.   fast_start_mttr_target   = 300
  198.   undo_management          = AUTO
  199.   undo_tablespace          = UNDOTBS1
  200.   undo_retention           = 10800
  201.   remote_login_passwordfile= EXCLUSIVE
  202.   db_domain                =
  203.   instance_name            = wyjsora
  204.   dispatchers              = (PROTOCOL=TCP) (SERVICE=wyjsoraXDB)
  205.   hash_join_enabled        = TRUE
  206.   background_dump_dest     = /u01/app/oracle/admin/wyjsora/bdump
  207.   user_dump_dest           = /u01/app/oracle/admin/wyjsora/udump
  208.   core_dump_dest           = /u01/app/oracle/admin/wyjsora/cdump
  209.   sort_area_size           = 524288
  210.   db_name                  = wyjsora
  211.   open_cursors             = 300
  212.   star_transformation_enabled= FALSE
  213.   query_rewrite_enabled    = FALSE
  214.   pga_aggregate_target     = 83886080
  215. PMON started with pid=2
  216. DBW0 started with pid=3
  217. LGWR started with pid=4
  218. CKPT started with pid=5
  219. SMON started with pid=6
  220. RECO started with pid=7
  221. Thu Feb  8 13:02:38 2007
  222. starting up 1 shared server(s) ...
  223. starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
  224. ARCH: STARTING ARCH PROCESSES
  225. ARC0 started with pid=10
  226. ARC0: Archival started
  227. ARC1 started with pid=11
  228. Thu Feb  8 13:02:38 2007
  229. ARCH: STARTING ARCH PROCESSES COMPLETE
  230. Thu Feb  8 13:02:38 2007
  231. ARC0: Thread not mounted
  232. Thu Feb  8 13:02:38 2007
  233. ARC1: Archival started
  234. ARC1: Thread not mounted
  235. Thu Feb  8 13:02:38 2007
  236. ALTER DATABASE   MOUNT
  237. Thu Feb  8 13:02:40 2007
  238. Shutting down instance: further logons disabled
  239. Shutting down instance (immediate)
  240. License high water mark = 2
  241. Thu Feb  8 13:02:40 2007
  242. ORA-1089 signalled during: ALTER DATABASE   MOUNT...
  243. Thu Feb  8 13:02:40 2007
  244. Waiting for dispatcher 'D000' to shutdown
  245. All dispatchers and shared servers shutdown
  246. Thu Feb  8 13:02:42 2007
  247. ALTER DATABASE CLOSE NORMAL
  248. ORA-1507 signalled during: ALTER DATABASE CLOSE NORMAL...
  249. ARCH: Archiving is disabled
  250. Shutting down archive processes
  251. Archiving is disabled
  252. Thu Feb  8 13:02:42 2007
  253. ARCH shutting down
  254. Thu Feb  8 13:02:42 2007
  255. ARCH shutting down
  256. Thu Feb  8 13:02:42 2007
  257. ARC0: Archival stopped
  258. Thu Feb  8 13:02:45 2007
  259. ARCH: Archiving is disabled
  260. Shutting down archive processes
  261. Archiving is disabled
  262. Archive process shutdown avoided: 0 active
  263. Thu Feb  8 13:02:53 2007
  264. Starting ORACLE instance (normal)
  265. LICENSE_MAX_SESSION = 0
  266. LICENSE_SESSIONS_WARNING = 0
  267. SCN scheme 3
  268. Using log_archive_dest parameter default value
  269. LICENSE_MAX_USERS = 0
  270. SYS auditing is disabled
  271. Starting up ORACLE RDBMS Version: 9.2.0.4.0.
  272. System parameters with non-default values:
  273.   processes                = 150
  274.   timed_statistics         = TRUE
  275.   shared_pool_size         = 536870912
  276.   large_pool_size          = 117440512
  277.   java_pool_size           = 218103808
  278.   control_files            = /u02/oradata/wyjsora/control01.ctl, /u03/oradata/wyjsor
  279. /u05/oradata/wyjsora/control03.ctl
  280.   db_block_size            = 8192
  281.   db_cache_size            = 5251268608
  282.   compatible               = 9.2.0.0.0
  283.   log_archive_start        = TRUE
  284.   log_archive_dest_1       = LOCATION=/u03/oradata/wyjsora/archive
  285.   log_archive_format       = %t_%s.dbf
  286.   db_file_multiblock_read_count= 16
  287.   fast_start_mttr_target   = 300
  288.   undo_management          = AUTO
  289.   undo_tablespace          = UNDOTBS1
  290.   undo_retention           = 10800
  291.   remote_login_passwordfile= EXCLUSIVE
  292.   db_domain                =
  293.   instance_name            = wyjsora
  294.   dispatchers              = (PROTOCOL=TCP) (SERVICE=wyjsoraXDB)
  295.   hash_join_enabled        = TRUE
  296.   background_dump_dest     = /u01/app/oracle/admin/wyjsora/bdump
  297.   user_dump_dest           = /u01/app/oracle/admin/wyjsora/udump
  298.   core_dump_dest           = /u01/app/oracle/admin/wyjsora/cdump
  299.   sort_area_size           = 524288
  300.   db_name                  = wyjsora
  301.   open_cursors             = 300
  302.   star_transformation_enabled= FALSE
  303.   query_rewrite_enabled    = FALSE
  304.   pga_aggregate_target     = 83886080
  305. PMON started with pid=2
  306. DBW0 started with pid=3
  307. LGWR started with pid=4
  308. CKPT started with pid=5
  309. SMON started with pid=6
  310. RECO started with pid=7
  311. Thu Feb  8 13:03:01 2007
  312. starting up 1 shared server(s) ...
  313. starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
  314. ARCH: STARTING ARCH PROCESSES
  315. ARC0 started with pid=10
  316. ARC0: Archival started
  317. ARC1 started with pid=11
  318. Thu Feb  8 13:03:01 2007
  319. ARCH: STARTING ARCH PROCESSES COMPLETE
  320. Thu Feb  8 13:03:01 2007
  321. ARC1: Archival started
  322. Thu Feb  8 13:03:01 2007
  323. ARC0: Thread not mounted
  324. Thu Feb  8 13:03:01 2007
  325. ARC1: Thread not mounted
  326. Thu Feb  8 13:03:01 2007
  327. ALTER DATABASE   MOUNT
  328. Thu Feb  8 13:03:05 2007
  329. Successful mount of redo thread 1, with mount id 2115733829.
  330. Thu Feb  8 13:03:05 2007
  331. Database mounted in Exclusive Mode.
  332. Completed: ALTER DATABASE   MOUNT
  333. Thu Feb  8 13:03:05 2007
  334. ALTER DATABASE OPEN
  335. Thu Feb  8 13:03:06 2007
  336. Beginning crash recovery of 1 threads
  337. Thu Feb  8 13:03:06 2007
  338. Started first pass scan
  339. Thu Feb  8 13:03:06 2007
  340. Completed first pass scan
  341. 316 redo blocks read, 95 data blocks need recovery
  342. Thu Feb  8 13:03:06 2007
  343. Started recovery at
  344. Thread 1: logseq 54605, block 61966, scn 0.0
  345. Recovery of Online Redo Log: Thread 1 Group 2 Seq 54605 Reading mem 0
  346.   Mem# 0 errs 0: /u03/oradata/wyjsora/redo02.log
  347. Thu Feb  8 13:03:06 2007
  348. Completed redo application
  349. Thu Feb  8 13:03:06 2007
  350. Ended recovery at
  351. Thread 1: logseq 54605, block 62282, scn 1.2730059357
  352. 95 data blocks read, 95 data blocks written, 316 redo blocks read
  353. Crash recovery completed successfully
  354. Thu Feb  8 13:03:06 2007
  355. LGWR: Primary database is in CLUSTER CONSISTENT mode
  356. Thread 1 advanced to log sequence 54606
  357. Thread 1 opened at log sequence 54606
  358.   Current log# 3 seq# 54606 mem# 0: /u05/oradata/wyjsora/redo03.log
  359. Successful open of redo thread 1.
  360. Thu Feb  8 13:03:06 2007
  361. SMON: enabling cache recovery
  362. Thu Feb  8 13:03:06 2007
  363. ARC0: Evaluating archive   log 2 thread 1 sequence 54605
  364. ARC0: Beginning to archive log 2 thread 1 sequence 54605
  365. Creating archive destination LOG_ARCHIVE_DEST_1: '/u03/oradata/wyjsora/archive/1_546
  366. Thu Feb  8 13:03:07 2007
  367. Undo Segment 1 Onlined
  368. ..
  369. Undo Segment 10 Onlined
  370. Successfully onlined Undo Tablespace 1.
  371. Thu Feb  8 13:03:07 2007
  372. SMON: enabling tx recovery
  373. Thu Feb  8 13:03:07 2007
  374. Database Characterset is ZHS16GBK
  375. replication_dependency_tracking turned off (no async multimaster replication found)
  376. Thu Feb  8 13:03:08 2007
  377. ARC0: Completed archiving  log 2 thread 1 sequence 54605
  378. Thu Feb  8 13:03:08 2007
  379. Completed: ALTER DATABASE OPEN
  380. Thu Feb  8 13:04:19 2007
  381. Errors in file /u01/app/oracle/admin/wyjsora/bdump/wyjsora_pmon_21159.trc:
  382. ORA-00474: SMON process terminated with error
  383. Thu Feb  8 13:04:19 2007
  384. PMON: terminating instance due to error 474
  385. Instance terminated by PMON, pid = 21159
  386. Thu Feb  8 13:04:30 2007
  387. Starting ORACLE instance (normal)
  388. LICENSE_MAX_SESSION = 0
  389. LICENSE_SESSIONS_WARNING = 0
  390. SCN scheme 3
  391.   Mem# 0 errs 0: /u03/oradata/wyjsora/redo02.log
  392. Thu Feb  8 13:03:06 2007
  393. Completed redo application
  394. Thu Feb  8 13:03:06 2007
  395. Ended recovery at
  396. Thread 1: logseq 54605, block 62282, scn 1.2730059357
  397. 95 data blocks read, 95 data blocks written, 316 redo blocks read
  398. Crash recovery completed successfully
  399. Thu Feb  8 13:03:06 2007
  400. LGWR: Primary database is in CLUSTER CONSISTENT mode
  401. Thread 1 advanced to log sequence 54606
  402. Thread 1 opened at log sequence 54606
  403.   Current log# 3 seq# 54606 mem# 0: /u05/oradata/wyjsora/redo03.log
  404. Successful open of redo thread 1.
  405. Thu Feb  8 13:03:06 2007
  406. SMON: enabling cache recovery
  407. Thu Feb  8 13:03:06 2007
  408. ARC0: Evaluating archive   log 2 thread 1 sequence 54605
  409. ARC0: Beginning to archive log 2 thread 1 sequence 54605
  410. Creating archive destination LOG_ARCHIVE_DEST_1: '/u03/oradata/wyjsora/archive/1_54605.dbf'
  411. Thu Feb  8 13:03:07 2007
  412. Undo Segment 1 Onlined
  413. ..
  414. Undo Segment 10 Onlined
  415. Successfully onlined Undo Tablespace 1.
  416. Thu Feb  8 13:03:07 2007
  417. SMON: enabling tx recovery
  418. Thu Feb  8 13:03:07 2007
  419. Database Characterset is ZHS16GBK
  420. replication_dependency_tracking turned off (no async multimaster replication found
  421. Thu Feb  8 13:03:08 2007
  422. ARC0: Completed archiving  log 2 thread 1 sequence 54605
  423. Thu Feb  8 13:03:08 2007
  424. Completed: ALTER DATABASE OPEN
  425. Thu Feb  8 13:04:19 2007
  426. Errors in file /u01/app/oracle/admin/wyjsora/bdump/wyjsora_pmon_21159.trc:
  427. ORA-00474: SMON process terminated with error
  428. Thu Feb  8 13:04:19 2007
  429. PMON: terminating instance due to error 474
  430. Instance terminated by PMON, pid = 21159
  431. Thu Feb  8 13:04:30 2007
  432. Starting ORACLE instance (normal)
  433. LICENSE_MAX_SESSION = 0
  434. LICENSE_SESSIONS_WARNING = 0
  435. SCN scheme 3
  436. Using log_archive_dest parameter default value
  437. LICENSE_MAX_USERS = 0
  438. SYS auditing is disabled
  439. Starting up ORACLE RDBMS Version: 9.2.0.4.0.
  440. System parameters with non-default values:
  441.   processes                = 150
  442.   timed_statistics         = TRUE
  443.   shared_pool_size         = 536870912
  444.   large_pool_size          = 117440512
  445.   java_pool_size           = 218103808
  446.   control_files            = /u02/oradata/wyjsora/control01.ctl, /u03/oradata/wyjs
  447. /u05/oradata/wyjsora/control03.ctl
  448.   db_block_size            = 8192
  449.   db_cache_size            = 5251268608
  450.   compatible               = 9.2.0.0.0
  451.   log_archive_start        = TRUE
  452.   log_archive_dest_1       = LOCATION=/u03/oradata/wyjsora/archive
  453.   log_archive_format       = %t_%s.dbf
  454.   db_file_multiblock_read_count= 16
  455.   fast_start_mttr_target   = 300
  456.   undo_management          = AUTO
  457.   undo_tablespace          = UNDOTBS1
  458.   undo_retention           = 10800
  459.   remote_login_passwordfile= EXCLUSIVE
  460.   db_domain                =
  461.   instance_name            = wyjsora
  462. ..
  463.   query_rewrite_enabled    = FALSE
  464.   pga_aggregate_target     = 83886080
  465. PMON started with pid=2
  466. DBW0 started with pid=3
  467. LGWR started with pid=4
  468. CKPT started with pid=5
  469. SMON started with pid=6
  470. RECO started with pid=7
  471. Thu Feb  8 13:04:38 2007
  472. starting up 1 shared server(s) ...
  473. starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=T
  474. ARCH: STARTING ARCH PROCESSES
  475. ARC0 started with pid=10
  476. ARC0: Archival started
  477. ARC1 started with pid=11
  478. Thu Feb  8 13:04:38 2007
  479. ARCH: STARTING ARCH PROCESSES COMPLETE
  480. Thu Feb  8 13:04:38 2007
  481. ARC1: Archival started
  482. Thu Feb  8 13:04:38 2007
  483. ARC0: Thread not mounted
  484. Thu Feb  8 13:04:38 2007
  485. ARC1: Thread not mounted
  486. Thu Feb  8 13:04:38 2007
  487. ALTER DATABASE   MOUNT
  488. Thu Feb  8 13:04:42 2007
  489. Successful mount of redo thread 1, with mount id 2115743398.
  490. Thu Feb  8 13:04:42 2007
  491. Database mounted in Exclusive Mode.
  492. Completed: ALTER DATABASE   MOUNT
  493. Thu Feb  8 13:04:42 2007
  494. ALTER DATABASE OPEN
  495. Thu Feb  8 13:04:42 2007
  496. Beginning crash recovery of 1 threads
  497. Thu Feb  8 13:04:42 2007
  498. Started first pass scan
  499. Thu Feb  8 13:04:42 2007
  500. Completed first pass scan
  501. 69770 redo blocks read, 263 data blocks need recovery
  502. Thu Feb  8 13:04:43 2007
  503. Started recovery at
  504. Thread 1: logseq 54606, block 3, scn 0.0
  505. Recovery of Online Redo Log: Thread 1 Group 3 Seq 54606 Reading mem 0
  506.   Mem# 0 errs 0: /u05/oradata/wyjsora/redo03.log
  507. Thu Feb  8 13:04:43 2007
  508. Completed redo application
  509. Thu Feb  8 13:04:43 2007
  510. Ended recovery at
  511. Thread 1: logseq 54606, block 69773, scn 1.2730081004
  512. 263 data blocks read, 263 data blocks written, 69770 redo blocks read
  513. Crash recovery completed successfully
  514. Thu Feb  8 13:04:43 2007
  515. LGWR: Primary database is in CLUSTER CONSISTENT mode
  516. Thread 1 advanced to log sequence 54607
  517. Thread 1 opened at log sequence 54607
  518.   Current log# 1 seq# 54607 mem# 0: /u02/oradata/wyjsora/redo01.log
  519. Successful open of redo thread 1.
  520. Thu Feb  8 13:04:43 2007
  521. ARC0: Evaluating archive   log 3 thread 1 sequence 54606
  522. Thu Feb  8 13:04:43 2007
  523. SMON: enabling cache recovery
  524. Thu Feb  8 13:04:43 2007
  525. ARC0: Beginning to archive log 3 thread 1 sequence 54606
  526. Creating archive destination LOG_ARCHIVE_DEST_1: '/u03/oradata/wyjsora/archive/1_5460
  527. Thu Feb  8 13:04:44 2007
  528. Undo Segment 1 Onlined
  529. ..
  530. Undo Segment 10 Onlined
  531. Successfully onlined Undo Tablespace 1.
  532. Thu Feb  8 13:04:44 2007
  533. SMON: enabling tx recovery
  534. Thu Feb  8 13:04:44 2007
  535. Database Characterset is ZHS16GBK
  536. replication_dependency_tracking turned off (no async multimaster replication found)
  537. Completed: ALTER DATABASE OPEN
  538. Thu Feb  8 13:04:45 2007
  539. ARC0: Completed archiving  log 3 thread 1 sequence 54606
  540. Thu Feb  8 13:11:19 2007
  541. Thread 1 advanced to log sequence 54608
  542.   Current log# 2 seq# 54608 mem# 0: /u03/oradata/wyjsora/redo02.log
  543. Thu Feb  8 13:11:19 2007
  544. *
复制代码
blue_stone

论坛徽章:
0
2楼 [报告]
发表于 2007-02-12 16:56 |只看该作者
看看双机软件的日志,或许能找到一些信息,
可能是因为oracle启动后的进行检查的时间间隔太小.
实战分享：从技术角度谈机器学习入门| 【大话IT】RadonDB低门槛向MySQL集群下战书 | ChinaUnix打赏功能已上线！ | 新一代分布式关系型数据库RadonDB知多少？
happytgrape

论坛徽章:
0
3楼 [报告]
发表于 2007-02-13 14:45 |只看该作者
原帖由 blue_stone 于 2007-2-12 16:56 发表
看看双机软件的日志,或许能找到一些信息,
可能是因为oracle启动后的进行检查的时间间隔太小.

能仔细说说 检查间隔怎么回事吗

[ 本帖最后由 happytgrape 于 2007-2-13 14:57 编辑 ]
实战分享：从技术角度谈机器学习入门| 【大话IT】RadonDB低门槛向MySQL集群下战书 | ChinaUnix打赏功能已上线！ | 新一代分布式关系型数据库RadonDB知多少？
liutao010010

论坛徽章:
0
4楼 [报告]
发表于 2009-06-01 17:04 |只看该作者
实战分享：从技术角度谈机器学习入门| 【大话IT】RadonDB低门槛向MySQL集群下战书 | ChinaUnix打赏功能已上线！ | 新一代分布式关系型数据库RadonDB知多少？
flutter

论坛徽章:
1
CU十二周年纪念徽章 日期:2013-10-24 15:41:34
5楼 [报告]
发表于 2009-06-02 11:56 |只看该作者
看日志的前2次关闭--启动，不象是ORACLE的异常关闭，估计是双机VTS主动关闭INSTANCE的。

   检查双机VTS的日志，可能是被检测的某一资源失效而导致VTS关闭数据库。
实战分享：从技术角度谈机器学习入门| 【大话IT】RadonDB低门槛向MySQL集群下战书 | ChinaUnix打赏功能已上线！ | 新一代分布式关系型数据库RadonDB知多少？
ciw2010

论坛徽章:
0
6楼 [报告]
发表于 2009-06-07 15:41 |只看该作者
看不懂诶
实战分享：从技术角度谈机器学习入门| 【大话IT】RadonDB低门槛向MySQL集群下战书 | ChinaUnix打赏功能已上线！ | 新一代分布式关系型数据库RadonDB知多少？
返回列表 发新帖
高级模式
B Color Image Link Quote Code Smilies
您需要登录后才可以回帖 登录 | 注册

本版积分规则 发表回复

  

北京盛拓优讯信息技术有限公司. 版权所有 京ICP备16024965号-6 北京市公安局海淀分局网监中心备案编号：11010802020122 niuxiaotong@pcpop.com 17352615567
未成年举报专区
中国互联网协会会员  联系我们：huangweiwei@itpub.net
感谢所有关心和支持过ChinaUnix的朋友们 转载本站内容请注明原作者名及出处

清除 Cookies - ChinaUnix - Archiver - WAP - TOP