虚拟机模拟部署Extended Clusters(四)故障模拟测试,存储链路恢复

本文涉及的产品
文档理解,结构化解析 100页
教育场景识别,教育场景识别 200次/月
自定义KV模板,自定义KV模板 500次/账号
简介: asm 磁盘组 当链路恢复之后,磁盘状态显示MISSING(CRS_0000,OCR_0000)。 [grid@prod02 ~]$ sqlplus / as sysdba SQL*Plus: Release 11.

asm 磁盘组

当链路恢复之后,磁盘状态显示MISSING(CRS_0000,OCR_0000)。

[grid@prod02 ~]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.4.0 Production on Tue Sep 17 14:49:06 2019

Copyright (c) 1982, 2013, Oracle.  All rights reserved.


Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Real Application Clusters and Automatic Storage Management options

SQL> @c

DG_NAME     DG_STATE   TYPE       DSK_NO DSK_NAME    PATH                           MOUNT_S FAILGROUP        STATE
--------------- ---------- ------ ---------- ---------- -------------------------------------------------- ------- -------------------- --------
CRS        MOUNTED    NORMAL       2 CRS_0002    /dev/oracleasm/disks/DISK03               CACHED  ZCDISK        NORMAL
CRS        MOUNTED    NORMAL       5 CRS_0005    /dev/oracleasm/disks/VOTEDB02               CACHED  CRS_0001        NORMAL
CRS        MOUNTED    NORMAL       9 CRS_0009                               MISSING CRS_0000        NORMAL
OCR        MOUNTED    NORMAL       0 OCR_0000                               MISSING OCR_0000        NORMAL
OCR        MOUNTED    NORMAL       1 OCR_0001    /dev/oracleasm/disks/NODE02DATA01           CACHED  OCR_0001        NORMAL


DISK_NUMBER NAME       PATH                          HEADER_STATUS         OS_MB   TOTAL_MB    FREE_MB REPAIR_TIMER V FAILGRO
----------- ---------- -------------------------------------------------- -------------------- ---------- ---------- ---------- ------------ - -------
      0           /dev/oracleasm/disks/NODE01DATA01          MEMBER             5120       0          0        0 N REGULAR
      1           /dev/oracleasm/disks/VOTEDB01              MEMBER             2048       0          0        0 Y REGULAR
      0 OCR_0000                              UNKNOWN            0    5120       3185        12410 N REGULAR
      9 CRS_0009                              UNKNOWN            0    2048       1584        12410 N REGULAR
      1 OCR_0001   /dev/oracleasm/disks/NODE02DATA01          MEMBER             5120    5120       3185        0 N REGULAR
      5 CRS_0005   /dev/oracleasm/disks/VOTEDB02              MEMBER             2048    2048       1648        0 Y REGULAR
      2 CRS_0002   /dev/oracleasm/disks/DISK03              MEMBER             5115    5115       5081        0 Y QUORUM

7 rows selected.


GROUP_NUMBER NAME    COMPATIBILITY                             DATABASE_COMPATIBILITY                      V
------------ ---------- ------------------------------------------------------------ ------------------------------------------------------------ -
       1 OCR    11.2.0.0.0                             11.2.0.0.0                           N
       2 CRS    11.2.0.0.0                             11.2.0.0.0                           Y

SQL>

恢复方法(在存活节点操作)

[grid@prod02 ~]$ sqlplus / as sysasm

SQL*Plus: Release 11.2.0.4.0 Production on Tue Sep 17 14:51:45 2019

Copyright (c) 1982, 2013, Oracle.  All rights reserved.


Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Real Application Clusters and Automatic Storage Management options

SQL> ALTER DISKGROUP crs online all;

Diskgroup altered.

SQL> ALTER DISKGROUP ocr online all;

Diskgroup altered.

SQL>

磁盘组状态显示:

[grid@prod02 ~]$ sqlplus / as sysasm

SQL*Plus: Release 11.2.0.4.0 Production on Tue Sep 17 14:52:55 2019

Copyright (c) 1982, 2013, Oracle.  All rights reserved.


Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Real Application Clusters and Automatic Storage Management options

SQL> @c

DG_NAME     DG_STATE   TYPE       DSK_NO DSK_NAME    PATH                           MOUNT_S FAILGROUP        STATE
--------------- ---------- ------ ---------- ---------- -------------------------------------------------- ------- -------------------- --------
CRS        MOUNTED    NORMAL       2 CRS_0002    /dev/oracleasm/disks/DISK03               CACHED  ZCDISK        NORMAL
CRS        MOUNTED    NORMAL       5 CRS_0005    /dev/oracleasm/disks/VOTEDB02               CACHED  CRS_0001        NORMAL
CRS        MOUNTED    NORMAL       9 CRS_0009    /dev/oracleasm/disks/VOTEDB01               CACHED  CRS_0000        NORMAL
OCR        MOUNTED    NORMAL       0 OCR_0000    /dev/oracleasm/disks/NODE01DATA01           CACHED  OCR_0000        NORMAL
OCR        MOUNTED    NORMAL       1 OCR_0001    /dev/oracleasm/disks/NODE02DATA01           CACHED  OCR_0001        NORMAL


