Re: Database Recovery/copy

Rachel, your approach will work, but it is overkill. I have a similar setup here where the development system is a "mirror" of the production system. While the production system is shutdown for cold backups, I have a script that simply does a LARGE number of "rcp" (remote copy commands) that are launched in background. This scripts copies all the datafiles & the three control files onto the development system. The iniSID.ora files are identical on both systems.

Once the copies have completed both instances can simply be brought up via STARTUP. NO recovery is needed. This procedure is done monthly strictly under operator control. No DBA intervention is required. :-)

This is NO different than doing a full system restore from "cold" backup tapes. Oracle does not know or care that it is running on a different system. Since there was a clean & orderly shutdown, Oracle will just start as though nothing happened while it was down.

Rachel Carmichael wrote:
>
> Ruth,
>
> overkill...... they HAVE a good backup
>
> what you will need to do is "backup controlfile to <file>" at the end of
> your backup of production (this is if you are in archivelog mode, if you are
> not in archivelog mode, just restore the backed up files to disk)
>
> Restore all the files to the development machine, since the file systems are
> the same, just copy them down to the same directories that they came from
>
> Restore the backed up controlfile
>
> yes, copy the init.ora over as well. Copy the archive logs to the same
> directory they get created in
>
> svrmgrl
> connect internal
> startup mount
> recover database until cancel using backup controlfile;
>
> it will ask for archive logs.... keep pressing Enter until you run out of
> archive logs (you can continually copy them over from production, but you
> can't open the database until you decide to stop the copying)
>
> once you have applied all the logs, type in CANCEL at the prompt for the
> next archive log
>
> alter database open resetlogs;
> exit
>
> and you are done
>
> >From: "Ruth Gramolini" <rgramolini_at_tax.state.vt.us>
> >Reply-To: ORACLE-L_at_fatcity.com
> >To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
> >Subject: Re: Database Recovery/copy
> >Date: Fri, 21 Jul 2000 04:46:27 -0800
> >
> >You can FTP the .dmp file or the production database and import it into
> >developement. You have to drop the tables in development that are going to
> >be imported. You can pre-create them and use ignore =Y or you can just
> >import the tables as they are in production. You don't have to do anything
> >to your controlfiles. This assumes that you will only be importing the
> >schema(s) that contain the application data.
> >
> >HTH,
> >Ruth
> >----- Original Message -----
> >To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
> >Sent: Thursday, July 20, 2000 4:42 PM
> >
> >
> > >
> > > We have an HPUX development box that has an 8.0.5 database on
> > > it that is the same SID, etc. as the production database. We
> > > want to drop that development database and restore a copy of
> > > the production database (which is on another box) to the development
> > > box. The other box has the same OS and drive/space configuration.
> > > The backup was taken with, and will be restored to the new box,
> > > using Veritas. Does anything special have to be done with the
> > > init or control files, etc.? Does anything at all have to be
> > > done after Veritas applies everything or do you just try and
> > > start the database up?
> > >
> > >
> > >
> > > -----
> > > Sent using MailStart.com ( http://MailStart.Com/welcome.html )
> > > The FREE way to access your mailbox via any web browser, anywhere!
> > >
> > > --
> > > Author:
> > > INET: cemail_at_sprintmail.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).
> > >
> >
> >--
> >Author: Ruth Gramolini
> > INET: rgramolini_at_tax.state.vt.us
> >
> >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).
>
> ________________________________________________________________________
> Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com
>
> --
> Author: Rachel Carmichael
> INET: carmichr_at_hotmail.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                              5505 Morehouse Drive   
858-552-6229                                  San Diego, CA 92121