I have 2 DB's. DB1 and DB2. Both are test db's, DB2 is brand new. Both 9i on a windows 2000 server. I want to refresh db2 from db1. I shutdown db1 cleanly, coppied all the datafiles to the DB2 directory, and rebuilt the control files for DB2. The control files were created and the database came to a mounted state. I issued the command "alter database open resetlogs;" and got the following error
alter database open
*
ERROR at line 1:
ORA-01092: ORACLE instance terminated. Disconnection forced
I have used this method hundreds of times to do refreshes and never had a problem. I looked around on the internet and found a few things. One said to restart the instance and try again. I stoped the db's nt service and started it up. Then connected to the db and issued the same command and it came back saying
ERROR at line 1:
ORA-01113: file 1 needs media recovery
ORA-01110: data file 1: 'F:\ORACLE\ORADATA\DB2\SYSTEM01.DBF'
I recovered the db with the recover db command and issued the "alter database open; command and got back to the original error message:
alter database open
*
ERROR at line 1:
ORA-01092: ORACLE instance terminated. Disconnection forced
could anyone help me out with this?