免费注册 查看新帖 |

Chinaunix

  平台 论坛 博客 文库
最近访问板块 发新帖
查看: 3159 | 回复: 6
打印 上一主题 下一主题

oracle912数据库修改成归档模式后频繁宕库,不知是何原因? [复制链接]

论坛徽章:
1
操作系统版块每日发帖之星
日期:2016-02-12 06:20:00
跳转到指定楼层
1 [收藏(0)] [报告]
发表于 2005-03-14 09:29 |只看该作者 |倒序浏览
我现有一AIX5.1.10.0+oracle9.1.2环境,需修改成归档模式,但当我修该成归档模式后,数据库频繁吊死,需直接kill掉所有oralce进程,才能再启动数据库。

论坛徽章:
0
2 [报告]
发表于 2005-03-14 10:13 |只看该作者

oracle912数据库修改成归档模式后频繁宕库,不知是何原因?

归档日志文件多大,要大一些。
还有参数LOG_BUFFER

论坛徽章:
1
操作系统版块每日发帖之星
日期:2016-02-12 06:20:00
3 [报告]
发表于 2005-03-14 11:00 |只看该作者

oracle912数据库修改成归档模式后频繁宕库,不知是何原因?

我log_  buffer: 524288
   归档日志文件大小是300M :

论坛徽章:
0
4 [报告]
发表于 2005-03-14 11:14 |只看该作者

oracle912数据库修改成归档模式后频繁宕库,不知是何原因?

把你的alert_SID.log贴上来看看

论坛徽章:
1
操作系统版块每日发帖之星
日期:2016-02-12 06:20:00
5 [报告]
发表于 2005-03-14 11:43 |只看该作者

oracle912数据库修改成归档模式后频繁宕库,不知是何原因?

alter tablespace ts_user online
Fri Mar 11 04:12:31 2005
Completed: alter tablespace ts_user online
Fri Mar 11 06:48:06 2005
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
SCN scheme 3
Using log_archive_dest parameter default value
LICENSE_MAX_USERS = 0
SYS auditing is disabled
Starting up ORACLE RDBMS Version: 9.2.0.5.0.
System parameters with non-default values:
  processes                = 300
  timed_statistics         = TRUE
  shared_pool_size         = 654311424
  large_pool_size          = 16777216
  java_pool_size           = 33554432
  spfile                   = /dev/rlvspfile
  control_files            = /dev/rlvcontrol01, /dev/rlvcontrol02, /dev/rlvcontrol03
  db_block_size            = 16384
  db_cache_size            = 536870912
  compatible               = 9.2.0.0.0
  log_archive_start        = FALSE
  db_files                 = 1500
  db_file_multiblock_read_count= 16
  fast_start_mttr_target   = 300
  undo_management          = AUTO
  undo_tablespace          = UNDOTBS1
  undo_retention           = 10800
  remote_os_authent        = TRUE
  remote_os_roles          = TRUE
  remote_login_passwordfile= EXCLUSIVE
  db_domain                =
  instance_name            = ora92
  job_queue_processes      = 3
  hash_join_enabled        = TRUE
  background_dump_dest     = /oracle/app/oracle/admin/ora92/bdump
  user_dump_dest           = /oracle/app/oracle/admin/ora92/udump
  core_dump_dest           = /oracle/app/oracle/admin/ora92/cdump
  sort_area_size           = 524288
  db_name                  = ora92
  open_cursors             = 300
  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
CJQ0 started with pid=8
Fri Mar 11 06:48:11 2005
ALTER DATABASE   MOUNT
Fri Mar 11 06:48:15 2005
Successful mount of redo thread 1, with mount id 1864622763
Fri Mar 11 06:48:15 2005
Database mounted in Exclusive Mode.
Completed: ALTER DATABASE   MOUNT
Fri Mar 11 06:48:16 2005
ALTER DATABASE OPEN
Fri Mar 11 06:48:16 2005
Beginning crash recovery of 1 threads
Fri Mar 11 06:48:16 2005
Started redo scan
Fri Mar 11 06:48:16 2005
Completed redo scan
0 redo blocks read, 0 data blocks need recovery
Fri Mar 11 06:48:16 2005
Started recovery at
Thread 1: logseq 7480, block 614399, scn 0.576517522
Recovery of Online Redo Log: Thread 1 Group 1 Seq 7480 Reading mem 0
  Mem# 0 errs 0: /dev/rlvredo1_1
  Mem# 1 errs 0: /dev/rlvredo1_2
  Mem# 2 errs 0: /dev/rlvredo1_3
