1
Oracle 19C RAC ADG 部署测试.pdf
5墨值下载
一、环境部署
1.1 主机配置
1.2 实施步骤
1、修改主库强制归档以及开启归档模式
2、修改主库初始化参数
3、主库增加Standby redo log
$sqlplus / as sysdba
SQL> startup mount;
SQL> alter system set log_archive_dest_1='location=+dg' scope=spfile;
System altered.
SQL> alter database archivelog;
Database altered.
SQL> alter database force logging;
Database altered.
开启数据库
SQL> alter database open;
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
alter system set LOG_ARCHIVE_CONFIG='DG_CONFIG=(orclcdb,orcldg)' scope=both
sid='*';
alter system set log_archive_dest_1='LOCATION=+dg VALID_FOR=
(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=orcl' scope=spfile;
alter system set LOG_ARCHIVE_DEST_6='SERVICE=cubedg LGWR ASYNC VALID_FOR=
(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=orcldg' scope=both sid='*';
alter system set FAL_CLIENT='orclcdb' scope=both sid='*';
alter system set FAL_SERVER='orcldg' scope=both sid='*';
alter system set standby_file_management=AUTO scope=both sid='*';
alter system set DB_FILE_NAME_CONVERT='+dg','+dg' scope=spfile sid='*';
alter system set LOG_FILE_NAME_CONVERT='+dg','+dg' scope=spfile sid='*';
alter system set log_archive_format='%t_%s_%r.arc' scope=spfile sid='*';
alter system set remote_login_passwordfile='EXCLUSIVE' scope=spfile;
1
2
3
4
5
6
7
8
9
10
SYS@orclcdb> select group#,thread#,bytes/1024/1024 from v$log order by
thread#;
7 1 500
6 1 500
13 1 500
12 1 500
1
2
3
4
5
11 1 500
5 1 500
2 1 500
1 1 500
15 2 500
14 2 500
10 2 500
9 2 500
16 2 500
4 2 500
3 2 500
8 2 500
16 rows selected.
alter database add standby logfile thread 1 group 101 '+dg' size 500M;
alter database add standby logfile thread 1 group 102 '+dg' size 500M;
alter database add standby logfile thread 1 group 103 '+dg' size 500M;
alter database add standby logfile thread 1 group 104 '+dg' size 500M;
alter database add standby logfile thread 1 group 105 '+dg' size 500M;
alter database add standby logfile thread 1 group 106 '+dg' size 500M;
alter database add standby logfile thread 1 group 107 '+dg' size 500M;
alter database add standby logfile thread 1 group 108 '+dg' size 500M;
alter database add standby logfile thread 1 group 109 '+dg' size 500M;
alter database add standby logfile thread 2 group 201 '+dg' size 500M;
alter database add standby logfile thread 2 group 202 '+dg' size 500M;
alter database add standby logfile thread 2 group 203 '+dg' size 500M;
alter database add standby logfile thread 2 group 204 '+dg' size 500M;
alter database add standby logfile thread 2 group 205 '+dg' size 500M;
alter database add standby logfile thread 2 group 206 '+dg' size 500M;
alter database add standby logfile thread 2 group 207 '+dg' size 500M;
alter database add standby logfile thread 2 group 208 '+dg' size 500M;
alter database add standby logfile thread 2 group 209 '+dg' size 500M;
SYS@cubecdb1> select group#,thread# from v$standby_log;
101 1
102 1
103 1
104 1
105 1
106 1
107 1
108 1
109 1
201 2
202 2
203 2
204 2
205 2
206 2
207 2
208 2
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
of 6
5墨值下载
【版权声明】本文为墨天轮用户原创内容，转载时必须标注文档的来源（墨天轮），文档链接，文档作者等基本信息，否则作者和墨天轮有权追究责任。如果您发现墨天轮中有涉嫌抄袭或者侵权的内容，欢迎发送邮件至：contact@modb.pro进行举报，并提供相关证据，一经查实，墨天轮将立刻删除相关内容。
下载排行榜
评论