This content has been marked as final. Show 6 replies
Since this database is only 2GB, the simplest approach would be to use export/import
Thank you for your reply so
so the steps would be
1. i will create new single instance database in 10.2.0.4 server(target server with RAC set up)
2. export from old 10.2.0.2 database and import same to target right
3.is there any issue creating single instance database in a rac cluster server or is it just same as usual. anything extra
i need to be careful about if you know of any doc for that it would be appreciated
You can create an "empty" RAC instance on the target and then export from the source instance and import into the RAC instance. There are no special considerations necessary.
3.is there any issue creating single instance database in a rac cluster server or is it just same as usual. anything extra i need to be careful about if you know of any doc for that it would be appreciatedThis Note may be helpful:
*How to create a RAC database using DBCA generated scripts from templates [ID 856783.1]*Hope this help,
Hi Thank you All for valuable in puts servers has been changed now requirement is slight different
management has agreed that they are fine with moving the single instance to multinode RAC
Source DB is single instance (10.2.0.2)+nonasm+HP-UX B.11.11
Traget server 2node RAC setup with two databases already running(GNU linux x86-64) (10.2.0.4)+ASM
so to sum up all this
i Guess i can go with only this solution
1. Create new database in existing RAC setup in target--- can someone point me to any doc for new database creation in existing RAC setup with other databases already present scenario would be nice
2.EXP source DB full db export
3.IMP to new DB(should i precreate datafiles and all since its an asm and source dump is nonasm) please suggest sequence for doing full exp imp from nonasm to asm directory structure ?
and i hope i can export from 10.2.0.2 to 10.2.0.4 without any issues... or should i upgrade source db before exp imp .
Thank you all Once again
once i get some input on above updated questions i willl close the thread..
Edited by: 1009005 on Jun 4, 2013 12:33 PM
My high level recommendation posted above still applies - you will need to create a new "empty" database on the target server, then export from the source database and import into target. On the target, you can pre-create tablespaces/datafiles as needed. Yes, you can export from 10.2.0.2 and import into 10.2.0.4 - upgrade on the source is not necessary.1 person found this helpful