Did I miss, to say that you need to create initfile,
create all the folders in admin folder, like bdump,cdump,create,udump and
pfile.
create initORACLE_SID.ora in that by providing controlfile.
create controlfile command.
Create password file with orapwd command.
Hope all set to go now.
regards - chirag
On 9/29/05, Chirag DBA <chiragdba_at_gmail.com> wrote:
>
> 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:35:44 CDT
