Re: Copy Database from NT to W2K

"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 - 08:26:25 CST