ITPub博客
首页 博客 专栏 学院 社区 IT新媒体评选
发博

首页 > 数据库 > Oracle > Oracle Data Guard 级联配置

Oracle Data Guard 级联配置

原创 Oracle 作者：卖灬柴的小男孩 时间：2016-08-11 21:09:49 0 删除 编辑
-- 源库配置
    源库 IP :192.168.0.10
    DB_NAME:ORA11GR2
    DB_UNIQUE_NAME :ORA11GR2
-- 备库配置
    备库 IP :192.168.0.11
    DB_NAME:ORA11GR2
    DB_UNIQUE_NAME :ORA11GR22
-- 级联备库
    备库 IP :192.168.0.12
    DB_NAME:ORA11GR2
    DB_UNIQUE_NAME :ORA11GR21

-- 源库

-- 源库参数文件

  1. [oracle@rac1 dbs]$ cat initORA11GR2.ora
  2. ORA11GR2.__db_cache_size=360710144
  3. ORA11GR2.__java_pool_size=4194304
  4. ORA11GR2.__large_pool_size=8388608
  5. ORA11GR2.__oracle_base='/u01/app/oracle'#ORACLE_BASE set from environment
  6. ORA11GR2.__pga_aggregate_target=289406976
  7. ORA11GR2.__sga_target=545259520
  8. ORA11GR2.__shared_io_pool_size=0
  9. ORA11GR2.__shared_pool_size=159383552
  10. ORA11GR2.__streams_pool_size=4194304
  11. *.audit_file_dest='/u01/app/oracle/admin/ORA11GR2/adump'
  12. *.audit_trail='db'
  13. *.compatible='11.2.0.4.0'
  14. *.control_files='/u01/app/oracle/oradata/ORA11GR2/control01.ctl','/u01/app/oracle/fast_recovery_area/ORA11GR2/control02.ctl'
  15. *.db_block_size=8192
  16. *.db_domain=''
  17. *.db_name='ORA11GR2'
  18. *.db_recovery_file_dest='/u01/app/oracle/fast_recovery_area'
  19. *.db_recovery_file_dest_size=4385144832
  20. *.db_unique_name='ORA11GR2'
  21. *.diagnostic_dest='/u01/app/oracle'
  22. *.dispatchers='(PROTOCOL=TCP) (SERVICE=ORA11GR2XDB)'
  23. *.log_archive_config='dg_config=(ORA11GR2,ORA11GR22)'
  24. *.log_archive_dest_1='location=/u01/app/oracle/arch/ORA11GR2/ valid_for=(all_logfiles,all_roles) db_unique_name=ORA11GR2'
  25. *.log_archive_dest_2='service=ORA11GR22 sync affirm net_timeout=10 valid_for=(online_logfile,primary_role) db_unique_name=ORA11GR22'
  26. *.log_archive_format='%t_%s_%r.dbf'
  27. *.memory_target=833617920
  28. *.open_cursors=300
  29. *.processes=150
  30. *.remote_login_passwordfile='EXCLUSIVE'
  31. *.undo_tablespace='UNDOTBS1'

-- 源库归档必须开启


点击(此处)折叠或打开

  1. SQL> archive log list
  2. Database log mode     Archive Mode
  3. Automatic archival     Enabled
  4. Archive destination     /u01/app/oracle/arch/ORA11GR2/
  5. Oldest online log sequence 20
  6. Next log sequence to archive 22
  7. Current log sequence     22
  8.  
  9. -- 如果源库归档未开,需启动数据库到 mount 状态开启归档
  10. shutdown immediate
  11. startup mount
  12. alter database archivelog;
  13. alter database open;

-- 数据库强制记录日志开启


点击(此处)折叠或打开

  1. SQL> select force_logging from v$database;

  3. FOR
  4. ---
  5. YES
  6.  
  7. -- 如果未开启执行下面命令开启
  8. ALTER DATABASE FORCE LOGGING;

-- 为源库添加备用日志文件,文件大小和 REDO 日志相同,数量比 REDO 日志文件多一个

点击(此处)折叠或打开

  1. ALTER DATABASE ADD STANDBY LOGFILE '/u01/app/oracle/oradata/ORA11GR2/sdb_01.log' size 50M;
  2. ALTER DATABASE ADD STANDBY LOGFILE '/u01/app/oracle/oradata/ORA11GR2/sdb_02.log' size 50M;
  3. ALTER DATABASE ADD STANDBY LOGFILE '/u01/app/oracle/oradata/ORA11GR2/sdb_03.log' size 50M;
  4. ALTER DATABASE ADD STANDBY LOGFILE '/u01/app/oracle/oradata/ORA11GR2/sdb_04.log' size 50M;

