Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> IMP/EXP accross platforms: What will be missing?
Hello
Going from 8.1.7 (Solaris) to 9.2.0.4 (Linux Redhat AS2.1) I will have to do exp/imp. One instance, about 230 GB (size of DB files). My plan:
Done.
In praxis: Not done (being realistic). I will test this of course, the goal being a reliable procedure and a minimal downtime. But what really concerns me is the kind of unexpected problems that I won't be prepared to cope with due to my lack of experience (well, I have already transferred a number of DBs this way, at times something fails and has to be fixed manually).
These are the things that seem prone to failure. Please comment or put your ideas:
Many questions here. How to freeze a DB structure? (I am not a developer, I don't trust the developers). How do I do a quick "sanity" check of the new DB? (Something could go wrong and remain unnoticed). How can I transfer jobs? Resource plans? Are sequences an issue? Should I install the new version of the clients beforehand? (I think so, but will there be any limitation until the new DB version is up and running?). Since the DB will have a new name, will DB links still be valid? Where can I find an exact list of example users? (I don't mean OUTLN, PERFSTAT, etc.)-
Init parameters to adapt, some specific to V 9 or with changed default:
DB_CHECKSUM (false)
DB_FILE_MULTIBLOCK_READ_COUNT
PGA_AGGREGATE_TARGET
OPTIMIZER_INDEX_COST_ADJ (about 30)
OPTIMIZER_INDEX_CACHING (perhaps 50)
PARALLELITY (don't remember exactly). Four CPUs, lots of disks.
START_ARCHIVING (or similar; true, of course).
DISK_ASYNCH_IO (true)
QUERY_REWRITE (true)
CURSOR_CACHING (force)
NUMBER_OF_PROCESSES
JOB_QUEUE_PROCESSES (1 or 2)
..
and some other memory parameters. I am afraid that something will
break. Until now, I have always done imp/exp in the same platform,
same version.
You could help me minimize Murphy's chances!
Thanks a lot
Rick Denoire
(who will spend Christmas/New Year on duty).
Received on Sun Nov 02 2003 - 15:14:40 CST