Thanks! I often do things the hard way out of ignorance.
Ruth
----- Original Message -----
From: Rachel Carmichael <carmichr_at_hotmail.com>
To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
Sent: Friday, July 21, 2000 12:33 PM
Subject: Re: Database Recovery/copy
> 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
Received on Fri Jul 21 2000 - 10:59:59 CDT
