User Tools

Site Tools


oracle

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
oracle [2021/02/11 09:30]
ss_wiki_admin [ASM]
oracle [2021/04/23 07:54] (current)
ss_wiki_admin [ASM]
Line 780: Line 780:
 == Add disk to diskgroups == == Add disk to diskgroups ==
 <code sql> <code sql>
-SQL> alter diskgroup dbfs_dg add disk 'o/192.168.3.143/DBFS_DG_CD_04_m1cel03man' name DBFS_DG_CD_04_m1CEL03MAN force rebalance nowait +SQL> alter diskgroup dbfs_dg add disk 'o/192.168.3.143/DBFS_DG_CD_04_m1cel03man' name DBFS_DG_CD_04_M1CEL03MAN force rebalance nowait 
-SQL> alter diskgroup reco_m1 add disk 'o/192.168.3.143/RECO_M1_CD_04_m1cel03man' name RECO_HEM1_CD_04_M1CEL03MAN+SQL> alter diskgroup reco_m1 add disk 'o/192.168.3.143/RECO_M1_CD_04_m1cel03man' name RECO_M1_CD_04_M1CEL03MAN
 </code> </code>
  
Line 801: Line 801:
 == Drop old disk == == Drop old disk ==
 <code sql> <code sql>
-alter diskgroup DATA_HEM1 drop disk '_DROPPED_0074_DATA_HEM1'; +alter diskgroup DATA_M1 drop disk '_DROPPED_0074_DATA_M1'; 
 </code> </code>
  
Line 812: Line 812:
 == Moving multiple files inside ASM == == Moving multiple files inside ASM ==
 <code bash> <code bash>
-for i in $(asmcmd ls +RECOC1/EIWODSD/ARCHIVELOG/RESTORE2); do +for i in $(asmcmd ls +RECOC1/DB/ARCHIVELOG/RESTORE2); do 
-   asmcmd cp +RECOC1/EIWODSD/ARCHIVELOG/RESTORE2/$i +DATAC1/TMPARCH/RESTORE2; +   asmcmd cp +RECOC1/DB/ARCHIVELOG/RESTORE2/$i +DATAC1/TMPARCH/RESTORE2; 
-   asmcmd rm +RECOC1/EIWODSD/ARCHIVELOG/RESTORE2/$i;+   asmcmd rm +RECOC1/DB/ARCHIVELOG/RESTORE2/$i;
 done done
 </code> </code>
oracle.1613035850.txt.gz · Last modified: 2021/02/11 09:30 by ss_wiki_admin