环境说明
roles |
db_unique_name |
db_vers |
system_vers |
scan_ip |
---|---|---|---|---|
primarydb |
pri |
19.23 RAC |
Red Hat Enterprise Linux Server release 7.6 (Maipo) |
10.6.0.125 |
standbydb |
stb |
19.23 RAC |
Red Hat Enterprise Linux Server release 7.6 (Maipo) |
10.6.0.225 |
主库 19.23 RAC 已经安装完成,归档模式已开启;备库安装GI 软件和 DB 软件,创建磁盘组 DATA 和 ARCH,不需要 dbca 建库。双向开通 1521 端口即可,如有必要,可开通 22 端口用于 scp 文件传输并配置主备间互信。
1.查询归档模式
archive log list;
--如果未启动归档,需重启数据库实例开启归档模式
alter database archivelog;
2.打开强制日志
--查询日志模式
select inst_id,name,log_mode,force_logging from gv$database;
--开启强制日志模式(任意节点)
alter database force logging;
3.创建standby日志
set linesize 250
COLUMN groupno FORMAT a6 HEADING 'Group'
COLUMN thread FORMAT a6 HEADING 'Thread'
COLUMN member FORMAT a50 HEADING 'Member'
COLUMN redo_file_type FORMAT a10 HEADING 'Redo Type'
COLUMN group_status FORMAT a12 HEADING 'Group Status'
COLUMN member_status FORMAT a15 HEADING 'Member Status'
COLUMN bytes FORMAT 999,999 HEADING 'Size(M)'
COLUMN archived FORMAT a10 HEADING 'Archived?'
BREAK ON groupno
SELECT
to_char(f.group#) groupno
, to_char(l.thread#) thread
, f.member member
, f.type redo_file_type
, l.status group_status
, f.status member_status
, l.bytes/1024/1024 bytes
, l.archived archived
FROM
v$logfile f
, v$log l
WHERE
f.group# = l.group#
ORDER BY
f.group#
, f.member;
--创建standby日志组(文件容量需一致,并且与主库日志文件容量一致)
ALTER DATABASE ADD standby LOGFILE THREAD 1 ('+DATA/PRI/stbredo01.log') SIZE 200M;
ALTER DATABASE ADD standby LOGFILE THREAD 1 ('+DATA/PRI/stbredo02.log') SIZE 200M;
ALTER DATABASE ADD standby LOGFILE THREAD 2 ('+DATA/PRI/stbredo03.log') SIZE 200M;
ALTER DATABASE ADD standby LOGFILE THREAD 2 ('+DATA/PRI/stbredo04.log') SIZE 200M;
--查询standby日志信息
select group#,MEMBER from v$logfile;
select GROUP#,THREAD#,BYTES/1024/1024 mb from v$standby_log;
4.创建备库密码文件
--密码文件存在于 ASM 磁盘组中,需将其 cp 到文件系统然后在传到备库
[grid@pri01 ~]$ asmcmd
ASMCMD> cd +DATA/PRI/PA