RE: Veritas netbackup and RMAN restore

From: Johnson, George <GJohnson_at_GAM.COM>
Date: Wed, 21 Sep 2005 09:31:47 +0100
Message-ID: <ECD91EB68018C04CA1B6801EE47A910F3A368949@ntas-ldn15.gam.com>

This is stuff, just off the top of my head, that we do when we get slow response from our NBU kit.

Assuming this is streaming from a media server across the network to the server holding the database, speak to your Netbackup admin and get them to confirm if the tape read speed is normal, they should also be able to suggest or perform the standard NBU speed checks on the bp processes to make sure they are performing optimally, on the server writing the data to the database disks. If read speed is slower on your restore, but others are OK, might suggest network or target server disk bottleneck. So you might want to get on to the network admin and check the network speed, on all the NBU components from media server down to the database server. If the server holding the database is a media server, then you need to check again with the NBU admin that the local tape access system is running at full speed. Finally check the database server disks are up to spec and there are no bottlenecks from the NBU bp processes to the disks.

This should hopefully trigger some thoughts on other places to look.

Rgds

-----Original Message-----

From: GUPTA, DEEPENDER [mailto:DGUPTA_at_entergy.com] Sent: 20 Sep 2005 17:55
To: oracle-l_at_freelists.org
Subject: Veritas netbackup and RMAN restore

We use RMAN to backup our databases and using Veritas Netbackup to save the backup sets on Tape. For Testing purpose I am restoring a 150 GB database from Tape for the last 3 days and it is taking long long time to restore the datafiles and archive files from Tape. On an average it takes about 7-8 hours to restore one set of data files on disk (irrespective of the size). Can anybody help how to improve the restore speed?

Thanks.

--

http://www.freelists.org/webpage/oracle-l

This message contains confidential information and is intended only for the individual or entity named. If you are not the named addressee you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately by e-mail if you have received this e-mail by mistake and delete this e-mail from your system. E-mail transmission cannot be guaranteed to be secure or error-free as information could be intercepted, corrupted, lost, destroyed, arrive late or incomplete, or contain viruses. The sender therefore does not accept liability for any errors or omissions in the contents of this message which arise as a result of e-mail transmission. If verification is required please request a hard-copy version. This message is provided for informational purposes and should not be construed as an invitation or offer to buy or sell any securities or related financial instruments.
GAM operates in many jurisdictions and is regulated or licensed in those jurisdictions as required.

--

http://www.freelists.org/webpage/oracle-l Received on Wed Sep 21 2005 - 03:34:04 CDT