单实例ADG搭建

单实例ADG搭建

作为本际云服务器推荐网的小编小本本，今天给大家介绍一下单实例ADG的搭建过程。

步骤

以下是ADG搭建的具体步骤：

1. 开启强制日志SQL：ALTER DATABASE FORCE LOGGING;
2. 添加standby日志SQL（比redolog多一组）：ALTER DATABASE ADD STANDBY LOGFILE (/oracle/dbs/slog1.rdo) SIZE 500M; ALTER DATABASE ADD STANDBY LOGFILE (/oracle/dbs/slog2.rdo) SIZE 500M; ALTER DATABASE ADD STANDBY LOGFILE (/oracle/dbs/slog3.rdo) SIZE 500M; ALTER DATABASE ADD STANDBY LOGFILE (/oracle/dbs/slog4.rdo) SIZE 500M;
3. 主库使用spfile创建pfile，包括需要改动的参数，如audit_file_dest、db_recovery_file_dest等，注意指定undo_tablespace：

Create pfile=’/home/oracle/pfile.ora’ from spfile;
.audit_file_dest=/u01/app/oracle/admin/PROD5/adump
.audit_trail=db
.compatible=12.1.0.2.0
.control_files=/u01/app/oracle/oradata/PROD5/control01.ctl,/u01/app/oracle/fast_recovery_area/PROD5/control02.ctl
.db_block_size=8192
.db_domain=example.com
.db_name=PROD5
.db_recovery_file_dest=/u01/app/oracle/fast_recovery_area
.db_recovery_file_dest_size=4560m
.diagnostic_dest=/u01/app/oracle
.memory_target=1160m
.open_cursors=300
.processes=300
.remote_login_passwordfile=EXCLUSIVE
.undo_tablespace=UNDOTBS1
DB_UNIQUE_NAME=PROD5H1
LOG_ARCHIVE_CONFIG = DG_CONFIG=(PROD5H1,PROD5H2)
LOG_ARCHIVE_DEST_1=LOCATION=USE_DB_RECOVERY_FILE_DEST VALID_FOR=(ALL_LOGFILES,ALL_ROLES)
DB_UNIQUE_NAME=PROD5H1
LOG_ARCHIVE_DEST_2=SERVICE=PROD5H2 ASYNC VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE)
DB_UNIQUE_NAME=PROD5H2
LOG_ARCHIVE_FORMAT=%t_%s_%r.arc
FAL_SERVER=PROD5H2
DB_FILE_NAME_CONVERT=/PROD5H2/,/PROD5H1/
LOG_FILE_NAME_CONVERT=/PROD5H2/,/PROD5H1/
STANDBY_FILE_MANAGEMENT=AUTO

4. 关闭主库使用改动的pfile创建spfile，并启动至nomount状态

Shutdown immediate;
Startup nomount pfile=’/home/oracle/pfile.ora’;
Create spfile from pfile=’/home/oracle/pfile.ora’;
Shutdown immediate;
Startup nomount

5. 添加tnsname，主库备库各创建本地监听listener.ora

主库：SID_LIST_LISTENER=
(SID_LIST=
(SID_DESC=
(GLOBAL_DBNAME=PROD5H1.example.com)(SID_NAME=PROD5)
(ORACLE_HOME=/u01/app/oracle/product/12.1.0/dbhome_1)
)
)
备库：SID_LIST_LISTENER=
(SID_LIST=
(SID_DESC=
(GLOBAL_DBNAME=PROD5H2.example.com)
(SID_NAME=PROD5)
(ORACLE_HOME=/u01/app/oracle/product/12.1.0/dbhome_1)
)
)

Tnsname.ora
主库：PROD5H1=
(DESCRIPTION=
(ADDRESS=(PROTOCOL=TCP)(HOST=host01.example.com)(PORT=1521))
(CONNECT_DATA=
(SERVER=DEDICATED)
(SERVICE_NAME=PROD5H1.example.com)
)
)
PROD5H2=
(DESCRIPTION=
(ADDRESS=(PROTOCOL=TCP)(HOST=host02.example.com)(PORT=1521))
(CONNECT_DATA=
(SERVER=DEDICATED)
(SERVICE_NAME=PROD5H2.example.com)
)
)
备库：PROD5H1=
(DESCRIPTION=
(ADDRESS=(PROTOCOL=TCP)(HOST=host01.example.com)(PORT=1521))
(CONNECT_DATA=
(SERVER=DEDICATED)
(SERVICE_NAME=PROD5H1.example.com)
)
)
PROD5H2=
(DESCRIPTION=
(ADDRESS=(PROTOCOL=TCP)(HOST=host02.example.com)(PORT=1521))
(CONNECT_DATA=
(SERVER=DEDICATED)
(SERVICE_NAME=PROD5H2.example.com)
)
)

6. 传递pfile至备库，更改pfile,创建对应的文件夹
7. 备库使用pfile创建spfile，并启动至nomount状态

Shutdown immediate;
Startup nomount pfile=’/home/oracle/pfile.ora’;
Create spfile from pfile=’/home/oracle/pfile.ora’;
Shutdown immediate;
Startup nomount

8. 使用RMAN进行duplicate同步数据库

RMAN target sys/oracle@prod5h1 auxiliary sys/oracle@prod5h2
Duplicate target database for standby from active database nofilenamecheck

9. 开启应用日志

ALTER DATABASE RECOVER MANAGED STANDBY DATABASE USING CURRENT LOGFILE DISCONNECT;

10. 查看日志同步状态

结论

以上即为单实例ADG搭建的全部步骤，可以通过早前本公众号发布的文章进行更详细的实际操作操作和细节查看。