DISK_NUMBER NAME       PATH                          HEADER_STATUS         OS_MB   TOTAL_MB    FREE_MB REPAIR_TIMER V FAILGRO
----------- ---------- -------------------------------------------------- -------------------- ---------- ---------- ---------- ------------ - -------
      0 OCR_0000   /dev/oracleasm/disks/NODE01DATA01          MEMBER             5120    5120       3184        0 N REGULAR
      1 OCR_0001   /dev/oracleasm/disks/NODE02DATA01          MEMBER             5120    5120       3184        0 N REGULAR
      9 CRS_0009   /dev/oracleasm/disks/VOTEDB01              MEMBER             2048    2048       1552        0 Y REGULAR
      5 CRS_0005   /dev/oracleasm/disks/VOTEDB02              MEMBER             2048    2048       1648        0 Y REGULAR
      2 CRS_0002   /dev/oracleasm/disks/DISK03              MEMBER             5115    5115       5081        0 Y QUORUM


GROUP_NUMBER NAME    COMPATIBILITY                             DATABASE_COMPATIBILITY                      V
------------ ---------- ------------------------------------------------------------ ------------------------------------------------------------ -
       1 OCR    11.2.0.0.0                             11.2.0.0.0                           N
       2 CRS    11.2.0.0.0                             11.2.0.0.0                           Y

SQL>

注意事项!!!,否则不能执行online 操作。

磁盘组属性11.2.0.0.0(DATABASE_COMPATIBILITY,COMPATIBILITY)

集群软件和数据库不需要操作,自动恢复。

[grid@prod01 ~]$ crsctl stat res -t 
--------------------------------------------------------------------------------
NAME           TARGET  STATE        SERVER                   STATE_DETAILS       
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.CRS.dg
               ONLINE  ONLINE       prod01                                       
               ONLINE  ONLINE       prod02                                       
ora.LISTENER.lsnr
               ONLINE  ONLINE       prod01                                       
               ONLINE  ONLINE       prod02                                       
ora.OCR.dg
               ONLINE  ONLINE       prod01                                       
               ONLINE  ONLINE       prod02                                       
ora.asm
               ONLINE  ONLINE       prod01                   Started             
               ONLINE  ONLINE       prod02                   Started             
ora.gsd
               OFFLINE OFFLINE      prod01                                       
               OFFLINE OFFLINE      prod02                                       
ora.net1.network
               ONLINE  ONLINE       prod01                                       
               ONLINE  ONLINE       prod02                                       
ora.ons
               ONLINE  ONLINE       prod01                                       
               ONLINE  ONLINE       prod02                                       
ora.registry.acfs
               ONLINE  ONLINE       prod01                                       
               ONLINE  ONLINE       prod02                                       
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.LISTENER_SCAN1.lsnr
      1        ONLINE  ONLINE       prod02                                       
ora.cvu
      1        ONLINE  ONLINE       prod02                                       
ora.oc4j
      1        ONLINE  ONLINE       prod02                                       
ora.ora.db
      1        ONLINE  ONLINE       prod01                   Open                
      2        ONLINE  ONLINE       prod02                   Open                
ora.prod01.vip
      1        ONLINE  ONLINE       prod01                                       
ora.prod02.vip
      1        ONLINE  ONLINE       prod02                                       
ora.scan1.vip
      1        ONLINE  ONLINE       prod02                                       
[grid@prod01 ~]$

prod01 grid log:

2019-09-17 14:49:12.688: 
[/u01/app/11.2.0/grid/bin/cssdagent(42554)]CRS-5818:Aborted command 'start' for resource 'ora.cssd'. Details at (:CRSAGF00113:) {0:15:28} in /u01/app/11.2.0/grid/log/prod01/agent/ohasd/oracssdagent_root/oracssdagent_root.log.
2019-09-17 14:49:13.787: 
[ohasd(36900)]CRS-2878:Failed to restart resource 'ora.cssd'
2019-09-17 14:49:13.788: 
[ohasd(36900)]CRS-2769:Unable to failover resource 'ora.cssd'.
2019-09-17 14:49:15.267: 
[cssd(44154)]CRS-1713:CSSD daemon is started in clustered mode
2019-09-17 14:49:26.061: 
[cssd(44154)]CRS-1707:Lease acquisition for node prod01 number 1 completed
2019-09-17 14:49:27.365: 
[cssd(44154)]CRS-1605:CSSD voting file is online: /dev/oracleasm/disks/VOTEDB02; details in /u01/app/11.2.0/grid/log/prod01/cssd/ocssd.log.
2019-09-17 14:49:27.373: 
[cssd(44154)]CRS-1605:CSSD voting file is online: /dev/oracleasm/disks/DISK03; details in /u01/app/11.2.0/grid/log/prod01/cssd/ocssd.log.
2019-09-17 14:49:29.932: 
[cssd(44154)]CRS-1601:CSSD Reconfiguration complete. Active nodes are prod01 prod02 .
2019-09-17 14:49:31.272: 
[ohasd(36900)]CRS-2878:Failed to restart resource 'ora.cssd'
2019-09-17 14:49:32.293: 
[ctssd(44276)]CRS-2403:The Cluster Time Synchronization Service on host prod01 is in observer mode.
2019-09-17 14:49:32.600: 
[ctssd(44276)]CRS-2407:The new Cluster Time Synchronization Service reference node is host prod02.
2019-09-17 14:49:32.602: 
[ctssd(44276)]CRS-2401:The Cluster Time Synchronization Service started on host prod01.
2019-09-17 14:49:34.282: 
[ohasd(36900)]CRS-2767:Resource state recovery not attempted for 'ora.diskmon' as its target state is OFFLINE
2019-09-17 14:49:34.282: 
[ohasd(36900)]CRS-2769:Unable to failover resource 'ora.diskmon'.
2019-09-17 14:49:41.580: 
[/u01/app/11.2.0/grid/bin/oraagent.bin(37016)]CRS-5011:Check of resource "+ASM" failed: details at "(:CLSN00006:)" in "/u01/app/11.2.0/grid/log/prod01/agent/ohasd/oraagent_grid/oraagent_grid.log"
2019-09-17 14:49:42.635: 
[ctssd(44276)]CRS-2409:The clock on host prod01 is not synchronous with the mean cluster time. No action has been taken as the Cluster Time Synchronization Service is running in observer mode.
2019-09-17 14:49:46.814: 
[/u01/app/11.2.0/grid/bin/oraagent.bin(37016)]CRS-5011:Check of resource "+ASM" failed: details at "(:CLSN00006:)" in "/u01/app/11.2.0/grid/log/prod01/agent/ohasd/oraagent_grid/oraagent_grid.log"
2019-09-17 14:49:58.993: 
[ohasd(36900)]CRS-2878:Failed to restart resource 'ora.asm'
2019-09-17 14:50:00.024: 
[ohasd(36900)]CRS-2878:Failed to restart resource 'ora.crsd'
2019-09-17 14:50:05.917: 
[crsd(44448)]CRS-1012:The OCR service started on node prod01.
2019-09-17 14:50:05.943: 
[evmd(44295)]CRS-1401:EVMD started on node prod01.
2019-09-17 14:50:07.250: 
[crsd(44448)]CRS-1201:CRSD started on node prod01.
2019-09-17 14:50:08.757: 
[/u01/app/11.2.0/grid/bin/oraagent.bin(44611)]CRS-5011:Check of resource "ora" failed: details at "(:CLSN00007:)" in "/u01/app/11.2.0/grid/log/prod01/agent/crsd/oraagent_oracle/oraagent_oracle.log"
2019-09-17 14:52:02.203: 
[cssd(44154)]CRS-1605:CSSD voting file is online: /dev/oracleasm/disks/VOTEDB01; details in /u01/app/11.2.0/grid/log/prod01/cssd/ocssd.log.
2019-09-17 14:52:02.203: 
[cssd(44154)]CRS-1626:A Configuration change request completed successfully
2019-09-17 14:52:02.217: 
[cssd(44154)]CRS-1601:CSSD Reconfiguration complete. Active nodes are prod01 prod02 .

