Differences

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

--- oracle [2021/01/04 08:49]
ss_wiki_admin [Auditing Control]
+++ oracle [2021/04/23 07:54] (current)
ss_wiki_admin [ASM]
@@ Line 755: / Line 755: @@
 SQL>
 select * from gv$asm_operation;
+</code>
+== Show rebalance operation estimates ==
+<code sql>
+select INST_ID, OPERATION, STATE, POWER, SOFAR, EST_WORK, EST_RATE, EST_MINUTES from GV$ASM_OPERATION;
 </code>
@@ Line 775: / Line 780: @@
 == Add disk to diskgroups ==
 <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>
@@ Line 796: / Line 801: @@
 == Drop old disk ==
 <code sql>
-alter diskgroup DATA_HEM1 drop disk '_DROPPED_0074_DATA_HEM1';
+alter diskgroup DATA_M1 drop disk '_DROPPED_0074_DATA_M1';
 </code>
@@ Line 807: / Line 812: @@
 == Moving multiple files inside ASM ==
 <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
 </code>

Shaun's Wiki

User Tools

Site Tools

Differences

Page Tools