在线漂移
[oracle@wallet01 ~]$ srvctl config database -d wallet
Database unique name: wallet
Database name: wallet
Oracle home: /u01/app/oracle/product/11.2.0/db_1
Oracle user: oracle
Spfile: +DATA/wallet/spfilewallet.ora
Domain:
Start options: open
Stop options: immediate
Database role: PRIMARY
Management policy: AUTOMATIC
Server pools: wallet
Database instances:
Disk Groups: DATA,FRA
Mount point paths:
Services: soe
Type: RACOneNode
Online relocation timeout: 30
Instance name prefix: wallet
Candidate servers: wallet01,wallet02
Database is administrator managed
[oracle@wallet01 ~]$ srvctl status database -d wallet
Instance wallet_1 is running on node wallet01
Online relocation: INACTIVE
[oracle@wallet01 ~]$ srvctl relocate database -d wallet -n wallet02 -w 10
[oracle@wallet01 ~]$ srvctl status database -d wallet
Instance wallet_2 is running on node wallet02
Online relocation: INACTIVE
RAC One Node 转换为 Full RAC
[oracle@wallet01 ~]$ srvctl config database -d wallet
Database unique name: wallet
Database name: wallet
Oracle home: /u01/app/oracle/product/11.2.0/db_1
Oracle user: oracle
Spfile: +DATA/wallet/spfilewallet.ora
Domain:
Start options: open
Stop options: immediate
Database role: PRIMARY
Management policy: AUTOMATIC
Server pools: wallet
Database instances:
Disk Groups: DATA,FRA
Mount point paths:
Services: soe
Type: RACOneNode
Online relocation timeout: 30
Instance name prefix: wallet
Candidate servers: wallet01,wallet02
Database is administrator managed
[oracle@wallet01 ~]$ srvctl convert database -d wallet -c RAC
[oracle@wallet01 ~]$ srvctl config database -d wallet
Database unique name: wallet
Database name: wallet
Oracle home: /u01/app/oracle/product/11.2.0/db_1
Oracle user: oracle
Spfile: +DATA/wallet/spfilewallet.ora
Domain:
Start options: open
Stop options: immediate
Database role: PRIMARY
Management policy: AUTOMATIC
Server pools: wallet
Database instances: wallet_1
Disk Groups: DATA,FRA
Mount point paths:
Services: soe
Type: RAC
Database is administrator managed
[oracle@wallet01 ~]$ srvctl add instance -d wallet -i wallet_2 -n wallet02
[oracle@wallet01 ~]$ srvctl config database -d wallet
Database unique name: wallet
Database name: wallet
Oracle home: /u01/app/oracle/product/11.2.0/db_1
Oracle user: oracle
Spfile: +DATA/wallet/spfilewallet.ora
Domain:
Start options: open
Stop options: immediate
Database role: PRIMARY
Management policy: AUTOMATIC
Server pools: wallet
Database instances: wallet_1,wallet_2
Disk Groups: DATA,FRA
Mount point paths:
Services: soe
Type: RAC
Database is administrator managed
[oracle@wallet01 ~]$ srvctl status database -d wallet
Instance wallet_1 is running on node wallet01
Instance wallet_2 is not running on node wallet02
[oracle@wallet01 ~]$ srvctl start instance -d wallet -i wallet_2
[oracle@wallet01 ~]$ srvctl status database -d wallet
Instance wallet_1 is running on node wallet01
Instance wallet_2 is running on node wallet02
Full RAC 转换为 RAC One Node
[oracle@wallet01 ~]$ srvctl config database -d wallet
Database unique name: wallet
Database name: wallet
Oracle home: /u01/app/oracle/product/11.2.0/db_1
Oracle user: oracle
Spfile: +DATA/wallet/spfilewallet.ora
Domain:
Start options: open
Stop options: immediate
Database role: PRIMARY
Management policy: AUTOMATIC
Server pools: wallet
Database instances: wallet_1,wallet_2
Disk Groups: DATA,FRA
Mount point paths:
Services: soe
Type: RAC
Database is administrator managed
[oracle@wallet01 ~]$ dbca -silent -deleteInstance -gdbName wallet -instanceName wallet_2 -sysDBAUserName sys -sysDBAPassword oracle
Deleting instance
1% complete
2% complete
6% complete
13% complete
20% complete
26% complete
33% complete
40% complete
46% complete
53% complete
60% complete
66% complete
Completing instance management.
100% complete
Look at the log file "/u01/app/oracle/cfgtoollogs/dbca/wallet.log" for further details.
[oracle@wallet01 ~]$ srvctl convert database -d wallet -c RACONENODE -i wallet01
[oracle@wallet01 ~]$ srvctl config database -d wallet
Database unique name: wallet
Database name: wallet
Oracle home: /u01/app/oracle/product/11.2.0/db_1
Oracle user: oracle
Spfile: +DATA/wallet/spfilewallet.ora
Domain:
Start options: open
Stop options: immediate
Database role: PRIMARY
Management policy: AUTOMATIC
Server pools: wallet
Database instances:
Disk Groups: DATA,FRA
Mount point paths:
Services: soe
Type: RACOneNode
Online relocation timeout: 30
Instance name prefix: wallet01
Candidate servers: wallet01
Database is administrator managed
Oracle RAC(十八):Oracle RAC One Node Database