prod01 asm log:

Tue Sep 17 14:49:52 2019
NOTE: No asm libraries found in the system
MEMORY_TARGET defaulting to 1128267776.
* instance_number obtained from CSS = 1, checking for the existence of node 0... 
* node 0 does not exist. instance_number = 1 
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Initial number of CPU is 8
Number of processor cores in the system is 8
Number of processor sockets in the system is 8
Private Interface 'eth1:1' configured from GPnP for use as a private interconnect.
  [name='eth1:1', type=1, ip=169.254.237.99, mac=00-0c-29-1e-dd-e5, net=169.254.0.0/16, mask=255.255.0.0, use=haip:cluster_interconnect/62]
Public Interface 'eth0' configured from GPnP for use as a public interface.
  [name='eth0', type=1, ip=192.168.0.230, mac=00-0c-29-1e-dd-db, net=192.168.0.0/24, mask=255.255.255.0, use=public/1]
CELL communication is configured to use 0 interface(s):
CELL IP affinity details:
    NUMA status: non-NUMA system
    cellaffinity.ora status: N/A
CELL communication will use 1 IP group(s):
    Grp 0: 
Picked latch-free SCN scheme 3
Using LOG_ARCHIVE_DEST_1 parameter default value as /u01/app/11.2.0/grid/dbs/arch
Autotune of undo retention is turned on. 
LICENSE_MAX_USERS = 0
SYS auditing is disabled
NOTE: Volume support  enabled
Starting up:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Real Application Clusters and Automatic Storage Management options.
ORACLE_HOME = /u01/app/11.2.0/grid
System name:    Linux
Node name:    prod01
Release:    2.6.32-642.el6.x86_64
Version:    #1 SMP Wed Apr 13 00:51:26 EDT 2016
Machine:    x86_64
VM name:    VMWare Version: 6
Using parameter settings in server-side spfile +CRS/prod-cluster01/asmparameterfile/registry.253.993388635
System parameters with non-default values:
  large_pool_size          = 12M
  instance_type            = "asm"
  remote_login_passwordfile= "EXCLUSIVE"
  asm_diskstring           = "/dev/oracleasm/disks/*"
  asm_diskgroups           = "VOTE"
  asm_diskgroups           = "OCR"
  asm_power_limit          = 1
  _asm_storagemaysplit     = TRUE
  diagnostic_dest          = "/u01/app/grid"
Cluster communication is configured to use the following interface(s) for this instance
  169.254.237.99
