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).
Received on Wed Mar 13 2002 - 13:02:32 CST
