Günün İpucu(Oracle): Oracle Backup Sql Sorgusu

Merhaba,

Günün İpucu: Oracle tarafında rman kullanarak, devam eden bir restore'unuz var ise, alttaki sql'i kullanarak restore'un devam edip etmediğini, inmekte olan datafile'ların % kaç'ının tamamlandığını alttaki sql sorgusunu kullanarak görebilirsiniz.


SELECT SID, SERIAL#, CONTEXT, SOFAR, TOTALWORK, ROUND(SOFAR/TOTALWORK*100,2) "%_COMPLETE" FROM  V$SESSION_LONGOPS WHERE OPNAME LIKE 'RMAN%' AND OPNAME NOT LIKE '%aggregate%' AND TOTALWORK != 0   AND SOFAR <> TOTALWORK;

Örnek Backup başlattığınızda:


RMAN> backup incremental level 1 for recover of copy with tag 'app_incr' database;

Starting backup at 2013-04-17:14:08:47
starting full resync of recovery catalog
full resync complete
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=33 device type=DISK
no parent backup or copy of datafile 1 found
no parent backup or copy of datafile 2 found
no parent backup or copy of datafile 5 found
no parent backup or copy of datafile 3 found
no parent backup or copy of datafile 6 found
no parent backup or copy of datafile 8 found
no parent backup or copy of datafile 7 found
no parent backup or copy of datafile 4 found
channel ORA_DISK_1: starting datafile copy
input datafile file number=00001 name=+DATA/orcl/datafile/system.260.734893311



output file name=+FRA/orcl/datafile/system.277.812988549 tag=APP_INCR RECID=6 STAMP=812989209
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:11:06
channel ORA_DISK_1: starting datafile copy
input datafile file number=00002 name=+DATA/orcl/datafile/sysaux.261.734893313



Durumu:

SQL> r
  1* SELECT SID, SERIAL#, CONTEXT, SOFAR, TOTALWORK, ROUND(SOFAR/TOTALWORK*100,2) "%_COMPLETE" FROM  V$SESSION_LONGOPS WHERE OPNAME LIKE 'RMAN%' AND OPNAME NOT LIKE '%aggregate%' AND TOTALWORK != 0   AND SOFAR <> TOTALWORK

       SID    SERIAL#    CONTEXT      SOFAR  TOTALWORK %_COMPLETE
---------- ---------- ---------- ---------- ---------- ----------
        33       1245          1      42110      70400      59.82

Teşekkürler
Fahrettin