阿里云-云小站（无限量代金券发放中）
【腾讯云】云服务器、云数据库、COS、CDN、短信等热卖云产品特惠抢购

手工搭建Data Guard

247次阅读
没有评论

共计 15842 个字符，预计需要花费 40 分钟才能阅读完成。

Data Guard 的搭建可以使用 GC 图形化安装，优缺点很明显，优点就是图形化操作，符合国人的习惯 (据 secooler 介绍外国程序员能用图形化做的事就一定用图形做，因为 boss 看得懂，和国人正相反。。。)，缺点就是如同 Windows 一样，宛如黑盒，换句话说，要时刻祈祷不要出问题，否则有时很难知道他为什么挂了。。。

Data Guard 还可以使用命令行操作，正如各位所知，图形化的任何操作背后，其实都是使用的命令。OCM 第七场景考试中，我也是纠结了许久，临开始前才决定使用手工方式创建 DG，怕的就是图形安装的不确定性。

当然，作为练习，两种方式都熟悉下没什么不好。最近新找了两台机器资源，于是决定搭建一下 DG 的测试环境，以备后用。

环境准备：
OS：RH Linux 
配置：2C4G，40G 磁盘空间 
数据库：11.2.0.4 
主库 SID：BEIJING，单实例 
备库 SID：GUOAN，单实例

1. 主库准备工作

编辑 listener.ora，配置主库静态监听：

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (GLOBAL_DBNAME = BEIJING)
      (Oracle_HOME = /u01/app/oracle/product/11.2.0.4)
      (SID_NAME = BEIJING)
    )
  ) LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = bill02)(PORT = 1521))
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
    )
  ) ADR_BASE_LISTENER = /u01/app/oracle

编辑 tnsnames.ora，配置备库连接串：

GUOAN = (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = bill01)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = GUOAN)
    )
  )

设置 force_logging 参数：

SYS@BEIJING> alter database force logging;

查看是否开启归档：

SYS@BEIJING> archive log list;
Database log mode              Archive Mode
Automatic archival             Enabled
Archive destination            USE_DB_RECOVERY_FILE_DEST
Oldest online log sequence 6 Next log sequence to archive 8 Current log sequence 8

若未开启，将库置于 mount 状态，执行：

alter database archivelog;

确认 shared_servers、max_shared_servers、dispatchers 和 max_dispatchers 参数是否置空。(此步骤为了防止创建过程出错，实际验证不设置亦可)。

查看主库日志组：

SYS@BEIJING> select group#, member from v$logfile;  GROUP# MEMBER  ---------- -------------------------------------------------- 1 /u01/app/oracle/oradata/BEIJING/redo01.log  2 /u01/app/oracle/oradata/BEIJING/redo02.log  3 /u01/app/oracle/oradata/BEIJING/redo03.log

一共有三组，再增加四组 standby 日志：

SYS@BEIJING> alter database add standby logfile '/u01/app/oracle/oradata/BEIJING/redo04.log' size 100M;
SYS@BEIJING> alter database add standby logfile '/u01/app/oracle/oradata/BEIJING/redo05.log' size 100M;
SYS@BEIJING> alter database add standby logfile '/u01/app/oracle/oradata/BEIJING/redo06.log' size 100M;
SYS@BEIJING> alter database add standby logfile '/u01/app/oracle/oradata/BEIJING/redo07.log' size 100M;

SYS@BEIJING> select group#, member, type from v$logfile;
GROUP# MEMBER                                        TYPE
---------- ---------------------------------------- ------- 1 /u01/app/oracle/oradata/BEIJING/redo01.log ONLINE 2 /u01/app/oracle/oradata/BEIJING/redo02.log ONLINE 3 /u01/app/oracle/oradata/BEIJING/redo03.log ONLINE 4 /u01/app/oracle/oradata/BEIJING/redo04.log STANDBY 5 /u01/app/oracle/oradata/BEIJING/redo05.log STANDBY 6 /u01/app/oracle/oradata/BEIJING/redo06.log STANDBY 7 /u01/app/oracle/oradata/BEIJING/redo07.log STANDBY

