First time migrator of database, what to do when doing the migration "live"?
Hi!
We are planning to migrate a 10.2.0.4 database to 11.2.0.2.
We have tested a couple of times (of course, its a PROD system, so I have only done a expdp with SCN) and not run into any major issues.
When doing the real migration Im planning to:
* Stop the listener
* Shutdown all the system talking with the database
* Kickout users still connected
* alter system switch logfile - 8-10 times
* Put affected tablespaces in read only
* Check current SCN
Export using expdp (with flashback_scn).
Is there anything else I should think of?
Regards
U
We are planning to migrate a 10.2.0.4 database to 11.2.0.2.
We have tested a couple of times (of course, its a PROD system, so I have only done a expdp with SCN) and not run into any major issues.
When doing the real migration Im planning to:
* Stop the listener
* Shutdown all the system talking with the database
* Kickout users still connected
* alter system switch logfile - 8-10 times
* Put affected tablespaces in read only
* Check current SCN
Export using expdp (with flashback_scn).
Is there anything else I should think of?
Regards
U
0