-- 备库

-- 备库参数文件配置

点击(此处)折叠或打开

  1. -- 源库操作
  2. SQL> create pfile from spfile;

  4. File created.
  5. -- 拷贝参数文件和密码文件到备库
  6. [oracle@rac1 dbs]$ scp initORA11GR2.ora 192.168.0.11:$ORACLE_HOME/dbs/initORA11GR22.ora
  7. [oracle@rac1 dbs]$ scp orapwORA11GR2 192.168.0.11:$ORACLE_HOME/dbs/orapwORA11GR22

-- 编辑备库参数文件

点击(此处)折叠或打开

  1. [oracle@lzb dbs]$ cat initORA11GR22.ora
  2. ORA11GR2.__db_cache_size=285212672
  3. ORA11GR22.__db_cache_size=352321536
  4. ORA11GR2.__java_pool_size=4194304
  5. ORA11GR22.__java_pool_size=4194304
  6. ORA11GR2.__large_pool_size=8388608
  7. ORA11GR22.__large_pool_size=8388608
  8. ORA11GR2.__oracle_base='/u01/app/oracle'#ORACLE_BASE set from environment
  9. ORA11GR22.__oracle_base='/u01/app/oracle'#ORACLE_BASE set from environment
  10. ORA11GR2.__pga_aggregate_target=335544320
  11. ORA11GR22.__pga_aggregate_target=335544320
  12. ORA11GR2.__sga_target=499122176
  13. ORA11GR22.__sga_target=499122176
  14. ORA11GR2.__shared_io_pool_size=0
  15. ORA11GR22.__shared_io_pool_size=0
  16. ORA11GR2.__shared_pool_size=188743680
  17. ORA11GR22.__shared_pool_size=125829120
  18. ORA11GR2.__streams_pool_size=4194304
  19. ORA11GR22.__streams_pool_size=0
  20. *.audit_file_dest='/u01/app/oracle/admin/ORA11GR2/adump'
  21. *.audit_trail='db'
  22. *.compatible='11.2.0.4.0'
  23. *.control_files='/u01/app/oracle/oradata/ORA11GR2/control01.ctl','/u01/app/oracle/fast_recovery_area/ORA11GR2/control02.ctl'
  24. *.db_block_size=8192
  25. *.db_domain=''
  26. *.db_file_name_convert='ORA11GR2','ORA11GR2'
  27. *.db_name='ORA11GR2'
  28. *.db_recovery_file_dest='/u01/app/oracle/fast_recovery_area'
  29. *.db_recovery_file_dest_size=4385144832
  30. *.db_unique_name='ORA11GR22'
  31. *.diagnostic_dest='/u01/app/oracle'
  32. *.dispatchers='(PROTOCOL=TCP) (SERVICE=ORA11GR2XDB)'
  33. *.fal_server='ORA11GR2'
  34. *.log_archive_config='dg_config=(ORA11GR2,ORA11GR22,ORA11GR21)'
  35. *.log_archive_dest_1='location=/u01/app/oracle/arch/ORA11GR2/ valid_for=(all_logfiles,all_roles) db_unique_name=ORA11GR22'
  36. *.log_archive_dest_2='service=ORA11GR2 sync affirm net_timeout=10 valid_for=(online_logfile,primary_role) db_unique_name=ORA11GR2'
  37. *.log_archive_dest_3='service=ORA11GR21 sync affirm net_timeout=10 valid_for=(standby_logfile,standby_role) db_unique_name=ORA11GR21'
  38. *.log_archive_format='%t_%s_%r.dbf'
  39. *.log_file_name_convert='ORA11GR2','ORA11GR2'
  40. *.memory_target=833617920
  41. *.open_cursors=300
  42. *.processes=150
  43. *.remote_login_passwordfile='EXCLUSIVE'
  44. *.standby_file_management='auto'
  45. *.undo_tablespace='UNDOTBS1'

-- 备库创建目录

点击(此处)折叠或打开

  1. mkdir -p $ORACLE_BASE/fast_recovery_area/ORA11GR2
  2. mkdir -p $ORACLE_BASE/admin/ORA11GR2/adump
  3. mkdir -p $ORACLE_BASE/admin/ORA11GR2/dpdump
  4. mkdir -p $ORACLE_BASE/admin/ORA11GR2/pfile
  5. mkdir -p $ORACLE_BASE/oradata/ORA11GR2
  6. mkdir -p $ORACLE_BASE/arch/ORA11GR2