Fri Mar 11 06:48:16 2005
Completed redo application
Fri Mar 11 06:48:16 2005
Ended recovery at
Thread 1: logseq 7480, block 614399, scn 0.576537523
0 data blocks read, 0 data blocks written, 0 redo blocks read
Crash recovery completed successfully
Fri Mar 11 06:48:17 2005
LGWR: Primary database is in CLUSTER CONSISTENT mode
Fri Mar 11 06:48:17 2005
ARCH: Evaluating archive   log 3 thread 1 sequence 7478
ARCH: Beginning to archive log 3 thread 1 sequence 7478
Creating archive destination LOG_ARCHIVE_DEST_1: '/oracle/app/oracle/product/9.2/dbs/arch/1_7478.dbf'
Fri Mar 11 06:48:27 2005
ARCH: Completed archiving  log 3 thread 1 sequence 7478
Fri Mar 11 06:48:27 2005
LGWR: Primary database is in CLUSTER CONSISTENT mode
Thread 1 advanced to log sequence 7481
Thread 1 opened at log sequence 7481
  Current log# 3 seq# 7481 mem# 0: /dev/rlvredo3_1
  Current log# 3 seq# 7481 mem# 1: /dev/rlvredo3_2
  Current log# 3 seq# 7481 mem# 2: /dev/rlvredo3_3
Successful open of redo thread 1
Fri Mar 11 06:48:27 2005
SMON: enabling cache recovery
Fri Mar 11 06:48:28 2005
Undo Segment 1 Onlined
Undo Segment 2 Onlined
Undo Segment 3 Onlined
Undo Segment 4 Onlined
Undo Segment 5 Onlined
Undo Segment 6 Onlined
Undo Segment 7 Onlined
Undo Segment 8 Onlined
Undo Segment 9 Onlined
Undo Segment 10 Onlined
Successfully onlined Undo Tablespace 1.
Fri Mar 11 06:48:28 2005
SMON: enabling tx recovery
Fri Mar 11 06:48:29 2005
Database Characterset is ZHS16GBK
replication_dependency_tracking turned off (no async multimaster replication found)
Completed: ALTER DATABASE OPEN
Fri Mar 11 06:51:22 2005
ORACLE Instance ora92 - Can not allocate log, archival required
Fri Mar 11 06:51:22 2005
ARCH: Connecting to console port...
Thread 1 cannot allocate new log, sequence 7482
All online logs needed archiving
  Current log# 3 seq# 7481 mem# 0: /dev/rlvredo3_1
  Current log# 3 seq# 7481 mem# 1: /dev/rlvredo3_2
  Current log# 3 seq# 7481 mem# 2: /dev/rlvredo3_3
Fri Mar 11 06:57:05 2005
Errors in file /oracle/app/oracle/admin/ora92/bdump/ora92_pmon_22050.trc:
ORA-00476: RECO process terminated with error
Fri Mar 11 06:57:05 2005
PMON: terminating instance due to error 476
Instance terminated by PMON, pid = 22050
Fri Mar 11 06:58:52 2005
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
SCN scheme 3
Using log_archive_dest parameter default value
LICENSE_MAX_USERS = 0
SYS auditing is disabled
Starting up ORACLE RDBMS Version: 9.2.0.5.0.
System parameters with non-default values:
  processes                = 300
  timed_statistics         = TRUE
  shared_pool_size         = 654311424
  large_pool_size          = 16777216
  java_pool_size           = 33554432
  spfile                   = /dev/rlvspfile
  control_files            = /dev/rlvcontrol01, /dev/rlvcontrol02, /dev/rlvcontrol03
  db_block_size            = 16384
  db_cache_size            = 536870912
  compatible               = 9.2.0.0.0
  log_archive_start        = FALSE
  db_files                 = 1500
  db_file_multiblock_read_count= 16
  fast_start_mttr_target   = 300
  undo_management          = AUTO
  undo_tablespace          = UNDOTBS1
  undo_retention           = 10800
  remote_os_authent        = TRUE
  remote_os_roles          = TRUE
  remote_login_passwordfile= EXCLUSIVE
  db_domain                =
  instance_name            = ora92
  job_queue_processes      = 3
  hash_join_enabled        = TRUE
  background_dump_dest     = /oracle/app/oracle/admin/ora92/bdump
  user_dump_dest           = /oracle/app/oracle/admin/ora92/udump
  core_dump_dest           = /oracle/app/oracle/admin/ora92/cdump
  sort_area_size           = 524288
  db_name                  = ora92
  open_cursors             = 300
  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
