[Search for users] [Overall Top Noters] [List of all Conferences] [Download this site]

Conference decwet::networker

Title:	NetWorker
Notice:	kits - 12-14, problem reporting - 41.*, basics 1-100
Moderator:	DECWET::RANDALL.com::lenox

Created:	Thu Oct 10 1996
Last Modified:	Fri Jun 06 1997
Last Successful Update:	Fri Jun 06 1997
Number of topics:	750
Total number of notes:	3361

451.0. "Backup configuration for 2 Oracle DB in ASE ?" by TAV02::KENIG () Mon Mar 03 1997 11:09

    I have to setup a backup solution ( the best performance) for a :
    2 x 8400 ase environment .
    2 Oracle DataBases - 70GB size on one and 40GB on the other 
       ( the database is seperated on  3 pairs of HSZ50 ( 3 KZPSA shared )
       3 TZ855 ( each machine has an extra scsi adaptor for the tapes ).
    
    The question is what is the best configuraion ?
    1. 2 tapes on one and 1 on the other i.e . - two NSR servers .
    2. 3 tapes on one - one NSR server the smaller DB is backed up via
    	ethernet ( NO FDDI)
    
    The mechanism is  NSR/DMO/EBU .
    We need to finish the backup during night in the minimum possible time 
    ( Hot backup is preferred ).  	
    
	Thanks for the recommendations
    	Yakov Kenig
    	Isarel

T.R	Title	User	Personal Name	Date	Lines
451.1	I'll give you the numbers, you tell me the answer	DECWET::EVANS	NSR Engineering	`Tue Mar 04 1997 19:58`	37
	Here's my breakdown, with Gb/hr units in "(..)" so you can use good comparisons: DMOV1+nsrV4.2b (33Gb/hr) DMOv2+nsrV4.2b (70Gb/hr??) The TZ87 (855) drive gets appx 1.2Mb/sec (4.32Gb/hr) Ethernet gets appc 800Kb/sec (0.00288Gb/hr) 8400 backplane is appx 1.2Tb/sec (no worries) 8400 TLIOP is appx 1.2Tb/sec (no worries) SCSI bus (fast/wide) is 20Mb/sec (72Gb/hr) RZ29b disks are about 4.2Mb/sec (15.12Gb/hr) Find your slowest point in the "data path", and that's how fast your Database will backup. I suggest not backing up across Ethernet, and I suggest running NetWorker and Oracle on the same system - when DMOV2 and the next NetWorker Server come out, they'll scream, but only with NO NETWORK and fast tapes (for example, multiple TZ89's). Right now, it appears you'll get appx 8-9 hrs total backup time, best case. "n"DB-disk <--> 8400 <--> EBU <--> DMO <--> NSR <--> 2TZ87 The more tapes you can connect, the faster you'll go. Use NetWorker's session/device and parallism to control activation of devices in parallel. ------------------------------ Using DMOV1 there is no ASE awareness. You could try setting the NSR_CLIENT environment variable to the service and see if that results in saving the data to the proper client index file (you could see that when the save is happening, by looking at the nwadmin GUI "sessions" display). Naturally, you need to pre-define the client resource to the NetWorker Server.
451.2		DECWET::MORRIS	This mind left intentionally blank	`Wed Mar 05 1997 08:10`	9
	You are absolutely CHOKING the backup by trying to go over the ethernet. My advice is NOT to do this. Back everything up locally or install FDDI as the customer WILL NOT be happy with the performance over an ethernet network. \tm (an aside - I just can't understand why ANYONE would have a pair of 8400's (i.e. MONSTER MACHINES) on and ethernet....beyond me!)
451.3		DECWET::FARLEE	Insufficient Virtual um...er....	`Mon Mar 10 1997 11:38`	11
	I will second the recommendation that large database backups be done locally if possible. Also note that I have a TZ877 (TZ87 jukebox) that runs at 2.4 MB/sec reliably. So, that works out to 8.4 GB/hr per TZ877. Put the drives where they are needed most (i.e. two on the big-db-system and one on the small-db-system) and get going. If/when the database grows, and backup performance is not sufficient, you've got a simple path to improve it by adding more/faster tape drives. Kevin Farlee