编辑 pfile 文件，

DB_NAME=BEIJING DB_UNIQUE_NAME=BEIJING LOG_ARCHIVE_CONFIG='DG_CONFIG=(BEIJING,GUOAN)’--顺序填写主备库 LOG_ARCHIVE_DEST_1='LOCATION=/home/oracle/flash                   --location 表示本机
  VALID_FOR=(ALL_LOGFILES,ALL_ROLES)            --填写主库归档路径
  DB_UNIQUE_NAME=BEIJING'LOG_ARCHIVE_DEST_2='SERVICE=GUOAN ASYNC                           --service 表示另一台机器
  VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE)
  DB_UNIQUE_NAME=GUOAN’--填写备库 DB 名称 LOG_ARCHIVE_DEST_STATE_1=ENABLE LOG_ARCHIVE_DEST_STATE_2=ENABLE REMOTE_LOGIN_PASSWORDFILE=EXCLUSIVE LOG_ARCHIVE_FORMAT=%t_%s_%r.arc LOG_ARCHIVE_MAX_PROCESSES=4        --最大归档进程数官方文档默认 30，此处改为 4 FAL_SERVER=GUOAN        --为了切换后主备角色互换使用，Fetch Archived Log 缩写 DB_FILE_NAME_CONVERT='GUOAN',’BEIJING’--数据文件目录结构对应关系 LOG_FILE_NAME_CONVERT='GUOAN',’BEIJING’--日志文件目录结构对应关系 STANDBY_FILE_MANAGEMENT=AUTO    --主库数据文件修改，备库可以选择自动或手工管理

将主库已经改好的参数文件和密码文件传至备库 dbs 路径下：

[oracle@bill02 dbs]$ scp initBEIJING.ora oracle@bill01:/u01/app/oracle/product/11.2.0.4/dbs/initGUOAN.ora
[oracle@bill02 dbs]$ scp orapwBEIJING oracle@bill01:/u01/app/oracle/product/11.2.0.4/dbs/orapwGUOAN

创建主库 spfile，并启动：

SYS@BEIJING> create spfile from pfile; SYS@BEIJING> startup;


2. 备库准备工作

编辑 tnsnames.ora 文件，创建主库连接串：

BEIJING = (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = bill02)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = BEIJING)
    )
  )

创建备库监听：略

编辑备库 pfile 文件，

db_name=‘BEIJING’--注意此处，主备库的 db_name 参数要一致 memory_target=1G processes = 150 audit_file_dest='/u01/app/oracle/admin/guoan/adump' audit_trail ='db' db_block_size=8192 db_domain=''db_recovery_file_dest='/u01/app/oracle/fast_recovery_area'db_recovery_file_dest_size=2G diagnostic_dest='/u01/app/oracle'dispatchers='(PROTOCOL=TCP) (SERVICE=GUOANXDB)'open_cursors=300 remote_login_passwordfile='EXCLUSIVE'undo_tablespace='UNDOTBS'control_files = (/u01/app/oracle/oradata/GUOAN/control01.ctl, /u01/app/oracle/oradata/GUOAN/control02.ctl) compatible ='11.2.0'DB_UNIQUE_NAME=GUOAN LOG_ARCHIVE_CONFIG='DG_CONFIG=(GUOAN,BEIJING)'LOG_ARCHIVE_DEST_1='LOCATION=/home/oracle/flash
  VALID_FOR=(ALL_LOGFILES,ALL_ROLES)
  DB_UNIQUE_NAME=GUOAN'LOG_ARCHIVE_DEST_2='SERVICE=BEIJING ASYNC
  VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE)
  DB_UNIQUE_NAME=BEIJING'LOG_ARCHIVE_DEST_STATE_1=ENABLE LOG_ARCHIVE_DEST_STATE_2=ENABLE REMOTE_LOGIN_PASSWORDFILE=EXCLUSIVE LOG_ARCHIVE_FORMAT=%t_%s_%r.arc LOG_ARCHIVE_MAX_PROCESSES=4 FAL_SERVER=BEIJING DB_FILE_NAME_CONVERT='BEIJING','GUOAN'LOG_FILE_NAME_CONVERT='BEIJING','GUOAN'STANDBY_FILE_MANAGEMENT=AUTO

