Are you sure the database was stopped before copying the files?
Giuseppe <giuseppe.didodo_at_bluewin.ch> schreef in berichtnieuws
df5fda08.0212230626.499cd4a1_at_posting.google.com...
| "Sybrand Bakker" <postbus_at_sybrandb.demon.nl> wrote in message
news:<v0drid7pfnp537_at_corp.supernews.com>...
| > "Giuseppe" <giuseppe.didodo_at_bluewin.ch> wrote in message
| > news:df5fda08.0212230209.5407db3b_at_posting.google.com...
| > > Hi, I have a question and maybe someone can help. We installed Oracle
| > > 7.3.3 on Windows NT, patched it to 7.3.4, then upgraded and migrated
| > > it till 8.1.7.4, still under NT. We saved the files, cleaned the
| > > machine and installed Windows W2K, because an upgrade fo Windows NT to
| > > W2K always crashed.
| > >
| > > After the installation of W2K, we installed Oracle 8.1.7.4. We deleted
| > > this datafiles and moved the datafiles under it, which we created on
| > > NT. We can mount the db, but at the open it crashes with ora-01092. I
| > > tried everything like 'recover... backup controlfiles' or 'recover
| > > until...', still the same.
| > >
| > > I think that basically the files from NT to W2K are not compatible,
| > > even if they're NTFS, I think something in NTFS changed between NT and
| > > W2K, but if we would migrate the OS, we wouldn't have a problem.
| > >
| > > Can somebody agree to this ?
| > This is simply NOT true
| >
| > or give me a hint ?
| >
| > Please look in the alert log for further error messages.
| > If you moved files you should have recreated the controlfile, which you
most
| > likely didn't. Your BIG BANG scenario was hence doomed to fail.
| >
| > We really don't know
| > > what to do. We didn't want to do export/import to save time, DB is
| > > 95G.
| >
| >
| > Most likely tables and indexes and indexes are not exported.
| > I also have the feeling you are describing from memory. You should post
the
| > *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
| underneath.
|
| 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 8.1.7.4 (8.1.6, 8.1.6.1, 8.1.7,
| 8.1.7.1 and finally 8.1.7.4). The DB still worked fine, now with NT4
| and 8.1.7.4. 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 -> 8.1.7.1 ->
| 8.1.7.4. 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.
|
| Giuseppe
Received on Mon Dec 23 2002 - 13:25:10 CST