cluster interconnect IPC version:Oracle UDP/IP (generic)
IPC Vendor 1 proto 2
Tue Sep 17 14:49:53 2019
PMON started with pid=2, OS id=44340 
Tue Sep 17 14:49:53 2019
PSP0 started with pid=3, OS id=44342 
Tue Sep 17 14:49:54 2019
VKTM started with pid=4, OS id=44345 at elevated priority
VKTM running at (1)millisec precision with DBRM quantum (100)ms
Tue Sep 17 14:49:54 2019
GEN0 started with pid=5, OS id=44349 
Tue Sep 17 14:49:54 2019
DIAG started with pid=6, OS id=44351 
Tue Sep 17 14:49:54 2019
PING started with pid=7, OS id=44353 
Tue Sep 17 14:49:54 2019
DIA0 started with pid=8, OS id=44355 
Tue Sep 17 14:49:54 2019
LMON started with pid=9, OS id=44357 
Tue Sep 17 14:49:54 2019
LMD0 started with pid=10, OS id=44359 
* Load Monitor used for high load check 
* New Low - High Load Threshold Range = [7680 - 10240] 
Tue Sep 17 14:49:54 2019
LMS0 started with pid=11, OS id=44361 at elevated priority
Tue Sep 17 14:49:54 2019
LMHB started with pid=12, OS id=44365 
Tue Sep 17 14:49:54 2019
MMAN started with pid=13, OS id=44367 
Tue Sep 17 14:49:54 2019
DBW0 started with pid=14, OS id=44369 
Tue Sep 17 14:49:54 2019
LGWR started with pid=15, OS id=44371 
Tue Sep 17 14:49:54 2019
CKPT started with pid=16, OS id=44373 
Tue Sep 17 14:49:54 2019
SMON started with pid=17, OS id=44375 
Tue Sep 17 14:49:54 2019
RBAL started with pid=18, OS id=44377 
Tue Sep 17 14:49:54 2019
GMON started with pid=19, OS id=44379 
Tue Sep 17 14:49:54 2019
MMON started with pid=20, OS id=44381 
Tue Sep 17 14:49:54 2019
MMNL started with pid=21, OS id=44383 
lmon registered with NM - instance number 1 (internal mem no 0)
Reconfiguration started (old inc 0, new inc 40)
ASM instance 
List of instances:
 1 2 (myinst: 1) 
 Global Resource Directory frozen
* allocate domain 0, invalid = TRUE 
 Communication channels reestablished
* allocate domain 2, invalid = TRUE 
* allocate domain 1, invalid = TRUE 
 * domain 0 valid = 1 according to instance 2 
 * domain 2 valid = 1 according to instance 2 
 * domain 1 valid = 1 according to instance 2 
 Master broadcasted resource hash value bitmaps
 Non-local Process blocks cleaned out
 LMS 0: 0 GCS shadows cancelled, 0 closed, 0 Xw survived
 Set master node info 
 Submitted all remote-enqueue requests
 Dwn-cvts replayed, VALBLKs dubious
 All grantable enqueues granted
 Submitted all GCS remote-cache requests
 Fix write in gcs resources
Reconfiguration complete
Tue Sep 17 14:49:55 2019
LCK0 started with pid=22, OS id=44386 
ORACLE_BASE not set in environment. It is recommended
that ORACLE_BASE be set in the environment
Tue Sep 17 14:49:57 2019
SQL> ALTER DISKGROUP ALL MOUNT /* asm agent call crs *//* {0:9:7} */ 
NOTE: Diskgroups listed in ASM_DISKGROUPS are
      VOTE
      OCR
NOTE: Diskgroup used for Voting files is:
      CRS
