Re: Database Recovery/copy

Charlie,

Please note I said that if they were not in archivelog mode, they could just use the backup and copy it to disk.

Perhaps a better way to phrase it would have been:

if you have the luxury of a cold backup, just copy the files to disk and start the database. If not, then follow the procedure I outlined

Rachel

>From: "Charlie Mengler" <charliem_at_mwh.com>
>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 09:28:48 -0800
>
>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
>There is a fine line between vision & hallucination. Don't cross it!
>--
>Author: Charlie Mengler
> INET: charliem_at_mwh.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 Fri Jul 21 2000 - 21:12:48 CDT