2
Oracle 19c rac+adg.pdf
5649
14页
125次
2019-08-21
5墨值下载
Oracle 19c rac+adg
rac
1rac
[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;
MB
----------
300
300
300
300
standby
2logfileslr󰑲󰁞thread
of 14
5墨值下载
【版权声明】本文为墨天轮用户原创内容,转载时必须标注文档的来源(墨天轮),文档链接,文档作者等基本信息,否则作者和墨天轮有权追究责任。如果您发现墨天轮中有涉嫌抄袭或者侵权的内容,欢迎发送邮件至:contact@modb.pro进行举报,并提供相关证据,一经查实,墨天轮将立刻删除相关内容。
关注
最新上传
暂无内容,敬请期待...
下载排行榜
Top250 周榜 月榜