-- 备库配置静态监听

点击(此处)折叠或打开

  1. [oracle@lzb ~]$ cat /u01/app/oracle/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora
  2. # listener.ora Network Configuration File: /u01/app/oracle/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora
  3. # Generated by Oracle configuration tools.

  5. LISTENER =
  6.   (DESCRIPTION_LIST =
  7.     (DESCRIPTION =
  8.       (ADDRESS = (PROTOCOL = TCP)(HOST = lzb)(PORT = 1521))
  9.       (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
  10.     )
  11.   )

  13. ADR_BASE_LISTENER = /u01/app/oracle

  15. SID_LIST_listener=
  16.   (SID_LIST=
  17.      (SID_DESC=
  18.         (GLOBAL_DBNAME= ORA11GR22)
  19.         (SID_NAME= ORA11GR22)
  20.         (ORACLE_HOME=/u01/app/oracle/oracle/product/11.2.0/dbhome_1)
  21.      )
  22.   )

-- 备库配置连接字符串

点击(此处)折叠或打开

  1. [oracle@lzb ~]$ cat /u01/app/oracle/oracle/product/11.2.0/dbhome_1/network/admin/tnsnames.ora
  2. # tnsnames.ora Network Configuration File: /u01/app/oracle/oracle/product/11.2.0/dbhome_1/network/admin/tnsnames.ora
  3. # Generated by Oracle configuration tools.

  5. ORA11GR22 =
  6.   (DESCRIPTION =
  7.     (ADDRESS_LIST =
  8.       (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.11)(PORT = 1521))
  9.     )
  10.     (CONNECT_DATA =
  11.       (SERVICE_NAME = ORA11GR22)
  12.     )
  13.   )

  15. ORA11GR2 =
  16.   (DESCRIPTION =
  17.     (ADDRESS_LIST =
  18.       (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.10)(PORT = 1521))
  19.     )
  20.     (CONNECT_DATA =
  21.       (SERVICE_NAME = ORA11GR2)
  22.     )
  23.   )

  25. ORA11GR21 =
  26.   (DESCRIPTION =
  27.     (ADDRESS_LIST =
  28.       (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.12)(PORT = 1521))
  29.     )
  30.     (CONNECT_DATA =
  31.       (SERVICE_NAME = ORA11GR21)
  32.     )
  33.   )

-- 备库: sqlplus 进入备库, 通过命令创建 spfile 文件, 启动到 nomount 状态

点击(此处)折叠或打开

  1. [oracle@lzb dbs]$ sqlplus / as sysdba

  3. SQL*Plus: Release 11.2.0.4.0 Production on Thu Aug 11 14:10:21 2016

  5. Copyright (c) 1982, 2013, Oracle. All rights reserved.

  7. Connected to an idle instance.

  9. SQL> create spfile from pfile;

  11. File created.

  13. SQL> startup nomount
  14. ORACLE instance started.

  16. Total System Global Area 830930944 bytes
  17. Fixed Size         2257800 bytes
  18. Variable Size         536874104 bytes
  19. Database Buffers     289406976 bytes
  20. Redo Buffers         2392064 bytes

-- 源库进入 rman 把源库的数据备份到备库

