免费注册 查看新帖 |

Chinaunix

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

oracle 9i cluster in redhat as3 一台机子oracle起不来了,何解? [复制链接]

论坛徽章:
0
跳转到指定楼层
1 [收藏(0)] [报告]
发表于 2006-12-04 12:16 |只看该作者 |倒序浏览
两台机子oracle原先都能正常启动切换,现发现B机cluster的IP和阵列能切过来,oracle不能启动(两机都没启动归档)
log如下:
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.4.0.
System parameters with non-default values:
  processes                = 500
  timed_statistics         = TRUE
  shared_pool_size         = 268435456
  large_pool_size          = 16777216
  java_pool_size           = 83886080
  spfile                   = /oradata1/dbs/spfilekkk.ora
  control_files            = /oradata1/kkk/control01.ctl, /oradata2/kkk/control02.ctl, /oradata3/kkk/control03.ctl
  db_block_size            = 8192
  db_cache_size            = 838860800
  compatible               = 9.2.0.0.0
  db_file_multiblock_read_count= 16
  fast_start_mttr_target   = 300
  undo_management          = AUTO
  undo_tablespace          = UNDOTBS1
  undo_retention           = 10800
  remote_login_passwordfile= EXCLUSIVE
  db_domain                = local
  instance_name            = kkk
  dispatchers              = (PROTOCOL=TCP) (SERVICE=kkkXDB)
  job_queue_processes      = 30
  hash_join_enabled        = TRUE
  background_dump_dest     = /opt/ora9/admin/kkk/bdump
  user_dump_dest           = /opt/ora9/admin/kkk/udump
  core_dump_dest           = /opt/ora9/admin/kkk/cdump
  sort_area_size           = 524288
  db_name                  = kkk
  open_cursors             = 300
  star_transformation_enabled= FALSE
  query_rewrite_enabled    = FALSE
  pga_aggregate_target     = 314572800
  aq_tm_processes          = 1
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
QMN0 started with pid=9
Fri Dec  1 23:29:43 2006
starting up 1 shared server(s) ...
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
Fri Dec  1 23:29:43 2006
ALTER DATABASE MOUNT
Fri Dec  1 23:29:47 2006
Successful mount of redo thread 1, with mount id 762133223.
Fri Dec  1 23:29:47 2006
Database mounted in Exclusive Mode.
Completed: ALTER DATABASE MOUNT
Fri Dec  1 23:29:47 2006
ALTER DATABASE OPEN
ORA-1113 signalled during: ALTER DATABASE OPEN...
Fri Dec  1 23:30:43 2006
Restarting dead background process QMN0
QMN0 started with pid=9
Fri Dec  1 23:35:44 2006
Restarting dead background process QMN0
QMN0 started with pid=9
Fri Dec  1 23:40:45 2006
Restarting dead background process QMN0
QMN0 started with pid=9
Fri Dec  1 23:41:13 2006
Shutting down instance: further logons disabled
Shutting down instance (immediate)


去掉双机配置,单机启动oracle 的log如下:
SQL> STARTUP NOMOUNT;
ALTER DATABASE MOUNT;
ALTER DATABASE OPEN; ORACLE instance started.

Total System Global Area 1242634520 bytes
Fixed Size                     452888 bytes
Variable Size                  402653184 bytes
Database Buffers          838860800 bytes
Redo Buffers                     667648 bytes
SQL>
Database altered.

SQL>
ALTER DATABASE OPEN
*
ERROR at line 1:
ORA-01113: file 3 needs media recovery
ORA-01110: data file 3: '/opt/ora9/oradata/kkk/cwmlite01.dbf'


SQL> shutdown immediate
ORA-01109: database not open


Database dismounted.
ORACLE instance shut down.
您需要登录后才可以回帖 登录 | 注册

本版积分规则 发表回复

  

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

清除 Cookies - ChinaUnix - Archiver - WAP - TOP