RMAN very Slow Restoration!!
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: RMAN very Slow Restoration!!

  1. #1
    Join Date
    May 2003
    Location
    Hyderabad
    Posts
    5

    RMAN very Slow Restoration!!

    Hi all!

    Working on Oracle 8i with OS as Unix Solaris 8.0.

    Could anyone out there improve on the topic:Improve restoration speed on RMAN Backup.

    Scenario:It takes approx 4 hours to backup datas on RMAN with around 200 to 300GB size of Database and around 2 to 3 Hours for restoration from Backup.

    In our case we are allocating 4 channels to read from one single tape device in case of RMAN but still the restoration speed goes beyond 12 Hours!!!

    Did anyone experience on this topic :How to improve RMAN backup Restoration speed.

    Thank You for your time.

    Regards,

    Amit.
    Amit
    Oracle DBA(OCP) v8i,v9i.

  2. #2
    Join Date
    Nov 2002
    Location
    New Delhi, INDIA
    Posts
    1,796

    Re: RMAN very Slow Restoration!!

    Originally posted by amitst
    Hi all!

    Working on Oracle 8i with OS as Unix Solaris 8.0.

    Could anyone out there improve on the topic:Improve restoration speed on RMAN Backup.

    Scenario:It takes approx 4 hours to backup datas on RMAN with around 200 to 300GB size of Database and around 2 to 3 Hours for restoration from Backup.

    In our case we are allocating 4 channels to read from one single tape device in case of RMAN but still the restoration speed goes beyond 12 Hours!!!

    Did anyone experience on this topic :How to improve RMAN backup Restoration speed.

    Thank You for your time.

    Regards,

    Amit.
    Restoration from tape is usually slow. And i don't think making more than one channel on a tape drive will help, because at one time only one location can be read on a tape(i.e. the place where the head is on the tape), its not like a hard disk where multiple files can be read at once.

    HTH

    PS: BTW are you related to amitstora. Your signature looks familiar
    Amar
    "There is a difference between knowing the path and walking the path."

    Amar's Blog  Get Firefox!

  3. #3
    Join Date
    May 2001
    Posts
    736
    If there is large amount of data need to be read from tape for recovery definitely it will take time.So if ther is good amount of hard disk space is there at your disposal keep one week worth of archive logs on your hard disk which will reduce your recovery time substantially.

  4. #4
    Join Date
    Feb 2000
    Location
    Singapore
    Posts
    1,758
    If possible also keep the latest backup on disk apart from archive logs.
    Sanjay G.
    Oracle Certified Professional 8i, 9i.

    "The degree of normality in a database is inversely proportional to that of its DBA"

Posting Permissions

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



Click Here to Expand Forum to Full Width