CJQ0 started with pid=8
Fri Mar 11 06:58:53 2005
ALTER DATABASE   MOUNT
Fri Mar 11 06:58:57 2005
Successful mount of redo thread 1, with mount id 1864605741
Fri Mar 11 06:58:57 2005
Database mounted in Exclusive Mode.
Completed: ALTER DATABASE   MOUNT
Fri Mar 11 06:59:06 2005
alter database open
Fri Mar 11 06:59:07 2005
Beginning crash recovery of 1 threads
Fri Mar 11 06:59:07 2005
Started redo scan
Fri Mar 11 06:59:11 2005
Completed redo scan
552773 redo blocks read, 18371 data blocks need recovery
Fri Mar 11 06:59:14 2005
Started recovery at
Thread 1: logseq 7481, block 61626, scn 0.0
Recovery of Online Redo Log: Thread 1 Group 3 Seq 7481 Reading mem 0
  Mem# 0 errs 0: /dev/rlvredo3_1
  Mem# 1 errs 0: /dev/rlvredo3_2
  Mem# 2 errs 0: /dev/rlvredo3_3
Fri Mar 11 06:59:22 2005
Completed redo application
Fri Mar 11 06:59:24 2005
Ended recovery at
Thread 1: logseq 7481, block 614399, scn 0.576620569
18371 data blocks read, 18371 data blocks written, 552773 redo blocks read
Crash recovery completed successfully
Fri Mar 11 06:59:25 2005
LGWR: Primary database is in CLUSTER CONSISTENT mode
Fri Mar 11 06:59:25 2005
ARCH: Evaluating archive   log 2 thread 1 sequence 7479
ARCH: Beginning to archive log 2 thread 1 sequence 7479
Creating archive destination LOG_ARCHIVE_DEST_1: '/oracle/app/oracle/product/9.2/dbs/arch/1_7479.dbf'
ARCH: Completed archiving  log 2 thread 1 sequence 7479
Fri Mar 11 06:59:35 2005
LGWR: Primary database is in CLUSTER CONSISTENT mode
Thread 1 advanced to log sequence 7482
Thread 1 opened at log sequence 7482
  Current log# 2 seq# 7482 mem# 0: /dev/rlvredo2_1
  Current log# 2 seq# 7482 mem# 1: /dev/rlvredo2_2
  Current log# 2 seq# 7482 mem# 2: /dev/rlvredo2_3
Successful open of redo thread 1
Fri Mar 11 06:59:35 2005
SMON: enabling cache recovery
Fri Mar 11 06:59:35 2005
Undo Segment 1 Onlined
Undo Segment 2 Onlined
Undo Segment 3 Onlined
Undo Segment 4 Onlined
Undo Segment 5 Onlined
Undo Segment 6 Onlined
Undo Segment 7 Onlined
Undo Segment 8 Onlined
Undo Segment 9 Onlined
Undo Segment 10 Onlined
Successfully onlined Undo Tablespace 1.
Fri Mar 11 06:59:35 2005
SMON: enabling tx recovery
Fri Mar 11 06:59:35 2005
Database Characterset is ZHS16GBK
replication_dependency_tracking turned off (no async multimaster replication found)
Completed: alter database open
Fri Mar 11 07:01:34 2005
Shutting down instance: further logons disabled
Shutting down instance (immediate)
License high water mark = 5
Fri Mar 11 07:01:37 2005
ALTER DATABASE CLOSE NORMAL
Fri Mar 11 07:01:37 2005
SMON: disabling tx recovery
SMON: disabling cache recovery
Fri Mar 11 07:01:37 2005
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
Thread 1 closed at log sequence 7482
Successful close of redo thread 1
Fri Mar 11 07:01:37 2005
Completed: ALTER DATABASE CLOSE NORMAL
Fri Mar 11 07:01:37 2005
ALTER DATABASE DISMOUNT
Completed: ALTER DATABASE DISMOUNT
ARCH: Archiving is disabled
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
ARCH: Archiving is disabled
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
Fri Mar 11 07:01:53 2005
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
SCN scheme 3
Using log_archive_dest parameter default value
LICENSE_MAX_USERS = 0
SYS auditing is disabled
Starting up ORACLE RDBMS Version: 9.2.0.5.0.
System parameters with non-default values:
  processes                = 300
  timed_statistics         = TRUE
  shared_pool_size         = 654311424
  large_pool_size          = 16777216
  java_pool_size           = 33554432
  spfile                   = /dev/rlvspfile
  control_files            = /dev/rlvcontrol01, /dev/rlvcontrol02, /dev/rlvcontrol03
  db_block_size            = 16384
  db_cache_size            = 536870912
  compatible               = 9.2.0.0.0
  log_archive_start        = FALSE
  db_files                 = 1500
  db_file_multiblock_read_count= 16
  fast_start_mttr_target   = 300
  undo_management          = AUTO
  undo_tablespace          = UNDOTBS1
  undo_retention           = 10800
  remote_os_authent        = TRUE
  remote_os_roles          = TRUE
  remote_login_passwordfile= EXCLUSIVE
  db_domain                =
  instance_name            = ora92
  job_queue_processes      = 3
  hash_join_enabled        = TRUE
  background_dump_dest     = /oracle/app/oracle/admin/ora92/bdump
  user_dump_dest           = /oracle/app/oracle/admin/ora92/udump
  core_dump_dest           = /oracle/app/oracle/admin/ora92/cdump
  sort_area_size           = 524288
  db_name                  = ora92
  open_cursors             = 300
  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
