oracle rac 贴吧,ORACLE RAC

本帖最后由 zyo320 于 2012-10-8 09:36 编辑

节点1：

Error 12528 rseceived logging on to the standby

Sun Sep 30 15:35:26 2012

Errors in file /opt/ora10g/admin/ORCL/bdump/orcl1_arc1_4972.trc:

ORA-12528: TNS:listener: all appropriate instances are blocking new connections

FAL[server, ARC1]: Error 12528 creating remote archivelog file 'ORCL2'

FAL[server, ARC1]: FAL archive failed, see trace file.

Sun Sep 30 15:35:26 2012

Errors in file /opt/ora10g/admin/ORCL/bdump/orcl1_arc1_4972.trc:

ORA-16055: FAL request rejected

节点2：

Sun Sep 30 15:35:06 2012

ALTER SYSTEM SET service_names='ORCL' SCOPE=MEMORY SID='ORCL2';

Sun Sep 30 15:35:07 2012

ALTER SYSTEM SET service_names='ORCL','orcldb' SCOPE=MEMORY SID='ORCL2';

Sun Sep 30 15:35:12 2012

Shutting down instance (abort)

License high water mark = 31

Instance terminated by USER, pid = 25486

Sun Sep 30 15:35:16 2012

Starting ORACLE instance (normal)

LICENSE_MAX_SESSION = 0

LICENSE_SESSIONS_WARNING = 0

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

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

Picked latch-free SCN scheme 1

Autotune of undo retention is turned on.

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.1.0.

System parameters with non-default values:

processes                = 300

sessions                 = 335

__shared_pool_size       = 587202560

__large_pool_size        = 16777216

__java_pool_size         = 16777216

__streams_pool_size      = 0

spfile                   = +ORCLDB_DISK/orcl/spfileorcl.ora

sga_target               = 5016387584

control_files            = +ORCLDB_DISK/orcl/controlfile/current.256.759414295

db_block_size            = 8192

__db_cache_size          = 4378853376

compatible               = 10.2.0.1.0

log_archive_dest_1       = location=/dbrac2_arch

log_archive_dest_2       = service=ORCL1

standby_archive_dest     = /dbrac1_backup

db_file_multiblock_read_count= 16

cluster_database         = TRUE

cluster_database_instances= 2

db_create_file_dest      = +ORCLDB_DISK

thread                   = 2

instance_number          = 2

undo_management          = AUTO

undo_tablespace          = UNDOTBS2

remote_login_passwordfile= EXCLUSIVE

db_domain                =

dispatchers              = (PROTOCOL=TCP) (SERVICE=ORCLXDB)

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

remote_listener          = LISTENERS_ORCL

job_queue_processes      = 10

background_dump_dest     = /opt/ora10g/admin/ORCL/bdump

user_dump_dest           = /opt/ora10g/admin/ORCL/udump

core_dump_dest           = /opt/ora10g/admin/ORCL/cdump

audit_file_dest          = /opt/ora10g/admin/ORCL/adump

db_name                  = ORCL

open_cursors             = 300

pga_aggregate_target     = 1669332992

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

192.168.100.101

Sun Sep 30 15:35:16 2012

cluster interconnect IPC version:Oracle UDP/IP

IPC Vendor 1 proto 2

PMON started with pid=2, OS id=25647

DIAG started with pid=3, OS id=25649

PSP0 started with pid=4, OS id=25651

LMON started with pid=5, OS id=25653

LMD0 started with pid=6, OS id=25655

LMS0 started with pid=7, OS id=25657

LMS1 started with pid=8, OS id=25661

LMS2 started with pid=9, OS id=25665

LMS3 started with pid=10, OS id=25669

MMAN started with pid=11, OS id=25673

DBW0 started with pid=12, OS id=25675

DBW1 started with pid=13, OS id=25677

LGWR started with pid=14, OS id=25679

CKPT started with pid=15, OS id=25681

SMON started with pid=16, OS id=25683

RECO started with pid=17, OS id=25685

CJQ0 started with pid=18, OS id=25687

MMON started with pid=19, OS id=25689

Sun Sep 30 15:35:17 2012

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

MMNL started with pid=20, OS id=25691

Sun Sep 30 15:35:17 2012

starting up 1 shared server(s) ...

Sun Sep 30 15:35:17 2012

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

Sun Sep 30 15:35:18 2012

Reconfiguration started (old inc 0, new inc 8)

pseudo shared rm latch used

List of nodes:

0 1

