Docker部署oracle19c+datagaurd（二）

前期环境及oracle部署：

Docker部署oracle19c+datagaurd（一）

5.确定datagaurd要配置的参数，并修改主备库参数

主库-19c1:

db_unique_name	ora19
global_name	ora19
service_name	ora19
ip地址	172.17.0.2   ##ifconfig查看
归档路径	/opt/oracle/oradata/ORA19/arch
文件路径	/opt/oracle/oradata/ORA19/dg

备库-19c2:

db_unique_name	ora19_dg
global_name	ora19
service_name	ora19_dg
ip地址	172.17.0.4   ##ifconfig查看
归档路径	/opt/oracle/oradata/ORA19/arch
文件路径	/opt/oracle/oradata/ORA19/dg

5.1配置主库

关闭主库，重启到mount，开启归档

SQL> conn sys/123456 as sysdba
Connected.
SQL> shutdown immediate;       
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup nomount
ORACLE instance started.

Total System Global Area 1610609888 bytes
Fixed Size                  9135328 bytes
Variable Size             385875968 bytes
Database Buffers         1207959552 bytes
Redo Buffers                7639040 bytes

SQL> alter database mount;

Database altered.

SQL> alter database archivelog;    ##更改为归档

Database altered.

SQL> alter database force logging;  ##设置强制归档

Database altered.

SQL> select name,force_logging from v$database;

NAME      FORCE_LOGGING
--------- ---------------------------------------
ORA19     YES

SQL> create pfile from spfile;    ##创建pfile，不指定文件会在$ORACLE_HOME/dbs下创建

File created.

[oracle@7f9534867bdf ~]$ cp $ORACLE_HOME/dbs/initORA19.ora $ORACLE_HOME/dbs/initORA19.ora.bk    ##修改前备份一下pfile

检查密码文件

SQL> show parameter password

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
remote_login_passwordfile            string      EXCLUSIVE

[oracle@7f9534867bdf ~]$ ll $ORACLE_HOME/dbs/orapwORA19 
lrwxrwxrwx 1 oracle oinstall 45 Mar 29 05:57 /opt/oracle/product/19c/dbhome_1/dbs/orapwORA19 -> /opt/oracle/oradata/dbconfig/ORA19/orapwORA19        
[oracle@7f9534867bdf ~]$ ll /opt/oracle/oradata/dbconfig/ORA19/orapwORA19
-rw-r----- 1 oracle oinstall 2048 Mar 29 05:38 /opt/oracle/oradata/dbconfig/ORA19/orapwORA19

创建文件夹

[oracle@7f9534867bdf ~]$ mkdir /opt/oracle/oradata/ORA19/arch        
[oracle@7f9534867bdf ~]$ mkdir /opt/oracle/oradata/ORA19/dg

修改pfile

vi $ORACLE_HOME/dbs/initORA19.ora


##添加下面内容

*.standby_file_management='AUTO'    ##自动同步
*.log_archive_dest_1='LOCATION=/opt/oracle/oradata/ORA19/arch valid_for=(all_logfiles,all_roles) db_unique_name=ORA19'    ##归档路径
*.log_archive_dest_state_1='enable'
*.log_archive_dest_2='SERVICE=ORA19_DG lgwr sync valid_for=(online_logfiles,primary_role) db_unique_name=ORA19_DG'        ##配置重做日志到备库
*.log_archive_dest_state_2='enable'
*.log_file_name_convert='/opt/oracle/oradata/ORA19/arch','/opt/oracle/oradata/ORA19/arch'
*.db_file_name_convert='/opt/oracle/oradata/ORA19/dg','/opt/oracle/oradata/ORA19/dg'
*.fal_server='ORA19_DG'    
*.fal_client='ORA19'
*.log_archive_config='dg_config=(ORA19,ORA19_DG)'

修改监听和tns，重启监听