Oracle RAC(十八):Oracle RAC One Node Database

在线漂移
[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

上一篇:SqlServer行转列关键字——Pivot


下一篇:Hadoop源码详解之DBOutputFormat类