| ORA-01092 Oracle instance terminated, disconnection forced (merged) [message #407566] |
Wed, 10 June 2009 09:45  |
woudy65
Messages: 1
Registered: June 2009
Location: Schiedam
|
Junior Member |
|
|
Dear all,
We use a copy of our PROD database for testing purposes.
We make a hard offline physical backup.
This backup is used as starting point of the TEST database.
This worked fine until now.
Copied all files from source DB to TEST db with the exception of the init.ora and controlfiles.
Then I do in sqlplus
startup nomount pfile=f:\oradb\test\inittest.ora
@f:\oradb\test\ccftest.sql (creating controlfiles)
alter database open resetlogs;
I will eventually get an ORA-01194 pointing to an inconsistent file f:\oradb\test\system01.dbf
checked with sql statements which logfiles were needed.
Did
recover database until cancel using backup controlfile
Did this twice with both found redo logs until I got the message Log applied. Media recovery complete.
Cheered and was very proud on myself but whenever I try to use the alter database open resetlogs I will be back were I started.
HELP!!
TIA
Hans Woudenberg
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