可以采用替换的方式来修改备库 pfile 文件：
(1) 将 BEIJING 替换为中间变量 TMP_BEIJING；
(2) 将 GUOAN 替换为 BEIJING；
(3) 将 TMP_BEIJING 替换为 GUOAN；

创建 spfile，启动备库：

SYS@GUOAN> create spfile from pfile;

SYS@GUOAN> startup
ORACLE instance started.
Total System Global Area 1068937216 bytes
Fixed Size 2260088 bytes
Variable Size 671089544 bytes
Database Buffers 390070272 bytes
Redo Buffers 5517312 bytes
ORA-00205: error in identifying control file, check alert log for more info

此处有报错，可以暂时忽略，因为备库还未有控制文件。


3. 主备库文件传输

此处我们采用 RMAN 来将主库文件传至备库：

oracle@bill02 dbs]$ rman target / auxiliary sys/oracle@guoan

Recovery Manager: Release 11.2.0.4.0 - Production on Fri Jul 29 09:46:22 2016  Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
connected to target database: BEIJING (DBID=882855131)
connected to auxiliary database: BEIJING (not mounted)

执行复制：

RMAN> duplicate target database for standby from active database;

Starting Duplicate Db at 29-JUL-16  using target database control file instead of recovery catalog
allocated channel: ORA_AUX_DISK_1
channel ORA_AUX_DISK_1: SID=10 device type=DISK contents of Memory Script:
{backup as copy reuse
   targetfile  '/u01/app/oracle/product/11.2.0.4/dbs/orapwBEIJING' auxiliary format 
 '/u01/app/oracle/product/11.2.0.4/dbs/orapwGUOAN'   ;
}
executing Memory Script

Starting backup at 29-JUL-16 allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=19 device type=DISK
Finished backup at 29-JUL-16 contents of Memory Script:
{backup as copy current controlfile for standby auxiliary format
  '/u01/app/oracle/oradata/GUOAN/control01.ctl';
   restore clone controlfile to '/u01/app/oracle/oradata/GUOAN/control02.ctl' from '/u01/app/oracle/oradata/GUOAN/control01.ctl';
}
executing Memory Script

Starting backup at 29-JUL-16 using channel ORA_DISK_1
channel ORA_DISK_1: starting datafile copy copying standby control file output file name=/u01/app/oracle/product/11.2.0.4/dbs/snapcf_BEIJING.f tag=TAG20160729T094647 RECID=1 STAMP=918467209 channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:03 Finished backup at 29-JUL-16 Starting restore at 29-JUL-16 using channel ORA_AUX_DISK_1

channel ORA_AUX_DISK_1: copied control file copy Finished restore at 29-JUL-16 contents of Memory Script:
{sql clone 'alter database mount standby database';}
executing Memory Script

sql statement: alter database mount standby database contents of Memory Script:
{set newname for tempfile 1 to "/u01/app/oracle/oradata/GUOAN/temp01.dbf";
   switch clone tempfile all; set newname for datafile 1 to "/u01/app/oracle/oradata/GUOAN/system01.dbf"; set newname for datafile 2 to "/u01/app/oracle/oradata/GUOAN/sysaux01.dbf"; set newname for datafile 3 to "/u01/app/oracle/oradata/GUOAN/undotbs01.dbf"; set newname for datafile 4 to "/u01/app/oracle/oradata/GUOAN/users01.dbf";
   backup as copy reuse
   datafile 1 auxiliary format "/u01/app/oracle/oradata/GUOAN/system01.dbf" datafile 2 auxiliary format "/u01/app/oracle/oradata/GUOAN/sysaux01.dbf" datafile 3 auxiliary format "/u01/app/oracle/oradata/GUOAN/undotbs01.dbf" datafile 4 auxiliary format "/u01/app/oracle/oradata/GUOAN/users01.dbf" ;
   sql 'alter system archive log current';
}
executing Memory Script

