Jadual Kandungan
RMAN备份进度查询
sandaran
Selesai
Semak
Pertanyaan
jadual
查看已经完成和未完成的RMAN备份进度 set line 9999 col opname for a35 col start_time for a19 SELECT SID , SERIAL# , opname , to_char(start_time , 'yyyy - mm - dd HH24:MI:SS') start_time , SOFAR , TOTALWORK , ROUND(SOFAR/TOTALWORK*100 , 2) "%
查看已经完成和未完成的RMAN备份进度
<code class=" hljs brainfuck"><span class="hljs-comment">set</span> <span class="hljs-comment">line</span> <span class="hljs-comment">9999</span>
<span class="hljs-comment">col</span> <span class="hljs-comment">opname</span> <span class="hljs-comment">for</span> <span class="hljs-comment">a35</span>
<span class="hljs-comment">col</span> <span class="hljs-comment">start_time</span> <span class="hljs-comment">for</span> <span class="hljs-comment">a19</span>
<span class="hljs-comment">SELECT</span> <span class="hljs-comment">SID</span><span class="hljs-string">,</span> <span class="hljs-comment">SERIAL#</span><span class="hljs-string">,</span><span class="hljs-comment">opname</span><span class="hljs-string">,</span> <span class="hljs-comment">to_char(start_time</span><span class="hljs-string">,</span><span class="hljs-comment">'yyyy</span><span class="hljs-literal">-</span><span class="hljs-comment">mm</span><span class="hljs-literal">-</span><span class="hljs-comment">dd</span> <span class="hljs-comment">HH24:MI:SS')</span> <span class="hljs-comment">start_time</span><span class="hljs-string">,</span> <span class="hljs-comment">SOFAR</span><span class="hljs-string">,</span> <span class="hljs-comment">TOTALWORK</span><span class="hljs-string">,</span>
<span class="hljs-comment">ROUND(SOFAR/TOTALWORK*100</span><span class="hljs-string">,</span><span class="hljs-comment">2)</span> <span class="hljs-comment">"%COMPLETE"</span><span class="hljs-string">,</span><span class="hljs-comment">ceil(ELAPSED_SECONDS/60)</span> <span class="hljs-comment">ELAPSED_MI</span>
<span class="hljs-comment">FROM</span> <span class="hljs-comment">V$SESSION_LONGOPS</span>
<span class="hljs-comment">where</span> <span class="hljs-comment">opname</span> <span class="hljs-comment">like</span> <span class="hljs-comment">'RMAN%'</span> <span class="hljs-comment">order</span> <span class="hljs-comment">by</span> <span class="hljs-comment">start_time</span> <span class="hljs-comment">asc;</span>
<span class="hljs-comment">SID</span> <span class="hljs-comment">SERIAL#</span> <span class="hljs-comment">OPNAME</span> <span class="hljs-comment">START_TIME</span> <span class="hljs-comment">SOFAR</span> <span class="hljs-comment">TOTALWORK</span> <span class="hljs-comment">%COMPLETE</span> <span class="hljs-comment">ELAPSED_MI</span>
<span class="hljs-literal">-</span><span class="hljs-literal">-</span><span class="hljs-literal">-</span><span class="hljs-literal">-</span><span class="hljs-literal">-</span><span class="hljs-literal">-</span><span class="hljs-literal">-</span><span class="hljs-literal">-</span><span class="hljs-literal">-</span><span class="hljs-literal">-</span> <span class="hljs-literal">-</span><span class="hljs-literal">-</span><span class="hljs-literal">-</span><span class="hljs-literal">-</span><span class="hljs-literal">-</span><span class="hljs-literal">-</span><span class="hljs-literal">-</span><span class="hljs-literal">-</span><span class="hljs-literal">-</span><span class="hljs-literal">-</span> <span class="hljs-literal">-</span><span class="hljs-literal">-</span><span class="hljs-literal">-</span><span class="hljs-literal">-</span><span class="hljs-literal">-</span><span class="hljs-literal">-</span><span class="hljs-literal">-</span><span class="hljs-literal">-</span><span class="hljs-literal">-</span><span class="hljs-literal">-</span><span class="hljs-literal">-</span><span class="hljs-literal">-</span><span class="hljs-literal">-</span><span class="hljs-literal">-</span><span class="hljs-literal">-</span><span class="hljs-literal">-</span><span class="hljs-literal">-</span><span class="hljs-literal">-</span><span class="hljs-literal">-</span><span class="hljs-literal">-</span><span class="hljs-literal">-</span><span class="hljs-literal">-</span><span class="hljs-literal">-</span><span class="hljs-literal">-</span><span class="hljs-literal">-</span><span class="hljs-literal">-</span><span class="hljs-literal">-</span><span class="hljs-literal">-</span><span class="hljs-literal">-</span><span class="hljs-literal">-</span><span class="hljs-literal">-</span><span class="hljs-literal">-</span><span class="hljs-literal">-</span><span class="hljs-literal">-</span><span class="hljs-literal">-</span> <span class="hljs-literal">-</span><span class="hljs-literal">-</span><span class="hljs-literal">-</span><span class="hljs-literal">-</span><span class="hljs-literal">-</span><span class="hljs-literal">-</span><span class="hljs-literal">-</span><span class="hljs-literal">-</span><span class="hljs-literal">-</span><span class="hljs-literal">-</span><span class="hljs-literal">-</span><span class="hljs-literal">-</span><span class="hljs-literal">-</span><span class="hljs-literal">-</span><span class="hljs-literal">-</span><span class="hljs-literal">-</span><span class="hljs-literal">-</span><span class="hljs-literal">-</span><span class="hljs-literal">-</span> <span class="hljs-literal">-</span><span class="hljs-literal">-</span><span class="hljs-literal">-</span><span class="hljs-literal">-</span><span class="hljs-literal">-</span><span class="hljs-literal">-</span><span class="hljs-literal">-</span><span class="hljs-literal">-</span><span class="hljs-literal">-</span><span class="hljs-literal">-</span> <span class="hljs-literal">-</span><span class="hljs-literal">-</span><span class="hljs-literal">-</span><span class="hljs-literal">-</span><span class="hljs-literal">-</span><span class="hljs-literal">-</span><span class="hljs-literal">-</span><span class="hljs-literal">-</span><span class="hljs-literal">-</span><span class="hljs-literal">-</span> <span class="hljs-literal">-</span><span class="hljs-literal">-</span><span class="hljs-literal">-</span><span class="hljs-literal">-</span><span class="hljs-literal">-</span><span class="hljs-literal">-</span><span class="hljs-literal">-</span><span class="hljs-literal">-</span><span class="hljs-literal">-</span><span class="hljs-literal">-</span> <span class="hljs-literal">-</span><span class="hljs-literal">-</span><span class="hljs-literal">-</span><span class="hljs-literal">-</span><span class="hljs-literal">-</span><span class="hljs-literal">-</span><span class="hljs-literal">-</span><span class="hljs-literal">-</span><span class="hljs-literal">-</span><span class="hljs-literal">-</span>
<span class="hljs-comment">425</span> <span class="hljs-comment">60361</span> <span class="hljs-comment">RMAN:</span> <span class="hljs-comment">aggregate</span> <span class="hljs-comment">input</span> <span class="hljs-comment">2016</span><span class="hljs-literal">-</span><span class="hljs-comment">05</span><span class="hljs-literal">-</span><span class="hljs-comment">06</span> <span class="hljs-comment">23:00:00</span> <span class="hljs-comment">56800564</span> <span class="hljs-comment">56800564</span> <span class="hljs-comment">100</span> <span class="hljs-comment">10</span>
<span class="hljs-comment">164</span> <span class="hljs-comment">7634</span> <span class="hljs-comment">RMAN:</span> <span class="hljs-comment">incremental</span> <span class="hljs-comment">datafile</span> <span class="hljs-comment">backup</span> <span class="hljs-comment">2016</span><span class="hljs-literal">-</span><span class="hljs-comment">05</span><span class="hljs-literal">-</span><span class="hljs-comment">06</span> <span class="hljs-comment">23:00:03</span> <span class="hljs-comment">91877</span> <span class="hljs-comment">91877</span> <span class="hljs-comment">100</span> <span class="hljs-comment">6</span>
<span class="hljs-comment">164</span> <span class="hljs-comment">7634</span> <span class="hljs-comment">RMAN:</span> <span class="hljs-comment">incremental</span> <span class="hljs-comment">datafile</span> <span class="hljs-comment">backup</span> <span class="hljs-comment">2016</span><span class="hljs-literal">-</span><span class="hljs-comment">05</span><span class="hljs-literal">-</span><span class="hljs-comment">06</span> <span class="hljs-comment">23:00:03</span> <span class="hljs-comment">22665768</span> <span class="hljs-comment">22665768</span> <span class="hljs-comment">100</span> <span class="hljs-comment">6</span>
<span class="hljs-comment">873</span> <span class="hljs-comment">12782</span> <span class="hljs-comment">RMAN:</span> <span class="hljs-comment">aggregate</span> <span class="hljs-comment">output</span> <span class="hljs-comment">2016</span><span class="hljs-literal">-</span><span class="hljs-comment">05</span><span class="hljs-literal">-</span><span class="hljs-comment">06</span> <span class="hljs-comment">23:02:06</span> <span class="hljs-comment">191157</span> <span class="hljs-comment">191157</span> <span class="hljs-comment">100</span> <span class="hljs-comment">5</span>
<span class="hljs-comment">164</span> <span class="hljs-comment">7634</span> <span class="hljs-comment">RMAN:</span> <span class="hljs-comment">archived</span> <span class="hljs-comment">log</span> <span class="hljs-comment">backup</span> <span class="hljs-comment">2016</span><span class="hljs-literal">-</span><span class="hljs-comment">05</span><span class="hljs-literal">-</span><span class="hljs-comment">06</span> <span class="hljs-comment">23:06:47</span> <span class="hljs-comment">6167946</span> <span class="hljs-comment">6167946</span> <span class="hljs-comment">100</span> <span class="hljs-comment">3</span>
<span class="hljs-comment">164</span> <span class="hljs-comment">7634</span> <span class="hljs-comment">RMAN:</span> <span class="hljs-comment">archived</span> <span class="hljs-comment">log</span> <span class="hljs-comment">backup</span> <span class="hljs-comment">2016</span><span class="hljs-literal">-</span><span class="hljs-comment">05</span><span class="hljs-literal">-</span><span class="hljs-comment">06</span> <span class="hljs-comment">23:06:47</span> <span class="hljs-comment">6167943</span> <span class="hljs-comment">6167943</span> <span class="hljs-comment">100</span> <span class="hljs-comment">3</span>
<span class="hljs-comment">873</span> <span class="hljs-comment">12782</span> <span class="hljs-comment">RMAN:</span> <span class="hljs-comment">aggregate</span> <span class="hljs-comment">output</span> <span class="hljs-comment">2016</span><span class="hljs-literal">-</span><span class="hljs-comment">05</span><span class="hljs-literal">-</span><span class="hljs-comment">06</span> <span class="hljs-comment">23:08:43</span> <span class="hljs-comment">11659959</span> <span class="hljs-comment">11659959</span> <span class="hljs-comment">100</span> <span class="hljs-comment">1</span>
<span class="hljs-comment">425</span> <span class="hljs-comment">60361</span> <span class="hljs-comment">RMAN:</span> <span class="hljs-comment">aggregate</span> <span class="hljs-comment">output</span> <span class="hljs-comment">2016</span><span class="hljs-literal">-</span><span class="hljs-comment">05</span><span class="hljs-literal">-</span><span class="hljs-comment">06</span> <span class="hljs-comment">23:09:10</span> <span class="hljs-comment">11659959</span> <span class="hljs-comment">11659959</span> <span class="hljs-comment">100</span> <span class="hljs-comment">0</span>
<span class="hljs-comment">425</span> <span class="hljs-comment">60361</span> <span class="hljs-comment">RMAN:</span> <span class="hljs-comment">aggregate</span> <span class="hljs-comment">output</span> <span class="hljs-comment">2016</span><span class="hljs-literal">-</span><span class="hljs-comment">05</span><span class="hljs-literal">-</span><span class="hljs-comment">06</span> <span class="hljs-comment">23:09:10</span> <span class="hljs-comment">11659959</span> <span class="hljs-comment">11659959</span> <span class="hljs-comment">100</span> <span class="hljs-comment">0</span>
<span class="hljs-comment">832</span> <span class="hljs-comment">32639</span> <span class="hljs-comment">RMAN:</span> <span class="hljs-comment">aggregate</span> <span class="hljs-comment">input</span> <span class="hljs-comment">2016</span><span class="hljs-literal">-</span><span class="hljs-comment">05</span><span class="hljs-literal">-</span><span class="hljs-comment">07</span> <span class="hljs-comment">23:00:00</span> <span class="hljs-comment">47200200</span> <span class="hljs-comment">47200200</span> <span class="hljs-comment">100</span> <span class="hljs-comment">8</span>
<span class="hljs-comment">185</span> <span class="hljs-comment">57618</span> <span class="hljs-comment">RMAN:</span> <span class="hljs-comment">incremental</span> <span class="hljs-comment">datafile</span> <span class="hljs-comment">backup</span> <span class="hljs-comment">2016</span><span class="hljs-literal">-</span><span class="hljs-comment">05</span><span class="hljs-literal">-</span><span class="hljs-comment">07</span> <span class="hljs-comment">23:00:02</span> <span class="hljs-comment">148787</span> <span class="hljs-comment">148787</span> <span class="hljs-comment">100</span> <span class="hljs-comment">7</span>
<span class="hljs-comment">SID</span> <span class="hljs-comment">SERIAL#</span> <span class="hljs-comment">OPNAME</span> <span class="hljs-comment">START_TIME</span> <span class="hljs-comment">SOFAR</span> <span class="hljs-comment">TOTALWORK</span> <span class="hljs-comment">%COMPLETE</span> <span class="hljs-comment">ELAPSED_MI</span>
<span class="hljs-literal">-</span><span class="hljs-literal">-</span><span class="hljs-literal">-</span><span class="hljs-literal">-</span><span class="hljs-literal">-</span><span class="hljs-literal">-</span><span class="hljs-literal">-</span><span class="hljs-literal">-</span><span class="hljs-literal">-</span><span class="hljs-literal">-</span> <span class="hljs-literal">-</span><span class="hljs-literal">-</span><span class="hljs-literal">-</span><span class="hljs-literal">-</span><span class="hljs-literal">-</span><span class="hljs-literal">-</span><span class="hljs-literal">-</span><span class="hljs-literal">-</span><span class="hljs-literal">-</span><span class="hljs-literal">-</span> <span class="hljs-literal">-</span><span class="hljs-literal">-</span><span class="hljs-literal">-</span><span class="hljs-literal">-</span><span class="hljs-literal">-</span><span class="hljs-literal">-</span><span class="hljs-literal">-</span><span class="hljs-literal">-</span><span class="hljs-literal">-</span><span class="hljs-literal">-</span><span class="hljs-literal">-</span><span class="hljs-literal">-</span><span class="hljs-literal">-</span><span class="hljs-literal">-</span><span class="hljs-literal">-</span><span class="hljs-literal">-</span><span class="hljs-literal">-</span><span class="hljs-literal">-</span><span class="hljs-literal">-</span><span class="hljs-literal">-</span><span class="hljs-literal">-</span><span class="hljs-literal">-</span><span class="hljs-literal">-</span><span class="hljs-literal">-</span><span class="hljs-literal">-</span><span class="hljs-literal">-</span><span class="hljs-literal">-</span><span class="hljs-literal">-</span><span class="hljs-literal">-</span><span class="hljs-literal">-</span><span class="hljs-literal">-</span><span class="hljs-literal">-</span><span class="hljs-literal">-</span><span class="hljs-literal">-</span><span class="hljs-literal">-</span> <span class="hljs-literal">-</span><span class="hljs-literal">-</span><span class="hljs-literal">-</span><span class="hljs-literal">-</span><span class="hljs-literal">-</span><span class="hljs-literal">-</span><span class="hljs-literal">-</span><span class="hljs-literal">-</span><span class="hljs-literal">-</span><span class="hljs-literal">-</span><span class="hljs-literal">-</span><span class="hljs-literal">-</span><span class="hljs-literal">-</span><span class="hljs-literal">-</span><span class="hljs-literal">-</span><span class="hljs-literal">-</span><span class="hljs-literal">-</span><span class="hljs-literal">-</span><span class="hljs-literal">-</span> <span class="hljs-literal">-</span><span class="hljs-literal">-</span><span class="hljs-literal">-</span><span class="hljs-literal">-</span><span class="hljs-literal">-</span><span class="hljs-literal">-</span><span class="hljs-literal">-</span><span class="hljs-literal">-</span><span class="hljs-literal">-</span><span class="hljs-literal">-</span> <span class="hljs-literal">-</span><span class="hljs-literal">-</span><span class="hljs-literal">-</span><span class="hljs-literal">-</span><span class="hljs-literal">-</span><span class="hljs-literal">-</span><span class="hljs-literal">-</span><span class="hljs-literal">-</span><span class="hljs-literal">-</span><span class="hljs-literal">-</span> <span class="hljs-literal">-</span><span class="hljs-literal">-</span><span class="hljs-literal">-</span><span class="hljs-literal">-</span><span class="hljs-literal">-</span><span class="hljs-literal">-</span><span class="hljs-literal">-</span><span class="hljs-literal">-</span><span class="hljs-literal">-</span><span class="hljs-literal">-</span> <span class="hljs-literal">-</span><span class="hljs-literal">-</span><span class="hljs-literal">-</span><span class="hljs-literal">-</span><span class="hljs-literal">-</span><span class="hljs-literal">-</span><span class="hljs-literal">-</span><span class="hljs-literal">-</span><span class="hljs-literal">-</span><span class="hljs-literal">-</span>
<span class="hljs-comment">185</span> <span class="hljs-comment">57618</span> <span class="hljs-comment">RMAN:</span> <span class="hljs-comment">incremental</span> <span class="hljs-comment">datafile</span> <span class="hljs-comment">backup</span> <span class="hljs-comment">2016</span><span class="hljs-literal">-</span><span class="hljs-comment">05</span><span class="hljs-literal">-</span><span class="hljs-comment">07</span> <span class="hljs-comment">23:00:02</span> <span class="hljs-comment">22664776</span> <span class="hljs-comment">22664776</span> <span class="hljs-comment">100</span> <span class="hljs-comment">7</span>
<span class="hljs-comment">185</span> <span class="hljs-comment">57618</span> <span class="hljs-comment">RMAN:</span> <span class="hljs-comment">archived</span> <span class="hljs-comment">log</span> <span class="hljs-comment">backup</span> <span class="hljs-comment">2016</span><span class="hljs-literal">-</span><span class="hljs-comment">05</span><span class="hljs-literal">-</span><span class="hljs-comment">07</span> <span class="hljs-comment">23:06:47</span> <span class="hljs-comment">889538</span> <span class="hljs-comment">889538</span> <span class="hljs-comment">100</span> <span class="hljs-comment">1</span>
<span class="hljs-comment">185</span> <span class="hljs-comment">57618</span> <span class="hljs-comment">RMAN:</span> <span class="hljs-comment">archived</span> <span class="hljs-comment">log</span> <span class="hljs-comment">backup</span> <span class="hljs-comment">2016</span><span class="hljs-literal">-</span><span class="hljs-comment">05</span><span class="hljs-literal">-</span><span class="hljs-comment">07</span> <span class="hljs-comment">23:06:47</span> <span class="hljs-comment">889536</span> <span class="hljs-comment">889536</span> <span class="hljs-comment">100</span> <span class="hljs-comment">1</span>
<span class="hljs-comment">832</span> <span class="hljs-comment">32639</span> <span class="hljs-comment">RMAN:</span> <span class="hljs-comment">aggregate</span> <span class="hljs-comment">output</span> <span class="hljs-comment">2016</span><span class="hljs-literal">-</span><span class="hljs-comment">05</span><span class="hljs-literal">-</span><span class="hljs-comment">07</span> <span class="hljs-comment">23:07:13</span> <span class="hljs-comment">2068890</span> <span class="hljs-comment">2068890</span> <span class="hljs-comment">100</span> <span class="hljs-comment">0</span>
<span class="hljs-comment">362</span> <span class="hljs-comment">16579</span> <span class="hljs-comment">RMAN:</span> <span class="hljs-comment">incremental</span> <span class="hljs-comment">datafile</span> <span class="hljs-comment">backup</span> <span class="hljs-comment">2016</span><span class="hljs-literal">-</span><span class="hljs-comment">05</span><span class="hljs-literal">-</span><span class="hljs-comment">08</span> <span class="hljs-comment">22:00:02</span> <span class="hljs-comment">11284214</span> <span class="hljs-comment">11284214</span> <span class="hljs-comment">100</span> <span class="hljs-comment">167</span>
<span class="hljs-comment">264</span> <span class="hljs-comment">62631</span> <span class="hljs-comment">RMAN:</span> <span class="hljs-comment">incremental</span> <span class="hljs-comment">datafile</span> <span class="hljs-comment">backup</span> <span class="hljs-comment">2016</span><span class="hljs-literal">-</span><span class="hljs-comment">05</span><span class="hljs-literal">-</span><span class="hljs-comment">08</span> <span class="hljs-comment">22:00:02</span> <span class="hljs-comment">22664776</span> <span class="hljs-comment">22664776</span> <span class="hljs-comment">100</span> <span class="hljs-comment">166</span>
<span class="hljs-comment">387</span> <span class="hljs-comment">54189</span> <span class="hljs-comment">RMAN:</span> <span class="hljs-comment">aggregate</span> <span class="hljs-comment">input</span> <span class="hljs-comment">2016</span><span class="hljs-literal">-</span><span class="hljs-comment">05</span><span class="hljs-literal">-</span><span class="hljs-comment">08</span> <span class="hljs-comment">22:00:02</span> <span class="hljs-comment">46328443</span> <span class="hljs-comment">46328443</span> <span class="hljs-comment">100</span> <span class="hljs-comment">168</span>
<span class="hljs-comment">264</span> <span class="hljs-comment">62631</span> <span class="hljs-comment">RMAN:</span> <span class="hljs-comment">incremental</span> <span class="hljs-comment">datafile</span> <span class="hljs-comment">backup</span> <span class="hljs-comment">2016</span><span class="hljs-literal">-</span><span class="hljs-comment">05</span><span class="hljs-literal">-</span><span class="hljs-comment">08</span> <span class="hljs-comment">22:00:02</span> <span class="hljs-comment">11246926</span> <span class="hljs-comment">11246926</span> <span class="hljs-comment">100</span> <span class="hljs-comment">166</span>
<span class="hljs-comment">362</span> <span class="hljs-comment">16579</span> <span class="hljs-comment">RMAN:</span> <span class="hljs-comment">incremental</span> <span class="hljs-comment">datafile</span> <span class="hljs-comment">backup</span> <span class="hljs-comment">2016</span><span class="hljs-literal">-</span><span class="hljs-comment">05</span><span class="hljs-literal">-</span><span class="hljs-comment">08</span> <span class="hljs-comment">22:00:02</span> <span class="hljs-comment">22665768</span> <span class="hljs-comment">22665768</span> <span class="hljs-comment">100</span> <span class="hljs-comment">167</span>
<span class="hljs-comment">362</span> <span class="hljs-comment">16579</span> <span class="hljs-comment">RMAN:</span> <span class="hljs-comment">archived</span> <span class="hljs-comment">log</span> <span class="hljs-comment">backup</span> <span class="hljs-comment">2016</span><span class="hljs-literal">-</span><span class="hljs-comment">05</span><span class="hljs-literal">-</span><span class="hljs-comment">09</span> <span class="hljs-comment">00:46:58</span> <span class="hljs-comment">505982</span> <span class="hljs-comment">505982</span> <span class="hljs-comment">100</span> <span class="hljs-comment">1</span>
<span class="hljs-comment">362</span> <span class="hljs-comment">16579</span> <span class="hljs-comment">RMAN:</span> <span class="hljs-comment">archived</span> <span class="hljs-comment">log</span> <span class="hljs-comment">backup</span> <span class="hljs-comment">2016</span><span class="hljs-literal">-</span><span class="hljs-comment">05</span><span class="hljs-literal">-</span><span class="hljs-comment">09</span> <span class="hljs-comment">00:46:58</span> <span class="hljs-comment">505984</span> <span class="hljs-comment">505984</span> <span class="hljs-comment">100</span> <span class="hljs-comment">1</span>
<span class="hljs-comment">SID</span> <span class="hljs-comment">SERIAL#</span> <span class="hljs-comment">OPNAME</span> <span class="hljs-comment">START_TIME</span> <span class="hljs-comment">SOFAR</span> <span class="hljs-comment">TOTALWORK</span> <span class="hljs-comment">%COMPLETE</span> <span class="hljs-comment">ELAPSED_MI</span>
<span class="hljs-literal">-</span><span class="hljs-literal">-</span><span class="hljs-literal">-</span><span class="hljs-literal">-</span><span class="hljs-literal">-</span><span class="hljs-literal">-</span><span class="hljs-literal">-</span><span class="hljs-literal">-</span><span class="hljs-literal">-</span><span class="hljs-literal">-</span> <span class="hljs-literal">-</span><span class="hljs-literal">-</span><span class="hljs-literal">-</span><span class="hljs-literal">-</span><span class="hljs-literal">-</span><span class="hljs-literal">-</span><span class="hljs-literal">-</span><span class="hljs-literal">-</span><span class="hljs-literal">-</span><span class="hljs-literal">-</span> <span class="hljs-literal">-</span><span class="hljs-literal">-</span><span class="hljs-literal">-</span><span class="hljs-literal">-</span><span class="hljs-literal">-</span><span class="hljs-literal">-</span><span class="hljs-literal">-</span><span class="hljs-literal">-</span><span class="hljs-literal">-</span><span class="hljs-literal">-</span><span class="hljs-literal">-</span><span class="hljs-literal">-</span><span class="hljs-literal">-</span><span class="hljs-literal">-</span><span class="hljs-literal">-</span><span class="hljs-literal">-</span><span class="hljs-literal">-</span><span class="hljs-literal">-</span><span class="hljs-literal">-</span><span class="hljs-literal">-</span><span class="hljs-literal">-</span><span class="hljs-literal">-</span><span class="hljs-literal">-</span><span class="hljs-literal">-</span><span class="hljs-literal">-</span><span class="hljs-literal">-</span><span class="hljs-literal">-</span><span class="hljs-literal">-</span><span class="hljs-literal">-</span><span class="hljs-literal">-</span><span class="hljs-literal">-</span><span class="hljs-literal">-</span><span class="hljs-literal">-</span><span class="hljs-literal">-</span><span class="hljs-literal">-</span> <span class="hljs-literal">-</span><span class="hljs-literal">-</span><span class="hljs-literal">-</span><span class="hljs-literal">-</span><span class="hljs-literal">-</span><span class="hljs-literal">-</span><span class="hljs-literal">-</span><span class="hljs-literal">-</span><span class="hljs-literal">-</span><span class="hljs-literal">-</span><span class="hljs-literal">-</span><span class="hljs-literal">-</span><span class="hljs-literal">-</span><span class="hljs-literal">-</span><span class="hljs-literal">-</span><span class="hljs-literal">-</span><span class="hljs-literal">-</span><span class="hljs-literal">-</span><span class="hljs-literal">-</span> <span class="hljs-literal">-</span><span class="hljs-literal">-</span><span class="hljs-literal">-</span><span class="hljs-literal">-</span><span class="hljs-literal">-</span><span class="hljs-literal">-</span><span class="hljs-literal">-</span><span class="hljs-literal">-</span><span class="hljs-literal">-</span><span class="hljs-literal">-</span> <span class="hljs-literal">-</span><span class="hljs-literal">-</span><span class="hljs-literal">-</span><span class="hljs-literal">-</span><span class="hljs-literal">-</span><span class="hljs-literal">-</span><span class="hljs-literal">-</span><span class="hljs-literal">-</span><span class="hljs-literal">-</span><span class="hljs-literal">-</span> <span class="hljs-literal">-</span><span class="hljs-literal">-</span><span class="hljs-literal">-</span><span class="hljs-literal">-</span><span class="hljs-literal">-</span><span class="hljs-literal">-</span><span class="hljs-literal">-</span><span class="hljs-literal">-</span><span class="hljs-literal">-</span><span class="hljs-literal">-</span> <span class="hljs-literal">-</span><span class="hljs-literal">-</span><span class="hljs-literal">-</span><span class="hljs-literal">-</span><span class="hljs-literal">-</span><span class="hljs-literal">-</span><span class="hljs-literal">-</span><span class="hljs-literal">-</span><span class="hljs-literal">-</span><span class="hljs-literal">-</span>
<span class="hljs-comment">264</span> <span class="hljs-comment">62631</span> <span class="hljs-comment">RMAN:</span> <span class="hljs-comment">archived</span> <span class="hljs-comment">log</span> <span class="hljs-comment">backup</span> <span class="hljs-comment">2016</span><span class="hljs-literal">-</span><span class="hljs-comment">05</span><span class="hljs-literal">-</span><span class="hljs-comment">09</span> <span class="hljs-comment">00:46:58</span> <span class="hljs-comment">490695</span> <span class="hljs-comment">490695</span> <span class="hljs-comment">100</span> <span class="hljs-comment">1</span>
<span class="hljs-comment">264</span> <span class="hljs-comment">62631</span> <span class="hljs-comment">RMAN:</span> <span class="hljs-comment">archived</span> <span class="hljs-comment">log</span> <span class="hljs-comment">backup</span> <span class="hljs-comment">2016</span><span class="hljs-literal">-</span><span class="hljs-comment">05</span><span class="hljs-literal">-</span><span class="hljs-comment">09</span> <span class="hljs-comment">00:46:58</span> <span class="hljs-comment">490693</span> <span class="hljs-comment">490693</span> <span class="hljs-comment">100</span> <span class="hljs-comment">1</span>
<span class="hljs-comment">387</span> <span class="hljs-comment">54189</span> <span class="hljs-comment">RMAN:</span> <span class="hljs-comment">aggregate</span> <span class="hljs-comment">output</span> <span class="hljs-comment">2016</span><span class="hljs-literal">-</span><span class="hljs-comment">05</span><span class="hljs-literal">-</span><span class="hljs-comment">09</span> <span class="hljs-comment">00:47:14</span> <span class="hljs-comment">3026566</span> <span class="hljs-comment">3026566</span> <span class="hljs-comment">100</span> <span class="hljs-comment">0</span>
<span class="hljs-comment">387</span> <span class="hljs-comment">54189</span> <span class="hljs-comment">RMAN:</span> <span class="hljs-comment">aggregate</span> <span class="hljs-comment">output</span> <span class="hljs-comment">2016</span><span class="hljs-literal">-</span><span class="hljs-comment">05</span><span class="hljs-literal">-</span><span class="hljs-comment">09</span> <span class="hljs-comment">00:47:17</span> <span class="hljs-comment">3026566</span> <span class="hljs-comment">3026566</span> <span class="hljs-comment">100</span> <span class="hljs-comment">0</span>
<span class="hljs-comment">26</span> <span class="hljs-comment">rows</span> <span class="hljs-comment">selected</span><span class="hljs-string">.</span>
<span class="hljs-comment">SQL</span>> </code>Salin selepas log masuk
查看未完成的RMAN备份进度
<code class=" hljs sql"><span class="hljs-operator"><span class="hljs-keyword">set</span> line <span class="hljs-number">9999</span> col opname <span class="hljs-keyword">for</span> a35 col start_time <span class="hljs-keyword">for</span> a19 <span class="hljs-keyword">SELECT</span> SID, SERIAL#,opname, to_char(start_time,<span class="hljs-string">'yyyy-mm-dd HH24:MI:SS'</span>) start_time, SOFAR, TOTALWORK, ROUND(SOFAR/TOTALWORK*<span class="hljs-number">100</span>,<span class="hljs-number">2</span>) <span class="hljs-string">"%COMPLETE"</span>,ceil(ELAPSED_SECONDS/<span class="hljs-number">60</span>) ELAPSED_MI <span class="hljs-keyword">FROM</span> V$SESSION_LONGOPS <span class="hljs-keyword">where</span> opname <span class="hljs-keyword">like</span> <span class="hljs-string">'RMAN%'</span> <span class="hljs-keyword">AND</span> SOFAR <> TOTALWORK <span class="hljs-keyword">order</span> <span class="hljs-keyword">by</span> start_time <span class="hljs-keyword">asc</span>;</span></code>
Salin selepas log masuk
这两个查询涉及到了一个动态性能视图v$session_longops，了解该视图的说明请参考我的另一篇文章：动态性能视图 V$SESSION_LONGOPS
Kenyataan Laman Web ini
Kandungan artikel ini disumbangkan secara sukarela oleh netizen, dan hak cipta adalah milik pengarang asal. Laman web ini tidak memikul tanggungjawab undang-undang yang sepadan. Jika anda menemui sebarang kandungan yang disyaki plagiarisme atau pelanggaran, sila hubungi admin@php.cn
Alat AI Hot
Undresser.AI Undress
Apl berkuasa AI untuk mencipta foto bogel yang realistik
AI Clothes Remover
Alat AI dalam talian untuk mengeluarkan pakaian daripada foto.
Undress AI Tool
Gambar buka pakaian secara percuma
Clothoff.io
Penyingkiran pakaian AI
AI Hentai Generator
Menjana ai hentai secara percuma.
Artikel Panas
R.E.P.O. Kristal tenaga dijelaskan dan apa yang mereka lakukan (kristal kuning)
3 minggu yang lalu
By 尊渡假赌尊渡假赌尊渡假赌
R.E.P.O. Tetapan grafik terbaik
3 minggu yang lalu
By 尊渡假赌尊渡假赌尊渡假赌
Assassin's Creed Shadows: Penyelesaian Riddle Seashell
2 minggu yang lalu
By DDD
R.E.P.O. Cara Memperbaiki Audio Jika anda tidak dapat mendengar sesiapa
3 minggu yang lalu
By 尊渡假赌尊渡假赌尊渡假赌
WWE 2K25: Cara Membuka Segala -galanya Di Myrise
4 minggu yang lalu
By 尊渡假赌尊渡假赌尊渡假赌
Alat panas
Notepad++7.3.1
Editor kod yang mudah digunakan dan percuma
SublimeText3 versi Cina
Versi Cina, sangat mudah digunakan
Hantar Studio 13.0.1
Persekitaran pembangunan bersepadu PHP yang berkuasa
Dreamweaver CS6
Alat pembangunan web visual
SublimeText3 versi Mac
Perisian penyuntingan kod peringkat Tuhan (SublimeText3)
Topik panas
Tutorial CakePHP
1377
52
1377
52
Semak langkah untuk memadam peranti log masuk pada Douyin
Mar 26, 2024 am 09:01 AM
1. Mula-mula, klik untuk membuka aplikasi Douyin dan klik [Saya]. 2. Klik ikon tiga titik di penjuru kanan sebelah atas. 3. Klik untuk memasuki [Tetapan]. 4. Klik untuk membuka [Akaun dan Keselamatan]. 5. Pilih dan klik [Log masuk ke pengurusan peranti]. 6. Akhir sekali, klik untuk memilih peranti dan klik [Remove].
12306 Cara menyemak rekod pembelian tiket sejarah Cara menyemak rekod pembelian tiket sejarah
Mar 28, 2024 pm 03:11 PM
Muat turun versi terbaharu aplikasi tempahan tiket 12306 Ia adalah perisian pembelian tiket perjalanan yang semua orang sangat berpuas hati dengannya -pengesahan nama untuk membeli tiket dalam talian Semua pengguna Anda boleh membeli tiket perjalanan dan tiket penerbangan dengan mudah dan menikmati diskaun yang berbeza. Anda juga boleh mula menempah tempahan terlebih dahulu untuk merebut tiket Anda boleh menempah hotel atau pemindahan kereta khas Dengan itu, anda boleh pergi ke mana-mana yang anda mahu pergi dan membeli tiket dengan satu klik lebih mudah dan memudahkan semua orang lebih selesa. Kini editor memperincikannya dalam talian Menyediakan 12306 pengguna cara untuk melihat rekod pembelian tiket sejarah. 1. Buka Keretapi 12306, klik Saya di sudut kanan bawah, dan klik Pesanan Saya 2. Klik Dibayar pada halaman pesanan. 3. Pada halaman berbayar
Bagaimana untuk menyemak kelayakan akademik anda di Xuexin.com
Mar 28, 2024 pm 04:31 PM
Bagaimana untuk menyemak kelayakan akademik saya di Xuexin.com? Anda boleh menyemak kelayakan akademik anda di Xuexin.com Ramai pengguna tidak tahu cara menyemak kelayakan akademik mereka di Xuexin.com Seterusnya, editor membawakan tutorial grafik kepada pengguna tentang cara menyemak kelayakan akademik mereka di Xuexin.com pengguna datang dan lihat! Tutorial penggunaan Xuexin.com: Cara menyemak kelayakan akademik anda di Xuexin.com 1. Pintu masuk Xuexin.com: https://www.chsi.com.cn/ 2. Pertanyaan laman web: Langkah 1: Klik pada alamat Xuexin.com di atas untuk masuk ke laman utama Klik [Education Query]; Langkah 4: Pada halaman log masuk Masukkan maklumat dan klik [Log Masuk];
Bagaimana untuk menggunakan sandaran dan pemulihan MySQL dalam PHP?
Jun 03, 2024 pm 12:19 PM
Membuat sandaran dan memulihkan pangkalan data MySQL dalam PHP boleh dicapai dengan mengikuti langkah berikut: Sandarkan pangkalan data: Gunakan arahan mysqldump untuk membuang pangkalan data ke dalam fail SQL. Pulihkan pangkalan data: Gunakan arahan mysql untuk memulihkan pangkalan data daripada fail SQL.
Cara menyemak ID anda sendiri di Xianyu_Pengenalan cara menyemak nama panggilan peribadi anda di Xianyu
Mar 22, 2024 am 08:21 AM
Sebagai platform dagangan, Xianyu memerlukan anda mendaftar dan log masuk ke akaun anda sebelum menggunakannya. Pengguna boleh menetapkan nama ID untuk akaun mereka Bagaimana jika mereka ingin menyemak ID mereka. Mari kita ketahui bersama di bawah! Pengenalan kepada kaedah menyemak nama panggilan peribadi Xianyu Mula-mula, mulakan aplikasi Xianyu Selepas memasuki halaman utama, beralih ke halaman menjual terbiar, mesej, dan saya, dan klik pilihan [Saya] di sudut kanan bawah. 2. Kemudian pada halaman saya, kita perlu mengklik [Avatar] di sudut kiri atas 2. Kemudian apabila kita pergi ke halaman utama peribadi kita boleh melihat maklumat yang berbeza, kita perlu mengklik butang [Edit Maklumat] di sini; Akhir sekali klik Kami boleh melihatnya kemudian pada halaman tempat kami mengedit maklumat;
Di mana untuk menyemak kedudukan muzik pada NetEase Cloud Music_How untuk menyemak kedudukan muzik pada NetEase Cloud Music
Mar 25, 2024 am 11:40 AM
1. Selepas menghidupkan telefon, pilih Muzik Awan NetEase. 2. Selepas memasuki halaman utama, semua orang boleh melihat [Senarai Kedudukan] dan klik untuk masuk. 3. Dalam senarai kedudukan, anda boleh memilih mana-mana senarai dan klik [Senarai Lagu Baru]. 4. Pilih lagu kegemaran anda dan klik padanya. 5. Kembali ke halaman sebelumnya untuk melihat lebih banyak senarai.
Bagaimana untuk melihat senarai hangat video Kuaishou Live Companion
Mar 29, 2024 pm 08:09 PM
Kuaishou Live Companion bukan sahaja alat bantu siaran langsung yang berkuasa, tetapi juga platform cerapan masa nyata untuk topik hangat dan aliran yang dicipta untuk penyiar. Melalui fungsi ini, sauh boleh menangkap kandungan yang paling dibimbangkan oleh khalayak dengan cepat, dan kemudian melaraskan kandungan langsung untuk menjadikannya lebih selaras dengan citarasa dan minat khalayak. Jadi bagaimana untuk menyemak senarai video hangat dalam aplikasi Kuaishou Live Companion ini akan memberi anda pengenalan terperinci kepada langkah-langkah saya harap ia dapat membantu anda. Bagaimana untuk melihat senarai video hangat di Kuaishou Live Companion Langkah kedua ialah mengklik senarai panas video harian. Langkah ketiga ialah menyemak senarai panas video harian.
Cara menyemak bilangan kumpulan yang telah anda sertai di WeChat: langkah mudah
Mar 26, 2024 am 10:06 AM
Tidak kira kehidupan atau pekerjaan, ramai orang telah lama terikat dengan WeChat dan akan ditarik ke dalam pelbagai kumpulan pada bila-bila masa Jadi berapa banyak kumpulan WeChat yang telah anda sertai? Anda mungkin mahu melihat sembang kumpulan dengan segera dalam buku alamat anda, tetapi hanya kumpulan WeChat yang telah anda simpan dalam buku alamat anda akan muncul di sana dan kumpulan lain tidak akan kelihatan. Jika anda ingin melihat semua kumpulan WeChat yang telah anda sertai, ia sangat mudah: masukkan nama panggilan anda dalam kotak carian di halaman utama WeChat, kemudian cari bahagian sembang kumpulan dalam hasil carian, dan klik "Lagi Sembang Kumpulan" untuk melihat semua maklumat sembang kumpulan yang berkaitan. Bagaimanapun, saya terkejut Terdapat lebih daripada seratus daripada mereka, dan bar skrol di sebelah kanan menjadi sangat kecil. Malangnya, tiada statistik nombor khusus... Kaedah ini juga boleh digunakan untuk menyemak kumpulan QQ yang telah anda sertai. PS: Beberapa netizen juga memberikan helah:
