Re: Poll & Questions

Kirti,

Why not using "hot" backup + archived log files ? Just wondering, if there is any specific reason.

Igor Neyman, OCP DBA
ineyman_at_perceptron.com

• Original Message ----- To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> Sent: Wednesday, March 13, 2002 11:23 AM

> I agree with Charlie. Disk is not very expensive.
>
> We have a prod db of about 85GB size. The test/dev env is on other server.
> They need 100% prod db for regression/volume testing etc. No sub-setting
of
> data is accepted. Whenever they wanted those environment refreshed with
prod
> data, we take a quick cold backup to the spare disks (downtime is less
than
> an hour). And then transfer (ftp/rcp) the files to the target server (3
> hours), rename the databases etc, and we are done. This process is in
place
> for a couple of years now. These databases are still running on Oracle
> 7.3.x.
>
> Convince the Mgmt for additional disks, if you can. The benefit in
investing
> in those is surely worth the cost but again most Damagers follow 'what it
> costs is more important than what it does' rule. In the absences of those
> spare disks, we would not have been able to do this cloning with the
> acceptable amount of downtime, and of course, the turn-around time.
>
> But, in our environment the User Community pays for the disk and not the
IT
> Dept. And that type of Financing works well with us. Sometimes, extremely
> well :)
>
> - Kirti
>
>
> -----Original Message-----
> Sent: Wednesday, March 13, 2002 8:43 AM
> To: Multiple recipients of list ORACLE-L
>
>
> Given that I saw a 120GB disk for $229 in Sunday's paper,
> I'm not convinced that the cost of hardware should be an issue.
> At $50/hour for the DBA, the break even point is less than 5
> hours. A development system doesn't need to be fast or contain
> RAID. It just should be big enough to hold a copy of production.
>
> The compromise we've made here is the production DB run on
> RAID-0+1 and the development DB run on RAID-5 on a box with
> fewer and slower CPUs.
>
> Tracy Rahmlow wrote:
> >
> > We currently have a production, system and development database here.
The
> > system and development databases are purged periodically and reloaded
with
> > lookup data. The developers are then responsible for entering
> transactional
> > data in both regions. I am looking to follow the same practice for
> > development, however I would like to clone my production database
directly
> to
> > the system test database. The production database is ~75G. Management
> does
> > not want to commit $ to a full sized system database. Costs outweigh
the
> > benefits. I would like to sway them. HOW? Please give me your
> costs/benefits
> > of doing this. In addition, what is the norm (if there can be one) in
> other
> > shops. Does utopia exist?
> >
> > ps. One of the biggest reasons for this database would be for
> benchmarking,
> > timings, stress-testing. I realize I can copy the production stats, but
> that
> > won't give me a good execution time. Do others load a subset of data
(say
> 25%)
> > and then extrapolate to a total time? Is that even necessarily accurate
> to do?
> > I have my doubts. Thanks
> >
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --
> > Author: Tracy Rahmlow
> > INET: Tracy.Rahmlow_at_aexp.com
> >
> > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> > San Diego, California -- Public Internet access / Mailing Lists
> > --------------------------------------------------------------------
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB ORACLE-L
> > (or the name of mailing list you want to be removed from). You may
> > also send the HELP command for other information (like subscribing).
>
> --
> Charlie Mengler Maintenance Warehouse
> charliem_at_mwh.com 10641 Scripps Summit Ct.
> 858-831-2229 San Diego, CA 92131
> Lead, follow, or at least have the courtesy to get out of my way!
> --
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Deshpande, Kirti
> INET: kirti.deshpande_at_verizon.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Igor Neyman
  INET: ineyman_at_perceptron.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).