偶的10g rac由于掉电产生了点小问题？

显示全部楼层 · 2005-7-16 18:49:11

ORA-00214: controlfile '/dev/raw/raw10' version 1378 inconsistent with file '/dev/raw/raw9' version 1376
现在node1已经启动，node2不能mount，
如果不重建controlfile该如何做？

千问 · 2005-7-16 18:49:11

SQL> startup;
ORACLE instance started.
Total System Global Area109051904 bytes
Fixed Size
777656 bytes
Variable Size
70263368 bytes
Database Buffers 37748736 bytes
Redo Buffers
262144 bytes
ORA-00214: controlfile '/dev/raw/raw10' version 1378 inconsistent with file '/dev/raw/raw9' version 1376
SQL> startup nomount exclusive
ORACLE instance started.
Total System Global Area109051904 bytes
Fixed Size
777656 bytes
Variable Size
70263368 bytes
Database Buffers 37748736 bytes
Redo Buffers
262144 bytes
SQL> CREATE CONTROLFILE REUSE DATABASE "RAC" RESETLOGSARCHIVELOG
2MAXLOGFILES 192
3MAXLOGMEMBERS 3
4MAXDATAFILES 1024
5MAXINSTANCES 32
6MAXLOGHISTORY 454
7LOGFILE
8GROUP 1 '/dev/raw/raw5'SIZE 10M,
9GROUP 2 '/dev/raw/raw6'SIZE 10M
10-- STANDBY LOGFILE
11DATAFILE
12'/dev/raw/raw14',
13'/dev/raw/raw12',
14'/dev/raw/raw19',
15'/dev/raw/raw13',
16'/dev/raw/raw16',
17'/dev/raw/raw18'
18CHARACTER SET US7ASCII;
CREATE CONTROLFILE REUSE DATABASE "RAC" RESETLOGSARCHIVELOG
*
ERROR at line 1:
ORA-01503: CREATE CONTROLFILE failed
ORA-12720: operation requires database is in EXCLUSIVE mode

千问 · 2005-7-16 18:49:11

[oracle@rac1 udump]$ dd if=/dev/raw/raw10 of=/dev/raw/raw9
dd: reading `/dev/raw/raw10': No such device or address
61408+0 records in
61408+0 records out
[oracle@rac1 udump]$ sql
[uniread] Loaded history (609 lines)
SQL*Plus: Release 10.1.0.2.0 - Production on Fri Jul 30 18:25:56 2004
Copyright (c) 1982, 2004, Oracle.All rights reserved.

Connected to:
Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 - Production
With the Partitioning, Real Application Clusters and Data Mining options
SQL> startup force;
ORACLE instance started.
Total System Global Area109051904 bytes
Fixed Size
777656 bytes
Variable Size
70263368 bytes
Database Buffers 37748736 bytes
Redo Buffers
262144 bytes
Database mounted.
Database opened.
SQL> startup force;
ORACLE instance started.
Total System Global Area109051904 bytes
Fixed Size
777656 bytes
Variable Size
70263368 bytes
Database Buffers 37748736 bytes
Redo Buffers
262144 bytes
ORA-00203: using the wrong controlfiles
ORA-00202: controlfile: '/dev/raw/raw9'

千问 · 2005-7-16 18:49:11

SQL> shutdown
ORA-01507: database not mounted

ORACLE instance shut down.
SQL> startup;
ORACLE instance started.
Total System Global Area109051904 bytes
Fixed Size
777656 bytes
Variable Size
70263368 bytes
Database Buffers 37748736 bytes
Redo Buffers
262144 bytes
ORA-01105: mount is incompatible with mounts by other instances
ORA-01104: number of controlfiles (1) does not equal 2

千问 · 2005-7-16 18:49:11

SQL> startup;
ORACLE instance started.
Total System Global Area109051904 bytes
Fixed Size
777656 bytes
Variable Size
70263368 bytes
Database Buffers 37748736 bytes
Redo Buffers
262144 bytes
ORA-00227: corrupt block detected in controlfile: (block 1, # blocks 1)
ORA-00202: controlfile: '/dev/raw/raw10'

千问 · 2005-7-16 18:49:11

生产数据库?
关注中...

千问 · 2005-7-16 18:49:11

SQL> startup;
ORACLE instance started.
Total System Global Area109051904 bytes
Fixed Size
777656 bytes
Variable Size
70263368 bytes
Database Buffers 37748736 bytes
Redo Buffers
262144 bytes
ORA-00600: internal error code, arguments: [kccrbl_stale], [0], [1441], [1434], [], [], [], []
现在所有node都启动不了啦......

千问 · 2005-7-16 18:49:11

最初由 husthxd 发布
[B]生产数据库?
关注中... [/B]
测试库......

千问 · 2005-7-16 18:49:11

还好还好
os是什么?
RAC环境太少了,还是上metalink把

千问 · 2005-7-16 18:49:11

最初由 husthxd 发布
[B]还好还好
os是什么?
RAC环境太少了,还是上metalink把 [/B]
metalink也找不到相关的信息
os:ads3