Re: Database Recovery/copy

I think cloning the database would be much quicker than export / import.

Basically...
on the production database, backup controlfile to trace.

Put the backed up datafiles from production to their new locations under the dev directory.

Edit the file created from step 1, deleting all of the lines up to "startup nomount", delete all the lines after the end of the controlfile statement, edit the paths to the DEV1 datafiles, etc., and change CREATE CONTROLFILE REUSE DATABASE "PROD1" NORESETLOGS ARCHIVELOG to CREATE CONTROLFILE SET DATABASE "DEV1" RESETLOGS NOARCHIVELOG. Move the old controlfiles for DEV1 to a temp directory or rename.

SET the ORACLE_SID to DEV1 and invoke the server manager.

Run the create controlfile script.

Mount the database.

Recover database using backup controlfile until cancel;

....apply all the logs

alter database open resetlogs;

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