CJQ0 started with pid=8
Fri Mar 11 07:01:54 2005
ALTER DATABASE   MOUNT
Fri Mar 11 07:01:58 2005
Successful mount of redo thread 1, with mount id 1864657634
Fri Mar 11 07:01:58 2005
Database mounted in Exclusive Mode.
Completed: ALTER DATABASE   MOUNT
Fri Mar 11 07:02:47 2005
alter database open
Fri Mar 11 07:02:47 2005
LGWR: Primary database is in CLUSTER CONSISTENT mode
Thread 1 opened at log sequence 7482
  Current log# 2 seq# 7482 mem# 0: /dev/rlvredo2_1
  Current log# 2 seq# 7482 mem# 1: /dev/rlvredo2_2
  Current log# 2 seq# 7482 mem# 2: /dev/rlvredo2_3
Successful open of redo thread 1
Fri Mar 11 07:02:47 2005
SMON: enabling cache recovery
Fri Mar 11 07:02:47 2005
Undo Segment 1 Onlined
Undo Segment 2 Onlined
Undo Segment 3 Onlined
Undo Segment 4 Onlined
Undo Segment 5 Onlined
Undo Segment 6 Onlined
Undo Segment 7 Onlined
Undo Segment 8 Onlined
Undo Segment 9 Onlined
Undo Segment 10 Onlined
Successfully onlined Undo Tablespace 1.
Fri Mar 11 07:02:47 2005
SMON: enabling tx recovery
Fri Mar 11 07:02:47 2005
Database Characterset is ZHS16GBK
replication_dependency_tracking turned off (no async multimaster replication found)
Completed:  alter database open
Fri Mar 11 07:04:16 2005
Shutting down instance: further logons disabled
Shutting down instance (immediate)
License high water mark = 5
Fri Mar 11 07:04:20 2005
ALTER DATABASE CLOSE NORMAL
Fri Mar 11 07:04:20 2005
SMON: disabling tx recovery
SMON: disabling cache recovery
Fri Mar 11 07:04:20 2005
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
Thread 1 closed at log sequence 7482
Successful close of redo thread 1
Fri Mar 11 07:04:20 2005
Completed: ALTER DATABASE CLOSE NORMAL
Fri Mar 11 07:04:20 2005
ALTER DATABASE DISMOUNT
Completed: ALTER DATABASE DISMOUNT
ARCH: Archiving is disabled
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
ARCH: Archiving is disabled
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
Fri Mar 11 07:04:35 2005
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
SCN scheme 3
Using log_archive_dest parameter default value
LICENSE_MAX_USERS = 0
SYS auditing is disabled
Starting up ORACLE RDBMS Version: 9.2.0.5.0.
System parameters with non-default values:
  processes                = 300
  timed_statistics         = TRUE
  shared_pool_size         = 654311424
  large_pool_size          = 16777216
  java_pool_size           = 33554432
  spfile                   = /dev/rlvspfile
  control_files            = /dev/rlvcontrol01, /dev/rlvcontrol02, /dev/rlvcontrol03
  db_block_size            = 16384
  db_cache_size            = 536870912
  compatible               = 9.2.0.0.0
  log_archive_start        = FALSE
  db_files                 = 1500
  db_file_multiblock_read_count= 16
  fast_start_mttr_target   = 300
  undo_management          = AUTO
  undo_tablespace          = UNDOTBS1
  undo_retention           = 10800
  remote_os_authent        = TRUE
  remote_os_roles          = TRUE
  remote_login_passwordfile= EXCLUSIVE
  db_domain                =
  instance_name            = ora92
  job_queue_processes      = 3
  hash_join_enabled        = TRUE
  background_dump_dest     = /oracle/app/oracle/admin/ora92/bdump
  user_dump_dest           = /oracle/app/oracle/admin/ora92/udump
  core_dump_dest           = /oracle/app/oracle/admin/ora92/cdump
  sort_area_size           = 524288
  db_name                  = ora92
  open_cursors             = 300
  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