Diskgroup with spfile:CRS
Diskgroup used for OCR is:OCR
NOTE: cache registered group OCR number=1 incarn=0xf62b4c86
NOTE: cache began mount (not first) of group OCR number=1 incarn=0xf62b4c86
NOTE: cache registered group CRS number=2 incarn=0x801b4c85
NOTE: cache began mount (not first) of group CRS number=2 incarn=0x801b4c85
NOTE: cache registered group VOTE number=3 incarn=0xe5ab4c87
NOTE: cache began mount (first) of group VOTE number=3 incarn=0xe5ab4c87
NOTE: Assigning number (1,1) to disk (/dev/oracleasm/disks/NODE02DATA01)
NOTE: Assigning number (1,0) to disk (/dev/oracleasm/disks/NODE01DATA01)
NOTE: cache closing disk 0 of grp 1: (not open) OCR_0000
NOTE: Assigning number (2,5) to disk (/dev/oracleasm/disks/VOTEDB02)
NOTE: Assigning number (2,9) to disk (/dev/oracleasm/disks/VOTEDB01)
NOTE: Assigning number (2,2) to disk (/dev/oracleasm/disks/DISK03)
NOTE: cache closing disk 9 of grp 2: (not open) CRS_0009
ERROR: no read quorum in group: required 2, found 0 disks
NOTE: cache dismounting (clean) group 3/0xE5AB4C87 (VOTE) 
NOTE: messaging CKPT to quiesce pins Unix process pid: 44399, image: oracle@prod01 (TNS V1-V3)
NOTE: dbwr not being msg'd to dismount
NOTE: lgwr not being msg'd to dismount
NOTE: cache dismounted group 3/0xE5AB4C87 (VOTE) 
NOTE: cache ending mount (fail) of group VOTE number=3 incarn=0xe5ab4c87
NOTE: cache deleting context for group VOTE 3/0xe5ab4c87
GMON dismounting group 3 at 4 for pid 23, osid 44399
ERROR: diskgroup VOTE was not mounted
GMON querying group 1 at 5 for pid 23, osid 44399
NOTE: cache closing disk 0 of grp 1: (not open) OCR_0000
NOTE: cache opening disk 1 of grp 1: OCR_0001 path:/dev/oracleasm/disks/NODE02DATA01
NOTE: F1X0 found on disk 1 au 2 fcn 0.7444
NOTE: cache mounting (not first) normal redundancy group 1/0xF62B4C86 (OCR)
kjbdomatt send to inst 2
NOTE: attached to recovery domain 1
NOTE: redo buffer size is 256 blocks (1053184 bytes)
NOTE: LGWR attempting to mount thread 1 for diskgroup 1 (OCR)
Process LGWR (pid 44371) is running at high priority QoS for Exadata I/O
NOTE: LGWR found thread 1 closed at ABA 6.290
NOTE: LGWR mounted thread 1 for diskgroup 1 (OCR)
NOTE: LGWR opening thread 1 at fcn 0.7444 ABA 7.291
NOTE: cache mounting group 1/0xF62B4C86 (OCR) succeeded
NOTE: cache ending mount (success) of group OCR number=1 incarn=0xf62b4c86
GMON querying group 2 at 6 for pid 23, osid 44399
NOTE: cache closing disk 9 of grp 2: (not open) CRS_0009
NOTE: cache opening disk 2 of grp 2: CRS_0002 path:/dev/oracleasm/disks/DISK03
NOTE: cache opening disk 5 of grp 2: CRS_0005 path:/dev/oracleasm/disks/VOTEDB02
NOTE: F1X0 found on disk 5 au 2 fcn 0.197448
NOTE: cache mounting (not first) normal redundancy group 2/0x801B4C85 (CRS)
kjbdomatt send to inst 2
NOTE: attached to recovery domain 2
NOTE: redo buffer size is 256 blocks (1053184 bytes)
NOTE: LGWR attempting to mount thread 2 for diskgroup 2 (CRS)
NOTE: LGWR found thread 2 closed at ABA 25.705
NOTE: LGWR mounted thread 2 for diskgroup 2 (CRS)
NOTE: LGWR opening thread 2 at fcn 0.197448 ABA 26.706
NOTE: cache mounting group 2/0x801B4C85 (CRS) succeeded
NOTE: cache ending mount (success) of group CRS number=2 incarn=0x801b4c85
NOTE: Instance updated compatible.asm to 11.2.0.0.0 for grp 1
SUCCESS: diskgroup OCR was mounted
NOTE: Instance updated compatible.asm to 11.2.0.0.0 for grp 2
SUCCESS: diskgroup CRS was mounted
ORA-15032: not all alterations performed
ORA-15017: diskgroup "VOTE" cannot be mounted
ORA-15040: diskgroup is incomplete
ERROR: ALTER DISKGROUP ALL MOUNT /* asm agent call crs *//* {0:9:7} */
SQL> ALTER DISKGROUP ALL ENABLE VOLUME ALL /* asm agent *//* {0:9:7} */ 
SUCCESS: ALTER DISKGROUP ALL ENABLE VOLUME ALL /* asm agent *//* {0:9:7} */
WARNING: failed to online diskgroup resource ora.OCR.dg (unable to communicate with CRSD/OHASD)
Tue Sep 17 14:50:00 2019
NOTE: [crsd.bin@prod01 (TNS V1-V3) 44448] opening OCR file
Starting background process ASMB
Tue Sep 17 14:50:00 2019
ASMB started with pid=25, OS id=44471 
Tue Sep 17 14:50:00 2019
NOTE: client +ASM1:+ASM registered, osid 44473, mbr 0x0
NOTE: Attempting voting file refresh on diskgroup CRS
NOTE: Refresh completed on diskgroup CRS
. Found 2 voting file(s).
NOTE: Voting file relocation is required in diskgroup CRS
NOTE: Attempting voting file relocation on diskgroup CRS
NOTE: Successful voting file relocation on diskgroup CRS
WARNING: failed to online diskgroup resource ora.CRS.dg (unable to communicate with CRSD/OHASD)
Tue Sep 17 14:50:37 2019
NOTE: client ora1:ora registered, osid 44859, mbr 0x1
Tue Sep 17 14:51:08 2019
ALTER SYSTEM SET local_listener=' (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.0.232)(PORT=1521))))' SCOPE=MEMORY SID='+ASM1';
Tue Sep 17 14:51:51 2019
NOTE: disk validation pending for group 2/0x801b4c85 (CRS)
NOTE: Attempting voting file refresh on diskgroup CRS
NOTE: Refresh completed on diskgroup CRS
. Found 2 voting file(s).
NOTE: Voting file relocation is required in diskgroup CRS
NOTE: Found /dev/oracleasm/disks/VOTEDB01 for disk CRS_0009
WARNING: ignoring disk  in deep discovery
SUCCESS: validated disks for 2/0x801b4c85 (CRS)
NOTE: membership refresh pending for group 2/0x801b4c85 (CRS)
NOTE: Attempting voting file relocation on diskgroup CRS
NOTE: Successful voting file relocation on diskgroup CRS
Tue Sep 17 14:51:57 2019
GMON querying group 2 at 9 for pid 18, osid 44377
NOTE: cache opening disk 9 of grp 2: CRS_0009 path:/dev/oracleasm/disks/VOTEDB01
SUCCESS: refreshed membership for 2/0x801b4c85 (CRS)
NOTE: Attempting voting file refresh on diskgroup CRS
NOTE: Refresh completed on diskgroup CRS
. Found 2 voting file(s).
NOTE: Voting file relocation is required in diskgroup CRS
NOTE: Attempting voting file relocation on diskgroup CRS
NOTE: voting file allocation on grp 2 disk CRS_0009
Tue Sep 17 14:52:02 2019
NOTE: Successful voting file relocation on diskgroup CRS
NOTE: Voting File refresh pending for group 2/0x801b4c85 (CRS)
NOTE: disk validation pending for group 1/0xf62b4c86 (OCR)
NOTE: Found /dev/oracleasm/disks/NODE01DATA01 for disk OCR_0000
WARNING: ignoring disk  in deep discovery
SUCCESS: validated disks for 1/0xf62b4c86 (OCR)
NOTE: Attempting voting file refresh on diskgroup CRS
NOTE: Refresh completed on diskgroup CRS
. Found 3 voting file(s).
Tue Sep 17 14:52:08 2019
NOTE: group OCR: updated PST location: disk 0001 (PST copy 0)
NOTE: group OCR: updated PST location: disk 0000 (PST copy 1)
NOTE: membership refresh pending for group 1/0xf62b4c86 (OCR)
GMON querying group 1 at 10 for pid 18, osid 44377
NOTE: group OCR: updated PST location: disk 0001 (PST copy 0)
NOTE: group OCR: updated PST location: disk 0000 (PST copy 1)
NOTE: cache opening disk 0 of grp 1: OCR_0000 path:/dev/oracleasm/disks/NODE01DATA01
SUCCESS: refreshed membership for 1/0xf62b4c86 (OCR)
NOTE: Voting File refresh pending for group 1/0xf62b4c86 (OCR)
Tue Sep 17 14:52:17 2019
NOTE: Attempting voting file refresh on diskgroup OCR
NOTE: Refresh completed on diskgroup OCR. No voting file found.