点击(此处)折叠或打开

  1. [oracle@rac1 dbs]$ rman target sys/oracle@ora11gr2 auxiliary sys/oracle@ora11gr22

  3. Recovery Manager: Release 11.2.0.4.0 - Production on Thu Aug 11 15:27:27 2016

  5. Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.

  7. connected to target database: ORA11GR2 (DBID=236114441)
  8. connected to auxiliary database: ORA11GR2 (not mounted)

  10. RMAN> duplicate target database for standby from active database dorecover nofilenamecheck;

  12. Starting Duplicate Db at 11-AUG-16
  13. using target database control file instead of recovery catalog
  14. allocated channel: ORA_AUX_DISK_1
  15. channel ORA_AUX_DISK_1: SID=20 device type=DISK

  17. contents of Memory Script:
  18. {
  19.    backup as copy reuse
  20.    targetfile '/u01/app/oracle/oracle/product/11.2.0/dbhome_1/dbs/orapwORA11GR2' auxiliary format
  21.  '/u01/app/oracle/oracle/product/11.2.0/dbhome_1/dbs/orapwORA11GR22' ;
  22. }
  23. executing Memory Script



  27. -------- 中间省略


  30. contents of Memory Script:
  31. {
  32.    set until scn 1066277;
  33.    recover
  34.    standby
  35.    clone database
  36.     delete archivelog
  37.    ;
  38. }
  39. executing Memory Script

  41. executing command: SET until clause

  43. Starting recover at 11-AUG-16
  44. using channel ORA_AUX_DISK_1

  46. starting media recovery

  48. archived log for thread 1 with sequence 13 is already on disk as file /u01/app/oracle/arch/ORA11GR2/1_13_919542923.dbf
  49. archived log for thread 1 with sequence 14 is already on disk as file /u01/app/oracle/arch/ORA11GR2/1_14_919542923.dbf
  50. archived log file name=/u01/app/oracle/arch/ORA11GR2/1_13_919542923.dbf thread=1 sequence=13
  51. archived log file name=/u01/app/oracle/arch/ORA11GR2/1_14_919542923.dbf thread=1 sequence=14
  52. media recovery complete, elapsed time: 00:00:01
  53. Finished recover at 11-AUG-16
  54. Finished Duplicate Db at 11-AUG-16

  56. RMAN> exit

-- 备库启动到 read only 状态,应用日志

点击(此处)折叠或打开

  1. SQL> alter database open;

  3. Database altered.

  5. SQL> alter database recover managed standby database using current logfile disconnect from session;

  7. Database altered.

  9. SQL> select database_role, open_mode from v$database;

  11. DATABASE_ROLE     OPEN_MODE
  12. ---------------- --------------------
  13. PHYSICAL STANDBY READ ONLY WITH APPLY

  15. SQL> select sequence#, applied from v$archived_log;

  17.  SEQUENCE# APPLIED
  18. ---------- ---------
  19.     13 YES
  20.     14 YES
  21.     15 YES
  22.     16 YES
  23.     17 YES
  24.     18 YES

  26. SQL> select protection_mode, protection_level from v$database;

  28. PROTECTION_MODE PROTECTION_LEVEL
  29. -------------------- --------------------
  30. MAXIMUM PERFORMANCE MAXIMUM PERFORMANCE

-- 源库

-- 源库的保护模式和等级配置到最高可用性

点击(此处)折叠或打开

  1. SQL> select protection_mode, protection_level from v$database;

  3. PROTECTION_MODE PROTECTION_LEVEL
  4. -------------------- --------------------
  5. MAXIMUM PERFORMANCE MAXIMUM PERFORMANCE

  7. SQL> alter database set standby database to maximize availability;

  9. Database altered.
  10.  
  11. SQL> select protection_mode, protection_level from v$database;

  13. PROTECTION_MODE      PROTECTION_LEVEL
  14. -------------------- --------------------
  15. MAXIMUM AVAILABILITY MAXIMUM AVAILABILITY

-- 备库

-- 备库把参数文件和密码文件拷贝到级联备库

点击(此处)折叠或打开

  1. [oracle@lzb oracle]$ scp initORA11GR21.ora 192.168.0.12:/u01/app/oracle/oracle/product/11.2.0/dbhome_1/dbs/.
  2. oracle@192.168.0.12's password:
  3. initORA11GR21.ora 100% 1992 2.0KB/s 00:00

  5. [oracle@lzb dbs]$ scp orapwORA11GR22 192.168.0.12:/u01/app/oracle/oracle/product/11.2.0/dbhome_1/dbs/orapwORA11GR21
  6. oracle@192.168.0.12's password:
  7. orapwORA11GR22 100% 1536 1.5KB/s 00:00

-- 级联备库

-- 配置参数文件

