Results 1 to 3 of 3
  1. #1
    Join Date
    Sep 2004
    Posts
    1

    Unanswered: Slow restore on v8.1 for Solaris 8

    I'm restoring a 14 gig db into a new database. The restore process
    took 3 hours to complete. How can I make the restore faster and How
    can I determine the progress of the restore.

    thanks

  2. #2
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650
    You can tune the utilheapsz, restbufsz ...

    The biggest bottleneck to the best of my knowledge is your I/o and if the backup is on a network, then your network bandwidth may have limitations ...

    HTH

    Sathyaram
    Visit the new-look IDUG Website , register to gain access to the excellent content.

  3. #3
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650
    ... to know the progress, I rely on 'get snapshot for tablespaces' and sometimes 'direct reads' in the database snapshot ...

    They may not show you the completed percentage, but atleast you know, your restore is working and where you stand ...

    If you are using vendor storage systems (like TSM), you can use their facility to view the progress ...

    For eg, if you use tsm , dsmadmc command followed by 'q sess' will help to know how much data is read from the storage system

    HTH

    sAthyaram
    Last edited by sathyaram_s; 09-01-04 at 19:54.
    Visit the new-look IDUG Website , register to gain access to the excellent content.

Posting Permissions

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