Oracle 12c DG配置（两节点）

一、系统版本

1.操作系统

[oracle@DB1 ~]$ cat /etc/redhat-release 
CentOS Linux release 7.7.1908 (Core)

2.数据库

3.节点情况

DB1:

DB2:

序号	主库（10.1.1.100）	备库（10.1.1.130）
1	sid：orcl	sid：orcl
2	db_unique_name='orcl_pd'	db_unique_name='orcl_st'

 

注：12c的物理DG是基于cdb级别的；

二、安装数据库（安装主库软件和建库，备库只需安装数据库软件）

见安装数据库章节；（此处略）

三、配置主库

1.归档

关机 shutdown immediate;

启动数据库到mount状态 startup mount;

启动归档：alter database archivelog;

启动数据库：alter database open;

设置归档目录：

SQL>alter system set log_archive_dest_1='location=/archivelog1/' scope=spfile ;
SQL>alter system set log_archive_format='arch_%t_%s_%r.arc' scope=spfile;

2.强制日志

SQL> alter database force logging;

3.创建standby redo log日志组

SQL> alter  database add  standby  logfile '/oradata/orcl/stdredo01.log'  size 200M;
SQL> alter  database add  standby  logfile '/oradata/orcl/stdredo01.log'  size 200M;
SQL> alter  database add  standby  logfile '/oradata/orcl/stdredo01.log'  size 200M;
SQL> alter  database add  standby  logfile '/oradata/orcl/stdredo01.log'  size 200M;

4.修改参数文件

创建参数文件：create pfile='/home/oracle/pfile.ora' from spfile;

[oracle@DB1 ~]$ vi pfile.ora
[oracle@DB1 ~]$ cat pfile.ora
orcl.__data_transfer_cache_size=0
orcl.__db_cache_size=587202560
orcl.__inmemory_ext_roarea=0
orcl.__inmemory_ext_rwarea=0
orcl.__java_pool_size=16777216
orcl.__large_pool_size=33554432
orcl.__oracle_base='/u01/app/oracle'#ORACLE_BASE set from environment
orcl.__pga_aggregate_target=553648128
orcl.__sga_target=1040187392
orcl.__shared_io_pool_size=50331648
orcl.__shared_pool_size=335544320
orcl.__streams_pool_size=0
*._catalog_foreign_restore=FALSE
*._restore_create_directory=FALSE
*.audit_file_dest='/u01/app/oracle/admin/orcl/adump'
*.audit_trail='db'
*.compatible='12.2.0'
*.control_file_record_keep_time=30
*.control_files='/oradata/orcl/control01.ctl','/oradata/orcl/control02.ctl'
*.db_block_size=8192
*.db_file_name_convert='/oradata/orcl','/oradata/orcl'
*.db_name='orcl'
*.db_recovery_file_dest='/archivelog'
*.db_recovery_file_dest_size=10737418240
*.db_unique_name='orcl_pd'
*.diagnostic_dest='/u01/app/oracle'
*.dispatchers='(PROTOCOL=TCP) (SERVICE=orclXDB)'
*.enable_ddl_logging=TRUE
*.enable_pluggable_database=true
*.fal_server='orcl_st'
*.local_listener='LISTENER_ORCL'
*.log_archive_config='dg_config=(orcl_pd,orcl_st,orcl_bt)'
*.log_archive_dest_1='location=/archivelog1/'
*.log_archive_dest_2='service=orcl_st lgwr async valid_for=(online_logfiles,primary_role) db_unique_name=orcl_st'
*.log_archive_dest_state_1='enable'
*.log_archive_dest_state_2='enable'
*.log_archive_format='arch_%t_%s_%r.arc'
*.log_file_name_convert='/oradata/orcl','/oradata/orcl' 
*.db_file_name_convert='/oradata/orcl','/oradata/orcl'

*.remote_login_passwordfile='EXCLUSIVE'
*.standby_file_management='auto'
*.memory_target=1507m
*.nls_language='AMERICAN'
*.nls_territory='AMERICA'
*.open_cursors=300
*.optimizer_capture_sql_plan_baselines=TRUE
*.processes=500
*.undo_tablespace='UNDOTBS1'

5.修改listener.ora和tnsname.ora文件并测试

[oracle@DB1 admin]$ cat listener.ora 
# listener.ora Network Configuration File: /u01/app/oracle/product/12.2.0.1/dbhome_1/network/admin/listener.ora
# Generated by Oracle configuration tools.
ADR_BASE_LISTENER = /u01/app/oracle

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 10.1.1.100)(PORT = 1521))
    )
  )

SID_LIST_LISTENER =  
  (SID_LIST =  
    (SID_DESC =  
      (GLOBAL_DBNAME = orcl)  
      (ORACLE_HOME = /u01/app/oracle/product/12.2.0.1/dbhome_1)  
      (SID_NAME = orcl)  
    ) 
       (SID_DESC =
       (GLOBAL_DBNAME = pdb01)  #pdb01
       (SID_NAME = orcl)
    )
        (SID_DESC =
       (GLOBAL_DBNAME = pdb02)  #pdb02
       (SID_NAME = orcl)
    )
        (SID_DESC =
       (GLOBAL_DBNAME = pdb03)  #pdb03
       (SID_NAME = orcl)
    ) 
  )

[oracle@DB1 admin]$ cat tnsnames.ora 
ORCL =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 10.1.1.100)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = orcl)
    )
  )

pdb01 =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 10.1.1.100)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = pdb01)  #pdbs
    )
  )

pdb02 =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 10.1.1.100)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = pdb02)  #pdbs
    )
  )

pdb03 =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 10.1.1.100)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = pdb03)  #pdbs
    )
  )

ORCL_ST =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 10.1.1.130)(PORT = 1521))
    )
    (CONNECT_DATA =
       (SERVER = DEDICATED)
       (SERVICE_NAME = orcl)
    )
  )

ORCL_PD =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 10.1.1.100)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVER = DEDICATED)