prod01 db log:

Tue Sep 17 14:50:29 2019
Adjusting the default value of parameter parallel_max_servers
from 320 to 120 due to the value of parameter processes (150)
Starting ORACLE instance (normal)
************************ Large Pages Information *******************
Per process system memlock (soft) limit = UNLIMITED
 
Total Shared Global Region in Large Pages = 0 KB (0%)
 
Large Pages used by this instance: 0 (0 KB)
Large Pages unused system wide = 0 (0 KB)
Large Pages configured system wide = 0 (0 KB)
Large Page size = 2048 KB
 
RECOMMENDATION:
  Total System Global Area size is 770 MB. For optimal performance,
  prior to the next instance restart:
  1. Increase the number of unused large pages by 
 at least 385 (page size 2048 KB, total size 770 MB) system wide to
  get 100% of the System Global Area allocated with large pages
********************************************************************
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Initial number of CPU is 8
Number of processor cores in the system is 8
Number of processor sockets in the system is 8
Private Interface 'eth1:1' configured from GPnP for use as a private interconnect.
  [name='eth1:1', type=1, ip=169.254.237.99, mac=00-0c-29-1e-dd-e5, net=169.254.0.0/16, mask=255.255.0.0, use=haip:cluster_interconnect/62]
Public Interface 'eth0' configured from GPnP for use as a public interface.
  [name='eth0', type=1, ip=192.168.0.230, mac=00-0c-29-1e-dd-db, net=192.168.0.0/24, mask=255.255.255.0, use=public/1]
Public Interface 'eth0:1' configured from GPnP for use as a public interface.
  [name='eth0:1', type=1, ip=192.168.0.232, mac=00-0c-29-1e-dd-db, net=192.168.0.0/24, mask=255.255.255.0, use=public/1]
CELL communication is configured to use 0 interface(s):
CELL IP affinity details:
    NUMA status: non-NUMA system
    cellaffinity.ora status: N/A
CELL communication will use 1 IP group(s):
    Grp 0: 
Picked latch-free SCN scheme 3
Using LOG_ARCHIVE_DEST_1 parameter default value as /u01/app/oracle/product/11.2.0/db_1/dbs/arch
Autotune of undo retention is turned on. 
LICENSE_MAX_USERS = 0
SYS auditing is disabled
Starting up:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, Real Application Clusters, OLAP, Data Mining
and Real Application Testing options.
ORACLE_HOME = /u01/app/oracle/product/11.2.0/db_1
System name:    Linux
Node name:    prod01
Release:    2.6.32-642.el6.x86_64
Version:    #1 SMP Wed Apr 13 00:51:26 EDT 2016
Machine:    x86_64
VM name:    VMWare Version: 6
Using parameter settings in server-side pfile /u01/app/oracle/product/11.2.0/db_1/dbs/initora1.ora
System parameters with non-default values:
  processes                = 150
  spfile                   = "+OCR/ora/spfileora.ora"
  sga_target               = 768M
  control_files            = "+OCR/ora/controlfile/current.260.1019221637"
  db_block_size            = 8192
  compatible               = "11.2.0.4.0"
  cluster_database         = TRUE
  db_create_file_dest      = "+OCR"
  thread                   = 1
  undo_tablespace          = "UNDOTBS1"
  instance_number          = 1
  remote_login_passwordfile= "EXCLUSIVE"
  db_domain                = ""
  dispatchers              = "(PROTOCOL=TCP) (SERVICE=oraXDB)"
  remote_listener          = "scan:1521"
  audit_file_dest          = "/u01/app/oracle/admin/ora/adump"
  audit_trail              = "DB"
  db_name                  = "ora"
  open_cursors             = 300
  pga_aggregate_target     = 256M
  diagnostic_dest          = "/u01/app/oracle"
Cluster communication is configured to use the following interface(s) for this instance
  169.254.237.99
