ath:/dev/asm-diskf
NOTE: cache mounting (first) external redundancy group 2/0x266B8137 (ZBDBA)
* allocate domain 2, invalid = TRUE
NOTE: attached to recovery domain 2
NOTE: starting recovery of thread=1 ckpt=7.284 group=2 (ZBDBA)
NOTE: advancing ckpt for group 2 (ZBDBA) thread=1 ckpt=7.284
NOTE: cache recovered group 2 to fcn 0.2892
NOTE: redo buffer size is 256 blocks (1053184 bytes)
NOTE: LGWR attempting to mount thread 1 for diskgroup 2 (ZBDBA)
NOTE: LGWR found thread 1 closed at ABA 7.283
NOTE: LGWR mounted thread 1 for diskgroup 2 (ZBDBA)
NOTE: LGWR opening thread 1 at fcn 0.2892 ABA 8.284
NOTE: cache mounting group 2/0x266B8137 (ZBDBA) succeeded
NOTE: cache ending mount (success) of group ZBDBA number=2 incarn=0x266b8137
NOTE: Instance updated compatible.asm to 11.2.0.0.0 for grp 1
SUCCESS: diskgroup DATA was mounted
NOTE: Instance updated compatible.asm to 10.1.0.0.0 for grp 2
SUCCESS: diskgroup ZBDBA was mounted
ORACLE_BASE value has been saved for future startups
SUCCESS: ALTER DISKGROUP ALL MOUNT
SQL> ALTER DISKGROUP ALL ENABLE VOLUME ALL
SUCCESS: ALTER DISKGROUP ALL ENABLE VOLUME ALL
NOTE: diskgroup resource ora.DATA.dg is online
NOTE: diskgroup resource ora.ZBDBA.dg is online
NOTE: Attempting voting file refresh on diskgroup DATA
NOTE: Refresh completed on diskgroup DATA
. Found 3 voting file(s).
NOTE: Voting file relocation is required in diskgroup DATA
NOTE: Attempting voting file relocation on diskgroup DATA
NOTE: Successful voting file relocation on diskgroup DATA
Sun Feb 08 02:50:00 2015
ALTER SYSTEM SET local_listener=' (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.56.52)(PORT=1521))))' SCOPE=MEMORY SID='+ASM1';
Sun Feb 08 02:50:01 2015
NOTE: [crsd.bin@zbdba1 (TNS V1-V3) 11280] opening OCR file
Starting background process ASMB
Sun Feb 08 02:50:01 2015
ASMB started with pid=26, OS id=11293
Sun Feb 08 02:50:01 2015
NOTE: client +ASM1:+ASM registered, osid 11295, mbr 0x0
Sun Feb 08 02:50:18 2015
Reconfiguration started (old inc 2, new inc 4)
List of instances:
1 2 (myinst: 1)
Global Resource Directory frozen
Communication channels reestablished
Master broadcasted resource hash value bitmaps
Non-local Process blocks cleaned out
Sun Feb 08 02:50:18 2015
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查看磁盘组状态:
ASMCMD> lsdg
State Type Rebal Sector Block AU Total_MB Free_MB Req_mir_free_MB Usable_file_MB Offline_disks Voting_files Name
MOUNTED NORMAL N 512 4096 1048576 6144 5218 2048 1585 0 Y DATA/
MOUNTED EXTERN N 512 4096 1048576 10240 8179 0 8179 0 N ZBDBA/
创建spfile:
create spfile='+DATA' from pfile;
启动另外一个节点ASM
7、创建数据库参数文件
[oracle@zbdba1 dbs]$ cat inittest1.ora
test1.__db_cache_size=264241152
test2.__db_cache_size=264241152
test1.__java_pool_size=4194304
test2.__java_pool_size=4194304
test1.__large_pool_size=8388608
test2.__large_pool_size=8388608
test1.__pga_aggregate_target=318767104
test2.__pga_aggregate_target=318767104
test1.__sga_target=469762048
test2.__sga_target=469762048
test1.__shared_io_pool_size=0
test2.__shared_io_pool_size=0
test1.__shared_pool_size=184549376
test2.__shared_pool_size=184549376
test1.__stre