Re: Media Recovery needed

Well, Oxford Health Plans (the company that I work for) has a 4-way OPS cluster
(HP-9000/N) which gets restored to a single class N machine. I perform database
recovery using backup controlfile until cancel and then somebody from the business
side verifies the number of members, providers and claims and we're done. To restore
the database, we are using the tapes from our external tape storage facility. This
proves that we're able to restore the service within 24 hours of alleged disaster.
We're not using RMAN but a product called DB Breeze from IBM.

On 2002.05.27 09:48 DENNIS WILLIAMS wrote:
> Mladen - I am curious about your disaster recovery test. I am in the
> process
> of implementing RMAN here, but management says I must continue to do
> cold
> backups until I can successfully perform a disaster recovery test
> using
> RMAN. I can't argue the point. In a realistic sense, in a real
> disaster, our
> hardware vendors have promised to make a somewhat similar system
> available
> to us. I've been trying to decide what a reasonable disaster recovery
> test
> would involve. Any insights would be appreciated.
> Dennis Williams
> DBA
> Lifetouch, Inc.
> dwilliams_at_lifetouch.com
>
>
> -----Original Message-----
> Sent: Monday, May 27, 2002 2:38 AM
> To: Multiple recipients of list ORACLE-L
>
>
>
> On 2002.05.27 02:33 Simon Waibale wrote:
> > Hi Mladen Gogala,
> > Thanks for your input, I did use similar approach to your
> suggestion
> > save I
> > left
> > everthing to oracle!
> >
> > 1) svrmgrl
> > 2) connect internal
> > 3) startup mount;
> > 4) recover automatic database;
> > 5) alter database open;
>
> That means that all the archives were in place. I do advise you to
> check whether
> the file is in the backup mode. That is a frequent cause of alarm,
> usually caused
> by a combination of a backup script and system reboot (either crash or
>
> negligence).
> Trust me, I did recovery more then once. The company that I work for
> has so-called
> DR tests at Comdisco in NJ once a year. There we fully recover our
> systems, just as if
> a disaster has taken place. Our configuration is 4 HP 9000/N systems
> with EMC and
> Hyperfabric, of course with OPS. The plan is to transition to RAC
> within a year.
>
>
> --
> Mladen Gogala
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Mladen Gogala
> INET: mgogala_at_adelphia.net
>
> 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: DENNIS WILLIAMS
> INET: DWILLIAMS_at_LIFETOUCH.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).
>

-- 
Mladen Gogala
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Mladen Gogala
  INET: mgogala_at_adelphia.net

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).