Re: Database move

Thanks to all who helped. The database is up and running and all is well. I truly appreciate your time in helping me.

Cathy

Brian Peasland wrote:

> Cathy,
>
> If you've moved the datafiles, then you need to tell the control file
> where they are. To do that, you need to do something like:
>
> SVRMGR> STARTUP MOUNT (to open the control file)
> SVRMGR> ALTER DATABASE RENAME FILE 'oranw732\database\sys1orcl.ora' TO
> 'newpathname\sys1orcl.ora'; (do this for all your
> database files)
> SVRMGR> ALTER DATABASE OPEN
>
> HTH,
> Brian
>
> Catherine Sylvester wrote:
> >
> > As per a message above I moved the Oracle database from one server to
> > another. I have been able to get the database running, however it
> > cannot find the data file. I receive the following errors:
> >
> > 01157 cannot identify data file 1 file not found
> >
> > 01110 data file 1 programs:oranw732\database\syslorcl.ora
> >
> > is there a way to start the database and tell it where to look for the
> > data file. I am assuming that is what it is looking for. The data??
> >
> > Cathy
>
> --
> ========================================
> Brian Peasland
> Raytheons Systems at
> USGS EROS Data Center
> These opinions are my own and do not
> necessarily reflect the opinions of my
> company!
> ========================================
Received on Tue Mar 21 2000 - 08:35:34 CST