点击(此处)折叠或打开

  1. [oracle@james dbs]$ vim initORA11GR21.ora
  2. ORA11GR2.__db_cache_size=285212672
  3. ORA11GR22.__db_cache_size=352321536
  4. ORA11GR2.__java_pool_size=4194304
  5. ORA11GR22.__java_pool_size=4194304
  6. ORA11GR2.__large_pool_size=8388608
  7. ORA11GR22.__large_pool_size=8388608
  8. ORA11GR2.__oracle_base='/u01/app/oracle'#ORACLE_BASE set from environment
  9. ORA11GR22.__oracle_base='/u01/app/oracle'#ORACLE_BASE set from environment
  10. ORA11GR2.__pga_aggregate_target=335544320
  11. ORA11GR22.__pga_aggregate_target=335544320
  12. ORA11GR2.__sga_target=499122176
  13. ORA11GR22.__sga_target=499122176
  14. ORA11GR2.__shared_io_pool_size=0
  15. ORA11GR22.__shared_io_pool_size=0
  16. ORA11GR2.__shared_pool_size=188743680
  17. ORA11GR22.__shared_pool_size=125829120
  18. ORA11GR2.__streams_pool_size=4194304
  19. ORA11GR22.__streams_pool_size=0
  20. *.audit_file_dest='/u01/app/oracle/admin/ORA11GR2/adump'
  21. *.audit_trail='db'
  22. *.compatible='11.2.0.4.0'
  23. *.control_files='/u01/app/oracle/oradata/ORA11GR2/control01.ctl','/u01/app/oracle/fast_recovery_area/ORA11GR2/
  24. control02.ctl'
  25. *.db_block_size=8192
  26. *.db_domain=''
  27. *.db_file_name_convert='ORA11GR2','ORA11GR2'
  28. *.db_name='ORA11GR2'
  29. *.db_recovery_file_dest='/u01/app/oracle/fast_recovery_area'
  30. *.db_recovery_file_dest_size=4385144832
  31. *.db_unique_name='ORA11GR21'
  32. *.diagnostic_dest='/u01/app/oracle'
  33. *.dispatchers='(PROTOCOL=TCP) (SERVICE=ORA11GR2XDB)'
  34. *.fal_server='ORA11GR22'
  35. *.log_archive_config='dg_config=(ORA11GR2,ORA11GR22,ORA11GR21)'
  36. *.log_archive_dest_1='location=/u01/app/oracle/arch/ORA11GR2/ valid_for=(all_logfiles,all_roles) db_unique_nam
  37. e=ORA11GR21'
  38. *.log_archive_dest_2='service=ORA11GR22 sync affirm net_timeout=10 valid_for=(online_logfile,primary_role) db_
  39. unique_name=ORA11GR22'
  40. *.log_archive_format='%t_%s_%r.dbf'
  41. *.log_file_name_convert='ORA11GR2','ORA11GR2'
  42. *.memory_target=833617920
  43. *.open_cursors=300
  44. *.processes=150
  45. *.remote_login_passwordfile='EXCLUSIVE'
  46. *.standby_file_management='auto'
  47. *.undo_tablespace='UNDOTBS1'

-- 配置静态监听

点击(此处)折叠或打开

  1. [oracle@james admin]$ cat listener.ora
  2. # listener.ora Network Configuration File: /u01/app/oracle/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora
  3. # Generated by Oracle configuration tools.

  5. LISTENER =
  6.   (DESCRIPTION_LIST =
  7.     (DESCRIPTION =
  8.       (ADDRESS = (PROTOCOL = TCP)(HOST = james)(PORT = 1521))
  9.       (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
  10.     )
  11.   )

  13. ADR_BASE_LISTENER = /u01/app/oracle

  15. SID_LIST_listener=
  16.   (SID_LIST=
  17.      (SID_DESC=
  18.         (GLOBAL_DBNAME= ORA11GR21)
  19.         (SID_NAME= ORA11GR21)
  20.         (ORACLE_HOME=/u01/app/oracle/oracle/product/11.2.0/dbhome_1)
  21.      )
  22.   )


点击(此处)折叠或打开

  1. [oracle@james admin]$ cat listener.ora
  2. # listener.ora Network Configuration File: /u01/app/oracle/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora
  3. # Generated by Oracle configuration tools.

  5. LISTENER =
  6.   (DESCRIPTION_LIST =
  7.     (DESCRIPTION =
  8.       (ADDRESS = (PROTOCOL = TCP)(HOST = james)(PORT = 1521))
  9.       (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
  10.     )
  11.   )

  13. ADR_BASE_LISTENER = /u01/app/oracle

  15. SID_LIST_listener=
  16.   (SID_LIST=
  17.      (SID_DESC=
  18.         (GLOBAL_DBNAME= ORA11GR21)
  19.         (SID_NAME= ORA11GR21)
  20.         (ORACLE_HOME=/u01/app/oracle/oracle/product/11.2.0/dbhome_1)
  21.      )
  22.   )

-- 配置连接字符串


点击(此处)折叠或打开

  1. [oracle@james admin]$ vim tnsnames.ora
  2. # tnsnames.ora Network Configuration File: /u01/app/oracle/oracle/product/11.2.0/dbhome_1/network/admin/tnsnam
  3. es.ora
  4. # Generated by Oracle configuration tools.

  6. ORA11GR21 =
  7.   (DESCRIPTION =
  8.     (ADDRESS_LIST =
  9.       (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.12)(PORT = 1521))
  10.     )
  11.     (CONNECT_DATA =
  12.       (SERVICE_NAME = ORA11GR21)
  13.     )
  14.   )

  16. ORA11GR22 =
  17.   (DESCRIPTION =
  18.     (ADDRESS_LIST =
  19.       (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.11)(PORT = 1521))
  20.     )
  21.     (CONNECT_DATA =
  22.       (SERVICE_NAME = ORA11GR22)
  23.     )
  24.   )


  27. ORA11GR2 =
  28.   (DESCRIPTION =
  29.     (ADDRESS_LIST =
  30.       (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.10)(PORT = 1521))
  31.     )
  32.     (CONNECT_DATA =
  33.       (SERVICE_NAME = ORA11GR2)
  34.     )
  35.   )

