1
oracle DG创建标准化文档.pdf
5墨值下载
1
archive log list
2
3
shutdown immediate;
4
startup mount
5
alter database archivelog;
6
alter database open;
7
select force_logging from v$database;
1
select * from v$datafile;
1
select * from v$tempfile;
2
select * from v$logfile;
3
CS** =
1
(DESCRIPTION =
2
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.126.**)(PORT = 1521))
3
(CONNECT_DATA =
4
(SERVER = DEDICATED)
5
(SERVICE_NAME = ***)
6
)
7
)
8
9
CS**1 =
10
(DESCRIPTION =
11
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.126.**)(PORT = 1521))
12
(CONNECT_DATA =
13
(SERVER = DEDICATED)
14
(SERVICE_NAME = cs**)
15
(INSTANCE_NAME = cs**1)
16
)
17
)
18
19
CS**2 =
20
(DESCRIPTION =
21
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.126.**)(PORT = 1521))
22
(CONNECT_DATA =
23
(SERVER = DEDICATED)
24
(SERVICE_NAME = cs**)
25
(INSTANCE_NAME = cs**2)
26
)
27
)
28
29
CS**DG =
30
(DESCRIPTION =
31
(ADDRESS_LIST =
32
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.128.**)(PORT = 1521))
33
)
34
(CONNECT_DATA =
35
(SERVICE_NAME = cs**dg)
36
)
37
)
38
DG
1
log_archive_dest_2
2
alter system set log_archive_config='dg_config=(CS**,CS**DG)' scope=both
sid='*';
3
alter system set log_archive_dest_2='service=cs**dg lgwr async valid_for=
(online_logfiles,primary_role) db_unique_name=cs**dg' scope=both sid='*';
4
dg
5
alter system set log_archive_dest_state_2=defer;
6
alter system set log_archive_dest_state_2=enable;
7
of 9
5墨值下载
【版权声明】本文为墨天轮用户原创内容，转载时必须标注文档的来源（墨天轮），文档链接，文档作者等基本信息，否则作者和墨天轮有权追究责任。如果您发现墨天轮中有涉嫌抄袭或者侵权的内容，欢迎发送邮件至：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
相关文档
评论