cluster interconnect IPC version:Oracle UDP/IP (generic)
IPC Vendor 1 proto 2
Tue Sep 17 14:50:35 2019
PMON started with pid=2, OS id=44805 
Tue Sep 17 14:50:35 2019
PSP0 started with pid=3, OS id=44807 
Tue Sep 17 14:50:36 2019
VKTM started with pid=4, OS id=44809 at elevated priority
VKTM running at (1)millisec precision with DBRM quantum (100)ms
Tue Sep 17 14:50:36 2019
GEN0 started with pid=5, OS id=44813 
Tue Sep 17 14:50:36 2019
DIAG started with pid=6, OS id=44815 
Tue Sep 17 14:50:36 2019
DBRM started with pid=7, OS id=44817 
Tue Sep 17 14:50:36 2019
PING started with pid=8, OS id=44819 
Tue Sep 17 14:50:36 2019
ACMS started with pid=9, OS id=44821 
Tue Sep 17 14:50:36 2019
DIA0 started with pid=10, OS id=44823 
Tue Sep 17 14:50:36 2019
LMON started with pid=11, OS id=44825 
Tue Sep 17 14:50:36 2019
LMD0 started with pid=12, OS id=44827 
* Load Monitor used for high load check 
* New Low - High Load Threshold Range = [7680 - 10240] 
Tue Sep 17 14:50:36 2019
LMS0 started with pid=13, OS id=44829 at elevated priority
Tue Sep 17 14:50:36 2019
LMS1 started with pid=14, OS id=44833 at elevated priority
Tue Sep 17 14:50:37 2019
RMS0 started with pid=15, OS id=44837 
Tue Sep 17 14:50:37 2019
LMHB started with pid=16, OS id=44839 
Tue Sep 17 14:50:37 2019
MMAN started with pid=17, OS id=44841 
Tue Sep 17 14:50:37 2019
DBW0 started with pid=18, OS id=44843 
Tue Sep 17 14:50:37 2019
LGWR started with pid=19, OS id=44845 
Tue Sep 17 14:50:37 2019
CKPT started with pid=20, OS id=44847 
Tue Sep 17 14:50:37 2019
SMON started with pid=21, OS id=44849 
Tue Sep 17 14:50:37 2019
RECO started with pid=22, OS id=44851 
Tue Sep 17 14:50:37 2019
RBAL started with pid=23, OS id=44853 
Tue Sep 17 14:50:37 2019
ASMB started with pid=24, OS id=44855 
Tue Sep 17 14:50:37 2019
MMON started with pid=25, OS id=44857 
Tue Sep 17 14:50:37 2019
MMNL started with pid=26, OS id=44861 
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
NOTE: initiating MARK startup 
starting up 1 shared server(s) ...Starting background process MARK

Tue Sep 17 14:50:37 2019
MARK started with pid=28, OS id=44865 
NOTE: MARK has subscribed 
lmon registered with NM - instance number 1 (internal mem no 0)
Reconfiguration started (old inc 0, new inc 16)
List of instances:
 1 2 (myinst: 1) 
 Global Resource Directory frozen
* allocate domain 0, invalid = TRUE 
 Communication channels reestablished
 * domain 0 valid according to instance 2 
 * domain 0 valid = 1 according to instance 2 
 Master broadcasted resource hash value bitmaps
 Non-local Process blocks cleaned out
 LMS 1: 0 GCS shadows cancelled, 0 closed, 0 Xw survived
 LMS 0: 0 GCS shadows cancelled, 0 closed, 0 Xw survived
 Set master node info 
 Submitted all remote-enqueue requests
 Dwn-cvts replayed, VALBLKs dubious
 All grantable enqueues granted
 Submitted all GCS remote-cache requests
 Fix write in gcs resources
Reconfiguration complete
Tue Sep 17 14:50:38 2019
LCK0 started with pid=31, OS id=44873 
Starting background process RSMN
Tue Sep 17 14:50:38 2019
RSMN started with pid=32, OS id=44875 
ORACLE_BASE not set in environment. It is recommended
that ORACLE_BASE be set in the environment
Tue Sep 17 14:50:39 2019
ALTER SYSTEM SET local_listener=' (ADDRESS=(PROTOCOL=TCP)(HOST=192.168.0.232)(PORT=1521))' SCOPE=MEMORY SID='ora1';
ALTER DATABASE MOUNT /* db agent *//* {1:13741:2} */
NOTE: Loaded library: System 
SUCCESS: diskgroup OCR was mounted
NOTE: dependency between database ora and diskgroup resource ora.OCR.dg is established
Successful mount of redo thread 1, with mount id 1637464745
Database mounted in Shared Mode (CLUSTER_DATABASE=TRUE)
Lost write protection disabled
Completed: ALTER DATABASE MOUNT /* db agent *//* {1:13741:2} */
ALTER DATABASE OPEN /* db agent *//* {1:13741:2} */
Picked broadcast on commit scheme to generate SCNs
Thread 1 opened at log sequence 6
  Current log# 2 seq# 6 mem# 0: +OCR/ora/onlinelog/group_2.262.1019221641