-- sqlplus 进入系统, 创建 spfile 文件,启动数据库到 nomount 状态

点击(此处)折叠或打开

  1. [oracle@james dbs]$ sqlplus / as sysdba

  3. SQL*Plus: Release 11.2.0.4.0 Production on Thu Aug 11 16:20:39 2016

  5. Copyright (c) 1982, 2013, Oracle. All rights reserved.

  7. Connected to an idle instance.

  9. SQL> create spfile from pfile;

  11. File created.

  13. SQL> startup nomount
  14. ORACLE instance started.

  16. Total System Global Area 830930944 bytes
  17. Fixed Size         2257800 bytes
  18. Variable Size         536874104 bytes
  19. Database Buffers     289406976 bytes
  20. Redo Buffers         2392064 bytes

-- 备库

-- 使用 rman 工具复制数据库到级联备库

点击(此处)折叠或打开

  1. [oracle@lzb dbs]$ rman target sys/oracle@ora11gr22 auxiliary sys/oracle@ora11gr21

  3. Recovery Manager: Release 11.2.0.4.0 - Production on Thu Aug 11 16:23:37 2016

  5. Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.

  7. connected to target database: ORA11GR2 (DBID=236114441)
  8. connected to auxiliary database: ORA11GR2 (not mounted)

  10. RMAN> duplicate target database for standby from active database dorecover nofilenamecheck;

-- 级联备库

-- 应用日志

点击(此处)折叠或打开

  1. SQL> select instance_name, status from v$instance;

  3. INSTANCE_NAME     STATUS
  4. ---------------- ------------
  5. ORA11GR21     MOUNTED

  7. SQL> select database_role, open_mode from v$database;

  9. DATABASE_ROLE     OPEN_MODE
  10. ---------------- --------------------
  11. PHYSICAL STANDBY MOUNTED

  13. SQL> alter database recover managed standby database using current logfile disconnect;

  15. Database altered.

-- 查看日志应用情况

点击(此处)折叠或打开

  1. SQL> select sequence#, applied from v$archived_log;

  3.  SEQUENCE# APPLIED
  4. ---------- ---------
  5.     20 IN-MEMORY

  7. SQL> select sequence#, applied from v$archived_log;

  9.  SEQUENCE# APPLIED
  10. ---------- ---------
  11.     20 YES

-- 打完收工

-- 看了别人的博客,看到了service_name 的问题,可以使用以下命令修改 service_name 参数的名称,并且需要修改静态监听,连接字符串
alter system set service_names = 'ORA11GR2';
重启数据库生效

来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/31369239/viewspace-2123354/ ，如需转载，请注明出处，否则将追究法律责任。

0
0
上一篇： 闪回数据库测试
下一篇： service_names 参数更改方法
请登录后发表评论 登录
全部评论
卖灬柴的小男孩

注册时间：2016-07-02

  • 博文量
    12
  • 访问量
    11693

最新文章

支持我们 作者招募 用户协议 FAQ Contact Us

北京盛拓优讯信息技术有限公司. 版权所有  京ICP备16024965号-8 北京市公安局海淀分局网监中心备案编号：11010802021510 niuxiaotong@pcpop.com 17352615567 未成年人举报专区

广播电视节目制作经营许可证(京) 字第1234号 中国互联网协会会员

违法和不良信息举报电话:18101376593