executing command: SET NEWNAME

renamed tempfile 1 to /u01/app/oracle/oradata/GUOAN/temp01.dbf in control file executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

Starting backup at 29-JUL-16 using channel ORA_DISK_1
channel ORA_DISK_1: starting datafile copy input datafile file number=00001 name=/u01/app/oracle/oradata/BEIJING/system01.dbf
output file name=/u01/app/oracle/oradata/GUOAN/system01.dbf tag=TAG20160729T094657
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:25 channel ORA_DISK_1: starting datafile copy input datafile file number=00002 name=/u01/app/oracle/oradata/BEIJING/sysaux01.dbf
output file name=/u01/app/oracle/oradata/GUOAN/sysaux01.dbf tag=TAG20160729T094657
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:15 channel ORA_DISK_1: starting datafile copy input datafile file number=00003 name=/u01/app/oracle/oradata/BEIJING/undotbs01.dbf
output file name=/u01/app/oracle/oradata/GUOAN/undotbs01.dbf tag=TAG20160729T094657
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:15 channel ORA_DISK_1: starting datafile copy input datafile file number=00004 name=/u01/app/oracle/oradata/BEIJING/users01.dbf
output file name=/u01/app/oracle/oradata/GUOAN/users01.dbf tag=TAG20160729T094657
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:07 Finished backup at 29-JUL-16 sql statement: alter system archive log current contents of Memory Script:
{switch clone datafile all;}
executing Memory Script

datafile 1 switched to datafile copy input datafile copy RECID=1 STAMP=918381060 file name=/u01/app/oracle/oradata/GUOAN/system01.dbf
datafile 2 switched to datafile copy input datafile copy RECID=2 STAMP=918381060 file name=/u01/app/oracle/oradata/GUOAN/sysaux01.dbf
datafile 3 switched to datafile copy input datafile copy RECID=3 STAMP=918381060 file name=/u01/app/oracle/oradata/GUOAN/undotbs01.dbf
datafile 4 switched to datafile copy input datafile copy RECID=4 STAMP=918381060 file name=/u01/app/oracle/oradata/GUOAN/users01.dbf
Finished Duplicate Db at 29-JUL-16

回显所使用的文件传输脚本和过程。

此时从备库可以使用 watch 监控文件传输进度：

watch ls
Every 2.0s: ls              Thu Jul 28 09:51:41 2016  control01.ctl  control02.ctl  redo01.log  redo02.log  redo03.log  redo04.log  redo05.log  redo06.log  redo07.log  sysaux01.dbf  system01.dbf  undotbs01.dbf  users01.dbf

传输完成，可以从备库查看，此时主备库数据文件、日志文件、参数文件保持一致：

oracle@bill01 GUOAN]$ ls -rlth
total 1.9G
-rw-r-----. 1 oracle oinstall 501M Jul 28 09:50 system01.dbf -rw-r-----. 1 oracle oinstall 326M Jul 28 09:50 sysaux01.dbf -rw-r-----. 1 oracle oinstall 201M Jul 28 09:50 undotbs01.dbf -rw-r-----. 1 oracle oinstall 101M Jul 28 09:50 users01.dbf -rw-r-----. 1 oracle oinstall 101M Jul 28 09:51 redo01.log -rw-r-----. 1 oracle oinstall 101M Jul 28 09:51 redo02.log -rw-r-----. 1 oracle oinstall 101M Jul 28 09:51 redo03.log -rw-r-----. 1 oracle oinstall 101M Jul 28 09:51 redo04.log -rw-r-----. 1 oracle oinstall 101M Jul 28 09:51 redo05.log -rw-r-----. 1 oracle oinstall 101M Jul 28 09:51 redo06.log -rw-r-----. 1 oracle oinstall 101M Jul 28 09:51 redo07.log -rw-r-----. 1 oracle oinstall 9.1M Jul 28 09:51 control01.ctl -rw-r-----. 1 oracle oinstall 9.1M Jul 28 09:51 control02.ctl

