19c手动版ADG搭建步骤使用静态监听

--------------------------------------------------------------------手动版ADG搭建步骤使用静态监听------------------------
1、备库操作修改listener文件
listener.ora

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = cbasdg)
(oracle_HOME = /u01/app/oracle/product/19c/dbhome_1)
(GLOBAL_DBNAME = cbasdg)
)
)


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

ADR_BASE_LISTENER = /u01/app/oracle

2、启动备库监听
lsnrctl start

3、修改备库tns
vi tnsnames.ora
cbasdg =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.0.2.3)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = cbasdg)
)
)

cbas =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.0.2.2)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = cbas)
)
)





4、主库修改listener文件
vi listener.ora

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = cbas)
(oracle_HOME = /u01/app/oracle/product/19c/dbhome_1)
(GLOBAL_DBNAME = cbas)
)
)

5、主库修改tns文件
vi tnsnames.ora
cbasdg =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.0.2.3)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = cbasdg)
)
)

cbas =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.0.2.2)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = cbas)
)
)

6、scp 密码文件，主库操作
scp orapwcbas 192.0.2.3:/u01/app/oracle/product/19c/dbhome_1/dbs/orapwcbasdg

7、主库开启归档模式

shutdown immediate;
alter database archivelog;

alter database force logging;
alter database archivelog;
alter database open;
alter database archivelog;
alter system set log_archive_dest_1='location=/oraarch';

8、备份主库参数文件

create pfile='/home/oracle/pfilecbas.ora' from spfile;

9、主库修改参数文件脚本
alter system set LOG_ARCHIVE_CONFIG = 'DG_CONFIG=(cbas,cbasdg)' scope=spfile sid='*';
alter system set LOG_ARCHIVE_DEST_1 = 'LOCATION=/oraarch VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=cbas' scope=spfile sid='*';
alter system set LOG_ARCHIVE_DEST_2 = 'SERVICE=cbasdg lgwr async noaffirm VALID_FOR=(online_logfiles,primary_role) DB_UNIQUE_NAME=cbasdg' scope=spfile sid='*';
alter system set FAL_SERVER = 'cbasdg' scope=spfile sid='*';
alter system set FAL_CLIENT = 'cbas' scope=spfile sid='*';
alter system set STANDBY_FILE_MANAGEMENT='AUTO' scope=spfile sid='*';
alter system set DB_FILE_NAME_CONVERT='/oradata/CBASDG/','/oradata/CBAS/' scope=spfile sid='*';
alter system set LOG_FILE_NAME_CONVERT='/oradata/CBASDG/','/oradata/CBAS/' scope=spfile sid='*';


10、主库被创建standby_redo : redo数据量+1
set lines 200 pages 200
col member for a70
select bytes/1024/1024 MB from v$log;
备库添加standby redo logfile
alter system set standby_file_management= manual;
alter database add standby logfile thread 1 group 21 ('/oradata/CBAS/std01.log') size 200M;
alter database add standby logfile thread 1 group 22 ('/oradata/CBAS/std02.log') size 200M;
alter database add standby logfile thread 1 group 23 ('/oradata/CBAS/std03.log') size 200M;
alter database add standby logfile thread 1 group 24 ('/oradata/CBAS/std04.log') size 200M;
alter system set standby_file_management= auto;

-------
11、备库创建必要文件
standby:$mkdir -p /u01/app/oracle/admin/cbas/adump /oradata/CBASDG/

12、主库同步参数文件到备库
scp pfilecbas.ora 192.0.2.3:/home/oracle/

vi pfilecbas.ora
*.control_files='/oradata/cbas/control01.ctl','/oradata/cbas/control02.ctl'
修改 为*.control_files='/oradata/CBASDG/control01.ctl','/oradata/CBASDG/control02.ctl'

mkdir /u01/app/oracle/admin/cbas/adump
mkdir /oradata/CBAS
13、启动备库nomount
startup nomount pfile='/home/oracle/pfilecbas.ora';

create spfile from pfile='/home/oracle/pfilecbas.ora';
shutdown abort
startup nomount;


14、修改备库参数文件

修改备库参数
alter system set LOG_ARCHIVE_CONFIG = 'DG_CONFIG=(cbas,cbasdg)' scope=spfile sid='*';
alter system set LOG_ARCHIVE_DEST_1 = 'LOCATION=/oraarch VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=cbasdg' scope=spfile sid='*';
alter system set LOG_ARCHIVE_DEST_2 = 'SERVICE=cbas lgwr async noaffirm VALID_FOR=(online_logfiles,primary_role) DB_UNIQUE_NAME=cbas' scope=spfile sid='*';
alter system set FAL_SERVER = 'cbas' scope=spfile sid='*';
alter system set FAL_CLIENT = 'cbasdg' scope=spfile sid='*';
alter system set STANDBY_FILE_MANAGEMENT='AUTO' scope=spfile sid='*';
alter system set DB_FILE_NAME_CONVERT='/oradata/CBAS/','/oradata/CBASDG/' scope=spfile sid='*';
alter system set LOG_FILE_NAME_CONVERT='/oradata/CBAS/','/oradata/CBASDG/' scope=spfile sid='*';
alter system set db_unique_name='cbasdg' scope=spfile;

shutdown abort;
startup nomount;
15、恢复数据库
参数文件编辑好了
rman target /
restore standby controlfile from service cbas;
alter database mount;
restore database from service cbas;

alter database open;
alter database recover managed standby database using current logfile disconnect from session;



16、主库查看通道是否正常

col DESTINATION for a50
SELECT DEST_ID,DESTINATION, STATUS, ERROR FROM V$ARCHIVE_DEST WHERE DEST_ID=2;

17.主库切换归档
aler system archive log current;


18.主备切换（主库操作）
ALTER DATABASE SWITCHOVER TO cbasdg;

19.回切（主库操作）
ALTER DATABASE SWITCHOVER TO cbas；