10g rac review

最新推荐文章于 2021-04-12 09:12:19 发布

原创最新推荐文章于 2021-04-12 09:12:19 发布 · 454 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#database #service #scalability #performance #application #system

oracle-HA 专栏收录该内容

13 篇文章

订阅专栏

本文介绍了Oracle Real Application Clusters (RAC)的基本概念和技术特点，包括高可用性、可扩展性和成本效益等优势。详细讲解了RAC的安装配置流程、数据库创建与管理方法，以及备份恢复策略，并探讨了性能调优技巧和服务管理。

1 Introduction

Why RAC. --HA, Scalability, Cost.

each instance see the recent version of block.(by internode sync).

GRD - read & write policy. (s)

Service : application group?

listener, service, instance 关系。

2 Install and config

VIP, client can use multiple public IP, but when one node fail, timeout will wait. Public IP(real and physical), VIP is logical , can float if node fail, so .... good solution

RAC software installation.

3 RAC database creation.

post work: srvctl config database -d RAC

Single instance -->convert to RAC. dbca, rcconfig.

4 RAC database administration.

Redo Log Files and RAC. thread.

Automatic Undo Management: -->one instance one undo space, but others can read/update in recovery,

Autostart/Manual, srvctl modify database -d xxx -y MANUAL/AUTOMATIC

RAC parameter, alter system set xxx sid=, remove entry reset.

Parameters: CLUSTER_DATABASE, CLUSTER_DATABASE_INSTANCES, CLUSTER_INTERCONNECTS, thread, spfile. undo_management一致，但undo_tablespace不一样。

Quiescing RAC database - db can not be opened by other instance.

impact: switch logfile, archive log current, alter system checkpoint (local/global), recover --database not instance.

ASM : parameter, cluster_database=true, asm_diskstring, group,

srvctl start/stop/status asm xxx

5 管理rac的备份和恢复

Archived log should be access by all instance.

Flash recovery area should be on shared storage.

archive log naming %t. raman autobackup switch on -->

Parallel can from different instance, but instance open status must be same(mount or open). or channel select one least workload.

During backup & restore -->autolocation from which node to recover.

5 RAC performance tuning (skip most of all)

instance recovery-->2 phase.

GC wait event.

6 Services.

Perferred service fail,then connection to another available service.

create service with srvctl, -r xx -a (optional). TAF --> none, basic, and preconnect.

8 HA connections

Connection: client side load balance(listner's LB)/failover/server side load balance.--实例级负载均衡。

run-time connection load balance.(中间件连接池)

TAP type - session, select. Method=basic-->reconnect when fail.

常用管理命令：

http://trailblizer.blog.163.com/blog/static/5963036420100752639263/ -gooda

http://wenku.baidu.com/view/6436a61dfc4ffe473368ab5a.html

http://hi.baidu.com/lee_eva/blog/item/8c8911a8c899fdf61f17a2f3.html