CJQ0 started with pid=8
Fri Mar 11 07:04:36 2005
ALTER DATABASE   MOUNT
Fri Mar 11 07:04:40 2005
Successful mount of redo thread 1, with mount id 1864620676
Fri Mar 11 07:04:40 2005
Database mounted in Exclusive Mode.
Completed: ALTER DATABASE   MOUNT
Fri Mar 11 07:04:50 2005
alter database open
Fri Mar 11 07:04:51 2005
LGWR: Primary database is in CLUSTER CONSISTENT mode
Thread 1 opened at log sequence 7482
  Current log# 2 seq# 7482 mem# 0: /dev/rlvredo2_1
  Current log# 2 seq# 7482 mem# 1: /dev/rlvredo2_2
  Current log# 2 seq# 7482 mem# 2: /dev/rlvredo2_3
Successful open of redo thread 1
Fri Mar 11 07:04:51 2005
SMON: enabling cache recovery
Fri Mar 11 07:04:51 2005
Undo Segment 1 Onlined
Undo Segment 2 Onlined
Undo Segment 3 Onlined
Undo Segment 4 Onlined
Undo Segment 5 Onlined
Undo Segment 6 Onlined
Undo Segment 7 Onlined
Undo Segment 8 Onlined
Undo Segment 9 Onlined
Undo Segment 10 Onlined
Successfully onlined Undo Tablespace 1.
Fri Mar 11 07:04:51 2005
SMON: enabling tx recovery
Fri Mar 11 07:04:51 2005
Database Characterset is ZHS16GBK
replication_dependency_tracking turned off (no async multimaster replication found)
Completed: alter database open
Fri Mar 11 07:09:55 2005
ORACLE Instance ora92 - Can not allocate log, archival required
Fri Mar 11 07:09:55 2005
ARCH: Connecting to console port...
Thread 1 cannot allocate new log, sequence 7483
All online logs needed archiving
  Current log# 2 seq# 7482 mem# 0: /dev/rlvredo2_1
  Current log# 2 seq# 7482 mem# 1: /dev/rlvredo2_2
  Current log# 2 seq# 7482 mem# 2: /dev/rlvredo2_3
Fri Mar 11 07:17:21 2005
Errors in file /oracle/app/oracle/admin/ora92/bdump/ora92_pmon_30004.trc:
ORA-00470: LGWR process terminated with error
Fri Mar 11 07:17:21 2005
PMON: terminating instance due to error 470
Instance terminated by PMON, pid = 30004
Fri Mar 11 07:19:19 2005
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
SCN scheme 3
Using log_archive_dest parameter default value
LICENSE_MAX_USERS = 0
SYS auditing is disabled
Starting up ORACLE RDBMS Version: 9.2.0.5.0.
System parameters with non-default values:
  processes                = 300
  timed_statistics         = TRUE
  shared_pool_size         = 654311424
  large_pool_size          = 16777216
  java_pool_size           = 33554432
  spfile                   = /dev/rlvspfile
  control_files            = /dev/rlvcontrol01, /dev/rlvcontrol02, /dev/rlvcontrol03
  db_block_size            = 16384
  db_cache_size            = 536870912
  compatible               = 9.2.0.0.0
  log_archive_start        = FALSE
  db_files                 = 1500
  db_file_multiblock_read_count= 16
  fast_start_mttr_target   = 300
  undo_management          = AUTO
  undo_tablespace          = UNDOTBS1
  undo_retention           = 10800
  remote_os_authent        = TRUE
  remote_os_roles          = TRUE
  remote_login_passwordfile= EXCLUSIVE
  db_domain                =
  instance_name            = ora92
  job_queue_processes      = 3
  hash_join_enabled        = TRUE
  background_dump_dest     = /oracle/app/oracle/admin/ora92/bdump
  user_dump_dest           = /oracle/app/oracle/admin/ora92/udump
  core_dump_dest           = /oracle/app/oracle/admin/ora92/cdump
  sort_area_size           = 524288
  db_name                  = ora92
  open_cursors             = 300
  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
