| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.misc -> Re: Database move
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
--
 |
 |