Re: Help restoring my database

If personal works like enterprise and I think it does. startup mount pfile=...
then

alter datafile rename FULLPATH_OF_WHERE_IT_WAS_NOW_AND_NAME to FULLPATH_OF_WHERE_IT_IS_NOW_AND_NAME; for every file.

Jim

--
Our new email address is kennedy-family_at_home.com
.
"Howard J. Rogers" <howardjr_at_www.com> wrote in message
news:3a73580a_at_news.iprimus.com.au...


> Two things spring to mind: you appear to have an expdat.dmp, which

> presumably is an export of the database you did earlier.  That can still

 be


> imported into your new database, and that would be the simplest thing to

 do.


> Maybe, however, it wasn't an ENTIRE database export, so...

>

> The second thing is that you appear to have a complete set of control

 files,


> datafiles and redo logs (I obviously can't tell if any are missing).

 Since


> there is no mention of archives, I presume these files were copied cold,

 and


> are thus internally consistent and useable.  So you've got a database

> there -you just need to start it up.  If this is on NT or the likes,

 you'll


> need to create a service for the old database first -but this is all

 getting


> way out of my league, since I've never used the Personal Edition, only the

> Enterprise.  So, normally I'd tell you to use oradim to create the new

> service, but I don't have a clue whether such advice holds for the

 Personal


> Edition.

>

> The only real nasty I see heading over the hill is that the Control File

 you


> have will have pointers to where the files *used* to be.  You'll probably

> restore them to somewhere else just to get the thing back up and

 running -so


> you'll have to get the database mounted first and issue a whole heap of

> 'rename file' commands to re-jig the control file so it points to the new

> locations.

>

> Once you've got the old one up and running, you can do a fresh entire

> database export, and import into the new one.

>

> I can't help you with the details, I'm afraid, because of the Personal

> Edition issues... but I think my essential point is "don't panic", because

> it seems that with a bit of work, and not very much at that, you should

 get


> everything back OK.

>

> Regards

> HJR

>

>

> Magnus S. Petersen <magnus_at_post.olivant.fo> wrote in message

> news:3a72f25f_at_news.olivant.fo...

> > I have been very unlucky in connection with upgrading from Oracle 8

 Personal


> > Edition version 8.0.4.0.4 to Oracle 8i Personal Edition version

 8.1.6.0.0.


> > which i downloaded.

> > Everything that could get wrong went wrong. The disk crashed and could

 not


> > be fixed. Therefore i only have a backup of the database on tape which i

> > have now restored back on the new disk.

> > Now I have no idea how to get the database into the new edition.

> > I have the following old files on the disk:

> > Name Size

> > CTL1ORCL.ORA 2.442 KB

> > INITORCL.ORA 7 KB

> > INITSEED.ORA 8 KB

> > LOG1ORCL.ORA 201 KB

> > LOG2ORCL.ORA 201 KB

> > PWDORCL.OR 2 KB

> > RBS1ORCL.ORA 10.242 KB

> > SYS1ORCL.ORA 30.722 KB

> > TMP1ORCL.ORA 7.170 KB

> > USR1ORCL.ORA 54.274 KB

> > EXPDAT.DMP 5.454 KB

> >

> > I have created a new database in 8i named GLDBNAME.MAGNUS-msp.

> > How can i reach my old belowed files.?????????

> > Desperately need help.

> >

> > Kind regards

> >

> > Magnus S. Petersen

> >

> >

> >

> >

>

>