Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Restore from cold to new server
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-lReceived on Thu Sep 29 2005 - 10:33:47 CDT
![]() |
![]() |