Successful open of redo thread 1
MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set
SMON: enabling cache recovery
minact-scn: Inst 1 is a slave inc#:16 mmon proc-id:44857 status:0x2
minact-scn status: grec-scn:0x0000.00000000 gmin-scn:0x0000.00000000 gcalc-scn:0x0000.00000000
[44877] Successfully onlined Undo Tablespace 2.
Undo initialization finished serial:0 start:11652414 end:11652714 diff:300 (3 seconds)
Verifying file header compatibility for 11g tablespace encryption..
Verifying 11g file header compatibility for tablespace encryption completed
SMON: enabling tx recovery
Database Characterset is WE8MSWIN1252
No Resource Manager plan active
Starting background process GTX0
Tue Sep 17 14:50:47 2019
GTX0 started with pid=36, OS id=44919 
Starting background process RCBG
Tue Sep 17 14:50:47 2019
RCBG started with pid=37, OS id=44921 
replication_dependency_tracking turned off (no async multimaster replication found)
Starting background process QMNC
Tue Sep 17 14:50:47 2019
QMNC started with pid=38, OS id=44923 
Tue Sep 17 14:50:50 2019
Completed: ALTER DATABASE OPEN /* db agent *//* {1:13741:2} */
Tue Sep 17 14:50:50 2019
Starting background process CJQ0
Tue Sep 17 14:50:50 2019
CJQ0 started with pid=33, OS id=44946 
Tue Sep 17 14:52:09 2019
NOTE: Found /dev/oracleasm/disks/NODE01DATA01 for disk OCR_0000
SUCCESS: disk OCR_0000 (0.3915103355) replaced in diskgroup OCR
NOTE: disk 0 (OCR_0000) in group 1 (OCR) is online for writes
Tue Sep 17 14:52:29 2019
NOTE: disk 0 (OCR_0000) in group 1 (OCR) is online for reads
Tue Sep 17 14:55:48 2019
Starting background process SMCO
Tue Sep 17 14:55:48 2019
SMCO started with pid=30, OS id=45629 
相关文章
|
26天前
|
机器学习/深度学习 编解码 监控
目标检测实战(六): 使用YOLOv8完成对图像的目标检测任务(从数据准备到训练测试部署的完整流程)
这篇文章详细介绍了如何使用YOLOv8进行目标检测任务,包括环境搭建、数据准备、模型训练、验证测试以及模型转换等完整流程。
688 1
目标检测实战(六): 使用YOLOv8完成对图像的目标检测任务(从数据准备到训练测试部署的完整流程)
|
28天前
|
Web App开发 前端开发 安全
前端研发链路之测试
本文由前端徐徐撰写,介绍了前端测试的重要性及其主要类型,包括单元测试、E2E测试、覆盖率测试、安全扫描和自动化测试。文章详细讲解了每种测试的工具和应用场景,并提供了选择合适测试策略的建议,帮助开发者提高代码质量和用户体验。
29 3
前端研发链路之测试
|
10天前
|
缓存 自然语言处理 并行计算
基于NVIDIA A30 加速卡推理部署通义千问-72B-Chat测试过程
本文介绍了基于阿里云通义千问72B大模型(Qwen-72B-Chat)的性能基准测试,包括测试环境准备、模型部署、API测试等内容。测试环境配置为32核128G内存的ECS云主机,配备8块NVIDIA A30 GPU加速卡。软件环境包括Ubuntu 22.04、CUDA 12.4.0、PyTorch 2.4.0等。详细介绍了模型下载、部署命令及常见问题解决方法,并展示了API测试结果和性能分析。
73 1
|
25天前
|
机器学习/深度学习 监控 计算机视觉
目标检测实战(八): 使用YOLOv7完成对图像的目标检测任务(从数据准备到训练测试部署的完整流程)
本文介绍了如何使用YOLOv7进行目标检测,包括环境搭建、数据集准备、模型训练、验证、测试以及常见错误的解决方法。YOLOv7以其高效性能和准确率在目标检测领域受到关注,适用于自动驾驶、安防监控等场景。文中提供了源码和论文链接,以及详细的步骤说明,适合深度学习实践者参考。
202 0
目标检测实战(八): 使用YOLOv7完成对图像的目标检测任务(从数据准备到训练测试部署的完整流程)
|
26天前
|
机器学习/深度学习 并行计算 数据可视化
目标分类笔记(二): 利用PaddleClas的框架来完成多标签分类任务(从数据准备到训练测试部署的完整流程)
这篇文章介绍了如何使用PaddleClas框架完成多标签分类任务,包括数据准备、环境搭建、模型训练、预测、评估等完整流程。
71 0
目标分类笔记(二): 利用PaddleClas的框架来完成多标签分类任务(从数据准备到训练测试部署的完整流程)
|
26天前
|
机器学习/深度学习 数据采集 算法
目标分类笔记(一): 利用包含多个网络多种训练策略的框架来完成多目标分类任务(从数据准备到训练测试部署的完整流程)
这篇博客文章介绍了如何使用包含多个网络和多种训练策略的框架来完成多目标分类任务,涵盖了从数据准备到训练、测试和部署的完整流程,并提供了相关代码和配置文件。
42 0
目标分类笔记(一): 利用包含多个网络多种训练策略的框架来完成多目标分类任务(从数据准备到训练测试部署的完整流程)
|
26天前
|
机器学习/深度学习 XML 并行计算
目标检测实战(七): 使用YOLOX完成对图像的目标检测任务(从数据准备到训练测试部署的完整流程)
这篇文章介绍了如何使用YOLOX完成图像目标检测任务的完整流程,包括数据准备、模型训练、验证和测试。
129 0
目标检测实战(七): 使用YOLOX完成对图像的目标检测任务(从数据准备到训练测试部署的完整流程)
|
1月前
|
Ubuntu API Python
Chat-TTS chat-tts-ui 实机部署上手测试!Ubuntu服务器实机 2070Super*2 8GB部署全流程
Chat-TTS chat-tts-ui 实机部署上手测试!Ubuntu服务器实机 2070Super*2 8GB部署全流程
60 1
|
1月前
|
前端开发 JavaScript 应用服务中间件
linux安装nginx和前端部署vue项目(实际测试react项目也可以)
本文是一篇详细的教程,介绍了如何在Linux系统上安装和配置nginx,以及如何将打包好的前端项目(如Vue或React)上传和部署到服务器上,包括了常见的错误处理方法。
170 0
linux安装nginx和前端部署vue项目(实际测试react项目也可以)
|
2月前
|
Kubernetes Linux API
CentOS 7.6使用kubeadm部署k8s 1.17.2测试集群实战篇
该博客文章详细介绍了在CentOS 7.6操作系统上使用kubeadm工具部署kubernetes 1.17.2版本的测试集群的过程,包括主机环境准备、安装Docker、配置kubelet、初始化集群、添加节点、部署网络插件以及配置k8s node节点管理api server服务器。
113 0
CentOS 7.6使用kubeadm部署k8s 1.17.2测试集群实战篇

热门文章

最新文章