Two Management Styles for Oracle RAC. Policy managed database introduced in oracle 11gr2
Steps to migrate Oracled database from Admin managed to Policy Managed
1. Add server pool 
 srvctl add srvpool -g oradbsrv -l 4 -u 4 -i 999 -n slial01,slial02,slial03,slial04
2. Check configuration of serverpool
 srvctl config srvpool
3. Modify database with new serverpool created in step1
 srvctl modify database -d oradb -g oastsrv
4. Check configuration of serverpool
 srvctl config database -d oradb -a
5. Check status base of database and name of instances since its will changes after restarting instances
 srvctl status database -d oradb
6. Stop and start DB
 srvctl stop database -d oradb
 srvctl start database -d oradb
5. Check status base of database with new name of instances 
 srvctl status database -d oradb
Note: New instance name will be diffrent from instance name before migration.
A place for people who love Oracle technology and want to learn Oracle more and more
About Me
- Anand Chavan
 - Pune, Maharashtra, India
 - Working on Oracle technology for more than 14+ years.Oracle Certified professional. Expertise in Oracle advance technologies like Oracle Real Application Cluster (RAC) , Oracle DataGuard, Oracle ASM, Oracle Golden gate. Experience in Area of migration/Replication of Oracle Database. Expertise in Storage/OS administration,Vertulization, Cloud technology. Activly involed in forum discussion of RAC sig and DBA village.
 
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment