-
RAC Upgrade steps
Hi,
We are in the process of migration / upgradation. Below are the steps, i am planning to follow. Can pls somebody correct me if i am missing something ??
Thx.
-------
Source:
2 Node RAC (production)
Cluster: 10g R1 CRS
DB: 10.1.0.4
OracleHome
File system: HP unix FS
Storage Data FileSystem: Rawfiles.
Requirement is to convert the Above Source into the below Target configuration
------------------------------------------------------------------------------------------------------------------
Target:
2 Node RAC
Cluster: 10g R2 CRS ( To be upgraded from R1)
DB: 10.2.0.3 (To be upgraded from 10.1.0.4)
OracleHome
File system: HP Unix FS
Data FileSystem: Veritas File System. ( Existing in source is RAW file system)
STEPS we are planning to follow:
--------------------------------
1.Shutdown the Source (production) and take cold backup of datafiles and Oracle home.
2. Copy the Raw files from source to target using dd command.
(The target has veritas FS)
To do this we are using dd command.
3. Copy Oracle Home from Source to Target. (Single Node)
4. Recreate Controlfile and bring up the single Node on Veritas File system
5. Ensure everything is working Fine.
Steps to upgrade.
--------------------------------
8. Upgrade DB from 10.1.0.4 To 10.2.0.1 and apply patchset 10.2.0.3.
10. Install 10.2.0.1 CRS on 2 nodes for RAC.
11. Upgrade 10.2.0.1 to 10.2.0.3 by applying patchset.
12. Convert Single node RAC to Dual node RAC (either using rconfig or DBCA )
------------------------------------------------------------------------
The most enjoyable things in the world are either Immoral or too Expensive or otherwise Inaccessible anyway
-
how do you steps match up against the upgrade guide supplied by oracle?
-
Hi
You need to first upgrade the oracle clusterware to 10.2 or reinstall it and then follow all the steps outlined by you.
Davey do you have a oracle supplied guide for doing this ?
regards
Hrishy
-
Hi
How about
Take a backup of the whole database
Install 10.2.0.1 CRS on 2 nodes for RAC
Startup the 10.1.0.4 RAC with 10.2.0.1 CRS
Install a New Oracle home for 10.2.0.1
Shutdown the 10.1.0.4 RAC Database
Use DBUA to upgrade the database to 10.2.0.1
Bring up the RAC and check everything
Shutdown the Database and instances
Use RMAN (you can also switch the database to copies etc) or DD the datafile to VXFS filesystem
Recreate the controlfile
restart the database
Note i have not done a upgrade from 10.1 to 10.2 RAC but i guess the key is getting the 10.2.0.1 CRS up and running right others all should be normal steps.
Wundering did you check with oracle support guys on this i am curious
I am curious why you went up the route of conveting to single instance and then back to a clustered instance ?
regards
Hrishy
-
Dear All,
1. Backup the database.
1a. Export the entire database.
2. Install the new CRS 10.2.0.1.0 and upgrade it to 10.2.0.3.0.
3. Create database using dbca which will be of version 10.2.0.3.0.
4. Import the full database.
-
Dear All,
Missed one step
1. Backup the database.
1a. Export the entire database.
2. Install the new CRS 10.2.0.1.0.
2a. Install Database software 10.2.0.1.0 and patch it 10.2.0.3.0 and upgrade crs IF NEEDED.
3. Create database using dbca which will be of version 10.2.0.3.0.
4. Import the full database.
-
Originally Posted by pareshjavkar
Dear All,
Missed one step
1. Backup the database.
1a. Export the entire database.
2. Install the new CRS 10.2.0.1.0.
2a. Install Database software 10.2.0.1.0 and patch it 10.2.0.3.0 and upgrade crs IF NEEDED.
3. Create database using dbca which will be of version 10.2.0.3.0.
4. Import the full database.
It is 500gb db. It would take long time for Export / Import.
------------------------------------------------------------------------
The most enjoyable things in the world are either Immoral or too Expensive or otherwise Inaccessible anyway
-
You can use expdp and impdp
-
What storage system are u anticipating for ur new 10.2.0.3 RAC database?
-
For a std upgrade from 10.1 to 10.2, shut down the CRS stack on all nodes, & unlock the CRS home using the script [B]mountpoint/clusterware/upgrade/preupdate.sh. When u run OUI & select the option to install Oracle Clusterware on a subset of nodes, OUI installs Oracle 10.2 clusterware into the existing CRS home on the local & remote node subset.
When all member nodes of the cluster are running clusterware 10.2, then the new clusterware becomes the active version.
You can now upgrade ur db from 10.1 to 10.2. If u're planning to use ASM for storage, then i'll suggest u install & patch the ASM from 10.2.0.1 to 10.2.0.3 & do the same for the oracle software separately. I found it easier trouble shooting separate ASM/software installs than first laying down the software & using dbca to create an ASM instance.
Good luck...
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|