4. 验证主备库状态

此时查看备库状态，处于 MOUNT，角色是物理备库：

SQL> select database_role, open_mode from v$database;
DATABASE_ROLE    OPEN_MODE ---------------- --------------------
PHYSICAL STANDBY MOUNTED

SQL> select status from v$instance; STATUS
------------ MOUNTED

此时主库状态，处于 OPEN，可读写：

SYS@BEIJING> select database_role, open_mode from v$database;
DATABASE_ROLE    OPEN_MODE ---------------- --------------------
PRIMARY          READ WRITE

SYS@BEIJING> select status from v$instance; STATUS
------------ OPEN


5. 切换 ADG

打开备库实时应用：

SQL> recover managed standby database using current logfile disconnect from session;
Media recovery complete.

SQL> recover managed standby database cancel;
Media recovery complete.

SQL> alter database open;

SQL> select database_role, open_mode from v$database;
DATABASE_ROLE    OPEN_MODE
---------------- --------------------
PHYSICAL STANDBY READ ONLY

其中 disconnect from session 表示后台执行，类似于 shell 的 &。可以看出现在备库处于 READ ONLY 状态，不再是处于 MOUNT 不可使用的状态，即现在可以执行只读操作了。

继续：

SQL> recover managed standby database using current logfile disconnect from session;
Media recovery complete.

SQL> select database_role, open_mode from v$database;
DATABASE_ROLE    OPEN_MODE
---------------- --------------------
PHYSICAL STANDBY READ ONLY WITH APPLY

此时数据库状态时 READ ONLY WITH APPLY，即只读且实时应用日志，通常所说的 ADG，Active Data Guard。

READ ONLY WITH APPLY 表示备库处于 READ ONLY 状态的同时可以接收主库传过来的日志文件并进行恢复，以便备库可以即时查看到主库的变化。


6. 切换 SNAPSHOT DATABASE

执行：

SQL> alter database recover managed standby database cancel;

SQL> alter database convert to snapshot standby;

SNAPSHOT 的原理是基于闪回数据原理，此时备库是可读写状态，可以用这种真实的生产环境进行一些无法在测试环境做的实验。使用完后，可以执行命令退回，SNAPSHOT 期间对备库做的所有变更都会还原：

SQL> alter database convert to physical standby;

SQL> alter database recover managed standby database disconnect;


7. 切换主库日志

通过主库手工切换日志，来看看备库是否实时接收应用了日志，可以看出此时备库的最新日志 SEQUENCE# 是 15 号：

SYS@BEIJING> alter system archive log current; 
System altered.

SYS@BEIJING> select sequence#, first_time, next_time from v$archived_log order by sequence#;  SEQUENCE# FIRST_TIME         NEXT_TIME  ---------- ------------------ ------------------ 13 29-JUL-16 29-JUL-16  13 29-JUL-16 29-JUL-16  14 29-JUL-16 29-JUL-16 14 29-JUL-16 29-JUL-16  15 29-JUL-16 29-JUL-16  15 29-JUL-16 29-JUL-16

此时查看备库，已经应用 15 号日志：

SQL> select sequence#, first_time, next_time from v$archived_log order by sequence#; SEQUENCE# FIRST_TIME         NEXT_TIME
---------- ------------------ ------------------ 12 29-JUL-16 29-JUL-16  13 29-JUL-16 29-JUL-16  14 29-JUL-16 29-JUL-16  15 29-JUL-16 29-JUL-16


8. 设置归档日志删除策略

