Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Restore from cold to new server

Re: Restore from cold to new server

From: Chirag DBA <chiragdba_at_gmail.com>
Date: Thu, 29 Sep 2005 11:31:40 -0400
Message-ID: <1a362960050929083176abd64c@mail.gmail.com>


No Problem. U have all the datafiles including system.  If it is windows, create a service with any name, either the ORACLE_SID you have in yr files, if you know the SID and wanna create with the same, or the new SID u want to create with.
 Hey, U should have the SID as you said you have the controlfile from the trace.
 Create the service.
 startup nomount.
 Create controlfile with the changes , I mean location of datafiles and redo log files.
 alter database open ;
 U r ready to go...!!! Let me know if you want anything more than this...!!!

 Regards - Chirag

 On 9/29/05, J. Dex <cemail_219_at_hotmail.com> wrote:
>
> I have received an OS backup from another server. I don't have an init and
> the only controlfile I have is a controlfile from trace from a clone (with
> a
> different SID name) of the original database. Is there a way to get the
> original database going on this new server without the init and
> controlfile
> from the original (especially since I don't have the ORACLE_SID info and
> system password for the original)?
>
> _________________________________________________________________
> Don't just search. Find. Check out the new MSN Search!
> http://search.msn.click-url.com/go/onm00200636ave/direct/01/
>
> --
> http://www.freelists.org/webpage/oracle-l
>

--
http://www.freelists.org/webpage/oracle-l
Received on Thu Sep 29 2005 - 10:33:47 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US