RE: Poll & Questions

Igor,
 Yes. That's what I was told.  

• Kirti

-----Original Message-----
Sent: Wednesday, March 13, 2002 1:24 PM
To: Multiple recipients of list ORACLE-L

Kirti,

So, your concern in this case was "total" elapsed time (from starting copying files to getting them on the target), not "db downtime". Is that's the reason for "cold" backup?

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 2:02 PM

> Hi Igor,
>
> Good Question.
>
> Our method (home scripts) for hot backups is single threaded (one TS at a
> time). The elapsed time in running multiple copy jobs with db down and
> subsequent ftp via FDDI backbone to the target server was much shorter as
> compared to the hot backup scenario.
>
> Also, the spare disks had the filesystems/mount directories exactly as
the
> target destination. So, scripting all this mess was rather easy.
>
> That's about it..
>
> Thanks,
> - Kirti
>
> -----Original Message-----
> Sent: Wednesday, March 13, 2002 11:24 AM
> To: Multiple recipients of list ORACLE-L
>
>
> 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).
-- 
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).