Oracle DG 搭建手册.docx
- 文档编号:9451624
- 上传时间:2023-02-04
- 格式:DOCX
- 页数:53
- 大小:152.82KB
Oracle DG 搭建手册.docx
《Oracle DG 搭建手册.docx》由会员分享,可在线阅读,更多相关《Oracle DG 搭建手册.docx(53页珍藏版)》请在冰豆网上搜索。
OracleDG搭建手册
ORACLEDG搭建手册
修订记录
版本
日期
作者
描述
V1.0
2018-09-09
Steven
形成初稿
1.概述
1.1什么是DataGuard(DG)?
备用数据库(StandbyDatabase),从Oracle9i开始也叫做DataGuard,是Oracle推出的一种高可用性(HighAvailable)数据库解决方案,其主要的目标是Oracle数据库层面的数据保护以及容灾方案。
主要组成部分为一个在线的生产数据库(或者是RAC集群),我们一般叫做Primary;以及一个在线备用数据库(或者是RAC集群),我们一般叫做Standby。
Primary与Standby之间通过日志同步来保证数据的同步和热备,备用节点是是一种随时处在databaserecovery的状态应用主节点传输过来的日志,并且随时保持active的状态以备随时切换与灾难恢复。
从9i开始正式更名为DataGuard,开始支持三种不同的数据保护模式,并可以采用LGWR/LNSn而不仅仅是以往的ARCH对数据进行传送,并增加了一个叫做DMON的后台进程进行监控。
支持多大9个standby同事复制。
1.2物理架构以及功能分布是?
在DG方案中,理论上至少需要两台主机,两套存储。
用于搭建逻辑上和物理上完全一致的DB,如果不是接管需要,standby可以比primary配置低一些。
与RAC不同的是DG一般只有一个节点是active的,只有当主机发生故障的时候,才考虑切换到备用服务器。
备用服务器一般不提供读写操作(因为通常状况下都是recoverstandby状态,该状态是没有open的)。
只有需要的时候才提供只读的报表查询服务,或者档主站点出现故障的时候,经过一定的切换条件,才转变为主数据库,提供正常服务。
1.3进程结构图
2.开始配置
2.1前期检查
2.1.1检查tns文件
3.[oracle@racnode1 ~]$ cd /u01/app/oracle/product/11.2.0/dbhome_1/network/admin/
4.[oracle@racnode1 admin]$ ls
5.samples shrept.lst tnsnames.ora
6.[oracle@racnode1 admin]$ cat tnsnames.ora
7.# tnsnames.ora Network Configuration File:
/u01/app/oracle/product/11.2.0/dbhome_1/network/admin/tnsnames.ora
8.# Generated by Oracle configuration tools.
9.
10.RACDB =
11. (DESCRIPTION =
12. (ADDRESS = (PROTOCOL = TCP)(HOST = racnode-cluster-scan)(PORT = 1521))
13. (CONNECT_DATA =
14. (SERVER = DEDICATED)
15. (SERVICE_NAME = RACDB)
16. )
17. )
2.1.2检查数据库监听
1.[oracle@racnode1 admin]$ lsnrctl status
2.
3.LSNRCTL for Linux:
Version 11.2.0.3.0 - Production on 24-AUG-2015 13:
22:
18
4.
5.Copyright (c) 1991, 2011, Oracle. All rights reserved.
6.
7.Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
8.STATUS of the LISTENER
9.------------------------
10.Alias LISTENER
11.Version TNSLSNR for Linux:
Version 11.2.0.3.0 - Production
12.Start Date 23-AUG-2015 18:
58:
20
13.Uptime 0 days 18 hr. 23 min. 58 sec
14.Trace Level off
15.Security ON:
Local OS Authentication
16.SNMP OFF
17.Listener Parameter File /u01/app/11.2.0/grid/network/admin/listener.ora
18.Listener Log File /u01/app/grid/diag/tnslsnr/racnode1/listener/alert/log.xml
19.Listening Endpoints Summary...
20. (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=LISTENER)))
21. (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.77.185)(PORT=1521)))
22. (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.77.187)(PORT=1521)))
23.Services Summary...
24.Service "+ASM" has 1 instance(s).
25. Instance "+ASM1", status READY, has 1 handler(s) for this service...
26.Service "RACDB" has 1 instance(s).
27. Instance "RACDB_1", status READY, has 1 handler(s) for this service...
28.Service "RACDBXDB" has 1 instance(s).
29. Instance "RACDB_1", status READY, has 1 handler(s) for this service...
30.The command completed successfully
2.2查询SID并创建RMAN备份目录
1.[oracle@racnode1 admin]$ sqlplus / as sysdba
2.
3.SQL*Plus:
Release 11.2.0.3.0 Production on Mon Aug 24 13:
22:
33 2015
4.
5.Copyright (c) 1982, 2011, Oracle. All rights reserved.
6.
7.
8.Connected to:
9.Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
10.With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
11.Data Mining and Real Application Testing options
12.
13.SQL> show parameter service
14.
15.NAME TYPE VALUE
16.------------------------------------ ----------- ------------------------------
17.service_names string RACDB
18.SQL> exit
19.Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
20.With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
21.Data Mining and Real Application Testing options
22.[oracle@racnode1 admin]$ mkdir /rmanbak
23.mkdir:
cannot create directory `/rmanbak':
Permission denied
24.[oracle@racnode1 admin]$ exit
25.logout
2.3将RAC主库修改为归档模式,并开启forcelogging模式
由于事先已经将数据库置为归档模式,故在此只需要修改forcelogging模式即可。
1.[oracle@racnode1 ~]$ sqlplus / as sysdba
2.SQL*Plus:
Release 11.2.0.3.0 Production on Mon Aug 24 13:
13:
57 2015
3.Copyright (c) 1982, 2011, Oracle. All rights reserved.
4.Connected to:
5.Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Productio
6.With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
7.Data Mining and Real Application Testing options
8.SQL> alter database force logging;
9.Database altered.
10.SQL> exit
11.Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
12.With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
13.Data Mining and Real Application Testing options
2.4主库全备,创建standbycontrolfile,生成pfile文件,复制密码文件。
然后将准备好的所有文件复制到备库所在目录(最好对应主库的备份目录,方便RMAN恢复。
)
1.[root@racnode1 ~]# mkdir /rmanbak
2.[root@racnode1 ~]# chown oracle:
oinstall /rmanbak/
3.[root@racnode1 ~]# su - oracle
4.[oracle@racnode1 ~]$ rman target /
5.Recovery Manager:
Release 11.2.0.3.0 - Production on Mon Aug 24 13:
27:
15 2015
6.Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
7.connected to target database:
RACDB (DBID=883515518)
8. #ff0000;">----------------------备份数据库和归档
9.RMAN> run {
10.2> allocate channel c1 type disk;
11.3> allocate channel c2 type disk;
12.4> allocate channel c3 type disk;
13.5> allocate channel c4 type disk;
14.6> backup database format '/rmanbak/FULL_%U.bak';
15.7> backup archivelog all format '/rmanbak/ARC_%U.bak';
16.8> release channel c1;
17.9> release channel c2;
18.10> release channel c3;
19.11> release channel c4;
20.12> }
21.released channel:
ORA_DISK_1
22.allocated channel:
c1
23.channel c1:
SID=155 instance=RACDB_1 device type=DISK
24.allocated channel:
c2
25.channel c2:
SID=24 instance=RACDB_1 device type=DISK
26.allocated channel:
c3
27.channel c3:
SID=29 instance=RACDB_1 device type=DISK
28.allocated channel:
c4
29.channel c4:
SID=158 instance=RACDB_1 device type=DISK
30.Starting backup at 24-AUG-15
31.channel c1:
starting full datafile backup set
32.channel c1:
specifying datafile(s) in backup set
33.input datafile file number=00006 name=+DATADG/racdb/datafile/data01.269.886180153
34.channel c1:
starting piece 1 at 24-AUG-15
35.channel c2:
starting full datafile backup set
36.channel c2:
specifying datafile(s) in backup set
37.input datafile file number=00002 name=+DATADG/racdb/datafile/sysaux.261.885898927
38.input datafile file number=00005 name=+DATADG/racdb/datafile/users.265.885899091
39.channel c2:
starting piece 1 at 24-AUG-15
40.channel c3:
starting full datafile backup set
41.channel c3:
specifying datafile(s) in backup set
42.input datafile file number=00003 name=+DATADG/racdb/datafile/undotbs1.262.885898975
43.input datafile file number=00007 name=+DATADG/racdb/datafile/index01.270.886180183
44.channel c3:
starting piece 1 at 24-AUG-15
45.channel c4:
starting full datafile backup set
46.channel c4:
specifying datafile(s) in backup set
47.input datafile file number=00001 name=+DATADG/racdb/datafile/system.260.885898771
48.input datafile file number=00004 name=+DATADG/racdb/datafile/undotbs2.264.885899061
49.channel c4:
starting piece 1 at 24-AUG-15
50.channel c2:
finished piece 1 at 24-AUG-15
51.piece handle=/rmanbak/FULL_0gqfdgi0_1_1.bak tag=TAG20150824T134016 comment=NONE
52.channel c2:
backup set complete, elapsed time:
00:
02:
54
53.channel c2:
starting full datafile backup set
54.channel c2:
specifying datafile(s) in backup set
55.channel c1:
finished piece 1 at 24-AUG-15
56.piece handle=/rmanbak/FULL_0fqfdgi0_1_1.bak tag=TAG20150824T134016 comment=NONE
57.channel c1:
backup set complete, elapsed time:
00:
03:
29
58.channel c1:
starting full datafile backup set
59.channel c1:
specifying datafile(s) in backup set
60.including current SPFILE in backup set
61.channel c1:
starting piece 1 at 24-AUG-15
62.channel c3:
finished piece 1 at 24-AUG-15
63.piece handle=/rmanbak/FULL_0hqfdgi0_1_1.bak tag=TAG20150824T134016 comment=NONE
64.channel c3:
backup set complete, elapsed time:
00:
03:
30
65.channel c4:
finished piece 1 at 24-AUG-15
66.piece handle=/rmanbak/FULL_0iqfdgi6_1_1.bak tag=TAG20150824T134016 comment=NONE
67.channel c4:
backup set complete, elapsed time:
00:
02:
48
68.channel c1:
finished piece 1 at 24-AUG-15
69.piece handle=/rmanbak/FULL_0kqfdgoh_1_1.bak tag=TAG20150824T134016 comment=NONE
70.channel c1:
backup set complete, elapsed time:
00:
00:
02
71.including current control file in backup set
72.channel c2:
starting piece 1 at 24-AUG-15
73.channel c2:
finished piece 1 at 24-AUG-15
74.piece handle=/rmanbak/FULL_0jqfdgni_1_1.bak tag=TAG20150824T134016 comment=NONE
75.channel c2:
backup set complete, elapsed time:
00:
00:
01
76.Finished backup at 24-AUG-15
77.Starting backup at 24-AUG-15
78.current log archived
79.channel c1:
starting archived log backup set
80.channel c1:
specifying archived log(s) in backup set
81.input archived log thread=1 sequence=148 RECID=3 STAMP=888506477
82.input archived log thread=2 sequence=47 RECID=1 STAMP=888506297
83.input archived log thread=2 sequence=48 RECID=2 STAMP=888506471
84.input archived log thread=2 sequence=49 RECID=5 STAMP=888507728
85.input archived log thread=1 sequence=149 RECID=4 STAMP=8885076
- 配套讲稿:
如PPT文件的首页显示word图标,表示该PPT已包含配套word讲稿。双击word图标可打开word文档。
- 特殊限制:
部分文档作品中含有的国旗、国徽等图片,仅作为作品整体效果示例展示,禁止商用。设计者仅对作品中独创性部分享有著作权。
- 关 键 词:
- Oracle DG 搭建手册 搭建 手册
![提示](https://static.bdocx.com/images/bang_tan.gif)