Tuesday, June 11, 2013

RAC One Node database online relocation


1. Create RAC One Node database using DBCA

2. Verify the configuration and status of RAC One Node database:

$ srvctl status database -d MYRONE
Instance MYRONE_2 is running on node oratest2-lnx
Online relocation: INACTIVE

$ srvctl config database -d MYRONE
Database unique name: MYRONE
Database name: MYRONE
Oracle home: /u01/app/oracle/product/11.2.0.3/db_1
Oracle user: oracle
Spfile: +DATA/MYRONE/spfileMYRONE.ora
Domain: intdata.com
Start options: open
Stop options: immediate
Database role: PRIMARY
Management policy: AUTOMATIC
Server pools: MYRONE
Database instances: 
Disk Groups: DATA,FLASH
Mount point paths: 
Services: MYRONE_S
Type: RACOneNode
Online relocation timeout: 30
Instance name prefix: MYRONE
Candidate servers: oratest1-lnx,oratest2-lnx
Database is administrator managed

3. Online database relocation:

$ srvctl relocate database -d MYRONE -n oratest1-lnx

4. Verify database stauts:

$ srvctl status database -d MYRONE 
Instance MYRONE_2 is running on node oratest2-lnx
Online relocation: ACTIVE
Source instance: MYRONE_2 on oratest2-lnx
Destination instance: MYRONE_1 on oratest1-lnx

$ srvctl status database -d MYRONE
Instance MYRONE_1 is running on node oratest1-lnx
Online relocation: INACTIVE

No comments:

Post a Comment