dataguard搭建切换.docx
5墨值下载
一、主备库信息
主备库 IP 实例名 db_unique_name 版本
10.200.8.38 orcl orcl 11.2.0.4
10.200.40.38 orcl orclbak 11.2.0.4
二、主备库修改 sys 密码和密码文件
alter user sys identified by "Sys_38";
orapwd
file=/home/u01/oracle/product/11.2.0/dbhome_1/dbs/orapworcl
password=Sys_38 entries=10
三、主库修改归档模式和强制 logging 模式
alter database archivelog;
alter database force logging;
select name, open_mode, log_mode, force_logging from v$database;
四、备库修改 db_unique_name
alter system set db_unique_name='orclbak' scope=spfile;
alter system set service_names='orcl';
SQL> show parameter name
NAME TYPE VALUE
------------------------------------ -----------
------------------------------
cell_offloadgroup_name string
db_file_name_convert string
db_name string orcl
db_unique_name string orclbak
global_names boolean FALSE
instance_name string orcl
lock_name_space string
log_file_name_convert string
processor_group_name string
service_names string orcl
五、主库增加 standby redo
alter database add standby logfile group 4
('/home/u01/oradata/orcl/redo01_sdy.log') size 50M;
alter database add standby logfile group 5
('/home/u01/oradata/orcl/redo02_sdy.log') size 50M;
alter database add standby logfile group 6
('/home/u01/oradata/orcl/redo03_sdy.log') size 50M;
alter database add standby logfile group 7
('/home/u01/oradata/orcl/redo04_sdy.log') size 50M;
六、备库增加 tnsnames 和静态监听
### tnsnames.ora
ORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.200.8.38)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)
orclbak =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.200.40.38)(PORT =
1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)
### listener.ora
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.200.40.38)(PORT =
1521))
)
)
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = orcl)
(ORACLE_HOME = /u01/app/oracle/product/11.2.0/dbhome_1)
(SID_NAME = orcl)
)
)
七、主库配置 tnsnames
ORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.200.8.38)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)
orclbak =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.200.40.38)(PORT =
1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)
八、主库参数修改
alter system set fal_client='orcl';
alter system set fal_server='orclbak';
alter system set standby_file_management='AUTO';
alter system set log_archive_config='DG_CONFIG=(orcl,orclbak)'
scope=both;
alter system set log_archive_dest_2='SERVICE=orclbak LGWR ASYNC
VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=orclbak';
alter system set log_archive_dest_state_2='ENABLE';
alter system set
db_file_name_convert='/home/u01/oradata/orcl','/home/u01/oradata/
orcl' scope=spfile;
alter system set
log_file_name_convert='/home/u01/oradata/orcl','/home/u01/oradata
/orcl' scope=spfile;
of 7
5墨值下载
【版权声明】本文为墨天轮用户原创内容，转载时必须标注文档的来源（墨天轮），文档链接，文档作者等基本信息，否则作者和墨天轮有权追究责任。如果您发现墨天轮中有涉嫌抄袭或者侵权的内容，欢迎发送邮件至：contact@modb.pro进行举报，并提供相关证据，一经查实，墨天轮将立刻删除相关内容。
最新上传
下载排行榜
1
2
9-数据库人的进阶之路：从PG分区、SQL优化到拥抱AI未来（罗敏）.pptx
3
1-PG版本兼容性案例（彭冲）.pptx
4
2-TDSQL PG在复杂查询场景中的挑战与实践-opensource.pdf
5
6-PostgreSQL 哈希索引原理浅析（文一）.pdf
6
8-基于PG向量和RAG技术的开源知识库问答系统MaxKB.pptx
7
3-AI时代的变革者-面向机器的接口语言(MOQL)_吕海波.pptx
8
4-IvorySQL V4：双解析器架构下的兼容性创新实践.pptx
9
7-拉起PG好伙伴DifySupaOdoo.pdf
10
《云原生安全攻防启示录》李帅臻.pdf
相关文档
评论