1. Forum Rules (PLEASE CLICK HERE TO READ BEFORE POSTING) Click the link to access ADSM.ORG Acceptable Use Policy and forum rules which should be observed when using this website. Violators may be banned from this website. This message will disappear after you have made at least 12 posts. Thank you for your cooperation.

Total amount of data during a DB Oracle restore

Discussion in 'Oracle' started by samiuri, Nov 23, 2012.

  1. samiuri

    samiuri New Member

    Joined:
    Apr 10, 2009
    Messages:
    12
    Likes Received:
    1
    Occupation:
    Employee
    Location:
    Sesto San Giovanni - Milan - Italy
    Hello,
    i'm performing a 300 Gb db Oracle restore with RMAN on TSM Server 6.2.1.0;
    when i issue the command 'q sess', TSM returns in the field 'Bytes sent' only the amount of data for single transaction; in fact, if I re-issue the command after some minutes, it shows me a decreased number (another block of datafiles is started); so i can't know how many Gb of the entire db have been restored.

    I'd like to monitor the restore operation and to to be able to estimate the end of it.

    Is it possible to see the amount of restored files?

    Thank you very much for your support.

    (I don't know RMAN, my colleagues Oracle admin launched the restore and they can't see the amount, too)

    Regards

    Sam
     
  2.  
  3. tsm_dude

    tsm_dude Senior Member

    Joined:
    Dec 12, 2007
    Messages:
    334
    Likes Received:
    21
    When I run q session it shows the total data amount. Perhaps this SQL query may return the restore amount;

    SELECT activity, cast(float(sum(bytes))/1024/1024/1024 as dec(8,2)) as GB FROM summary WHERE activity<>'TAPE MOUNT' AND activity<>'EXPIRATION' AND end_time>current_timestamp-24 hours GROUP BY activity

    ps; its last 24 hours of activity so change that if you need
     
  4. samiuri

    samiuri New Member

    Joined:
    Apr 10, 2009
    Messages:
    12
    Likes Received:
    1
    Occupation:
    Employee
    Location:
    Sesto San Giovanni - Milan - Italy
    Thanks a lot for your help. I'll try that command as soon as possible.

    Cheers

    Sam

    ------------------------------------------------------------------------------------------------------------

     

Share This Page