ASM disk group mount fails with ORA-15036
ASM 磁碟組無法mount:
Autotune of undo retention is turned on.
IMODE=BR
ILAT =0
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 Automatic Storage Management option.
ORACLE_HOME = /u01/app/grid/product/11.2.0.4/crs_1
System name: Linux
Node name: dn2newtest
Release: 2.6.18-274.el5
Version: #1 SMP Fri Jul 8 17:36:59 EDT 2011
Machine: x86_64
VM name: VMWare Version: 6
Using parameter settings in server-side spfile +DATA01/asm/asmparameterfile/registry.253.862232957
System parameters with non-default values:
large_pool_size = 12M
instance_type = "asm"
remote_login_passwordfile= "EXCLUSIVE"
asm_diskgroups = "DATA02"
asm_diskgroups = "DATA03"
asm_diskgroups = "DATA04"
asm_power_limit = 1
diagnostic_dest = "/u01/app/grid/11.2.0.4"
Wed Oct 29 14:57:36 2014
PMON started with pid=2, OS id=5056
Wed Oct 29 14:57:36 2014
PSP0 started with pid=3, OS id=5058
Wed Oct 29 14:57:37 2014
VKTM started with pid=4, OS id=5060 at elevated priority
VKTM running at (1)millisec precision with DBRM quantum (100)ms
Wed Oct 29 14:57:37 2014
GEN0 started with pid=5, OS id=5064
Wed Oct 29 14:57:37 2014
DIAG started with pid=6, OS id=5066
Wed Oct 29 14:57:37 2014
DIA0 started with pid=7, OS id=5068
Wed Oct 29 14:57:37 2014
MMAN started with pid=8, OS id=5070
Wed Oct 29 14:57:37 2014
DBW0 started with pid=9, OS id=5072
Wed Oct 29 14:57:37 2014
LGWR started with pid=10, OS id=5074
Wed Oct 29 14:57:37 2014
CKPT started with pid=11, OS id=5076
Wed Oct 29 14:57:37 2014
SMON started with pid=12, OS id=5078
Wed Oct 29 14:57:37 2014
RBAL started with pid=13, OS id=5080
Wed Oct 29 14:57:38 2014
GMON started with pid=14, OS id=5082
Wed Oct 29 14:57:38 2014
MMON started with pid=15, OS id=5084
Wed Oct 29 14:57:38 2014
MMNL started with pid=16, OS id=5086
ORACLE_BASE not set in environment. It is recommended
that ORACLE_BASE be set in the environment
Wed Oct 29 14:57:39 2014
SQL> ALTER DISKGROUP ALL MOUNT /* asm agent call crs *//* {0:0:2} */
NOTE: Diskgroups listed in ASM_DISKGROUPS are
DATA02
DATA03
DATA04
Diskgroup with spfile:DATA01
NOTE: cache registered group DATA01 number=1 incarn=0xf2988d9d
NOTE: cache began mount (first) of group DATA01 number=1 incarn=0xf2988d9d
NOTE: cache registered group DATA02 number=2 incarn=0xf2a88d9e
NOTE: cache began mount (first) of group DATA02 number=2 incarn=0xf2a88d9e
NOTE: cache registered group DATA03 number=3 incarn=0xf2b88d9f
NOTE: cache began mount (first) of group DATA03 number=3 incarn=0xf2b88d9f
NOTE: cache registered group DATA04 number=4 incarn=0xf2c88da0
NOTE: cache began mount (first) of group DATA04 number=4 incarn=0xf2c88da0
NOTE: Loaded library: /opt/oracle/extapi/64/asm/orcl/1/libasm.so
NOTE: Assigning number (1,0) to disk (ORCL:DATA11)
NOTE: Assigning number (1,1) to disk (ORCL:DATA12)
NOTE: Assigning number (1,2) to disk (ORCL:DATA13)
NOTE: Assigning number (1,3) to disk (ORCL:DATA31)
NOTE: Assigning number (1,4) to disk (ORCL:DATA32)
NOTE: cache dismounting (clean) group 1/0xF2988D9D (DATA01)
NOTE: messaging CKPT to quiesce pins Unix process pid: 5088, image: oracle@dn2newtest (TNS V1-V3)
NOTE: dbwr not being msg'd to dismount
NOTE: lgwr not being msg'd to dismount
NOTE: cache dismounted group 1/0xF2988D9D (DATA01)
NOTE: cache ending mount (fail) of group DATA01 number=1 incarn=0xf2988d9d
NOTE: cache deleting context for group DATA01 1/0xf2988d9d
GMON dismounting group 1 at 1 for pid 17, osid 5088
NOTE: Disk DATA11 in mode 0x9 marked for de-assignment
NOTE: Disk DATA12 in mode 0x9 marked for de-assignment
NOTE: Disk DATA13 in mode 0x9 marked for de-assignment
NOTE: Disk DATA31 in mode 0x9 marked for de-assignment
NOTE: Disk DATA32 in mode 0x9 marked for de-assignment
ERROR: diskgroup DATA01 was not mounted
NOTE: Assigning number (2,1) to disk (ORCL:DATA33)
NOTE: cache dismounting (clean) group 2/0xF2A88D9E (DATA02)
NOTE: messaging CKPT to quiesce pins Unix process pid: 5088, image: oracle@dn2newtest (TNS V1-V3)
NOTE: dbwr not being msg'd to dismount
NOTE: lgwr not being msg'd to dismount
NOTE: cache dismounted group 2/0xF2A88D9E (DATA02)
NOTE: cache ending mount (fail) of group DATA02 number=2 incarn=0xf2a88d9e
NOTE: cache deleting context for group DATA02 2/0xf2a88d9e
GMON dismounting group 2 at 2 for pid 17, osid 5088
NOTE: Disk DATA33 in mode 0x9 marked for de-assignment
ERROR: diskgroup DATA02 was not mounted
NOTE: Assigning number (3,0) to disk (ORCL:DATA21)
NOTE: Assigning number (3,1) to disk (ORCL:DATA22)
NOTE: Assigning number (3,2) to disk (ORCL:DATA23)
NOTE: cache dismounting (clean) group 3/0xF2B88D9F (DATA03)
NOTE: messaging CKPT to quiesce pins Unix process pid: 5088, image: oracle@dn2newtest (TNS V1-V3)
NOTE: dbwr not being msg'd to dismount
NOTE: lgwr not being msg'd to dismount
NOTE: cache dismounted group 3/0xF2B88D9F (DATA03)
NOTE: cache ending mount (fail) of group DATA03 number=3 incarn=0xf2b88d9f
NOTE: cache deleting context for group DATA03 3/0xf2b88d9f
GMON dismounting group 3 at 3 for pid 17, osid 5088
NOTE: Disk DATA21 in mode 0x9 marked for de-assignment
NOTE: Disk DATA22 in mode 0x9 marked for de-assignment
NOTE: Disk DATA23 in mode 0x9 marked for de-assignment
ERROR: diskgroup DATA03 was not mounted
NOTE: Assigning number (4,0) to disk (ORCL:DATA24)
NOTE: cache dismounting (clean) group 4/0xF2C88DA0 (DATA04)
NOTE: messaging CKPT to quiesce pins Unix process pid: 5088, image: oracle@dn2newtest (TNS V1-V3)
NOTE: dbwr not being msg'd to dismount
NOTE: lgwr not being msg'd to dismount
NOTE: cache dismounted group 4/0xF2C88DA0 (DATA04)
NOTE: cache ending mount (fail) of group DATA04 number=4 incarn=0xf2c88da0
NOTE: cache deleting context for group DATA04 4/0xf2c88da0
GMON dismounting group 4 at 4 for pid 17, osid 5088
NOTE: Disk DATA24 in mode 0x9 marked for de-assignment
ERROR: diskgroup DATA04 was not mounted
WARNING: Disk Group DATA01 containing spfile for this instance is not mounted
ORA-15032: not all alterations performed
ORA-15036: disk 'ORCL:DATA34' is truncated
ORA-15036: disk 'ORCL:DATA14' is truncated
ERROR: ALTER DISKGROUP ALL MOUNT /* asm agent call crs *//* {0:0:2} */
SQL> ALTER DISKGROUP ALL ENABLE VOLUME ALL /* asm agent *//* {0:0:2} */
Wed Oct 29 14:57:41 2014
SQL> ALTER DISKGROUP DATA01 MOUNT /* asm agent *//* {0:0:2} */
Wed Oct 29 14:57:41 2014
SQL> ALTER DISKGROUP DATA04 MOUNT /* asm agent *//* {0:0:2} */
Wed Oct 29 14:57:41 2014
SQL> ALTER DISKGROUP DATA02 MOUNT /* asm agent *//* {0:0:2} */
Wed Oct 29 14:57:41 2014
SQL> ALTER DISKGROUP DATA03 MOUNT /* asm agent *//* {0:0:2} */
NOTE: cache registered group DATA01 number=1 incarn=0x01988da5
NOTE: cache began mount (first) of group DATA01 number=1 incarn=0x01988da5
NOTE: Assigning number (1,0) to disk (ORCL:DATA11)
NOTE: Assigning number (1,1) to disk (ORCL:DATA12)
NOTE: Assigning number (1,2) to disk (ORCL:DATA13)
NOTE: Assigning number (1,3) to disk (ORCL:DATA31)
NOTE: Assigning number (1,4) to disk (ORCL:DATA32)
Wed Oct 29 14:57:41 2014
ALTER SYSTEM SET local_listener=' (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=127.0.0.1
)(PORT=1521))))' SCOPE=MEMORY SID='+ASM';
NOTE: GMON heartbeating for grp 1
GMON querying group 1 at 7 for pid 19, osid 5104
NOTE: cache opening disk 0 of grp 1: DATA11 label:DATA11
NOTE: F1X0 found on disk 0 au 2 fcn 0.0
NOTE: cache opening disk 1 of grp 1: DATA12 label:DATA12
NOTE: F1X0 found on disk 1 au 2 fcn 0.0
NOTE: cache opening disk 2 of grp 1: DATA13 label:DATA13
NOTE: F1X0 found on disk 2 au 2 fcn 0.0
NOTE: cache opening disk 3 of grp 1: DATA31 label:DATA31
NOTE: cache opening disk 4 of grp 1: DATA32 label:DATA32
NOTE: cache mounting (first) high redundancy group 1/0x01988DA5 (DATA01)
NOTE: cache recovered group 1 to fcn 0.219
NOTE: redo buffer size is 256 blocks (1053184 bytes)
Wed Oct 29 14:57:48 2014
NOTE: LGWR attempting to mount thread 1 for diskgroup 1 (DATA01)
Process LGWR (pid 5074) is running at high priority QoS for Exadata I/O
NOTE: LGWR found thread 1 closed at ABA 4.14
NOTE: LGWR mounted thread 1 for diskgroup 1 (DATA01)
NOTE: LGWR opening thread 1 at fcn 0.219 ABA 5.15
NOTE: cache mounting group 1/0x01988DA5 (DATA01) succeeded
NOTE: cache ending mount (success) of group DATA01 number=1 incarn=0x01988da5
Wed Oct 29 14:57:48 2014
NOTE: Instance updated compatible.asm to 11.2.0.0.0 for grp 1
SUCCESS: diskgroup DATA01 was mounted
NOTE: cache registered group DATA04 number=2 incarn=0x2b688da8
NOTE: cache began mount (first) of group DATA04 number=2 incarn=0x2b688da8
NOTE: Assigning number (2,0) to disk (ORCL:DATA24)
SUCCESS: ALTER DISKGROUP DATA01 MOUNT /* asm agent *//* {0:0:2} */
Wed Oct 29 14:57:48 2014
NOTE: diskgroup resource ora.DATA01.dg is updated
Wed Oct 29 14:57:54 2014
NOTE: GMON heartbeating for grp 2
GMON querying group 2 at 11 for pid 18, osid 5114
Wed Oct 29 14:57:54 2014
NOTE: cache opening disk 0 of grp 2: DATA24 label:DATA24
NOTE: F1X0 found on disk 0 au 2 fcn 0.0
NOTE: cache mounting (first) external redundancy group 2/0x2B688DA8 (DATA04)
NOTE: cache recovered group 2 to fcn 0.10
NOTE: redo buffer size is 256 blocks (1053184 bytes)
NOTE: LGWR attempting to mount thread 1 for diskgroup 2 (DATA04)
NOTE: LGWR found thread 1 closed at ABA 3.3
NOTE: LGWR mounted thread 1 for diskgroup 2 (DATA04)
NOTE: LGWR opening thread 1 at fcn 0.10 ABA 4.4
NOTE: cache mounting group 2/0x2B688DA8 (DATA04) succeeded
NOTE: cache ending mount (success) of group DATA04 number=2 incarn=0x2b688da8
NOTE: Instance updated compatible.asm to 11.2.0.0.0 for grp 2
SUCCESS: diskgroup DATA04 was mounted
SUCCESS: ALTER DISKGROUP DATA04 MOUNT /* asm agent *//* {0:0:2} */
Wed Oct 29 14:57:54 2014
NOTE: cache registered group DATA02 number=3 incarn=0x53188dad
NOTE: cache began mount (first) of group DATA02 number=3 incarn=0x53188dad
NOTE: Assigning number (3,1) to disk (ORCL:DATA33)
NOTE: cache dismounting (clean) group 3/0x53188DAD (DATA02)
NOTE: messaging CKPT to quiesce pins Unix process pid: 5108, image: oracle@dn2newtest (TNS V1-V3)
NOTE: dbwr not being msg'd to dismount
NOTE: lgwr not being msg'd to dismount
NOTE: cache dismounted group 3/0x53188DAD (DATA02)
NOTE: cache ending mount (fail) of group DATA02 number=3 incarn=0x53188dad
NOTE: cache deleting context for group DATA02 3/0x53188dad
GMON dismounting group 3 at 13 for pid 17, osid 5108
NOTE: Disk DATA33 in mode 0x9 marked for de-assignment
ERROR: diskgroup DATA02 was not mounted
ORA-15032: not all alterations performed
ORA-15036: disk 'ORCL:DATA34' is truncated
ORA-15036: disk 'ORCL:DATA14' is truncated
ERROR: ALTER DISKGROUP DATA02 MOUNT /* asm agent *//* {0:0:2} */
Wed Oct 29 14:57:54 2014
NOTE: cache registered group DATA03 number=3 incarn=0x54188db1
NOTE: cache began mount (first) of group DATA03 number=3 incarn=0x54188db1
NOTE: Assigning number (3,0) to disk (ORCL:DATA21)
NOTE: Assigning number (3,1) to disk (ORCL:DATA22)
NOTE: Assigning number (3,2) to disk (ORCL:DATA23)
NOTE: GMON heartbeating for grp 3
GMON querying group 3 at 16 for pid 20, osid 5112
NOTE: cache opening disk 0 of grp 3: DATA21 label:DATA21
NOTE: F1X0 found on disk 0 au 2 fcn 0.0
NOTE: cache opening disk 1 of grp 3: DATA22 label:DATA22
NOTE: F1X0 found on disk 1 au 2 fcn 0.0
NOTE: cache opening disk 2 of grp 3: DATA23 label:DATA23
NOTE: F1X0 found on disk 2 au 2 fcn 0.0
NOTE: cache mounting (first) normal redundancy group 3/0x54188DB1 (DATA03)
NOTE: cache recovered group 3 to fcn 0.8
NOTE: redo buffer size is 256 blocks (1053184 bytes)
Wed Oct 29 14:58:01 2014
NOTE: LGWR attempting to mount thread 1 for diskgroup 3 (DATA03)
NOTE: LGWR found thread 1 closed at ABA 3.3
NOTE: LGWR mounted thread 1 for diskgroup 3 (DATA03)
NOTE: LGWR opening thread 1 at fcn 0.8 ABA 4.4
NOTE: cache mounting group 3/0x54188DB1 (DATA03) succeeded
NOTE: cache ending mount (success) of group DATA03 number=3 incarn=0x54188db1
Wed Oct 29 14:58:01 2014
NOTE: Instance updated compatible.asm to 11.2.0.0.0 for grp 3
SUCCESS: diskgroup DATA03 was mounted
SUCCESS: ALTER DISKGROUP DATA03 MOUNT /* asm agent *//* {0:0:2} */
Wed Oct 29 14:58:28 2014
SQL> ALTER DISKGROUP DATA02 MOUNT /* asm agent *//* {0:0:118} */
NOTE: cache registered group DATA02 number=4 incarn=0x24e88db5
NOTE: cache began mount (first) of group DATA02 number=4 incarn=0x24e88db5
NOTE: Assigning number (4,1) to disk (ORCL:DATA33)
NOTE: cache dismounting (clean) group 4/0x24E88DB5 (DATA02)
NOTE: messaging CKPT to quiesce pins Unix process pid: 5104, image: oracle@dn2newtest (TNS V1-V3)
NOTE: dbwr not being msg'd to dismount
NOTE: lgwr not being msg'd to dismount
NOTE: cache dismounted group 4/0x24E88DB5 (DATA02)
NOTE: cache ending mount (fail) of group DATA02 number=4 incarn=0x24e88db5
NOTE: cache deleting context for group DATA02 4/0x24e88db5
Wed Oct 29 14:58:28 2014
GMON dismounting group 4 at 18 for pid 19, osid 5104
NOTE: Disk DATA33 in mode 0x9 marked for de-assignment
ERROR: diskgroup DATA02 was not mounted
ORA-15032: not all alterations performed
ORA-15036: disk 'ORCL:DATA34' is truncated
ORA-15036: disk 'ORCL:DATA14' is truncated
ERROR: ALTER DISKGROUP DATA02 MOUNT /* asm agent *//* {0:0:118} */
Wed Oct 29 14:58:30 2014
SQL> ALTER DISKGROUP DATA02 MOUNT /* asm agent *//* {0:0:131} */
NOTE: cache registered group DATA02 number=4 incarn=0x32588db8
NOTE: cache began mount (first) of group DATA02 number=4 incarn=0x32588db8
NOTE: Assigning number (4,1) to disk (ORCL:DATA33)
NOTE: cache dismounting (clean) group 4/0x32588DB8 (DATA02)
NOTE: messaging CKPT to quiesce pins Unix process pid: 5108, image: oracle@dn2newtest (TNS V1-V3)
NOTE: dbwr not being msg'd to dismount
NOTE: lgwr not being msg'd to dismount
NOTE: cache dismounted group 4/0x32588DB8 (DATA02)
NOTE: cache ending mount (fail) of group DATA02 number=4 incarn=0x32588db8
NOTE: cache deleting context for group DATA02 4/0x32588db8
GMON dismounting group 4 at 19 for pid 17, osid 5108
NOTE: Disk DATA33 in mode 0x9 marked for de-assignment
ERROR: diskgroup DATA02 was not mounted
ORA-15032: not all alterations performed
ORA-15036: disk 'ORCL:DATA34' is truncated
ORA-15036: disk 'ORCL:DATA14' is truncated
ERROR: ALTER DISKGROUP DATA02 MOUNT /* asm agent *//* {0:0:131} */
Wed Oct 29 14:58:32 2014
SQL> ALTER DISKGROUP DATA02 MOUNT /* asm agent *//* {0:0:144} */
NOTE: cache registered group DATA02 number=4 incarn=0x3f188dbb
NOTE: cache began mount (first) of group DATA02 number=4 incarn=0x3f188dbb
NOTE: Assigning number (4,1) to disk (ORCL:DATA33)
NOTE: cache dismounting (clean) group 4/0x3F188DBB (DATA02)
NOTE: messaging CKPT to quiesce pins Unix process pid: 5114, image: oracle@dn2newtest (TNS V1-V3)
NOTE: dbwr not being msg'd to dismount
NOTE: lgwr not being msg'd to dismount
NOTE: cache dismounted group 4/0x3F188DBB (DATA02)
NOTE: cache ending mount (fail) of group DATA02 number=4 incarn=0x3f188dbb
NOTE: cache deleting context for group DATA02 4/0x3f188dbb
GMON dismounting group 4 at 20 for pid 18, osid 5114
NOTE: Disk DATA33 in mode 0x9 marked for de-assignment
ERROR: diskgroup DATA02 was not mounted
ORA-15032: not all alterations performed
ORA-15036: disk 'ORCL:DATA34' is truncated
ORA-15036: disk 'ORCL:DATA14' is truncated
ERROR: ALTER DISKGROUP DATA02 MOUNT /* asm agent *//* {0:0:144} */
Wed Oct 29 14:58:38 2014
SQL> ALTER DISKGROUP DATA02 MOUNT /* asm agent *//* {0:0:164} */
NOTE: cache registered group DATA02 number=4 incarn=0x64488dbe
NOTE: cache began mount (first) of group DATA02 number=4 incarn=0x64488dbe
NOTE: Assigning number (4,1) to disk (ORCL:DATA33)
NOTE: cache dismounting (clean) group 4/0x64488DBE (DATA02)
NOTE: messaging CKPT to quiesce pins Unix process pid: 5104, image: oracle@dn2newtest (TNS V1-V3)
NOTE: dbwr not being msg'd to dismount
NOTE: lgwr not being msg'd to dismount
NOTE: cache dismounted group 4/0x64488DBE (DATA02)
NOTE: cache ending mount (fail) of group DATA02 number=4 incarn=0x64488dbe
NOTE: cache deleting context for group DATA02 4/0x64488dbe
Wed Oct 29 14:58:38 2014
GMON dismounting group 4 at 21 for pid 19, osid 5104
NOTE: Disk DATA33 in mode 0x9 marked for de-assignment
ERROR: diskgroup DATA02 was not mounted
ORA-15032: not all alterations performed
ORA-15036: disk 'ORCL:DATA34' is truncated
ORA-15036: disk 'ORCL:DATA14' is truncated
ERROR: ALTER DISKGROUP DATA02 MOUNT /* asm agent *//* {0:0:164} */
Wed Oct 29 14:59:26 2014
SQL> alter diskgroup DATA02 MOUNT /* ASMCA */
NOTE: cache registered group DATA02 number=4 incarn=0x90d88dfd
NOTE: cache began mount (first) of group DATA02 number=4 incarn=0x90d88dfd
NOTE: Assigning number (4,1) to disk (ORCL:DATA33)
NOTE: cache dismounting (clean) group 4/0x90D88DFD (DATA02)
NOTE: messaging CKPT to quiesce pins Unix process pid: 5423, image: oracle@dn2newtest (TNS V1-V3)
NOTE: dbwr not being msg'd to dismount
NOTE: lgwr not being msg'd to dismount
NOTE: cache dismounted group 4/0x90D88DFD (DATA02)
NOTE: cache ending mount (fail) of group DATA02 number=4 incarn=0x90d88dfd
NOTE: cache deleting context for group DATA02 4/0x90d88dfd
Wed Oct 29 14:59:26 2014
GMON dismounting group 4 at 22 for pid 20, osid 5423
NOTE: Disk DATA33 in mode 0x9 marked for de-assignment
ERROR: diskgroup DATA02 was not mounted
ORA-15032: not all alterations performed
ORA-15036: disk 'ORCL:DATA34' is truncated
ORA-15036: disk 'ORCL:DATA14' is truncated
ERROR: alter diskgroup DATA02 MOUNT /* ASMCA */
Wed Oct 29 15:00:10 2014
SQL> alter diskgroup DATA01 dismount /* ASMCA */
NOTE: Active use of SPFILE in group
Wed Oct 29 15:00:10 2014
NOTE: Instance updated compatible.asm to 11.2.0.0.0 for grp 1
ORA-15032: not all alterations performed
ORA-15027: active use of diskgroup "DATA01" precludes its dismount
ERROR: alter diskgroup DATA01 dismount /* ASMCA */
Wed Oct 29 15:00:11 2014
SQL> alter diskgroup DATA03 dismount /* ASMCA */
NOTE: cache dismounting (clean) group 3/0x54188DB1 (DATA03)
NOTE: messaging CKPT to quiesce pins Unix process pid: 5449, image: oracle@dn2newtest (TNS V1-V3)
Wed Oct 29 15:00:11 2014
NOTE: LGWR doing clean dismount of group 3 (DATA03)
NOTE: LGWR closing thread 1 of diskgroup 3 (DATA03) at ABA 4.5
NOTE: cache dismounted group 3/0x54188DB1 (DATA03)
Wed Oct 29 15:00:11 2014
GMON dismounting group 3 at 24 for pid 20, osid 5449
NOTE: Disk DATA21 in mode 0x7f marked for de-assignment
NOTE: Disk DATA22 in mode 0x7f marked for de-assignment
NOTE: Disk DATA23 in mode 0x7f marked for de-assignment
SUCCESS: diskgroup DATA03 was dismounted
NOTE: cache deleting context for group DATA03 3/0x54188db1
Wed Oct 29 15:00:11 2014
NOTE: diskgroup resource ora.DATA03.dg is offline
SUCCESS: alter diskgroup DATA03 dismount /* ASMCA */
NOTE: diskgroup resource ora.DATA03.dg is updated
SQL> alter diskgroup DATA04 dismount /* ASMCA */
NOTE: cache dismounting (clean) group 2/0x2B688DA8 (DATA04)
NOTE: messaging CKPT to quiesce pins Unix process pid: 5449, image: oracle@dn2newtest (TNS V1-V3)
NOTE: LGWR doing clean dismount of group 2 (DATA04)
NOTE: LGWR closing thread 1 of diskgroup 2 (DATA04) at ABA 4.5
NOTE: cache dismounted group 2/0x2B688DA8 (DATA04)
GMON dismounting group 2 at 25 for pid 20, osid 5449
NOTE: Disk DATA24 in mode 0x7f marked for de-assignment
SUCCESS: diskgroup DATA04 was dismounted
NOTE: cache deleting context for group DATA04 2/0x2b688da8
NOTE: diskgroup resource ora.DATA04.dg is offline
SUCCESS: alter diskgroup DATA04 dismount /* ASMCA */
NOTE: diskgroup resource ora.DATA04.dg is updated
Wed Oct 29 15:00:22 2014
SQL> alter diskgroup DATA02 MOUNT /* ASMCA */
NOTE: cache registered group DATA02 number=2 incarn=0xef588e75
NOTE: cache began mount (first) of group DATA02 number=2 incarn=0xef588e75
NOTE: Assigning number (2,1) to disk (ORCL:DATA33)
NOTE: cache dismounting (clean) group 2/0xEF588E75 (DATA02)
NOTE: messaging CKPT to quiesce pins Unix process pid: 5449, image: oracle@dn2newtest (TNS V1-V3)
NOTE: dbwr not being msg'd to dismount
NOTE: lgwr not being msg'd to dismount
NOTE: cache dismounted group 2/0xEF588E75 (DATA02)
NOTE: cache ending mount (fail) of group DATA02 number=2 incarn=0xef588e75
NOTE: cache deleting context for group DATA02 2/0xef588e75
Wed Oct 29 15:00:22 2014
GMON dismounting group 2 at 26 for pid 20, osid 5449
NOTE: Disk DATA33 in mode 0x9 marked for de-assignment
ERROR: diskgroup DATA02 was not mounted
ORA-15032: not all alterations performed
ORA-15036: disk 'ORCL:DATA34' is truncated
ORA-15036: disk 'ORCL:DATA14' is truncated
ERROR: alter diskgroup DATA02 MOUNT /* ASMCA */
Wed Oct 29 15:00:22 2014
SQL> alter diskgroup DATA03 MOUNT /* ASMCA */
NOTE: cache registered group DATA03 number=2 incarn=0xf1988e7e
NOTE: cache began mount (first) of group DATA03 number=2 incarn=0xf1988e7e
NOTE: Assigning number (2,0) to disk (ORCL:DATA21)
NOTE: Assigning number (2,1) to disk (ORCL:DATA22)
NOTE: Assigning number (2,2) to disk (ORCL:DATA23)
NOTE: GMON heartbeating for grp 2
GMON querying group 2 at 29 for pid 20, osid 5460
NOTE: cache opening disk 0 of grp 2: DATA21 label:DATA21
NOTE: F1X0 found on disk 0 au 2 fcn 0.0
NOTE: cache opening disk 1 of grp 2: DATA22 label:DATA22
NOTE: F1X0 found on disk 1 au 2 fcn 0.0
NOTE: cache opening disk 2 of grp 2: DATA23 label:DATA23
NOTE: F1X0 found on disk 2 au 2 fcn 0.0
NOTE: cache mounting (first) normal redundancy group 2/0xF1988E7E (DATA03)
NOTE: cache recovered group 2 to fcn 0.11
NOTE: redo buffer size is 256 blocks (1053184 bytes)
Wed Oct 29 15:00:29 2014
NOTE: LGWR attempting to mount thread 1 for diskgroup 2 (DATA03)
NOTE: LGWR found thread 1 closed at ABA 4.5
NOTE: LGWR mounted thread 1 for diskgroup 2 (DATA03)
NOTE: LGWR opening thread 1 at fcn 0.11 ABA 5.6
NOTE: cache mounting group 2/0xF1988E7E (DATA03) succeeded
NOTE: cache ending mount (success) of group DATA03 number=2 incarn=0xf1988e7e
Wed Oct 29 15:00:29 2014
NOTE: Instance updated compatible.asm to 11.2.0.0.0 for grp 2
SUCCESS: diskgroup DATA03 was mounted
Wed Oct 29 15:00:29 2014
NOTE: diskgroup resource ora.DATA03.dg is online
SUCCESS: alter diskgroup DATA03 MOUNT /* ASMCA */
NOTE: diskgroup resource ora.DATA03.dg is updated
SQL> alter diskgroup DATA04 MOUNT /* ASMCA */
NOTE: cache registered group DATA04 number=3 incarn=0x1a088e86
NOTE: cache began mount (first) of group DATA04 number=3 incarn=0x1a088e86
NOTE: Assigning number (3,0) to disk (ORCL:DATA24)
Wed Oct 29 15:00:35 2014
NOTE: GMON heartbeating for grp 3
GMON querying group 3 at 33 for pid 20, osid 5460
Wed Oct 29 15:00:35 2014
NOTE: cache opening disk 0 of grp 3: DATA24 label:DATA24
NOTE: F1X0 found on disk 0 au 2 fcn 0.0
NOTE: cache mounting (first) external redundancy group 3/0x1A088E86 (DATA04)
NOTE: cache recovered group 3 to fcn 0.13
NOTE: redo buffer size is 256 blocks (1053184 bytes)
NOTE: LGWR attempting to mount thread 1 for diskgroup 3 (DATA04)
NOTE: LGWR found thread 1 closed at ABA 4.5
NOTE: LGWR mounted thread 1 for diskgroup 3 (DATA04)
NOTE: LGWR opening thread 1 at fcn 0.13 ABA 5.6
NOTE: cache mounting group 3/0x1A088E86 (DATA04) succeeded
NOTE: cache ending mount (success) of group DATA04 number=3 incarn=0x1a088e86
NOTE: Instance updated compatible.asm to 11.2.0.0.0 for grp 3
SUCCESS: diskgroup DATA04 was mounted
NOTE: diskgroup resource ora.DATA04.dg is online
SUCCESS: alter diskgroup DATA04 MOUNT /* ASMCA */
NOTE: diskgroup resource ora.DATA04.dg is updated
Wed Oct 29 15:05:30 2014
NOTE: client ygzhou:ygzhou registered, osid 5844, mbr 0x0
Wed Oct 29 15:31:29 2014
SQL> alter diskgroup DATA02 resize disk DATA09 size 5098M
ORA-15032: not all alterations performed
ORA-15001: diskgroup "DATA02" does not exist or is not mounted
ERROR: alter diskgroup DATA02 resize disk DATA09 size 5098M
Wed Oct 29 15:32:23 2014
SQL> alter diskgroup DATA02 MOUNT /* ASMCA */
NOTE: cache registered group DATA02 number=4 incarn=0xd0c88efd
NOTE: cache began mount (first) of group DATA02 number=4 incarn=0xd0c88efd
NOTE: Assigning number (4,0) to disk (ORCL:DATA14)
NOTE: Assigning number (4,1) to disk (ORCL:DATA33)
NOTE: Assigning number (4,2) to disk (ORCL:DATA34)
Wed Oct 29 15:32:30 2014
NOTE: GMON heartbeating for grp 4
GMON querying group 4 at 37 for pid 23, osid 6193
NOTE: cache opening disk 0 of grp 4: DATA14 label:DATA14
NOTE: F1X0 found on disk 0 au 2 fcn 0.0
NOTE: cache opening disk 1 of grp 4: DATA33 label:DATA33
NOTE: F1X0 found on disk 1 au 2 fcn 0.0
NOTE: cache opening disk 2 of grp 4: DATA34 label:DATA34
NOTE: F1X0 found on disk 2 au 2 fcn 0.0
NOTE: cache mounting (first) high redundancy group 4/0xD0C88EFD (DATA02)
NOTE: cache recovered group 4 to fcn 0.6
NOTE: redo buffer size is 256 blocks (1053184 bytes)
Wed Oct 29 15:32:30 2014
NOTE: LGWR attempting to mount thread 1 for diskgroup 4 (DATA02)
NOTE: LGWR found thread 1 closed at ABA 3.3
NOTE: LGWR mounted thread 1 for diskgroup 4 (DATA02)
NOTE: LGWR opening thread 1 at fcn 0.6 ABA 4.4
NOTE: cache mounting group 4/0xD0C88EFD (DATA02) succeeded
NOTE: cache ending mount (success) of group DATA02 number=4 incarn=0xd0c88efd
Wed Oct 29 15:32:30 2014
NOTE: Instance updated compatible.asm to 11.2.0.0.0 for grp 4
SUCCESS: diskgroup DATA02 was mounted
SUCCESS: alter diskgroup DATA02 MOUNT /* ASMCA */
Wed Oct 29 15:32:31 2014
NOTE: diskgroup resource ora.DATA02.dg is online
Autotune of undo retention is turned on.
IMODE=BR
ILAT =0
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 Automatic Storage Management option.
ORACLE_HOME = /u01/app/grid/product/11.2.0.4/crs_1
System name: Linux
Node name: dn2newtest
Release: 2.6.18-274.el5
Version: #1 SMP Fri Jul 8 17:36:59 EDT 2011
Machine: x86_64
VM name: VMWare Version: 6
Using parameter settings in server-side spfile +DATA01/asm/asmparameterfile/registry.253.862232957
System parameters with non-default values:
large_pool_size = 12M
instance_type = "asm"
remote_login_passwordfile= "EXCLUSIVE"
asm_diskgroups = "DATA02"
asm_diskgroups = "DATA03"
asm_diskgroups = "DATA04"
asm_power_limit = 1
diagnostic_dest = "/u01/app/grid/11.2.0.4"
Wed Oct 29 14:57:36 2014
PMON started with pid=2, OS id=5056
Wed Oct 29 14:57:36 2014
PSP0 started with pid=3, OS id=5058
Wed Oct 29 14:57:37 2014
VKTM started with pid=4, OS id=5060 at elevated priority
VKTM running at (1)millisec precision with DBRM quantum (100)ms
Wed Oct 29 14:57:37 2014
GEN0 started with pid=5, OS id=5064
Wed Oct 29 14:57:37 2014
DIAG started with pid=6, OS id=5066
Wed Oct 29 14:57:37 2014
DIA0 started with pid=7, OS id=5068
Wed Oct 29 14:57:37 2014
MMAN started with pid=8, OS id=5070
Wed Oct 29 14:57:37 2014
DBW0 started with pid=9, OS id=5072
Wed Oct 29 14:57:37 2014
LGWR started with pid=10, OS id=5074
Wed Oct 29 14:57:37 2014
CKPT started with pid=11, OS id=5076
Wed Oct 29 14:57:37 2014
SMON started with pid=12, OS id=5078
Wed Oct 29 14:57:37 2014
RBAL started with pid=13, OS id=5080
Wed Oct 29 14:57:38 2014
GMON started with pid=14, OS id=5082
Wed Oct 29 14:57:38 2014
MMON started with pid=15, OS id=5084
Wed Oct 29 14:57:38 2014
MMNL started with pid=16, OS id=5086
ORACLE_BASE not set in environment. It is recommended
that ORACLE_BASE be set in the environment
Wed Oct 29 14:57:39 2014
SQL> ALTER DISKGROUP ALL MOUNT /* asm agent call crs *//* {0:0:2} */
NOTE: Diskgroups listed in ASM_DISKGROUPS are
DATA02
DATA03
DATA04
Diskgroup with spfile:DATA01
NOTE: cache registered group DATA01 number=1 incarn=0xf2988d9d
NOTE: cache began mount (first) of group DATA01 number=1 incarn=0xf2988d9d
NOTE: cache registered group DATA02 number=2 incarn=0xf2a88d9e
NOTE: cache began mount (first) of group DATA02 number=2 incarn=0xf2a88d9e
NOTE: cache registered group DATA03 number=3 incarn=0xf2b88d9f
NOTE: cache began mount (first) of group DATA03 number=3 incarn=0xf2b88d9f
NOTE: cache registered group DATA04 number=4 incarn=0xf2c88da0
NOTE: cache began mount (first) of group DATA04 number=4 incarn=0xf2c88da0
NOTE: Loaded library: /opt/oracle/extapi/64/asm/orcl/1/libasm.so
NOTE: Assigning number (1,0) to disk (ORCL:DATA11)
NOTE: Assigning number (1,1) to disk (ORCL:DATA12)
NOTE: Assigning number (1,2) to disk (ORCL:DATA13)
NOTE: Assigning number (1,3) to disk (ORCL:DATA31)
NOTE: Assigning number (1,4) to disk (ORCL:DATA32)
NOTE: cache dismounting (clean) group 1/0xF2988D9D (DATA01)
NOTE: messaging CKPT to quiesce pins Unix process pid: 5088, image: oracle@dn2newtest (TNS V1-V3)
NOTE: dbwr not being msg'd to dismount
NOTE: lgwr not being msg'd to dismount
NOTE: cache dismounted group 1/0xF2988D9D (DATA01)
NOTE: cache ending mount (fail) of group DATA01 number=1 incarn=0xf2988d9d
NOTE: cache deleting context for group DATA01 1/0xf2988d9d
GMON dismounting group 1 at 1 for pid 17, osid 5088
NOTE: Disk DATA11 in mode 0x9 marked for de-assignment
NOTE: Disk DATA12 in mode 0x9 marked for de-assignment
NOTE: Disk DATA13 in mode 0x9 marked for de-assignment
NOTE: Disk DATA31 in mode 0x9 marked for de-assignment
NOTE: Disk DATA32 in mode 0x9 marked for de-assignment
ERROR: diskgroup DATA01 was not mounted
NOTE: Assigning number (2,1) to disk (ORCL:DATA33)
NOTE: cache dismounting (clean) group 2/0xF2A88D9E (DATA02)
NOTE: messaging CKPT to quiesce pins Unix process pid: 5088, image: oracle@dn2newtest (TNS V1-V3)
NOTE: dbwr not being msg'd to dismount
NOTE: lgwr not being msg'd to dismount
NOTE: cache dismounted group 2/0xF2A88D9E (DATA02)
NOTE: cache ending mount (fail) of group DATA02 number=2 incarn=0xf2a88d9e
NOTE: cache deleting context for group DATA02 2/0xf2a88d9e
GMON dismounting group 2 at 2 for pid 17, osid 5088
NOTE: Disk DATA33 in mode 0x9 marked for de-assignment
ERROR: diskgroup DATA02 was not mounted
NOTE: Assigning number (3,0) to disk (ORCL:DATA21)
NOTE: Assigning number (3,1) to disk (ORCL:DATA22)
NOTE: Assigning number (3,2) to disk (ORCL:DATA23)
NOTE: cache dismounting (clean) group 3/0xF2B88D9F (DATA03)
NOTE: messaging CKPT to quiesce pins Unix process pid: 5088, image: oracle@dn2newtest (TNS V1-V3)
NOTE: dbwr not being msg'd to dismount
NOTE: lgwr not being msg'd to dismount
NOTE: cache dismounted group 3/0xF2B88D9F (DATA03)
NOTE: cache ending mount (fail) of group DATA03 number=3 incarn=0xf2b88d9f
NOTE: cache deleting context for group DATA03 3/0xf2b88d9f
GMON dismounting group 3 at 3 for pid 17, osid 5088
NOTE: Disk DATA21 in mode 0x9 marked for de-assignment
NOTE: Disk DATA22 in mode 0x9 marked for de-assignment
NOTE: Disk DATA23 in mode 0x9 marked for de-assignment
ERROR: diskgroup DATA03 was not mounted
NOTE: Assigning number (4,0) to disk (ORCL:DATA24)
NOTE: cache dismounting (clean) group 4/0xF2C88DA0 (DATA04)
NOTE: messaging CKPT to quiesce pins Unix process pid: 5088, image: oracle@dn2newtest (TNS V1-V3)
NOTE: dbwr not being msg'd to dismount
NOTE: lgwr not being msg'd to dismount
NOTE: cache dismounted group 4/0xF2C88DA0 (DATA04)
NOTE: cache ending mount (fail) of group DATA04 number=4 incarn=0xf2c88da0
NOTE: cache deleting context for group DATA04 4/0xf2c88da0
GMON dismounting group 4 at 4 for pid 17, osid 5088
NOTE: Disk DATA24 in mode 0x9 marked for de-assignment
ERROR: diskgroup DATA04 was not mounted
WARNING: Disk Group DATA01 containing spfile for this instance is not mounted
ORA-15032: not all alterations performed
ORA-15036: disk 'ORCL:DATA34' is truncated
ORA-15036: disk 'ORCL:DATA14' is truncated
ERROR: ALTER DISKGROUP ALL MOUNT /* asm agent call crs *//* {0:0:2} */
SQL> ALTER DISKGROUP ALL ENABLE VOLUME ALL /* asm agent *//* {0:0:2} */
Wed Oct 29 14:57:41 2014
SQL> ALTER DISKGROUP DATA01 MOUNT /* asm agent *//* {0:0:2} */
Wed Oct 29 14:57:41 2014
SQL> ALTER DISKGROUP DATA04 MOUNT /* asm agent *//* {0:0:2} */
Wed Oct 29 14:57:41 2014
SQL> ALTER DISKGROUP DATA02 MOUNT /* asm agent *//* {0:0:2} */
Wed Oct 29 14:57:41 2014
SQL> ALTER DISKGROUP DATA03 MOUNT /* asm agent *//* {0:0:2} */
NOTE: cache registered group DATA01 number=1 incarn=0x01988da5
NOTE: cache began mount (first) of group DATA01 number=1 incarn=0x01988da5
NOTE: Assigning number (1,0) to disk (ORCL:DATA11)
NOTE: Assigning number (1,1) to disk (ORCL:DATA12)
NOTE: Assigning number (1,2) to disk (ORCL:DATA13)
NOTE: Assigning number (1,3) to disk (ORCL:DATA31)
NOTE: Assigning number (1,4) to disk (ORCL:DATA32)
Wed Oct 29 14:57:41 2014
ALTER SYSTEM SET local_listener=' (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=127.0.0.1
)(PORT=1521))))' SCOPE=MEMORY SID='+ASM';
NOTE: GMON heartbeating for grp 1
GMON querying group 1 at 7 for pid 19, osid 5104
NOTE: cache opening disk 0 of grp 1: DATA11 label:DATA11
NOTE: F1X0 found on disk 0 au 2 fcn 0.0
NOTE: cache opening disk 1 of grp 1: DATA12 label:DATA12
NOTE: F1X0 found on disk 1 au 2 fcn 0.0
NOTE: cache opening disk 2 of grp 1: DATA13 label:DATA13
NOTE: F1X0 found on disk 2 au 2 fcn 0.0
NOTE: cache opening disk 3 of grp 1: DATA31 label:DATA31
NOTE: cache opening disk 4 of grp 1: DATA32 label:DATA32
NOTE: cache mounting (first) high redundancy group 1/0x01988DA5 (DATA01)
NOTE: cache recovered group 1 to fcn 0.219
NOTE: redo buffer size is 256 blocks (1053184 bytes)
Wed Oct 29 14:57:48 2014
NOTE: LGWR attempting to mount thread 1 for diskgroup 1 (DATA01)
Process LGWR (pid 5074) is running at high priority QoS for Exadata I/O
NOTE: LGWR found thread 1 closed at ABA 4.14
NOTE: LGWR mounted thread 1 for diskgroup 1 (DATA01)
NOTE: LGWR opening thread 1 at fcn 0.219 ABA 5.15
NOTE: cache mounting group 1/0x01988DA5 (DATA01) succeeded
NOTE: cache ending mount (success) of group DATA01 number=1 incarn=0x01988da5
Wed Oct 29 14:57:48 2014
NOTE: Instance updated compatible.asm to 11.2.0.0.0 for grp 1
SUCCESS: diskgroup DATA01 was mounted
NOTE: cache registered group DATA04 number=2 incarn=0x2b688da8
NOTE: cache began mount (first) of group DATA04 number=2 incarn=0x2b688da8
NOTE: Assigning number (2,0) to disk (ORCL:DATA24)
SUCCESS: ALTER DISKGROUP DATA01 MOUNT /* asm agent *//* {0:0:2} */
Wed Oct 29 14:57:48 2014
NOTE: diskgroup resource ora.DATA01.dg is updated
Wed Oct 29 14:57:54 2014
NOTE: GMON heartbeating for grp 2
GMON querying group 2 at 11 for pid 18, osid 5114
Wed Oct 29 14:57:54 2014
NOTE: cache opening disk 0 of grp 2: DATA24 label:DATA24
NOTE: F1X0 found on disk 0 au 2 fcn 0.0
NOTE: cache mounting (first) external redundancy group 2/0x2B688DA8 (DATA04)
NOTE: cache recovered group 2 to fcn 0.10
NOTE: redo buffer size is 256 blocks (1053184 bytes)
NOTE: LGWR attempting to mount thread 1 for diskgroup 2 (DATA04)
NOTE: LGWR found thread 1 closed at ABA 3.3
NOTE: LGWR mounted thread 1 for diskgroup 2 (DATA04)
NOTE: LGWR opening thread 1 at fcn 0.10 ABA 4.4
NOTE: cache mounting group 2/0x2B688DA8 (DATA04) succeeded
NOTE: cache ending mount (success) of group DATA04 number=2 incarn=0x2b688da8
NOTE: Instance updated compatible.asm to 11.2.0.0.0 for grp 2
SUCCESS: diskgroup DATA04 was mounted
SUCCESS: ALTER DISKGROUP DATA04 MOUNT /* asm agent *//* {0:0:2} */
Wed Oct 29 14:57:54 2014
NOTE: cache registered group DATA02 number=3 incarn=0x53188dad
NOTE: cache began mount (first) of group DATA02 number=3 incarn=0x53188dad
NOTE: Assigning number (3,1) to disk (ORCL:DATA33)
NOTE: cache dismounting (clean) group 3/0x53188DAD (DATA02)
NOTE: messaging CKPT to quiesce pins Unix process pid: 5108, image: oracle@dn2newtest (TNS V1-V3)
NOTE: dbwr not being msg'd to dismount
NOTE: lgwr not being msg'd to dismount
NOTE: cache dismounted group 3/0x53188DAD (DATA02)
NOTE: cache ending mount (fail) of group DATA02 number=3 incarn=0x53188dad
NOTE: cache deleting context for group DATA02 3/0x53188dad
GMON dismounting group 3 at 13 for pid 17, osid 5108
NOTE: Disk DATA33 in mode 0x9 marked for de-assignment
ERROR: diskgroup DATA02 was not mounted
ORA-15032: not all alterations performed
ORA-15036: disk 'ORCL:DATA34' is truncated
ORA-15036: disk 'ORCL:DATA14' is truncated
ERROR: ALTER DISKGROUP DATA02 MOUNT /* asm agent *//* {0:0:2} */
Wed Oct 29 14:57:54 2014
NOTE: cache registered group DATA03 number=3 incarn=0x54188db1
NOTE: cache began mount (first) of group DATA03 number=3 incarn=0x54188db1
NOTE: Assigning number (3,0) to disk (ORCL:DATA21)
NOTE: Assigning number (3,1) to disk (ORCL:DATA22)
NOTE: Assigning number (3,2) to disk (ORCL:DATA23)
NOTE: GMON heartbeating for grp 3
GMON querying group 3 at 16 for pid 20, osid 5112
NOTE: cache opening disk 0 of grp 3: DATA21 label:DATA21
NOTE: F1X0 found on disk 0 au 2 fcn 0.0
NOTE: cache opening disk 1 of grp 3: DATA22 label:DATA22
NOTE: F1X0 found on disk 1 au 2 fcn 0.0
NOTE: cache opening disk 2 of grp 3: DATA23 label:DATA23
NOTE: F1X0 found on disk 2 au 2 fcn 0.0
NOTE: cache mounting (first) normal redundancy group 3/0x54188DB1 (DATA03)
NOTE: cache recovered group 3 to fcn 0.8
NOTE: redo buffer size is 256 blocks (1053184 bytes)
Wed Oct 29 14:58:01 2014
NOTE: LGWR attempting to mount thread 1 for diskgroup 3 (DATA03)
NOTE: LGWR found thread 1 closed at ABA 3.3
NOTE: LGWR mounted thread 1 for diskgroup 3 (DATA03)
NOTE: LGWR opening thread 1 at fcn 0.8 ABA 4.4
NOTE: cache mounting group 3/0x54188DB1 (DATA03) succeeded
NOTE: cache ending mount (success) of group DATA03 number=3 incarn=0x54188db1
Wed Oct 29 14:58:01 2014
NOTE: Instance updated compatible.asm to 11.2.0.0.0 for grp 3
SUCCESS: diskgroup DATA03 was mounted
SUCCESS: ALTER DISKGROUP DATA03 MOUNT /* asm agent *//* {0:0:2} */
Wed Oct 29 14:58:28 2014
SQL> ALTER DISKGROUP DATA02 MOUNT /* asm agent *//* {0:0:118} */
NOTE: cache registered group DATA02 number=4 incarn=0x24e88db5
NOTE: cache began mount (first) of group DATA02 number=4 incarn=0x24e88db5
NOTE: Assigning number (4,1) to disk (ORCL:DATA33)
NOTE: cache dismounting (clean) group 4/0x24E88DB5 (DATA02)
NOTE: messaging CKPT to quiesce pins Unix process pid: 5104, image: oracle@dn2newtest (TNS V1-V3)
NOTE: dbwr not being msg'd to dismount
NOTE: lgwr not being msg'd to dismount
NOTE: cache dismounted group 4/0x24E88DB5 (DATA02)
NOTE: cache ending mount (fail) of group DATA02 number=4 incarn=0x24e88db5
NOTE: cache deleting context for group DATA02 4/0x24e88db5
Wed Oct 29 14:58:28 2014
GMON dismounting group 4 at 18 for pid 19, osid 5104
NOTE: Disk DATA33 in mode 0x9 marked for de-assignment
ERROR: diskgroup DATA02 was not mounted
ORA-15032: not all alterations performed
ORA-15036: disk 'ORCL:DATA34' is truncated
ORA-15036: disk 'ORCL:DATA14' is truncated
ERROR: ALTER DISKGROUP DATA02 MOUNT /* asm agent *//* {0:0:118} */
Wed Oct 29 14:58:30 2014
SQL> ALTER DISKGROUP DATA02 MOUNT /* asm agent *//* {0:0:131} */
NOTE: cache registered group DATA02 number=4 incarn=0x32588db8
NOTE: cache began mount (first) of group DATA02 number=4 incarn=0x32588db8
NOTE: Assigning number (4,1) to disk (ORCL:DATA33)
NOTE: cache dismounting (clean) group 4/0x32588DB8 (DATA02)
NOTE: messaging CKPT to quiesce pins Unix process pid: 5108, image: oracle@dn2newtest (TNS V1-V3)
NOTE: dbwr not being msg'd to dismount
NOTE: lgwr not being msg'd to dismount
NOTE: cache dismounted group 4/0x32588DB8 (DATA02)
NOTE: cache ending mount (fail) of group DATA02 number=4 incarn=0x32588db8
NOTE: cache deleting context for group DATA02 4/0x32588db8
GMON dismounting group 4 at 19 for pid 17, osid 5108
NOTE: Disk DATA33 in mode 0x9 marked for de-assignment
ERROR: diskgroup DATA02 was not mounted
ORA-15032: not all alterations performed
ORA-15036: disk 'ORCL:DATA34' is truncated
ORA-15036: disk 'ORCL:DATA14' is truncated
ERROR: ALTER DISKGROUP DATA02 MOUNT /* asm agent *//* {0:0:131} */
Wed Oct 29 14:58:32 2014
SQL> ALTER DISKGROUP DATA02 MOUNT /* asm agent *//* {0:0:144} */
NOTE: cache registered group DATA02 number=4 incarn=0x3f188dbb
NOTE: cache began mount (first) of group DATA02 number=4 incarn=0x3f188dbb
NOTE: Assigning number (4,1) to disk (ORCL:DATA33)
NOTE: cache dismounting (clean) group 4/0x3F188DBB (DATA02)
NOTE: messaging CKPT to quiesce pins Unix process pid: 5114, image: oracle@dn2newtest (TNS V1-V3)
NOTE: dbwr not being msg'd to dismount
NOTE: lgwr not being msg'd to dismount
NOTE: cache dismounted group 4/0x3F188DBB (DATA02)
NOTE: cache ending mount (fail) of group DATA02 number=4 incarn=0x3f188dbb
NOTE: cache deleting context for group DATA02 4/0x3f188dbb
GMON dismounting group 4 at 20 for pid 18, osid 5114
NOTE: Disk DATA33 in mode 0x9 marked for de-assignment
ERROR: diskgroup DATA02 was not mounted
ORA-15032: not all alterations performed
ORA-15036: disk 'ORCL:DATA34' is truncated
ORA-15036: disk 'ORCL:DATA14' is truncated
ERROR: ALTER DISKGROUP DATA02 MOUNT /* asm agent *//* {0:0:144} */
Wed Oct 29 14:58:38 2014
SQL> ALTER DISKGROUP DATA02 MOUNT /* asm agent *//* {0:0:164} */
NOTE: cache registered group DATA02 number=4 incarn=0x64488dbe
NOTE: cache began mount (first) of group DATA02 number=4 incarn=0x64488dbe
NOTE: Assigning number (4,1) to disk (ORCL:DATA33)
NOTE: cache dismounting (clean) group 4/0x64488DBE (DATA02)
NOTE: messaging CKPT to quiesce pins Unix process pid: 5104, image: oracle@dn2newtest (TNS V1-V3)
NOTE: dbwr not being msg'd to dismount
NOTE: lgwr not being msg'd to dismount
NOTE: cache dismounted group 4/0x64488DBE (DATA02)
NOTE: cache ending mount (fail) of group DATA02 number=4 incarn=0x64488dbe
NOTE: cache deleting context for group DATA02 4/0x64488dbe
Wed Oct 29 14:58:38 2014
GMON dismounting group 4 at 21 for pid 19, osid 5104
NOTE: Disk DATA33 in mode 0x9 marked for de-assignment
ERROR: diskgroup DATA02 was not mounted
ORA-15032: not all alterations performed
ORA-15036: disk 'ORCL:DATA34' is truncated
ORA-15036: disk 'ORCL:DATA14' is truncated
ERROR: ALTER DISKGROUP DATA02 MOUNT /* asm agent *//* {0:0:164} */
Wed Oct 29 14:59:26 2014
SQL> alter diskgroup DATA02 MOUNT /* ASMCA */
NOTE: cache registered group DATA02 number=4 incarn=0x90d88dfd
NOTE: cache began mount (first) of group DATA02 number=4 incarn=0x90d88dfd
NOTE: Assigning number (4,1) to disk (ORCL:DATA33)
NOTE: cache dismounting (clean) group 4/0x90D88DFD (DATA02)
NOTE: messaging CKPT to quiesce pins Unix process pid: 5423, image: oracle@dn2newtest (TNS V1-V3)
NOTE: dbwr not being msg'd to dismount
NOTE: lgwr not being msg'd to dismount
NOTE: cache dismounted group 4/0x90D88DFD (DATA02)
NOTE: cache ending mount (fail) of group DATA02 number=4 incarn=0x90d88dfd
NOTE: cache deleting context for group DATA02 4/0x90d88dfd
Wed Oct 29 14:59:26 2014
GMON dismounting group 4 at 22 for pid 20, osid 5423
NOTE: Disk DATA33 in mode 0x9 marked for de-assignment
ERROR: diskgroup DATA02 was not mounted
ORA-15032: not all alterations performed
ORA-15036: disk 'ORCL:DATA34' is truncated
ORA-15036: disk 'ORCL:DATA14' is truncated
ERROR: alter diskgroup DATA02 MOUNT /* ASMCA */
Wed Oct 29 15:00:10 2014
SQL> alter diskgroup DATA01 dismount /* ASMCA */
NOTE: Active use of SPFILE in group
Wed Oct 29 15:00:10 2014
NOTE: Instance updated compatible.asm to 11.2.0.0.0 for grp 1
ORA-15032: not all alterations performed
ORA-15027: active use of diskgroup "DATA01" precludes its dismount
ERROR: alter diskgroup DATA01 dismount /* ASMCA */
Wed Oct 29 15:00:11 2014
SQL> alter diskgroup DATA03 dismount /* ASMCA */
NOTE: cache dismounting (clean) group 3/0x54188DB1 (DATA03)
NOTE: messaging CKPT to quiesce pins Unix process pid: 5449, image: oracle@dn2newtest (TNS V1-V3)
Wed Oct 29 15:00:11 2014
NOTE: LGWR doing clean dismount of group 3 (DATA03)
NOTE: LGWR closing thread 1 of diskgroup 3 (DATA03) at ABA 4.5
NOTE: cache dismounted group 3/0x54188DB1 (DATA03)
Wed Oct 29 15:00:11 2014
GMON dismounting group 3 at 24 for pid 20, osid 5449
NOTE: Disk DATA21 in mode 0x7f marked for de-assignment
NOTE: Disk DATA22 in mode 0x7f marked for de-assignment
NOTE: Disk DATA23 in mode 0x7f marked for de-assignment
SUCCESS: diskgroup DATA03 was dismounted
NOTE: cache deleting context for group DATA03 3/0x54188db1
Wed Oct 29 15:00:11 2014
NOTE: diskgroup resource ora.DATA03.dg is offline
SUCCESS: alter diskgroup DATA03 dismount /* ASMCA */
NOTE: diskgroup resource ora.DATA03.dg is updated
SQL> alter diskgroup DATA04 dismount /* ASMCA */
NOTE: cache dismounting (clean) group 2/0x2B688DA8 (DATA04)
NOTE: messaging CKPT to quiesce pins Unix process pid: 5449, image: oracle@dn2newtest (TNS V1-V3)
NOTE: LGWR doing clean dismount of group 2 (DATA04)
NOTE: LGWR closing thread 1 of diskgroup 2 (DATA04) at ABA 4.5
NOTE: cache dismounted group 2/0x2B688DA8 (DATA04)
GMON dismounting group 2 at 25 for pid 20, osid 5449
NOTE: Disk DATA24 in mode 0x7f marked for de-assignment
SUCCESS: diskgroup DATA04 was dismounted
NOTE: cache deleting context for group DATA04 2/0x2b688da8
NOTE: diskgroup resource ora.DATA04.dg is offline
SUCCESS: alter diskgroup DATA04 dismount /* ASMCA */
NOTE: diskgroup resource ora.DATA04.dg is updated
Wed Oct 29 15:00:22 2014
SQL> alter diskgroup DATA02 MOUNT /* ASMCA */
NOTE: cache registered group DATA02 number=2 incarn=0xef588e75
NOTE: cache began mount (first) of group DATA02 number=2 incarn=0xef588e75
NOTE: Assigning number (2,1) to disk (ORCL:DATA33)
NOTE: cache dismounting (clean) group 2/0xEF588E75 (DATA02)
NOTE: messaging CKPT to quiesce pins Unix process pid: 5449, image: oracle@dn2newtest (TNS V1-V3)
NOTE: dbwr not being msg'd to dismount
NOTE: lgwr not being msg'd to dismount
NOTE: cache dismounted group 2/0xEF588E75 (DATA02)
NOTE: cache ending mount (fail) of group DATA02 number=2 incarn=0xef588e75
NOTE: cache deleting context for group DATA02 2/0xef588e75
Wed Oct 29 15:00:22 2014
GMON dismounting group 2 at 26 for pid 20, osid 5449
NOTE: Disk DATA33 in mode 0x9 marked for de-assignment
ERROR: diskgroup DATA02 was not mounted
ORA-15032: not all alterations performed
ORA-15036: disk 'ORCL:DATA34' is truncated
ORA-15036: disk 'ORCL:DATA14' is truncated
ERROR: alter diskgroup DATA02 MOUNT /* ASMCA */
Wed Oct 29 15:00:22 2014
SQL> alter diskgroup DATA03 MOUNT /* ASMCA */
NOTE: cache registered group DATA03 number=2 incarn=0xf1988e7e
NOTE: cache began mount (first) of group DATA03 number=2 incarn=0xf1988e7e
NOTE: Assigning number (2,0) to disk (ORCL:DATA21)
NOTE: Assigning number (2,1) to disk (ORCL:DATA22)
NOTE: Assigning number (2,2) to disk (ORCL:DATA23)
NOTE: GMON heartbeating for grp 2
GMON querying group 2 at 29 for pid 20, osid 5460
NOTE: cache opening disk 0 of grp 2: DATA21 label:DATA21
NOTE: F1X0 found on disk 0 au 2 fcn 0.0
NOTE: cache opening disk 1 of grp 2: DATA22 label:DATA22
NOTE: F1X0 found on disk 1 au 2 fcn 0.0
NOTE: cache opening disk 2 of grp 2: DATA23 label:DATA23
NOTE: F1X0 found on disk 2 au 2 fcn 0.0
NOTE: cache mounting (first) normal redundancy group 2/0xF1988E7E (DATA03)
NOTE: cache recovered group 2 to fcn 0.11
NOTE: redo buffer size is 256 blocks (1053184 bytes)
Wed Oct 29 15:00:29 2014
NOTE: LGWR attempting to mount thread 1 for diskgroup 2 (DATA03)
NOTE: LGWR found thread 1 closed at ABA 4.5
NOTE: LGWR mounted thread 1 for diskgroup 2 (DATA03)
NOTE: LGWR opening thread 1 at fcn 0.11 ABA 5.6
NOTE: cache mounting group 2/0xF1988E7E (DATA03) succeeded
NOTE: cache ending mount (success) of group DATA03 number=2 incarn=0xf1988e7e
Wed Oct 29 15:00:29 2014
NOTE: Instance updated compatible.asm to 11.2.0.0.0 for grp 2
SUCCESS: diskgroup DATA03 was mounted
Wed Oct 29 15:00:29 2014
NOTE: diskgroup resource ora.DATA03.dg is online
SUCCESS: alter diskgroup DATA03 MOUNT /* ASMCA */
NOTE: diskgroup resource ora.DATA03.dg is updated
SQL> alter diskgroup DATA04 MOUNT /* ASMCA */
NOTE: cache registered group DATA04 number=3 incarn=0x1a088e86
NOTE: cache began mount (first) of group DATA04 number=3 incarn=0x1a088e86
NOTE: Assigning number (3,0) to disk (ORCL:DATA24)
Wed Oct 29 15:00:35 2014
NOTE: GMON heartbeating for grp 3
GMON querying group 3 at 33 for pid 20, osid 5460
Wed Oct 29 15:00:35 2014
NOTE: cache opening disk 0 of grp 3: DATA24 label:DATA24
NOTE: F1X0 found on disk 0 au 2 fcn 0.0
NOTE: cache mounting (first) external redundancy group 3/0x1A088E86 (DATA04)
NOTE: cache recovered group 3 to fcn 0.13
NOTE: redo buffer size is 256 blocks (1053184 bytes)
NOTE: LGWR attempting to mount thread 1 for diskgroup 3 (DATA04)
NOTE: LGWR found thread 1 closed at ABA 4.5
NOTE: LGWR mounted thread 1 for diskgroup 3 (DATA04)
NOTE: LGWR opening thread 1 at fcn 0.13 ABA 5.6
NOTE: cache mounting group 3/0x1A088E86 (DATA04) succeeded
NOTE: cache ending mount (success) of group DATA04 number=3 incarn=0x1a088e86
NOTE: Instance updated compatible.asm to 11.2.0.0.0 for grp 3
SUCCESS: diskgroup DATA04 was mounted
NOTE: diskgroup resource ora.DATA04.dg is online
SUCCESS: alter diskgroup DATA04 MOUNT /* ASMCA */
NOTE: diskgroup resource ora.DATA04.dg is updated
Wed Oct 29 15:05:30 2014
NOTE: client ygzhou:ygzhou registered, osid 5844, mbr 0x0
Wed Oct 29 15:31:29 2014
SQL> alter diskgroup DATA02 resize disk DATA09 size 5098M
ORA-15032: not all alterations performed
ORA-15001: diskgroup "DATA02" does not exist or is not mounted
ERROR: alter diskgroup DATA02 resize disk DATA09 size 5098M
Wed Oct 29 15:32:23 2014
SQL> alter diskgroup DATA02 MOUNT /* ASMCA */
NOTE: cache registered group DATA02 number=4 incarn=0xd0c88efd
NOTE: cache began mount (first) of group DATA02 number=4 incarn=0xd0c88efd
NOTE: Assigning number (4,0) to disk (ORCL:DATA14)
NOTE: Assigning number (4,1) to disk (ORCL:DATA33)
NOTE: Assigning number (4,2) to disk (ORCL:DATA34)
Wed Oct 29 15:32:30 2014
NOTE: GMON heartbeating for grp 4
GMON querying group 4 at 37 for pid 23, osid 6193
NOTE: cache opening disk 0 of grp 4: DATA14 label:DATA14
NOTE: F1X0 found on disk 0 au 2 fcn 0.0
NOTE: cache opening disk 1 of grp 4: DATA33 label:DATA33
NOTE: F1X0 found on disk 1 au 2 fcn 0.0
NOTE: cache opening disk 2 of grp 4: DATA34 label:DATA34
NOTE: F1X0 found on disk 2 au 2 fcn 0.0
NOTE: cache mounting (first) high redundancy group 4/0xD0C88EFD (DATA02)
NOTE: cache recovered group 4 to fcn 0.6
NOTE: redo buffer size is 256 blocks (1053184 bytes)
Wed Oct 29 15:32:30 2014
NOTE: LGWR attempting to mount thread 1 for diskgroup 4 (DATA02)
NOTE: LGWR found thread 1 closed at ABA 3.3
NOTE: LGWR mounted thread 1 for diskgroup 4 (DATA02)
NOTE: LGWR opening thread 1 at fcn 0.6 ABA 4.4
NOTE: cache mounting group 4/0xD0C88EFD (DATA02) succeeded
NOTE: cache ending mount (success) of group DATA02 number=4 incarn=0xd0c88efd
Wed Oct 29 15:32:30 2014
NOTE: Instance updated compatible.asm to 11.2.0.0.0 for grp 4
SUCCESS: diskgroup DATA02 was mounted
SUCCESS: alter diskgroup DATA02 MOUNT /* ASMCA */
Wed Oct 29 15:32:31 2014
NOTE: diskgroup resource ora.DATA02.dg is online
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/24867586/viewspace-1313474/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- ASM disk group mount fails with ORA-15036: disk is truncated [ID 1077175.1]ASMAI
- Mount ASM Disk Group Fails : ORA-15186, ORA-15025, ORA-15063_1384504.1ASMAI
- ASM Disk Group TemplateASM
- 規劃ASM DISK GROUP、檢視asm 磁碟當前狀態、mount or dismount 磁碟組ASM
- Oracle ASM spfile in a disk groupOracleASM
- 直接修改ASM disk大小導致ORA-15036ASM
- Oracle ASM ACFS disk group rebalanceOracleASM
- Oracle ASM Disk Group AttributesOracleASM
- ORA-15260: permission denied on ASM disk groupASM
- How to move ASM spfile to a different disk group [ID 1082943.1]ASM
- 移動ASM的spfile到一個新的disk groupASM
- 解決ORA-15036:disk is truncated錯誤
- drop asm disk、撤銷drop asm diskASM
- mount windows shared diskWindows
- 手工建立ASM Disk Groups、為 ASM Disk Groups 新增 diskASM
- Asm disk managerASM
- ASM DISK Group載入ORA-15183錯誤一例ASM
- Oracle ASM Disk DirectoryOracleASM
- Oracle ASM Disk PartnerOracleASM
- ASM: Device is already labeled for ASM diskASMdev
- Oracle ASM Disk HeaderOracleASMHeader
- Oracle ASM Disk Used Space DirectoryOracleASM
- ASM DISK HEADER CORRUPTION & REPAIRASMHeaderAI
- ASM Normal需要3個disk ?ASMORM
- asm disk 的結構(1)ASM
- oracleasm createdisk ASM: Device is already labeled for ASM diskOracleASMdev
- ASM 翻譯系列第十彈:ASM Internal ASM DISK headerASMHeader
- Using ASMLIB Management ASM DiskASM
- [Oracle Script] ASM Disk Groups UsedOracleASM
- ASM磁碟組刪除DISK操作ASM
- Identify If A Disk/Part Is Still Used By ASM,Used by ASM Or Used by ASM_603210.1IDEASM
- Oracle ASM User Directory and Group DirectoryOracleASM
- oracle asm Unable to mount ASMlib driver filesystemOracleASM
- RAC關鍵資訊(OCR/VOTE DISK/ASM DISK HEADER)備份ASMHeader
- ASM 11g New Features - How ASM Disk Resync WorksASM
- Oracle ASM disk誤被格式化OracleASM
- V$ASM_DISK 檢視含義ASM
- 11g ASM asm_preferred_read_failure_groupASMAI