Oracle 19c rac+adg.pdf - 墨天轮文档

Oracle 19c rac+adg.pdf

Kay

7265

14页

165次

2019-08-21

5墨值下载

Oracle 19c rac+adg

rac

1rac

[oracle@rac1:/home/oracle]$sqlplus / as sysdba

SQL> startup mount;

SQL> alter system set log_archive_dest_1='location=+arch' scope=spfile;

System altered.

SQL> alter database archivelog;

Database altered.

Primary Standb y

DB Version 19.3.0 19.3.0

HOST IP

192.168.189.211 rac1

192.168.189.212 rac2

192.168.189.209 std

SCAN IP 192.168.189.215 rac-scan

DB_NAME orcl orcl

DB_UNIQUE_NAME orcl std

Instance_Name orcl std

ArchiveFile +data /u01/arch/

DB Storage ASM FileSystem

ASM for DB files +DATA/ORCL/DATAFILE/ /u01/app/oracle/oradata/std/datafile/

ASM for LOG files +DATA/orcl/onlinelog /u01/app/oracle/oradata/orcl/onlinelog

ASM for TEMP files +DATA/orcl/tempfile/ /u01/app/oracle/oradata/std/tempfile/

ORACLE_HOME /u01/app/oracle/product/19.3.0/db_1/ /u01/app/oracle/product/19.3.0/db_1/

OS Red Hat Enterprise Linux Server 7.4 CentOS 7.6

SQL> alter database force logging;

Database altered.



SQL> alter database open;

2󰉈dataguard

force logging󰈱󰀉

alter database force logging;

alter system set LOG_ARCHIVE_CONFIG='DG_CONFIG=(orcl,std)' scope=both sid='*';

alter system set log_archive_dest_1='LOCATION=+arch VALID_FOR=

(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=orcl' scope=spfile;

alter system set LOG_ARCHIVE_DEST_2='SERVICE=std LGWR ASYNC VALID_FOR=

(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=std' scope=both sid='*';

alter system set fal_client='orcl' scope=both sid='*';

alter system set FAL_SERVER='std' scope=both sid='*';

alter system set standby_file_management=AUTO scope=both sid='*';

alter system set

DB_FILE_NAME_CONVERT='/u01/app/oracle/oradata/orcl/datafile','+DATA/orcl/datafile','/

u01/app/oracle/oradata/orcl/tempfile','+DATA/orcl/tempfile' scope=spfile sid='*';

alter system set

LOG_FILE_NAME_CONVERT='/u01/app/oracle/oradata/orcl/onlinelog','+DATA/orcl/onlinelog'

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;

alter system set PARALLEL_EXECUTION_MESSAGE_SIZE=8192 scope=spfile;

󰌀

3srl

SQL> select bytes/1024/1024 mb from v$log;

----------

300

standby

2logfileslr󰑲󰁞thread

of 14

5墨值下载

文档被以下合辑收录

墨天轮最受欢迎的技术文档-高可用架构篇（共121篇）

数据库高可用如何实现？这份合辑你或许可以用到！本文为大家整理了墨天轮社区上一些受欢迎的数据库高可用架构实践主题相关文档，包含Oracle、PostgreSQL、MySQL三类数据库，欢迎大家下载查看🌹

关注

文档被以下合辑收录

评论