This content has been marked as final. Show 7 replies
1. It is not necessary to change the character set of the database.
2. yes you can migrate if database version is different using rman. yes you can start the process between 10.2.01 on windows to 18.104.22.168 on linux
but remeber one thing while migrating using rman cross platform the archive of windows platform cannot be applied to the linx platform and vice versa for recover. So you need to take backup of database using down time when no activity is performed and no change in database is happening.
foryour reference you can also check this link
Edited by: saurabh on Aug 13, 2012 12:45 PM
AL32UTF8 is the recommended characterset - http://docs.oracle.com/cd/E11882_01/server.112/e25494/create001.htm#ADMIN13343
Pl see this MOS Doc for further details -
AL32UTF8 / UTF8 (Unicode) Database Character Set Implications [ID 788156.1]
Pl post the complete export and import commands used, along with the first 20 and last 20 lines of the export and import logs. Why weren't all of the tables imported ?
How big is the database ? How much downtime can you afford ?
the database size is small
i will not be using 'exp' or 'expdp' since rman is more recommended
this export- data-pump was done just to check dml and dql from .NET applications(yes it has to work fine and it is working fine)
should i plan to change the character set (if yes should i change it before or after migration)
are you suggesting me to use data pump instead of rman
i think rman is better option here considering the disparity in oracle version (**10.2.0.1.0** and **22.214.171.124.0**)
is character set migration a safe job considering the database's usability after migration
(i am a little wary about changing the character set since changing it and then using dbnewid utility resulted in ora 600 rendering one user to read only - dont know the reason)
i will be taking backups before and after every change
any advice about using rman for migration please
thanks for the response
Edited by: 946207 on Aug 14, 2012 1:02 PM
Edited by: 946207 on Aug 15, 2012 2:16 PM
If you use export/import, then you can upgrade and change the characterset in one step, rather that taking two downtimes (one for the upgrade and another for the characterset conversion). There is no requirement to change the characterset, it is only a recommendation at this point. If you use RMAN, you can do the upgrade without performing a change in the characterset