11.2.0.2管理Oracle RAC One Node Database
Applies to:
Oracle Server - Enterprise Edition - Version: 11.2.0.2.0 to 11.2.0.2 - Release: 11.2 to 11.2Information in this document applies to any platform.
Goal
This is a reference document for RAC One installation and Administration for version 11.2.0.2.Solution
Oracle Real Application Clusters One Node (Oracle RAC One Node) is a single instance of an Oracle Real Application Clusters (Oracle RAC) database that runs on one node in a cluster. This option adds to the flexibility that Oracle offers for database consolidation. There are significant changes in the way a RAC One database is administered in version 11.2.0.2 compared to 11.2.0.1.Major Changes include:
- OUI has a new option to select RAC One Installation.
- DBCA is now capable of configuring RAC One database.
- SRVCTL is capable of configuring and administering RAC One database. (In 11.2.0.1 this was performed using scripts like "Omotion”, “raconestatus” etc).
- DBUA is RAC One aware.
- Install and configure 11.2.0.2 Grid Infrastructure on all the cluster nodes that are part of the RAC One node setup.
- Install Oracle RDBMS software by selecting RAC One in all the participating nodes.
- Create a RAC One node database using DBCA.
1). Verifying an existing RAC One database:
command: srvctl config database -d
Eg:
[oracle@harac1 bin]$ srvctl config database -d racone
Database unique name: racone
Database name:
Oracle home: /home/oracle/product/11gR2/11.2.0.2_RACOne
Oracle user: oracle
Spfile: +DG2/RacOne/spfileRacOne.ora
Domain:
Start options: open
Stop options: immediate
Database role: PRIMARY
Management policy: AUTOMATIC
Server pools: racone
Database instances:
Disk Groups: DG2,DG1
Mount point paths:
Services:
Type: RACOneNode <<<<
Online relocation timeout: 30
Instance name prefix: racone
Candidate servers: harac1,harac2,lfmsx3
Database is administrator managed
command: srvctl status database -d
Eg:
[oracle@harac1 bin]$ srvctl status database -d racone
Instance racone_1 is running on node harac1
Online relocation: INACTIVE
Eg:
[oracle@harac1 bin]$ srvctl config database -d racone
Database unique name: racone
Database name:
Oracle home: /home/oracle/product/11gR2/11.2.0.2_RACOne
Oracle user: oracle
Spfile: +DG2/RacOne/spfileRacOne.ora
Domain:
Start options: open
Stop options: immediate
Database role: PRIMARY
Management policy: AUTOMATIC
Server pools: racone
Database instances:
Disk Groups: DG2,DG1
Mount point paths:
Services:
Type: RACOneNode <<<<
Online relocation timeout: 30
Instance name prefix: racone
Candidate servers: harac1,harac2,lfmsx3
Database is administrator managed
command: srvctl status database -d
Eg:
[oracle@harac1 bin]$ srvctl status database -d racone
Instance racone_1 is running on node harac1
Online relocation: INACTIVE
2). Performing an online migration:
Command: srvctl relocate database -d {[-n ] [-w ] | -a [-r]} [-v]
-d Unique name of database to relocate
-n Target node to which to relocate database
-w Online relocation timeout in minutes
-a Abort failed online relocation
-r Remove target node of failed online relocation request from the candidate server list of administrator-managed RAC One Node database
-v Verbose output
-h Print usage
Eg:
[oracle@harac2 dbs]$ srvctl relocate database -d racone -n harac1 -w 15 -v
Configuration updated to two instances
Instance racone_1 started
Waiting for 15 minutes for instance racone_2 to stop.....
Instance racone_2 stopped
Configuration updated to one instance
-d
-n
-w
-a Abort failed online relocation
-r Remove target node of failed online relocation request from the candidate server list of administrator-managed RAC One Node database
-v Verbose output
-h Print usage
Eg:
[oracle@harac2 dbs]$ srvctl relocate database -d racone -n harac1 -w 15 -v
Configuration updated to two instances
Instance racone_1 started
Waiting for 15 minutes for instance racone_2 to stop.....
Instance racone_2 stopped
Configuration updated to one instance
The default timeout is 30 minutes, for the sessions to migrate to the new instance. If a different timeout is preferred, then one can use the -w option.
Status during the relocation:
[oracle@harac2 bin]$ srvctl status database -d racone
Instance racone_1 is running on node harac1
Online relocation: ACTIVE
Source instance: racone_2 on harac2
Destination instance: racone_1 on harac1
[oracle@harac2 bin]$ srvctl status database -d racone
Instance racone_1 is running on node harac1
Online relocation: ACTIVE
Source instance: racone_2 on harac2
Destination instance: racone_1 on harac1
Once the migration is completed, we should see the sessions moved to the remote instance.
Eg:
[oracle@harac2 orarootagent]$ srvctl status database -d racone
Instance racone_1 is running on node harac1
Online relocation: INACTIVE
[oracle@harac2 orarootagent]$ srvctl status database -d racone
Instance racone_1 is running on node harac1
Online relocation: INACTIVE
3) Converting a RAC One database to RAC or vice versa
Converting between RAC One and RAC has been simplified with "srvctl convert database" command.
For example:
To convert a database from RAC One to RAC:
Command: srvctl convert database -d -c RAC [-n ]
srvctl convert database -d racone -c RAC -n harac1
Add the instances on other nodes as well:
[oracle@harac2 bin]$ srvctl add instance -d racone -i racone_1 -n harac1
[oracle@harac2 bin]$ srvctl add instance -d racone -i racone_3 -n lfmsx3
[oracle@harac2 bin]$ srvctl config database -d racone
Database unique name: racone
Database name:
Oracle home: /home/oracle/product/11gR2/11.2.0.2_RACOne
Oracle user: oracle
Spfile: +DG2/RacOne/spfileRacOne.ora
Domain:
Start options: open
Stop options: immediate
Database role: PRIMARY
Management policy: AUTOMATIC
Server pools: racone
Database instances: racone_1,racone_2,racone_3
Disk Groups: DG2,DG1
Mount point paths:
Services:
Type: RAC
Database is administrator managed
After starting the database on all the 3 nodes:
[oracle@harac2 bin]$ srvctl status database -d racone
Instance racone_1 is running on node harac1
Instance racone_2 is running on node harac2
Instance racone_3 is running on node lfmsx3
To convert a database from RAC to RACOne:
command: srvctl convert database -d -c RACONENODE -i -w
Eg: srvctl convert database -d racone -c RACONENODE -w 30 -i racone
[oracle@harac2 bin]$ srvctl config database -d racone
Database unique name: racone
Database name:
Oracle home: /home/oracle/product/11gR2/11.2.0.2_RACOne
Oracle user: oracle
Spfile: +DG2/RacOne/spfileRacOne.ora
Domain:
Start options: open
Stop options: immediate
Database role: PRIMARY
Management policy: AUTOMATIC
Server pools: racone
Database instances:
Disk Groups: DG2,DG1
Mount point paths:
Services: racone_taf
Type: RACOneNode
Online relocation timeout: 30
Instance name prefix: racone
Candidate servers: harac1,harac2,lfmsx3
Database is administrator managed
After starting the database:
[oracle@harac2 bin]$ srvctl status database -d racone
Instance racone_1 is running on node harac1
Online relocation: INACTIVE
Notes:
1)
Please ensure that at least one service is configured, before running the convert command, otherwise the following error will appear:
[oracle@harac2 oswtop]$ srvctl convert database -d racone -c RACONENODE -w 30 -i racone
PRCD-1242 : Unable to convert RAC database racone to RAC One Node database because the database had no service added.
2)
During the RAC to RACOne conversion, please ensure that the addition instances are removed using DBCA before we run the "srvctl convert database" command.
$ srvctl convert database -d racone -c RACONENODE -w 30 -i racone
PRCD-1214 : Administrator-managed RAC database racone has more than one instance
To convert a database from RAC One to RAC:
Command: srvctl convert database -d
Add the instances on other nodes as well:
[oracle@harac2 bin]$ srvctl add instance -d racone -i racone_1 -n harac1
[oracle@harac2 bin]$ srvctl add instance -d racone -i racone_3 -n lfmsx3
[oracle@harac2 bin]$ srvctl config database -d racone
Database unique name: racone
Database name:
Oracle home: /home/oracle/product/11gR2/11.2.0.2_RACOne
Oracle user: oracle
Spfile: +DG2/RacOne/spfileRacOne.ora
Domain:
Start options: open
Stop options: immediate
Database role: PRIMARY
Management policy: AUTOMATIC
Server pools: racone
Database instances: racone_1,racone_2,racone_3
Disk Groups: DG2,DG1
Mount point paths:
Services:
Type: RAC
Database is administrator managed
After starting the database on all the 3 nodes:
[oracle@harac2 bin]$ srvctl status database -d racone
Instance racone_1 is running on node harac1
Instance racone_2 is running on node harac2
Instance racone_3 is running on node lfmsx3
To convert a database from RAC to RACOne:
command: srvctl convert database -d
Eg: srvctl convert database -d racone -c RACONENODE -w 30 -i racone
[oracle@harac2 bin]$ srvctl config database -d racone
Database unique name: racone
Database name:
Oracle home: /home/oracle/product/11gR2/11.2.0.2_RACOne
Oracle user: oracle
Spfile: +DG2/RacOne/spfileRacOne.ora
Domain:
Start options: open
Stop options: immediate
Database role: PRIMARY
Management policy: AUTOMATIC
Server pools: racone
Database instances:
Disk Groups: DG2,DG1
Mount point paths:
Services: racone_taf
Type: RACOneNode
Online relocation timeout: 30
Instance name prefix: racone
Candidate servers: harac1,harac2,lfmsx3
Database is administrator managed
After starting the database:
[oracle@harac2 bin]$ srvctl status database -d racone
Instance racone_1 is running on node harac1
Online relocation: INACTIVE
Notes:
1)
Please ensure that at least one service is configured, before running the convert command, otherwise the following error will appear:
[oracle@harac2 oswtop]$ srvctl convert database -d racone -c RACONENODE -w 30 -i racone
PRCD-1242 : Unable to convert RAC database racone to RAC One Node database because the database had no service added.
2)
During the RAC to RACOne conversion, please ensure that the addition instances are removed using DBCA before we run the "srvctl convert database" command.
$ srvctl convert database -d racone -c RACONENODE -w 30 -i racone
PRCD-1214 : Administrator-managed RAC database racone has more than one instance
4) Upgrading a RAC One database from 11.2.0.1 to 11.2.0.2
The steps would include
- Upgrade Grid Infrastructure to 11.2.0.2 (Only out of place upgrade is possible).
- Upgrade RAC RDBMS software to 11.2.0.2(an out of place upgrade is recommended).
- Run DBUA to upgrade the RAC One database to 11.2.0.2. (In a 11.2.0.2 RDBMS HOME , scripts like Omotion , raconestatus are no longer presented, RAC One database administration is performed using srvctl only).
For more details, please refer to Oracle Real Application Clusters Administration and Deployment Guide
11g Release 2 (11.2)
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/23135684/viewspace-689519/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- RAC轉換至RAC One Node
- Oracle 11g RAC One node 安裝與配置Oracle
- rac one node、Single Instance HA(SIHA)、Oracle Restart的概念OracleREST
- Oracle RAC Cache Fusion 系列十四:Oracle RAC CR Server Part OneOracleServer
- How to drop Oracle RAC database manually?OracleDatabase
- Important Changes to Oracle Database Patch Sets Starting With 11.2.0.2_1189783.1ImportOracleDatabase
- 安裝11.2.0.2 RAC被HANG
- RAC One Node資料庫的轉換與線上遷移資料庫
- Oracle DataBase單例項遷移到Oracle RACOracleDatabase單例
- Create RAC Standby Database for RAC Primary DatabaseDatabase
- 安裝Oracle11.2.0.2 RAC for Linux X86-64(三)OracleLinux
- 安裝Oracle11.2.0.2 RAC for Linux X86-64(二)OracleLinux
- 安裝Oracle11.2.0.2 RAC for Linux X86-64(一)OracleLinux
- How does one rename a database?Database
- How to find Master Node in Oracle RAC(zt)ASTOracle
- 管理ORACLE RAC GUARD——RAC GUARD概念和管理Oracle
- 2015.05.15 網路公開課 《Oracle 11G RAC深入探索之RAC和RAC One Node之間的切換》Oracle
- Oracle RAC基本管理Oracle
- Reinstall ASM or DB HOME on One RAC Node From the Install Media_864614.1ASM
- OCA-OCP Oracle Database 11g All-in-One ExamOracleDatabase
- Oracle 11g rac add nodeOracle
- Setup Standby Database on One PC(轉)Database
- Can one rename a database user (schema)?Database
- Oracle RAC Database 11.1.0.6監聽故障案例OracleDatabase
- oracle 11.2.0.2的組成Oracle
- oracle 升級到 11.2.0.2Oracle
- (EXPDP) Fails With Errors ORA-39079 ORA-25306 On One Node In RAC EnvironmentAIError
- Oracle RAC日常管理命令Oracle
- Oracle 11G RAC One Node's Instance Arise ORA-01105 ORA-01606Oracle
- 11gR2 11.2.0.2 Database Certified with E-Business SuiteDatabaseUI
- Migrate database from single instance to Oracle RACDatabaseOracle
- 安裝Oracle 11i EBS+Database RACOracleDatabase
- Oracle Database 11g Release 2 RAC On LinuxOracleDatabaseLinux
- 【RAC]升級RAC from 11.2.0.1 to 11.2.0.2 on Linux x86_64Linux
- ORACLE RAC GUARD操作——RAC GUARD概念和管理Oracle
- Book - Oracle Database 10g OCP Certification All-in-One Exam GuideOracleDatabaseGUIIDE
- [RAC]ORACLE Database 10g RAC for Administrators學習筆記(五)OracleDatabase筆記
- [RAC]ORACLE Database 10g RAC for Administrators學習筆記(一)OracleDatabase筆記