DG搭建步骤 - 墨天轮文档

DG搭建步骤

gilbert

1083

1页

4次

2020-04-05

5墨值下载

Creating a Physical Standby Database

1.1 enable force logging

alter database force logging;

select force_logging from v$database;

1.2 create a password file

scp

1.3 configure listeners

netmgr

$ORACLE_HOME/network/admin

1.4 set primary database initalization parameters

DB_NAME=chicago

DB_UNIQUE_NAME=chicago

LOG_ARCHIVE_CONFIG='DG_CONFIG=(chicago,boston)'

CONTROL_FILES='/arch1/chicago/control1.ctl', '/arch2/chicago/control2.ctl'

LOG_ARCHIVE_DEST_1=

'LOCATION=/arch1/chicago/

VALID_FOR=(ALL_LOGFILES,ALL_ROLES)

DB_UNIQUE_NAME=chicago'

LOG_ARCHIVE_DEST_2=

'SERVICE=boston LGWR ASYNC

VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE)

DB_UNIQUE_NAME=boston'

FAL_SERVER=boston

FAL_CLIENT=chicago

DB_FILE_NAME_CONVERT='boston','chicago'

LOG_FILE_NAME_CONVERT=

'/arch1/boston/','/arch1/chicago/','/arch2/boston/','/arch2/chicago/'

STANDBY_FILE_MANAGEMENT=AUTO

1.5 enable archiving

show parameter arch

startup mount;

alter database archivelog;

2.1 create a backup copy of the primary database datafile

cp...

2.2 create a control file for the standby database

startup mount;

alter database create standby controlfile as

'/opt/oracle/oradata/sid2/control.ctl';

2.3 set standby database initalization parameters

2.4 create spfile

create spfile from pfile;

2.5 start the physical standby database

2.6 check

alter system switch logfile;

archive log list;

of 1

5墨值下载

oracle 安装部署

关注

评论