Results 1 to 3 of 3
  1. #1
    Newcomer
    Join Date
    Apr 2009
    Location
    Sesto San Giovanni - Milan - Italy
    Posts
    12
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Default Total amount of data during a DB Oracle restore

    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. #2
    Senior Member
    Join Date
    Dec 2007
    Posts
    330
    Thanks
    1
    Thanked 19 Times in 19 Posts

    Default

    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

  3. #3
    Newcomer
    Join Date
    Apr 2009
    Location
    Sesto San Giovanni - Milan - Italy
    Posts
    12
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Default

    Thanks a lot for your help. I'll try that command as soon as possible.

    Cheers

    Sam

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

    Quote Originally Posted by tsm_dude View Post
    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

Similar Threads

  1. Replies: 8
    Last Post: 04-27-2011, 07:06 AM
  2. amount of data expired
    By straitor in forum TSM Reporting & Monitoring
    Replies: 1
    Last Post: 09-19-2010, 10:44 PM
  3. Total amount of storage used per node
    By dexter1972 in forum Scripting
    Replies: 15
    Last Post: 01-18-2008, 11:07 AM
  4. Replies: 7
    Last Post: 01-13-2007, 08:16 AM
  5. Total amount of Network data transferred for last 24 hrs
    By ravikanth in forum TSM Reporting & Monitoring
    Replies: 4
    Last Post: 06-01-2006, 11:41 AM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •