2
2
RAC对单机DG.pdf
10墨值下载
RACDG
1
RAC+DG
hosts
vi /etc/hosts
#public IP
192.168.23.20 rac1
192.168.23.21 rac2
#virtual IP
192.168.23.43 rac1-vip
192.168.23.44 rac2-vip
#private IP
192.168.240.15 rac1-priv
192.168.240.16 rac2-priv
#rac scan IP
192.168.23.22 definescan
#standby IP
192.168.162.128 rac3
SQL> select log_mode, force_logging from v$database;
LOG_MODE FORCE_LOGGING
------------ ---------------------------------------
ARCHIVELOG NO
mount
SQL> alter system set log_archive_dest_1='location=+data' sid=
RACDG
2
System altered.
SQL> shutdown immediate; #
SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup mount; # 1
SQL> startup mount;
ORACLE instance started.
Total System Global Area 1191178320 bytes
Fixed Size 9134160 bytes
Variable Size 536870912 bytes
Database Buffers 637534208 bytes
Redo Buffers 7639040 bytes
Database mounted.
SQL> alter database archivelog;
Database altered.
SQL> alter database open;
Database altered.
open
SQL> alter database force logging;
Database altered.
SQL> startup # 1open 2
ORACLE instance started.
Total System Global Area 1191178320 bytes
Fixed Size 9134160 bytes
Variable Size 536870912 bytes
RACDG
3
Database Buffers 637534208 bytes
Redo Buffers 7639040 bytes
Database mounted.
Database opened.
SQL> select log_mode, force_logging from v$database;
LOG_MODE FORCE_LOGGING
------------ ---------------------------------------
ARCHIVELOG YES
dataguard
alter system set log_archive_config='dg_config=(orcl2,test1)'
System altered.
alter system set log_archive_dest_3='service=test1 valid_for=
System altered.
scp
[oracle@rac1:/home/oracle/.ssh]$ cat id_rsa.pub
ssh-rsa AAAAB3NzaC1yc2EAAAADAQABAAABAQDAVmLdEa5j4kUMoS3G3HYQle
[oracle@rac1:/home/oracle/.ssh]$ ssh-copy-id oracle@192.168.23
/bin/ssh-copy-id: INFO: Source of key(s) to be installed: "/ho
The authenticity of host '192.168.23.128 (192.168.23.128)' ca
ECDSA key fingerprint is SHA256:nRH6sLCXvdTgicpyc9iRQyFtgITaP4
ECDSA key fingerprint is MD5:81:c7:ec:74:35:4c:27:20:de:92:00
Are you sure you want to continue connecting (yes/no)? yes
/bin/ssh-copy-id: INFO: attempting to log in with the new key
of 33
10墨值下载
【版权声明】本文为墨天轮用户原创内容，转载时必须标注文档的来源（墨天轮），文档链接，文档作者等基本信息，否则作者和墨天轮有权追究责任。如果您发现墨天轮中有涉嫌抄袭或者侵权的内容，欢迎发送邮件至：contact@modb.pro进行举报，并提供相关证据，一经查实，墨天轮将立刻删除相关内容。
下载排行榜
1
2
白鳝-DBAIOPS：国产化替换浪潮进行时，信创数据库该如何选型？.pdf
3
centos7下oracle11.2.0.4 rac安装详细图文（虚拟机模拟多路径）.docx
4
PostgreSQL 缓存命中率低？可以这么做.doc
5
李飞-AI 引领的企业级智能分析架构演进与行业实践.pdf
6
达梦数据2024年年度报告.pdf
7
吕昕-如何建设人人都能训大模型的技术氛围-V脱敏.pdf
8
菜鸟低代码创新实践：全栈转型与技术效能突破.pdf
9
刘杰-江苏广电：从Oracle+Hadoop到TiDB，数据中台、实时数仓运维0负担.pdf
10
曾国洋-端侧模型的知识密度：迈向 AGI 的关键技术实践.pdf
相关文档
评论