ADSM-L

Database Statistics and Timings

2015-10-04 17:30:26
Subject: Database Statistics and Timings
From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU]On Behalf Of
To: ADSM-L AT VM.MARIST DOT EDU
Here are my Backup Sizes. I apologize if this does not format properly on
your screen.

The backups go to an RS/6000 R50 (2 CPU)

AIX 4.3
ADSM 3.1.2.40
STK 9710 with 8 Tape Drives

Storage Pool    Size
PROD_DBA        40 GB           (Cold Backups)
PROD_DBB        44 GB           (Hot Backups)
DEV_DBA 56 GB           (Dev/Test Cold Backups)

Backup                  Orig Size       Stg Pool        HOT Backup      COLD
BACKUP          Client Hardware         Client CPU's    4 G Mount Points
---------------------------------   --------------      --------------------
-------------------     ----------------------
-------------------     ----------------------
----------------------                  -------------------
----------------------                  -------------------
-------------------------
-------------------------
PROD ORACLE APPS        150GB           PROD_DBx        4.5 Hours       3.5
PROD ORACLE APPS        150GB           PROD_DBx        4.5 Hours       3.5
Hours           HP T600         12              39
PROD WEB DB             14GB            PROD_DBx        45 Min.         30
Min.                    HP K580         4               5

Database backed up less Frequently (2-3 times a week)

TEST ORACLE APPS        150GB           DEV_DBx N/A             8 Hours
HP T520         12              39
DEV ORACLE APPS 120GB           DEV_DBx N/A             9 Hours (Contention)
HP T520         12              39

Our script runs and processes each file system mount point. 1 process
submitted for each CPU the client has.

My system backups (9) run less than an hour except for the main production
system which has large vista partitions on it and it runs about 3-4 hours.

I have other smaller databases that are staggered and backup much less data.

I periodically run backup stgpool to get the data offsite and we keep the
data on disk to speed up restore time (If needed) till the next morning. I
then migrate (Flush) all the disk pools to the primary tape pool.

We run HPUX Ignite Monthly (To aid our incremental forever........a
discussion I am not adding to). We also run mksysb on the RS6K every month
also.


Bill Slaughter
Tupperware U.S., Inc.
14901 S. Orange Blossom Trail
Orlando, FL 32837
(407) 826-4580
(407) 826-8890 Fax
Text Pages 4079747099.5701585 AT pagenet DOT net
<Prev in Thread] Current Thread [Next in Thread>