This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision Next revision | Previous revision | ||
|
oracle [2021/02/11 09:29] ss_wiki_admin [ASM] |
oracle [2021/04/23 07:54] (current) ss_wiki_admin [ASM] |
||
|---|---|---|---|
| Line 759: | Line 759: | ||
| == Show rebalance operation estimates == | == Show rebalance operation estimates == | ||
| <code sql> | <code sql> | ||
| - | select INST_ID, OPERATION, STATE, POWER, SOFAR, EST_WORK, EST_RATE, EST_MINUTES from GV$ASM_OPERATION | + | select INST_ID, OPERATION, STATE, POWER, SOFAR, EST_WORK, EST_RATE, EST_MINUTES from GV$ASM_OPERATION; |
| </ | </ | ||
| Line 780: | Line 780: | ||
| == Add disk to diskgroups == | == Add disk to diskgroups == | ||
| <code sql> | <code sql> | ||
| - | SQL> alter diskgroup dbfs_dg add disk ' | + | SQL> alter diskgroup dbfs_dg add disk ' |
| - | SQL> alter diskgroup reco_m1 add disk ' | + | SQL> alter diskgroup reco_m1 add disk ' |
| </ | </ | ||
| Line 801: | Line 801: | ||
| == Drop old disk == | == Drop old disk == | ||
| <code sql> | <code sql> | ||
| - | alter diskgroup | + | alter diskgroup |
| </ | </ | ||
| 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/ | + | for i in $(asmcmd ls +RECOC1/DB/ |
| - | | + | |
| - | | + | |
| done | done | ||
| </ | </ | ||