oracle集群解决什么问题,RAC做不完全恢复，节点2遇到ora-00205问题【已解决】

10G 10.2.0.5

RAC之前做过dataguard 最大可用模式。

追加一下 节点2 的         alert.log

Starting ORACLE instance (normal)

LICENSE_MAX_SESSION = 0

LICENSE_SESSIONS_WARNING = 0

Interface type 1 eth1 10.10.17.0 configured from OCR for use as a cluster interconnect

Interface type 1 eth0 193.168.17.0 configured from OCR for use as  a public interface

Picked latch-free SCN scheme 3

WARNING: db_recovery_file_dest is same as db_create_file_dest

LICENSE_MAX_USERS = 0

SYS auditing is disabled

ksdpec: called for event 13740 prior to event group initialization

Starting up ORACLE RDBMS Version: 10.2.0.5.0.

System parameters with non-default values:

processes                = 1200

sessions                 = 1325

__shared_pool_size       = 1308622848

shared_pool_size         = 1308622848

__large_pool_size        = 33554432

large_pool_size          = 33554432

__java_pool_size         = 33554432

java_pool_size           = 33554432

__streams_pool_size      = 0

streams_pool_size        = 0

spfile                   = +DATA/racdb/spfileracdb.ora

nls_language             = SIMPLIFIED CHINESE

nls_territory            = CHINA

sga_target               = 0

control_files            = +DATA/racdb/controlfile/current.261.757703699, +DATA/racdb/controlfile/current.260.757703699

db_file_name_convert     = /oracle/oradata/RACDB/, +DATA/RACDB/datafile/, /oracle/oradata/RACDB/tempdata/, +DATA/RACDB/tempfile/

log_file_name_convert    = /oracle/oradata/RACDB/, +DATA/RACDB/onlinelog/

db_block_size            = 8192

__db_cache_size          = 7029653504

db_cache_size            = 7029653504

compatible               = 10.2.0.5.0

log_archive_config       = dg_config=(RACDB,RACDG)

log_archive_dest_1       =

log_archive_dest_2       = SERVICE=RACDG LGWR SYNC AFFIRM VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=RACDG

log_archive_dest_10      = location=USE_DB_RECOVERY_FILE_DEST

log_archive_max_processes= 3

standby_archive_dest     =

log_archive_format       = %t_%s_%r.dbf

fal_client               = RACDB2

fal_server               = RACDG

db_file_multiblock_read_count= 16

cluster_database         = TRUE

cluster_database_instances= 2

db_create_file_dest      = +DATA

db_recovery_file_dest    = +DATA

db_recovery_file_dest_size= 2147483648

standby_file_management  = AUTO

thread                   = 2

instance_number          = 2

undo_management          = AUTO

undo_tablespace          = UNDOTBS2

remote_login_passwordfile= EXCLUSIVE

db_domain                =

service_names            = RACDB, CRM

dispatchers              = (PROTOCOL=TCP) (SERVICE=RACDBXDB)

local_listener           = (ADDRESS = (PROTOCOL=TCP)(HOST=193.168.17.9)(PORT=1521))

remote_listener          = LISTENERS_RACDB

job_queue_processes      = 10

background_dump_dest     = /oracle/admin/RACDB/bdump

user_dump_dest           = /oracle/admin/RACDB/udump

core_dump_dest           = /oracle/admin/RACDB/cdump

audit_file_dest          = /oracle/admin/RACDB/adump

db_name                  = RACDB

open_cursors             = 300

pga_aggregate_target     = 2097152000

Cluster communication is configured to use the following interface(s) for this instance

10.10.17.222

Mon Aug 22 11:24:20 CST 2011

cluster interconnect IPC version:Oracle UDP/IP (generic)

IPC Vendor 1 proto 2

PMON started with pid=2, OS id=5951

DIAG started with pid=3, OS id=5953

PSP0 started with pid=4, OS id=5955

LMON started with pid=5, OS id=5957

LMD0 started with pid=6, OS id=5959

LMS0 started with pid=7, OS id=5961

LMS1 started with pid=8, OS id=5965

LMS2 started with pid=9, OS id=5969

MMAN started with pid=10, OS id=5973

DBW0 started with pid=11, OS id=5975

DBW1 started with pid=12, OS id=5978

LGWR started with pid=13, OS id=5980

CKPT started with pid=14, OS id=5982

SMON started with pid=15, OS id=5984

RECO started with pid=16, OS id=5986

CJQ0 started with pid=17, OS id=5988

MMON started with pid=18, OS id=5990

Mon Aug 22 11:24:20 CST 2011

starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...

MMNL started with pid=19, OS id=5992

Mon Aug 22 11:24:20 CST 2011

starting up 1 shared server(s) ...

Mon Aug 22 11:24:21 CST 2011

lmon registered with NM - instance id 2 (internal mem no 1)

Mon Aug 22 11:24:21 CST 2011

Reconfiguration started (old inc 0, new inc 28)

List of nodes:

0 1

Global Resource Directory frozen

* allocate domain 0, invalid = TRUE

Communication channels reestablished

* domain 0 valid = 1 according to instance 0

Mon Aug 22 11:24:22 CST 2011

Master broadcasted resource hash value bitmaps

Non-local Process blocks cleaned out

Mon Aug 22 11:24:22 CST 2011

LMS 0: 0 GCS shadows cancelled, 0 closed

Mon Aug 22 11:24:22 CST 2011

LMS 2: 0 GCS shadows cancelled, 0 closed

Mon Aug 22 11:24:22 CST 2011

LMS 1: 0 GCS shadows cancelled, 0 closed

Set master node info

Submitted all remote-enqueue requests

Dwn-cvts replayed, VALBLKs dubious

All grantable enqueues granted

Mon Aug 22 11:24:22 CST 2011

LMS 2: 0 GCS shadows traversed, 0 replayed

Mon Aug 22 11:24:22 CST 2011

LMS 0: 0 GCS shadows traversed, 0 replayed

Mon Aug 22 11:24:22 CST 2011

LMS 1: 0 GCS shadows traversed, 0 replayed

Mon Aug 22 11:24:22 CST 2011

Submitted all GCS remote-cache requests

Fix write in gcs resources

Reconfiguration complete

LCK0 started with pid=22, OS id=6012

Mon Aug 22 11:24:22 CST 2011

ALTER DATABASE   MOUNT

Mon Aug 22 11:24:22 CST 2011

Starting background process ASMB

ASMB started with pid=24, OS id=6018

Starting background process RBAL

RBAL started with pid=25, OS id=6022

Loaded ASM Library - Generic Linux, version 2.0.4 (KABI_V2) library for asmlib interface

Mon Aug 22 11:24:26 CST 2011

SUCCESS: diskgroup DATA was mounted

Mon Aug 22 11:24:26 CST 2011

ORA-00210: ???????????

ORA-00202: ????: ''+DATA/racdb/controlfile/current.261.757703699''

ORA-17503: ksfdopn: 2 ?????? +DATA/racdb/controlfile/current.261.757703699

ORA-15012: ASM file '+DATA/racdb/controlfile/current.261.757703699' does not exist

Mon Aug 22 11:24:26 CST 2011

ORA-205 signalled during: ALTER DATABASE   MOUNT...

Mon Aug 22 11:24:26 CST 2011

Shutting down instance (abort)

License high water mark = 2

Instance terminated by USER, pid = 6125

[本帖最后由 jackyhu999 于 2011-8-22 11:27 编辑]