Re: CAN'T OPEN THE DATABASE...why?

If it is a NEW database why not create it as NEW in the new location

Move database between machine is often fraught with pitfalls. Is it the same version of the OS. Is it the same version of the server software. Are all the files in the same location on the disk subsystem. and so it goes one. If you need to transfer the data you can even do that after creating a NEW database with an export from OLD to import on NEW.

Regards

--
Kevin A Lewis (BOCM PAULS LTD) - Animal Feed Manufacturer - Ipswich United Kingdom)

                        <Kevin_A_Lewis_at_Hotmail.com>

The views expressed herein by the author of this document are not necessarily those of BOCM PAULS Ltd. <lkj741_at_my-deja.com> wrote in message news:893fvp$osd$1_at_nnrp1.deja.com...
> After transferring new database from my DEV machine to the new server
> through FTP I'm having problem opening the database. When I installed
> the database I had to change the SID. I also updated Oratab, init.ora
> all the necessary files.
>
> After doing all changes I tried to startup the database. I could start
> the instance, but couldn't mount the database and couldn't open the
> database. I was getting the ORA-00205 error. So I did change the
> control file by connecting the old database and using ..
> >alter database backup controlfile to trace;
>
> I did change the Sid and the entire log files Sid and datafiles SIDS
> and ran that script on my new database.
>
> Now I can run startup the database and mount. But when I try to open up
> the database by...
> SVRMGR>alter database open;
>
> ORA-01589 must use RESETLOGS OR NO RESETLOGS option for database open.
>
> SVRMGR>alter database open resetlogs;
>
> ORA- 01194: file 1 needs more recovery to be consistent
> ORA-01110: data file 1: '/db0/u01/oradata/rock/system01.dbf'
>
> Any idea, please help. It is a new database I don't have anything to
> recover.
>
> Thanks
>
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Thu Feb 24 2000 - 11:19:59 CST