Using disk for separate oracle instances

[Dudek]

Hi there.

I have a one instance running Oracle 816 32 bit and one disk with all the data in it. I also have another instance on another server running 817 64 bit. Both the databases are the same (table spaces/ tables etc etc). So i was wondering whether i can just take the disk form the 816 32 bit server and port it to the 817 64 bit server. ie so that the 817 64 bit will use the data from the 816 32 bit server. Is this possible? And if it is what are the issues that i have to bear in mind?

TIA

JD

 

[spenglerr]

sorry, but that is not that easy.

1. the datafiles contain information about the database (a number identifying the database unique).
2. the datafiles have another version with significant changes in the database dictionary information and thus in the tablespace administration.
3. there is the possibility of transportable tablespaces, but this is limited to same hardware/database version/OS.
4. Since the table names and tablespace names ,... are the same you will get problems with conflicting names!

I expect that you just plan to append the data from one databases tables to the others. If this is the case, then
use exp to export the 8.1.6 database and imp to import it to the 8.1.7 using the IGNORE=Y feature then your data will be appended to the present data in the 8.1.7 except the primary key is the same then it will be ignored. All database objects which exist in 8.1.7 already will be kept and the ones which do not exist will be generated.

This will only give problems if your database triggers, procedures, packages and so on are newer on the 8.1.6!

 

[Dudek]

Hi there..

Sorry for the late reply. But actually what i really need to know is,

If i have 2 different oracle instances running on the same server, basically one is oracle 816 32 bit and the other is oracle 817 64bit (64 bit OS obviuosly).

Currently i have the database with the data running on the 816 version of oracle. What i was wondering could happen is whether i can just shut dwon the 816 instance, and then create a new 817 instance that basically points to all the control files, datafiles, redo log files etc etc of the 816 instance. So basically it is just the same DB but now running on 817 instead of 816.

Can this be done, and if so, what major issues come to mind, and what do i have to keep in mind. Thanks

JD

 

[alexhu]

Yes - what you are doing is an upgrade so use export / import

Alex

 

[Dudek]

Thanks for the reply...

Yeah.. import/export would be able to do it.

But is there any other way to do it wihtout using imp/exp.

That is why I am wondering whether the steps i mention would work or not and if it *could* work, how do i go about doing it and what are the main points / issues i should keep in mind.

Thanks in advance
JD

 

[alexhu]

The only other way that I know is to ugrade the current database - thus should be covered in the install docs for 8.1.7

You normally have to upgrade the data dictionary by running a script - its not quite the same as your're suggesting - usually involves running an SQL script or 2

Alex

 

[Turkbear]

The 816 and 817 instances are totally different 'beasts' to Oracle...There is no way the files associated with the 816 instance can be used by the 817 one...different version, operating system, etc. ( the data is transportable but not the files themselves so just export the 816 and import into 817...)..

 

[karluk]

Upgrading Oracle 8.1.6 to 8.1.7 is one of the topics discussed in the Oracle 8i Migration manual. It's far too complex a subject to cover in an online thread like this. Please consult the manual. If you have follow up questions, I'm sure we'll be glad to take a look.

 

[naushi]

If you just want to append the 816 database to 817 database then Spenglerr's solution is correct meaning you can export the tables and users from 816 and import them into 817. If yuou want to replace the database then you would need to drop the schema on 817 'drop user xxx cascade' and get rid of the data in 817, recreate the schema xxx with resource permission and then imort the data from 816.

You cant put the disk on the other server and meger the two databases. Control file has different database number and the datafiles are configured differently in eacn database. Regards,
Naushi Hussain
Naushi.hussain@honeywell.com

 

[Dudek]

Hi there..

Sorry for the late reply again.

The reason why i dont want to use import export is because the database is huge 10TB and to do and import export would cause a too long down time.

Actually i have read somewhere that if you have the contorlfiles, datafiles and all (from the 815), you can just use those files on the new database (817)and recreate the new instance there using the file/or have an instance there already and point them all to those datafiles/contorlfiles. So i was wondering whether this is possible and if so, how do i go about doing this?

TIA
JD

 

[karluk]

At the risk of repeating myself, please read the Oracle 8i migration manual. The manual tells how to upgrade 8.1.6 to 8.1.7, but of course you will never learn how to do it if you don't read the appropriate documentation.