[oracle@rac01 ~]$ crs_stat -t
Name Type Target State Host
------------------------------------------------------------
ora.dba.db application ONLINE ONLINE rac01
ora....a1.inst application ONLINE ONLINE rac01
ora....a2.inst application ONLINE ONLINE rac02
ora....SM1.asm application ONLINE ONLINE rac01
ora....01.lsnr application ONLINE ONLINE rac01
ora.rac01.gsd application ONLINE ONLINE rac01
ora.rac01.ons application ONLINE ONLINE rac01
ora.rac01.vip application ONLINE ONLINE rac01
ora....SM2.asm application ONLINE ONLINE rac02
ora....02.lsnr application ONLINE ONLINE rac02
ora.rac02.gsd application ONLINE ONLINE rac02
ora.rac02.ons application ONLINE ONLINE rac02
ora.rac02.vip application ONLINE ONLINE rac02
[oracle@rac01 ~]$ ps -ef |grep oracle
oracle 712 8301 0 11:55 pts/4 00:00:00 ps -ef
oracle 713 8301 0 11:55 pts/4 00:00:00 grep oracle
root 3457 1 0 10:30 ? 00:00:00 /bin/su -l oracle -c sh -c 'ulimit -c unlimited; cd /data/oracle/product/10.2.0/crs_1/log/rac01/evmd; exec /data/oracle/product/10.2.0/crs_1/bin/evmd '
root 3465 1 0 10:30 ? 00:00:03 /data/oracle/product/10.2.0/crs_1/bin/crsd.bin reboot
root 3833 3798 0 10:30 pts/1 00:00:00 su - oracle
oracle 3834 3833 0 10:30 pts/1 00:00:00 -bash
oracle 3909 3457 0 10:31 ? 00:00:00 /data/oracle/product/10.2.0/crs_1/bin/evmd.bin
root 4006 3881 0 10:31 ? 00:00:00 /bin/su -l oracle -c /bin/sh -c 'ulimit -c unlimited; cd /data/oracle/product/10.2.0/crs_1/log/rac01/cssd; /data/oracle/product/10.2.0/crs_1/bin/ocssd || exit $?'
oracle 4007 4006 0 10:31 ? 00:00:00 /bin/sh -c ulimit -c unlimited; cd /data/oracle/product/10.2.0/crs_1/log/rac01/cssd; /data/oracle/product/10.2.0/crs_1/bin/ocssd || exit $?
oracle 4039 4007 0 10:31 ? 00:00:07 /data/oracle/product/10.2.0/crs_1/bin/ocssd.bin
oracle 4335 3909 0 10:31 ? 00:00:00 /data/oracle/product/10.2.0/crs_1/bin/evmlogger.bin -o /data/oracle/product/10.2.0/crs_1/evm/log/evmlogger.info -l /data/oracle/product/10.2.0/crs_1/evm/log/evmlogger.log
root 8300 7889 0 11:17 pts/4 00:00:00 su - oracle
oracle 8301 8300 0 11:17 pts/4 00:00:00 -bash
oracle 12464 1 0 11:20 ? 00:00:00 asm_pmon_+ASM1
oracle 12466 1 0 11:20 ? 00:00:00 asm_diag_+ASM1
oracle 12468 1 0 11:20 ? 00:00:00 asm_psp0_+ASM1
oracle 12470 1 0 11:20 ? 00:00:04 asm_lmon_+ASM1
oracle 12472 1 0 11:20 ? 00:00:04 asm_lmd0_+ASM1
oracle 12477 1 0 11:20 ? 00:00:04 asm_lms0_+ASM1
oracle 12503 1 0 11:20 ? 00:00:00 asm_mman_+ASM1
oracle 12505 1 0 11:20 ? 00:00:00 asm_dbw0_+ASM1
oracle 12507 1 0 11:20 ? 00:00:00 asm_lgwr_+ASM1
oracle 12509 1 0 11:20 ? 00:00:00 asm_ckpt_+ASM1
oracle 12511 1 0 11:20 ? 00:00:00 asm_smon_+ASM1
oracle 12513 1 0 11:20 ? 00:00:00 asm_rbal_+ASM1
oracle 12515 1 0 11:20 ? 00:00:00 asm_gmon_+ASM1
oracle 12542 1 0 11:20 ? 00:00:00 asm_lck0_+ASM1
oracle 12712 1 0 11:20 ? 00:00:00 /data/oracle/product/10.2.0/db_1/bin/racgimon daemon ora.rac01.ASM1.asm
oracle 12757 1 0 11:20 ? 00:00:00 /data/oracle/product/10.2.0/crs_1/opmn/bin/ons -d
oracle 12758 12757 0 11:20 ? 00:00:00 /data/oracle/product/10.2.0/crs_1/opmn/bin/ons -d
oracle 12806 1 0 11:20 ? 00:00:00 /data/oracle/product/10.2.0/db_1/bin/racgimon startd dba
oracle 13014 1 0 11:20 ? 00:00:00 asm_o001_+ASM1
oracle 13091 1 0 11:20 ? 00:00:00 ora_pmon_mega1
oracle 13093 1 0 11:20 ? 00:00:00 ora_diag_mega1
oracle 13095 1 0 11:20 ? 00:00:00 ora_psp0_mega1
oracle 13097 1 0 11:20 ? 00:00:05 ora_lmon_mega1
oracle 13099 1 0 11:20 ? 00:00:07 ora_lmd0_mega1
oracle 13101 1 0 11:20 ? 00:00:14 ora_lms0_mega1
oracle 13105 1 0 11:20 ? 00:00:00 ora_mman_mega1
oracle 13107 1 0 11:20 ? 00:00:00 ora_dbw0_mega1
oracle 13109 1 0 11:20 ? 00:00:00 ora_lgwr_mega1
oracle 13111 1 0 11:20 ? 00:00:00 ora_ckpt_mega1
oracle 13113 1 0 11:20 ? 00:00:00 ora_smon_mega1
oracle 13115 1 0 11:20 ? 00:00:00 ora_reco_mega1
oracle 13117 1 0 11:20 ? 00:00:00 ora_cjq0_mega1
oracle 13119 1 0 11:20 ? 00:00:04 ora_mmon_mega1
oracle 13121 1 0 11:20 ? 00:00:00 ora_mmnl_mega1
oracle 13123 1 0 11:20 ? 00:00:00 ora_d000_mega1
oracle 13125 1 0 11:20 ? 00:00:00 ora_s000_mega1
oracle 13152 1 0 11:20 ? 00:00:00 ora_lck0_mega1
oracle 13159 1 0 11:20 ? 00:00:00 ora_asmb_mega1
oracle 13161 1 0 11:20 ? 00:00:00 oracle+ASM1 (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
oracle 13164 1 0 11:20 ? 00:00:00 ora_rbal_mega1
oracle 13502 1 0 11:20 ? 00:00:00 ora_qmnc_mega1
oracle 13711 1 0 11:20 ? 00:00:00 oraclemega1 (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
oracle 13722 1 0 11:20 ? 00:00:00 /data/oracle/product/10.2.0/db_1/bin/tnslsnr LISTENER_RAC01 -inherit
oracle 13780 1 0 11:20 ? 00:00:00 ora_q000_mega1
oracle 13864 1 0 11:21 ? 00:00:00 oraclemega1 (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
oracle 13872 1 0 11:21 ? 00:00:00 oraclemega1 (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
oracle 13875 1 0 11:21 ? 00:00:00 oraclemega1 (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
oracle 13902 1 0 11:21 ? 00:00:00 ora_q001_mega1
oracle 26526 1 0 11:50 ? 00:00:00 ora_pz99_mega1
oracle 26528 1 0 11:50 ? 00:00:00 ora_pz98_mega1
oracle 30211 1 0 11:31 ? 00:00:00 ora_o001_mega1
[oracle@rac01 ~]$ sqlplus / as sysdba
SQL*Plus: Release 10.2.0.1.0 - Production on Tue Sep 3 12:09:48 2013
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Connected to an idle instance.
SQL> archive log list;
ORA-01034: ORACLE not available
SQL>
alter 日志：
Tue Sep 3 11:20:30 2013
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Interface type 1 bond1 10.0.0.0 configured from OCR for use as a cluster interconnect
Interface type 1 bond0 192.168.1.0 configured from OCR for use as a public interface
Picked latch-free SCN scheme 1
Using LOG_ARCHIVE_DEST_1 parameter default value as /data/oracle/product/10.2.0/db_1/dbs/arch
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 = 150
__shared_pool_size = 113246208
__large_pool_size = 4194304
__java_pool_size = 4194304
__streams_pool_size = 0
spfile = +AMSDISK/dba/spfilemega.ora
sga_target = 285212672
control_files = +AMSDISK/dba/controlfile/current.256.825102207
db_block_size = 8192
__db_cache_size = 159383552
compatible = 10.2.0.1.0
db_file_multiblock_read_count= 16
cluster_database = TRUE
cluster_database_instances= 2
db_create_file_dest = +AMSDISK
thread = 1
instance_number = 1
undo_management = AUTO
undo_tablespace = UNDOTBS1
remote_login_passwordfile= EXCLUSIVE
db_domain =
dispatchers = (PROTOCOL=TCP) (SERVICE=megaXDB)
shared_servers = 1
job_queue_processes = 10
background_dump_dest = /data/oracle/admin/dba/bdump
user_dump_dest = /data/oracle/admin/dba/udump
core_dump_dest = /data/oracle/admin/dba/cdump
audit_file_dest = /data/oracle/admin/dba/adump
db_name = dba
open_cursors = 300
pga_aggregate_target = 94371840
Cluster communication is configured to use the following interface(s) for this instance
10.0.0.12
Tue Sep 3 11:20:31 2013
cluster interconnect IPC version:Oracle UDP/IP
IPC Vendor 1 proto 2
PMON started with pid=2, OS id=13091
DIAG started with pid=3, OS id=13093
PSP0 started with pid=4, OS id=13095
LMON started with pid=5, OS id=13097
LMD0 started with pid=6, OS id=13099
LMS0 started with pid=7, OS id=13101
MMAN started with pid=8, OS id=13105
DBW0 started with pid=9, OS id=13107
LGWR started with pid=10, OS id=13109
CKPT started with pid=11, OS id=13111
SMON started with pid=12, OS id=13113
RECO started with pid=13, OS id=13115
CJQ0 started with pid=14, OS id=13117
MMON started with pid=15, OS id=13119
MMNL started with pid=16, OS id=13121
Tue Sep 3 11:20:31 2013
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
starting up 1 shared server(s) ...
Tue Sep 3 11:20:31 2013
lmon registered with NM - instance id 1 (internal mem no 0)
Tue Sep 3 11:20:32 2013
Reconfiguration started (old inc 0, new inc 2)
pseudo shared rm latch used
List of nodes:
0
Global Resource Directory frozen
* allocate domain 0, invalid = TRUE
Communication channels reestablished
Master broadcasted resource hash value bitmaps
Non-local Process blocks cleaned out
Tue Sep 3 11:20:32 2013
LMS 0: 0 GCS shadows cancelled, 0 closed
Set master node info
Submitted all remote-enqueue requests
Dwn-cvts replayed, VALBLKs dubious
All grantable enqueues granted
Post SMON to start 1st pass IR
Tue Sep 3 11:20:32 2013
LMS 0: 0 GCS shadows traversed, 0 replayed
Tue Sep 3 11:20:32 2013
Submitted all GCS remote-cache requests
Post SMON to start 1st pass IR
Fix write in gcs resources
Reconfiguration complete
LCK0 started with pid=19, OS id=13152
Tue Sep 3 11:20:32 2013
ALTER DATABASE MOUNT
Tue Sep 3 11:20:32 2013
This instance was first to mount
Tue Sep 3 11:20:32 2013
Starting background process ASMB
ASMB started with pid=21, OS id=13159
Starting background process RBAL
RBAL started with pid=22, OS id=13164
Tue Sep 3 11:20:34 2013
Reconfiguration started (old inc 2, new inc 4)
List of nodes:
0 1
Global Resource Directory frozen
Communication channels reestablished
Master broadcasted resource hash value bitmaps
Non-local Process blocks cleaned out
Tue Sep 3 11:20:35 2013
LMS 0: 0 GCS shadows cancelled, 0 closed
Set master node info
Submitted all remote-enqueue requests
Dwn-cvts replayed, VALBLKs dubious
All grantable enqueues granted
Tue Sep 3 11:20:35 2013
LMS 0: 0 GCS shadows traversed, 0 replayed
Tue Sep 3 11:20:35 2013
Submitted all GCS remote-cache requests
Post SMON to start 1st pass IR
Fix write in gcs resources
Reconfiguration complete
Tue Sep 3 11:20:36 2013
SUCCESS: diskgroup AMSDISK was mounted
Tue Sep 3 11:20:40 2013
Setting recovery target incarnation to 1
Tue Sep 3 11:20:40 2013
Successful mount of redo thread 1, with mount id 1284327744
Tue Sep 3 11:20:40 2013
Database mounted in Shared Mode (CLUSTER_DATABASE=TRUE)
Completed: ALTER DATABASE MOUNT
Tue Sep 3 11:20:40 2013
ALTER DATABASE OPEN
This instance was first to open
Tue Sep 3 11:20:41 2013
Beginning crash recovery of 2 threads
Tue Sep 3 11:20:41 2013
Started redo scan
Tue Sep 3 11:20:42 2013
Completed redo scan
37 redo blocks read, 26 data blocks need recovery
Tue Sep 3 11:20:42 2013
Started redo application at
Thread 1: logseq 25, block 112
Thread 2: logseq 3, block 7145, scn 478763
Tue Sep 3 11:20:42 2013
Recovery of Online Redo Log: Thread 1 Group 1 Seq 25 Reading mem 0
Mem# 0 errs 0: +AMSDISK/dba/onlinelog/group_1.257.825102207
Tue Sep 3 11:20:42 2013
Recovery of Online Redo Log: Thread 2 Group 3 Seq 3 Reading mem 0
Mem# 0 errs 0: +AMSDISK/dba/onlinelog/group_3.265.825103265
Tue Sep 3 11:20:42 2013
Completed redo application
Tue Sep 3 11:20:42 2013
Completed crash recovery at
Thread 1: logseq 25, block 143, scn 498843
Thread 2: logseq 3, block 7151, scn 498827
26 data blocks read, 20 data blocks written, 37 redo blocks read
Switch log for thread 2 to sequence 4
Picked broadcast on commit scheme to generate SCNs
Tue Sep 3 11:20:42 2013
Thread 1 advanced to log sequence 26
Thread 1 opened at log sequence 26
Current log# 2 seq# 26 mem# 0: +AMSDISK/dba/onlinelog/group_2.258.825102211
Successful open of redo thread 1
Tue Sep 3 11:20:42 2013
MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set
Tue Sep 3 11:20:42 2013
SMON: enabling cache recovery
Tue Sep 3 11:20:44 2013
Successfully onlined Undo Tablespace 1.
Tue Sep 3 11:20:44 2013
SMON: enabling tx recovery
Tue Sep 3 11:20:44 2013
Database Characterset is ZHS16GBK
replication_dependency_tracking turned off (no async multimaster replication found)
Starting background process QMNC
QMNC started with pid=25, OS id=13502
Tue Sep 3 11:20:52 2013
Completed: ALTER DATABASE OPEN
[oracle@rac01 ~]$
1709
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
