Printable View
Okay, all you RMAN experts out there!
I have an 8.1.7 database that I'm backing up to Disk using RMAN.
I want to create a duplicate of that database on a DIFFERENT machine. I want the duplicate to run a test upgrade to 9i.
The catches are:
The 8.1.7 db is 32 bit on AIX 4.3.3
The new box is AIX 5.2, and only has Oracle 9i, which is 64 bit.
So, can I create the duplicate even if 8i isn't on the new box? Are the word differences going to cause me a problem?
Thanks a bunch!
I haven't cloned with RMAN. But logically speaking - no you can't perform a restore to a machine which doesn't have the required database software. If you don't have 8i installed on the new machine, how are you gonna bring the database up?
Just noticed - different OS too. Nope, you can't restore databases from one OS to another. 10g makes it possible..not 9i.
Well, that's the thing. I don't want to bring it up. I just want to mount it and run the upgrade to 9i scripts.Quote:
Originally posted by Axr2
I haven't cloned with RMAN. But logically speaking - no you can't perform a restore to a machine which doesn't have the required database software. If you don't have 8i installed on the new machine, how are you gonna bring the database up?
The OS was the other main concern. They're both AIX, but different versions.
The database is really tiny, but I can't use exp/imp because it has LONG RAW columns.... hmmmm
Any other ideas would be great!
You still need the software to mount the database.Quote:
Well, that's the thing. I don't want to bring it up. I just want to mount it and run the upgrade to 9i scripts.
> The database is really tiny, but I can't use exp/imp because it has LONG RAW columns.... hmmmm
So? Why can't you exp? Do you get errors? If so, what?
dont need the 8i software to mount the database - how else do you upgrade a database - must mount it with the new oracle software
So you're saying she would be able to mount 8.1.7 datbase (32 bit 4.3.3) with a 9i 64 bit on 5.2? And her upgrade scripts would run fine?! I find that pretty hard to believe. If at all, wouldn't she atleast have to convert from 32 to 64bit, before even attempting an upgrade?Quote:
Originally posted by davey23uk
dont need the 8i software to mount the database - how else do you upgrade a database - must mount it with the new oracle software
well i dont know about the aix bit - never used it, but on Solaris you sure can do it.
Shutdown the 8i instance, startup migrate with the 9i software - run the migration scripts and then open.
I've done this many times with 8i 32 bit to 9iR2 64 bit
you can mount a 8i database with 9i binaries with no problems
im just curious as to how you think you can migrate a database without mounting an 8i database with 9i binaries (or using exp/imp)
You asking me? If so - I meant mounting a 32bit Oracle on AIX 4.3.3 with a 64bit Oracle AIX 5.1. I didn't think it was possible. Looked up metalink..folks say there are issues.Quote:
Originally posted by davey23uk
im just curious as to how you think you can migrate a database without mounting an 8i database with 9i binaries (or using exp/imp)
ok fair enough with aix, never touched it - doable with solaris 8 - 9
you can mount a 8i database with 9i binaries with no problems
______________________
If this is correct .. My job will be so easy for next couple of days. I couldn't believe this. ANy way I will try now. I am thinking I have to have same binaries on the other box to recover hot/cold backup and migrate the binaries to higher version.
Glad to see I'm not the only one unsure about all of this.
Thanks for all your input! I looked further at the db, and the 3 tables with BLOBs and LONG RAWs are actually empty. (I can't believe I didn't check this earlier!) So, the exp/imp should be fine.
raghud -
I'm almost positive you can mount an 8i instance with 9i binaries. My concerns were the word size and OS difference. Also with RMAN, wasn't sure how that would work to make a duplicate with those differences. Let us know what you find with your testing.
Thanks again!
Jodie