Global Resource Directory frozen

* allocate domain 0, invalid = TRUE

Communication channels reestablished

* domain 0 valid = 0 according to instance 0

Sun Sep 30 15:35:19 2012

Master broadcasted resource hash value bitmaps

Non-local Process blocks cleaned out

Sun Sep 30 15:35:19 2012

LMS 0: 0 GCS shadows cancelled, 0 closed

Sun Sep 30 15:35:19 2012

LMS 1: 0 GCS shadows cancelled, 0 closed

Sun Sep 30 15:35:19 2012

LMS 2: 0 GCS shadows cancelled, 0 closed

Sun Sep 30 15:35:19 2012

LMS 3: 0 GCS shadows cancelled, 0 closed

Set master node info

Submitted all remote-enqueue requests

Dwn-cvts replayed, VALBLKs dubious

All grantable enqueues granted

Sun Sep 30 15:35:20 2012

LMS 1: 0 GCS shadows traversed, 0 replayed

Sun Sep 30 15:35:20 2012

LMS 0: 0 GCS shadows traversed, 0 replayed

Sun Sep 30 15:35:20 2012

LMS 2: 0 GCS shadows traversed, 0 replayed

Sun Sep 30 15:35:20 2012

LMS 3: 0 GCS shadows traversed, 0 replayed

Sun Sep 30 15:35:20 2012

Submitted all GCS remote-cache requests

Fix write in gcs resources

Reconfiguration complete

LCK0 started with pid=23, OS id=25779

Sun Sep 30 15:35:21 2012

ALTER DATABASE   MOUNT

Sun Sep 30 15:35:21 2012

Starting background process ASMB

ASMB started with pid=25, OS id=25809

Starting background process RBAL

RBAL started with pid=26, OS id=25813

Sun Sep 30 15:35:29 2012

SUCCESS: diskgroup ORCLDB_DISK was mounted

Sun Sep 30 15:35:33 2012

Setting recovery target incarnation to 1

Sun Sep 30 15:35:33 2012

Successful mount of redo thread 2, with mount id 2683020474

Sun Sep 30 15:35:33 2012

Database mounted in Shared Mode (CLUSTER_DATABASE=TRUE)

Completed: ALTER DATABASE   MOUNT

Sun Sep 30 15:35:34 2012

ALTER DATABASE OPEN

Picked broadcast on commit scheme to generate SCNs

Sun Sep 30 15:35:34 2012

LGWR: STARTING ARCH PROCESSES

ARC0 started with pid=28, OS id=26156

Sun Sep 30 15:35:34 2012

ARC0: Archival started

ARC1: Archival started

LGWR: STARTING ARCH PROCESSES COMPLETE

ARC1 started with pid=29, OS id=26158

Sun Sep 30 15:35:34 2012

Thread 2 opened at log sequence 8457

Current log# 4 seq# 8457 mem# 0: +ORCLDB_DISK/orcl/onlinelog/group_4.266.759415229

Successful open of redo thread 2

Sun Sep 30 15:35:34 2012

MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set

Sun Sep 30 15:35:34 2012

SMON: enabling cache recovery

Sun Sep 30 15:35:34 2012

ARC1: STARTING ARCH PROCESSES

Sun Sep 30 15:35:34 2012

ARC0: Becoming the 'no FAL' ARCH

ARC0: Becoming the 'no SRL' ARCH

Sun Sep 30 15:35:34 2012

ARC2: Archival started

ARC1: STARTING ARCH PROCESSES COMPLETE

ARC1: Becoming the heartbeat ARCH

ARC2 started with pid=30, OS id=26160

Sun Sep 30 15:35:35 2012

Successfully onlined Undo Tablespace 4.

Sun Sep 30 15:35:35 2012

SMON: enabling tx recovery

Sun Sep 30 15:35:35 2012

Database Characterset is ZHS16GBK

replication_dependency_tracking turned off (no async multimaster replication found)

Starting background process QMNC

QMNC started with pid=32, OS id=26239

Sun Sep 30 15:35:39 2012

Completed: ALTER DATABASE OPEN

Sun Sep 30 15:36:34 2012

ARC1: Archival destination is a Primary RAC instance: 'ORCL1'

Sun Sep 30 15:40:35 2012

Shutting down archive processes

Sun Sep 30 15:40:40 2012

ARCH shutting down

ARC2: Archival stopped

Redo Shipping Client Connected as PUBLIC

-- Connected User is Valid

RFS[1]: Assigned to RFS process 25775