可以设置主库的归档日志应用至备库后再删除的策略，一方面保证了归档日志传输接收，另一方面可以有效控制归档日志文件的产生量大小。默认是没有任何删除策略：

[oracle@bill02 BEIJING]$ rman target /

Recovery Manager: Release 11.2.0.4.0 - Production on Fri Jul 29 10:10:55 2016  Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
connected to target database: BEIJING (DBID=882855131)

RMAN> show all;

using target database control file instead of recovery catalog
RMAN configuration parameters for database with db_unique_name BEIJING are:
CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # default  CONFIGURE BACKUP OPTIMIZATION OFF; # default  CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default  CONFIGURE CONTROLFILE AUTOBACKUP OFF; # default  CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default  CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO BACKUPSET; # default  CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default  CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default  CONFIGURE MAXSETSIZE TO UNLIMITED; # default CONFIGURE ENCRYPTION FOR DATABASE OFF; # default  CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default  CONFIGURE COMPRESSION ALGORITHM 'BASIC' AS OF RELEASE 'DEFAULT' OPTIMIZE FOR LOAD TRUE ; # default  CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u01/app/oracle/product/11.2.0.4/dbs/snapcf_BEIJING.f'; # default

执行：

RMAN> CONFIGURE ARCHIVELOG DELETION POLICY TO APPLIED ON ALL STANDBY; new RMAN configuration parameters:
CONFIGURE ARCHIVELOG DELETION POLICY TO APPLIED ON ALL STANDBY; new RMAN configuration parameters are successfully stored

再次查看：

RMAN> show all;

RMAN configuration parameters for database with db_unique_name BEIJING are:
CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # default  CONFIGURE BACKUP OPTIMIZATION OFF; # default  CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default  CONFIGURE CONTROLFILE AUTOBACKUP OFF; # default  CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default  CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO BACKUPSET; # default  CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default  CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default  CONFIGURE MAXSETSIZE TO UNLIMITED; # default CONFIGURE ENCRYPTION FOR DATABASE OFF; # default  CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default  CONFIGURE COMPRESSION ALGORITHM 'BASIC' AS OF RELEASE 'DEFAULT' OPTIMIZE FOR LOAD TRUE ; # default  CONFIGURE ARCHIVELOG DELETION POLICY TO APPLIED ON ALL STANDBY;
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u01/app/oracle/product/11.2.0.4/dbs/snapcf_BEIJING.f'; # default

9. 总结 
Data Guard 的手工搭建方式，如果理清思路，还是比较清晰的，我最开始做的时候，由于监听、连接串一系列问题，总是 duplicate 出错，但手工方式好就好在可以让你有调试排查的机会，因为每一步手工操作都有他的意义，过程可逆，若是图形操作，则相对封闭些。
另外，这里只是 DG 搭建的最基础方式，其实对于一套 DG 生产环境，还有很多预防性设置，之前参考过某些牛人的梳理，确实很详细，有些内容自己还未掌握，还需要继续学习。

————————————– 分割线 ————————————–

Oracle Data Guard 重要配置参数 http://www.linuxidc.com/Linux/2013-08/88784.htm

基于同一主机配置 Oracle 11g Data Guard http://www.linuxidc.com/Linux/2013-08/88848.htm

探索 Oracle 之 11g DataGuard http://www.linuxidc.com/Linux/2013-08/88692.htm

Oracle Data Guard（RAC+DG) 归档删除策略及脚本 http://www.linuxidc.com/Linux/2013-07/87782.htm

Oracle Data Guard 的角色转换 http://www.linuxidc.com/Linux/2013-06/86190.htm

Oracle Data Guard 的日志 FAL gap 问题 http://www.linuxidc.com/Linux/2013-04/82561.htm

Oracle 11g Data Guard Error 16143 Heartbeat failed to connect to standby 处理方法 http://www.linuxidc.com/Linux/2013-03/82009.htm

————————————– 分割线 ————————————–

