RE: Database Recovery/copy

If you have two identical systems then you simply restore all database related files to their correct locations and start the database up . There is no need for export import or anything fancy. It is as if you are restoring to the same machine.

Regards

Phil West - Impex IT ltd
Unix Sys Admin and Oracle Financials DBA Services

[ all opinions - unless otherwise stated - may be ill-informed and will be defended as such! ]

-----Original Message-----
From: Ruth Gramolini [mailto:rgramolini_at_tax.state.vt.us] Sent: 21 July 2000 13:46
To: Multiple recipients of list ORACLE-L Subject: Re: Database Recovery/copy

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


*******************************************************************************
The information in this Internet e-mail is confidential and may be legally privileged.  It is intended solely for the addressee.  Access to this Internet e-mail by anyone else is unauthorised and any disclosure, copying, distribution or any action taken or omitted to be taken in reliance on it, is prohibited and may be unlawful. 
 When addressed to our clients any opinions or advice contained in this Internet e-mail are subject to the terms and conditions expressed in any applicable documentation or market practices governing the relationship between Garban Intercapital plc and its clients.

Any views expressed in this message are those of the individual sender except where they are stated to be the views of Garban Intercapital plc.