CJQ0 started with pid=8
Fri Mar 11 07:19:19 2005
ALTER DATABASE   MOUNT
Fri Mar 11 07:19:24 2005
Successful mount of redo thread 1, with mount id 1864628215
Fri Mar 11 07:19:24 2005
Database mounted in Exclusive Mode.
Completed: ALTER DATABASE   MOUNT
Fri Mar 11 07:20:22 2005
alter database open
Fri Mar 11 07:20:22 2005
Beginning crash recovery of 1 threads
Fri Mar 11 07:20:22 2005
Started redo scan
Fri Mar 11 07:20:27 2005
Completed redo scan
553021 redo blocks read, 11311 data blocks need recovery
Fri Mar 11 07:20:29 2005
Started recovery at
Thread 1: logseq 7482, block 61378, scn 0.0
Recovery of Online Redo Log: Thread 1 Group 2 Seq 7482 Reading mem 0
  Mem# 0 errs 0: /dev/rlvredo2_1
  Mem# 1 errs 0: /dev/rlvredo2_2
  Mem# 2 errs 0: /dev/rlvredo2_3
Fri Mar 11 07:20:34 2005
Completed redo application
Fri Mar 11 07:20:35 2005
Ended recovery at
Thread 1: logseq 7482, block 614399, scn 0.576728111
11311 data blocks read, 11222 data blocks written, 553021 redo blocks read
Crash recovery completed successfully
Fri Mar 11 07:20:36 2005
LGWR: Primary database is in CLUSTER CONSISTENT mode
Fri Mar 11 07:20:36 2005
ARCH: Evaluating archive   log 1 thread 1 sequence 7480
ARCH: Beginning to archive log 1 thread 1 sequence 7480
Creating archive destination LOG_ARCHIVE_DEST_1: '/oracle/app/oracle/product/9.2/dbs/arch/1_7480.dbf'
ARCH: Completed archiving  log 1 thread 1 sequence 7480
Fri Mar 11 07:20:46 2005
LGWR: Primary database is in CLUSTER CONSISTENT mode
Thread 1 advanced to log sequence 7483
Thread 1 opened at log sequence 7483
  Current log# 1 seq# 7483 mem# 0: /dev/rlvredo1_1
  Current log# 1 seq# 7483 mem# 1: /dev/rlvredo1_2
  Current log# 1 seq# 7483 mem# 2: /dev/rlvredo1_3
Successful open of redo thread 1
Fri Mar 11 07:20:46 2005
SMON: enabling cache recovery
Fri Mar 11 07:20:46 2005
Undo Segment 1 Onlined
Undo Segment 2 Onlined
Undo Segment 3 Onlined
Undo Segment 4 Onlined
Undo Segment 5 Onlined
Undo Segment 6 Onlined
Undo Segment 7 Onlined
Undo Segment 8 Onlined
Undo Segment 9 Onlined
Undo Segment 10 Onlined
Successfully onlined Undo Tablespace 1.
Fri Mar 11 07:20:46 2005
SMON: enabling tx recovery
Fri Mar 11 07:20:46 2005
Database Characterset is ZHS16GBK
replication_dependency_tracking turned off (no async multimaster replication found)
Completed: alter database open
Fri Mar 11 07:53:35 2005
/* OracleOEM */ ALTER TABLESPACE "TS_USER" OFFLINE NORMAL

论坛徽章:
0
6 [报告]
发表于 2005-03-14 14:29 |只看该作者

oracle912数据库修改成归档模式后频繁宕库,不知是何原因?

you will need to set
log_archive_start        =  true
otherwise you need to manually archive the log files
SQL>; alter system archive log all;

论坛徽章:
1
操作系统版块每日发帖之星
日期:2016-02-12 06:20:00
7 [报告]
发表于 2005-03-14 20:40 |只看该作者

oracle912数据库修改成归档模式后频繁宕库,不知是何原因?

问题已经解决,原因是我的存放归档日志文件的文件系统空间不够了!
方法是把归档目录修改到了一个有充分的空间的文件系统下!
您需要登录后才可以回帖 登录 | 注册

本版积分规则 发表回复

  

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

清除 Cookies - ChinaUnix - Archiver - WAP - TOP