> > *exact* steps. Currently, there a no clues to work on.
> What you meant 'it's not true ?'. Ok, here the complete story:
> We went to a customer and took his datafiles, incl. control-files,
> init.ora and so on. The customer had NT4, and 7.3.4. Before we left,
> we did a 'alter database backup controlfile to trace' -> x.sql. We
> installed our machine with NT4 and 7.3.3. We patched to 7.3.4, then we
> deleted all the datafiles and put the ones from the customer
> We edited x.sql and changed the new pathes and took the line 'Recover
> database using backup controlfile' out of the script. We started the
> script which ends with 'alter database open resetlogs'. It worked
> under NT4, 7.3.4, great !
> We migrated this db all way up to 18.104.22.168 (8.1.6, 22.214.171.124, 8.1.7,
> 126.96.36.199 and finally 188.8.131.52). The DB still worked fine, now with NT4
> and 184.108.40.206. Before we left, we did a 'alter database backup
> controlfile to trace' -> y.sql.
> Now we wanted to upgrade the machine to W2K which always failed
> because of a driver for the controller. After several attempts we
> deleted the machine and instead of doing an upgrade we did a new
> installation of W2K. Then we installed Oracle DB 8.1.7 -> 220.127.116.11 ->
> 18.104.22.168. So, at this point we now deleted the new datafiles and wanted
> to put the migrated customer Files underneath.
> We did the same thing like at the customer, we started the generated
> y.sql file. The database mounted and tried to open, at this step we
> suddenly got an ora-01092, which we couldn't explain. We tried with
> 'recover database until cancel' which didn't help. We had archive logs
> till DEV00049.001, but the system wanted DEV00050.001, which we didn't
> have. The system TS was touched and then the DB crashed.
> What I suspect is, the DB opened and started to make changes, when it
> wanted to write the archive log, it crashed with 1092. We checked all
> the read/write permissions, everything seems ok. I can't explain the
> 1092 otherwise.
> Any idea ? In alertlog we had one thing '1534 PRS_0 Rollback.. not
> found', we forgot to take this out of the init.ora, but I don't think
> that this is a problem...
> I would appreciate every hint and help I can get.