RE: Veritas netbackup and RMAN restore

A few thoughts.

How long does it take to backup the same 150Gb database. If you look at the NW gui (nwadmin) then you should be able to see what I happening on the networker server (not necessarily the database server. Identify what you are using as the value for NSR_SERVER from your RMAN backup configuration.

Log onto that server and open an x-session and export your display. Run the nwadmin command - on Solaris I find it at /opt/networker/bin/nwadmin but another way is to ps -ef |grep nsr and see where the binaries are kept.

That allows you to see what is happening on the server when you backup and restore is running. I suggest monitoring this during a backup and seeing what throughput you are getting to tape and then repeating on a restore.

To save time why not just backup and recover a single datafile or tablespace.

On the restore use the same channels setting as you did on the backup.

Hope this helps and if not perhaps you can provide more details of the setup.

John

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

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of GUPTA, DEEPENDER Sent: 20 September 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

--

http://www.freelists.org/webpage/oracle-l Received on Wed Sep 21 2005 - 02:37:08 CDT