更多 Oracle 相关信息见 Oracle 专题页面 http://www.linuxidc.com/topicnews.aspx?tid=12

本文永久更新链接地址 ：http://www.linuxidc.com/Linux/2016-08/133836.htm

正文完
星哥玩云-微信公众号
post-qrcode
Data Guard MongoDB MySQL NoSQL Oracle Oracle教程 Oracle数据库 PostgreSQL 手工搭建Data Guard 数据库
发表至： 数据库技术
2022-01-22
 0
星锅
版权声明：本站原创文章，由 星锅 于2022-01-22发表，共计15842字。
转载说明：除特殊说明外本站文章皆由CC-4.0协议发布，转载请注明出处。
【腾讯云】推广者专属福利，新客户无门槛领取总价值高达2860元代金券，每种代金券限量500张，先到先得。
MySQL 存储过程中使用游标中使用临时表可以替代数组效果
数据库事务系列－MySQL跨行事务模型
Oracle直方图详解
Oracle临时表空间过大解决方法
MySQL客户端和服务器端工具集
Linux（Rhat&CentOS）下源码安装MySQL数据库
Solr5.3.0导入 Oracle 数据
Redis集群模式下的redis-py-cluster方式读写测试
阿里云-最新活动爆款每日限量供应
评论（没有评论）
验证码
星哥说事
星哥说事
分享互联网知识
阅读量
3593433
评论数
4
文章搜索
热门文章
选择PHP与Python，可以考虑这三个问题

选择PHP与Python，可以考虑这三个问题

导读 尽管 RESTful API 和跨平台库已经使网页开发容易起来，但依然没有解决阻碍并隔分开发者、管理者和...
Centos 7平滑无缝升级PHP7.1.0到PHP 7.1.5

Centos 7平滑无缝升级PHP7.1.0到PHP 7.1.5

实验环境：CentOS Linux release 7.3.1611 (Core) 内核版本：Linux ve...
介绍ansible的Ad-hoc与commands模块

介绍ansible的Ad-hoc与commands模块

Ad-Hoc 是指 ansible 下临时执行的一条命令，并且不需要保存的命令，对于复杂的命令后面会说 pla...
Linux安装使用pidstat命令以对进程数据进行监控

Linux安装使用pidstat命令以对进程数据进行监控

导读 Linux 系统监控的命令其实有很多，pidstat 命令就是其中的一种，使用 pidstat 命令可以...
linux下使用tree命令以树形结构显示文件目录结构

linux下使用tree命令以树形结构显示文件目录结构

导读 今天小编来给分享 Linux 系统下一个非常有用的命令的使用：tree 命令可以以树形结构显示文件目录结...
CDN
阿里云CDN-提高用户访问的响应速度和成功率
随机文章
Linux命令之进阶之路

Linux命令之进阶之路

导读 当我们熟悉一定的基础命令时，我们往往会接触到一些高级的命令操作，或者说是陌生的命令操作，今天我们就来和大...
CentOS7 configuration uses the SFTP server

CentOS7 configuration uses the SFTP server

导读 SFTP，即 SSH 文件传输协议（SSH File Transfer Protocol），或者说是安全...
如何解决MySQL内存不足启动失败的问题

如何解决MySQL内存不足启动失败的问题

1. 启动 MySQL 时一直不成功，查看错误日志 /var/log/mysql/error.log 2. 主...
MySQL Dump and Restore,Stored Procedures and Triggers

MySQL Dump and Restore,Stored Procedures and Triggers

导读 存储过程和触发器在 MySQL 5.0 中首先介绍了。所以，如果你还在使用 MySQL 旧版本的它升级到...
Nginx创建密码验证保护网站目录安全

Nginx创建密码验证保护网站目录安全

在生产环境中，网站需要授权访问的场景非常之多，比如数据库管理工具：phpMyAdmin、MysqlUp、Bac...
一言一句话
-「」
【腾讯云】云服务器、云数据库、COS、CDN、短信等云产品特惠热卖中