Re: Restore from cold to new server
- From: Chirag DBA <chiragdba@xxxxxxxxx>
- To: cemail_219@xxxxxxxxxxx
- Date: Thu, 29 Sep 2005 11:31:40 -0400
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@xxxxxxxxxxx> 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
>
- Follow-Ups:
- Re: Restore from cold to new server
- From: Chirag DBA
- References:
- Restore from cold to new server
- From: J. Dex
Other related posts:
- » Restore from cold to new server
- » Re: Restore from cold to new server
- » Re: Restore from cold to new server
- » RE: Restore from cold to new server
- Re: Restore from cold to new server
- From: Chirag DBA
- Restore from cold to new server
- From: J. Dex