It is easier to add a disk image to ASM using DBCA on node 1. Two new directories are created: ARCHLOG and BACKUP. Node 2 cannot be loaded! [Oracle @ node2bdump] $ exportORACLE_SID + ASM2 [oracle @ node2bdump] $ asmcmdASMCMDllcommands: -------- cddufindhelplslsctlsdgmkalias
It is easier to add a disk image to ASM using DBCA on node 1. Two new directories are created: ARCHLOG and BACKUP. Node 2 cannot be loaded! [Oracle @ node2bdump] $ export ORACLE_SID = + ASM2 [oracle @ node2bdump] $ asmcmd ASMCMDll commands: -------- cd du find help ls lsct lsdg mkalias
It is easier to add a disk image to ASM using DBCA on node 1. Two new directories are created: ARCHLOG and BACKUP. Node 2 cannot be loaded!
[Oracle @ node2bdump] $ export ORACLE_SID = + ASM2
[Oracle @ node2bdump] $ asmcmd
ASMCMD> ll
Commands:
--------
Cd
Du
Find
Help
Ls
Lsct
Lsdg
Mkalias
Mkdir
Pwd
Rm
Rmalias
ASMCMD> ls
ARCHLOG/
BACKUP/
DATA/
ASMCMD> cd DATA
ASMCMD> ls
MYRAC/
ASMCMD> cd ..
ASMCMD> cd ARCHLOG
Unable to access this directory
Start the ASM instance
SQL> startup
ORA-32004: obsolete and/or deprecated parameter (s) specified
ASMinstance started
TotalSystem Global Area 92274688 bytes
FixedSize 1217884 bytes
VariableSize 65890980 bytes
ASMCache 25165824 bytes
ORA-15032: not all alterations saved med
ORA-15003: diskgroup "DATA" already mounted in another lock name space
ORA-15003: diskgroup "BACKUP" already mounted in another lock name space
ORA-15003: diskgroup "ARCHLOG" already mounted in another lock name space
The ASM instance already exists.
[Oracle @ node2dbs] $ ps-ef | grep asm _
Oracle 26435 1 0? 00:00:00 asm_pmon _ + ASM2
Oracle 26437 1 0? 00:00:00 asm_diag _ + ASM2
Oracle 26439 1 0? 00:00:00 asm_psp0 _ + ASM2
Oracle 26459 1 0? 00:00:01 asm_lmon _ + ASM2
Oracle 26461 1 0? 00:00:00 asm_lmd0 _ + ASM2
Oracle 26463 1 0? 00:00:00 asm_lms0 _ + ASM2
Oracle 26480 1 0? 00:00:00 asm_mman _ + ASM2
Oracle 26482 1 0? 00:00:00 asm_dbw0 _ + ASM2
Oracle 26484 1 0? 00:00:00 asm_lgwr _ + ASM2
Oracle 26486 1 0? 00:00:00 asm_ckpt _ + ASM2
Oracle 26488 1 0? 00:00:00 asm_smon _ + ASM2
Oracle 26490 1 0? 00:00:00 asm_rbal _ + ASM2
Oracle 26492 1 0? 00:00:00 asm_gmon _ + ASM2
Oracle 26564 1 0? 00:00:00 asm_lck0 _ + ASM2
Oracle 32297 24832 0 00:00:00 pts/1 grep asm _
ExportORACLE_SID = + ASM2
Sqlplus/as sysdba
SQL> shutdown immediate;
SQL> conn/as sysdba
Connectedto an idle instance.
SQL> startup
ASMinstance started
TotalSystem Global Area 92274688 bytes
FixedSize 1217884 bytes
VariableSize 65890980 bytes
ASMCache 25165824 bytes
ORA-15032: not all alterations saved med
ORA-15063: ASM discovered an insufficient number of disks for diskgroup
"BACKUP"
ORA-15063: ASM discovered an insufficient number of disks for diskgroup
"ARCHLOG"
View ASM logs
Tail-100/opt/oracle/database/admin/+ ASM/bdump/alert _ + ASM2.log
SQL> ALTER DISKGROUP ALL MOUNT
TueSep 25 17:52:30 2012
NOTE: cache registered group DATA number = 1 incarn = 0x28a105da
NOTE: cache registered group ARCHLOG number = 2 incarn = 0x25e105d8
NOTE: cache registered group BACKUP number = 3 incarn = 0x262105d9
TueSep 25 17:52:30 2012
LoadedASM Library-Generic Linux, version 2.0.4 (KABI_V2) library for asmlib interface
TueSep 25 17:52:30 2012
NOTE: When at: instance not first (grp 1)
ERROR: no PST quorum in group 2: required 1, found 0
Tue Sep 25 17:52:30 2012
NOTE: cache dismounting group2/0x25E105D8 (ARCHLOG)
NOTE: dbwr not being msg 'd to dismount
ERROR: diskgroup ARCHLOG was not mounted
TueSep 25 17:52:30 2012
ERROR: no PST quorum in group 3: required 1, found 0
TueSep 25 17:52:30 2012
NOTE: cache dismounting group 3/0x262105D9 (BACKUP)
NOTE: dbwr not being msg 'd to dismount
ERROR: diskgroup BACKUP was not mounted
NOTE: cache opening disk 0 of grp 1: VOL1 label: VOL1
NOTE: F1X0 found on disk 0 fcn 0.0
NOTE: cache opening disk 1 of grp 1: VOL2 label: VOL2
NOTE: cache mounting (not first) group 1/0x28A105DA (DATA)
TueSep 25 17:52:31 2012
Kjbdomattsend to node 0
TueSep 25 17:52:31 2012
NOTE: attached to recovery domain 1
TueSep 25 17:52:32 2012
NOTE: opening chunk 1 at fcn 0.7142 ABA
NOTE: seq = 42 blk = 940
TueSep 25 17:52:32 2012
NOTE: cache mounting group 1/0x28A105DA (DATA) succeeded
SUCCESS: diskgroup DATA was mounted
TueSep 25 17:52:34 2012
NOTE: recovering COD for group 1/0x28a105da (DATA)
SUCCESS: completed COD recovery for group 1/0x28a105da (DATA)
Disable the VM and modify the VMX file.
Scsi1.sharedBus = "VIRTUAL"