Category Archives: ASM

Move OCR, Voting Disk File, ASM SPILE to a New Diskgroup ( 11.2.0.4 )

Below exercise is to move everything from old OCR/VOTING diskgroup OCR_VOTE ┬áto new diskgroup OCR_VOTE2. 1)Create New CRS Diskgroup: SQL> create diskgroup OCR_VOTE2 external redundancy disk ‘ORCL:OCR_VOTE2’; Diskgroup created. SQL> alter diskgroup OCR_VOTE2 set attribute ‘compatible.asm’=’11.2.0.0’; Diskgroup altered. 2) Mount … Continue reading

Posted in ASM, GI and RAC | Tagged , , , , , , , , , , , | Leave a comment

How to Move Datafiles From One Diskgroup DATA1 to Another Diskgroup DATA2 For a Standby Database

TASK This task is to move all the datafiles of diskgroup DATA1 to another diskgroup DATA2 for a standby database. SOULUTION 1)Check the diskgroup space availability SQL> set pagesize 120 SQL> set linesize 180 SQL> select NAME,TOTAL_MB/1024,FREE_MB/1024,USABLE_FILE_MB/1024 from v$asm_diskgroup; NAME … Continue reading

Posted in ASM, DataGuard, RMAN Restore and Recovery | Tagged , , , , , , , | Leave a comment