Devinder Singh Virdi
asked on
10g to 11g Upgrade
We are thinking of upgrading 10g to 11g.
Just want to know if anyone of you did this earlier.
I need all the steps and time taken asap.
Thanks
Just want to know if anyone of you did this earlier.
I need all the steps and time taken asap.
Thanks
May i ask how big is the database ?
ASKER
5 TB.
Also, sorry for not asking this question before.
In how much window this has to be done?
If the window is less like quarter of a day or less, i would recommend the below method.
1. enable the block change tracking on the source database
2. install 11g on the target database host
3. take a level 0 backup on the source
4. take that backup and restore it on the target
5. leave the target in recovery mode
5. keep a test cutover date
6. take incremental on source (assume you are cutting all connections on the source DB at this time)
7. apply that incremental to the target
8. open the target DB
In how much window this has to be done?
If the window is less like quarter of a day or less, i would recommend the below method.
1. enable the block change tracking on the source database
2. install 11g on the target database host
3. take a level 0 backup on the source
4. take that backup and restore it on the target
5. leave the target in recovery mode
5. keep a test cutover date
6. take incremental on source (assume you are cutting all connections on the source DB at this time)
7. apply that incremental to the target
8. open the target DB
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
I'm just doing a 10g to 11g upgrade from windows 32bit to linux 64bit RAC
Preferred way is using export/import (datapump).
Compared to migration assistant export/import is straightforward and you can be sure to have no inherited 10g burdens in your new data dictionary area...
Preferred way is using export/import (datapump).
Compared to migration assistant export/import is straightforward and you can be sure to have no inherited 10g burdens in your new data dictionary area...
ASKER
Thanks you:
Basically, we need to put the proposal to our client and we need the documentation on upgrade process and time taken by each process. All above examples are really good for DBA prospective, but I am looking something from management side.
Like in Test Env:-
Pre check of rpm, privileges
Installation
Upgradation
Post check (invalidation, issues, security, services etc.)
Basically, we need to put the proposal to our client and we need the documentation on upgrade process and time taken by each process. All above examples are really good for DBA prospective, but I am looking something from management side.
Like in Test Env:-
Pre check of rpm, privileges
Installation
Upgradation
Post check (invalidation, issues, security, services etc.)
Time take will likely be specific to each environment.
My exp might take 1 hour, others 5 minutes, maybe 10 hours.
To many variables.
Same for pre and post checks. What is important to verify to me, is different than others.
It all also depends on the approach you take.
My exp might take 1 hour, others 5 minutes, maybe 10 hours.
To many variables.
Same for pre and post checks. What is important to verify to me, is different than others.
It all also depends on the approach you take.
ASKER
Basically I don't want to go for Import/export method.
I prefer to go with khadermoinuddin method.
I am looking more towards how many hours will Pre/Install/Post and Testing will take on test environment.
For testing, we will run load test for 1 day, but need to know about other.
It is possible that we need to troubleshoot the environment if required with the help of SR, but just want to know if that happened to any of you and how much time it took.
Obviously we have to take care of performance issues and they will also come for few months as per my last 9i to 10g upgrade experience.
Thanks
I prefer to go with khadermoinuddin method.
I am looking more towards how many hours will Pre/Install/Post and Testing will take on test environment.
For testing, we will run load test for 1 day, but need to know about other.
It is possible that we need to troubleshoot the environment if required with the help of SR, but just want to know if that happened to any of you and how much time it took.
Obviously we have to take care of performance issues and they will also come for few months as per my last 9i to 10g upgrade experience.
Thanks
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
I've used both the exp/imp and database migration assistant. Time is proportional to the size and options used.
If I can, I prefer the exp/imp since I have a pristine instance to start with.
The migration assistant can leave some 'bad' stuff around. Especially in spfile parameters.