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