RMAN备份进度查询-mysql教程-PHP中文网

首页

数据库

mysql教程

RMAN备份进度查询

WBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWB

Jun 07, 2016 pm 02:50 PM

备份完成查看查询进度

查看已经完成和未完成的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>

查看未完成的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>

这两个查询涉及到了一个动态性能视图v$session_longops，了解该视图的说明请参考我的另一篇文章：动态性能视图 V$SESSION_LONGOPS

声明

本文内容由网友自发贡献，版权归原作者所有，本站不承担相应法律责任。如您发现有涉嫌抄袭侵权的内容，请联系admin@php.cn

MySQL：世界上最受欢迎的数据库的简介Apr 12, 2025 am 12:18 AM

MySQL是一种开源的关系型数据库管理系统，主要用于快速、可靠地存储和检索数据。其工作原理包括客户端请求、查询解析、执行查询和返回结果。使用示例包括创建表、插入和查询数据，以及高级功能如JOIN操作。常见错误涉及SQL语法、数据类型和权限问题，优化建议包括使用索引、优化查询和分表分区。

MySQL的重要性：数据存储和管理Apr 12, 2025 am 12:18 AM

MySQL是一个开源的关系型数据库管理系统，适用于数据存储、管理、查询和安全。1.它支持多种操作系统，广泛应用于Web应用等领域。2.通过客户端-服务器架构和不同存储引擎，MySQL高效处理数据。3.基本用法包括创建数据库和表，插入、查询和更新数据。4.高级用法涉及复杂查询和存储过程。5.常见错误可通过EXPLAIN语句调试。6.性能优化包括合理使用索引和优化查询语句。

为什么要使用mysql？利益和优势Apr 12, 2025 am 12:17 AM

选择MySQL的原因是其性能、可靠性、易用性和社区支持。1.MySQL提供高效的数据存储和检索功能，支持多种数据类型和高级查询操作。2.采用客户端-服务器架构和多种存储引擎，支持事务和查询优化。3.易于使用，支持多种操作系统和编程语言。4.拥有强大的社区支持，提供丰富的资源和解决方案。

描述InnoDB锁定机制（共享锁，独家锁，意向锁，记录锁，间隙锁，下一键锁）。Apr 12, 2025 am 12:16 AM

InnoDB的锁机制包括共享锁、排他锁、意向锁、记录锁、间隙锁和下一个键锁。1.共享锁允许事务读取数据而不阻止其他事务读取。2.排他锁阻止其他事务读取和修改数据。3.意向锁优化锁效率。4.记录锁锁定索引记录。5.间隙锁锁定索引记录间隙。6.下一个键锁是记录锁和间隙锁的组合，确保数据一致性。

MySQL查询性能差的常见原因是什么？Apr 12, 2025 am 12:11 AM

MySQL查询性能不佳的原因主要包括没有使用索引、查询优化器选择错误的执行计划、表设计不合理、数据量过大和锁竞争。 1.没有索引导致查询缓慢，添加索引后可显着提升性能。 2.使用EXPLAIN命令可以分析查询计划，找出优化器错误。 3.重构表结构和优化JOIN条件可改善表设计问题。 4.数据量大时，采用分区和分表策略。 5.高并发环境下，优化事务和锁策略可减少锁竞争。

您什么时候应该使用复合索引与多个单列索引？Apr 11, 2025 am 12:06 AM

在数据库优化中，应根据查询需求选择索引策略：1.当查询涉及多个列且条件顺序固定时，使用复合索引；2.当查询涉及多个列但条件顺序不固定时，使用多个单列索引。复合索引适用于优化多列查询，单列索引则适合单列查询。

如何识别和优化MySQL中的慢速查询？（慢查询日志，performance_schema）Apr 10, 2025 am 09:36 AM

要优化MySQL慢查询，需使用slowquerylog和performance_schema：1.启用slowquerylog并设置阈值，记录慢查询；2.利用performance_schema分析查询执行细节，找出性能瓶颈并优化。

MySQL和SQL：开发人员的基本技能Apr 10, 2025 am 09:30 AM

MySQL和SQL是开发者必备技能。1.MySQL是开源的关系型数据库管理系统，SQL是用于管理和操作数据库的标准语言。2.MySQL通过高效的数据存储和检索功能支持多种存储引擎，SQL通过简单语句完成复杂数据操作。3.使用示例包括基本查询和高级查询，如按条件过滤和排序。4.常见错误包括语法错误和性能问题，可通过检查SQL语句和使用EXPLAIN命令优化。5.性能优化技巧包括使用索引、避免全表扫描、优化JOIN操作和提升代码可读性。

See all articles