Cannot mount server [message #50077] |
Wed, 27 February 2002 06:45 |
Manish Sukhwani
Messages: 4 Registered: February 2002
|
Junior Member |
|
|
I have a database existing on the server. i want to create one more and for that on Sql prompt i specified the pfile and started a database without mounting it.
After above said, on Sql prompt i gave command as Create database ----
and reuse the control and system01.dbf files of the existing database.
it gave me error create database failed.
now i m not able to start my existing database.
when i tried to open my existing database
it gives me error as follows:
ORA-01122- database file 1 failed verification check.
ORA-01110- c:....System01.dbf
ORA-01202- wrong incarnation of this file - wrong
creation time.
I want to recover my database
pls help me.
|
|
|
Re: Cannot mount server [message #50083 is a reply to message #50077] |
Wed, 27 February 2002 09:11 |
Grant
Messages: 578 Registered: January 2002
|
Senior Member |
|
|
The only way to recover is restore from backup. You don't ever want to use existing database files when you create another one.
|
|
|