REMOTE_LOGIN_PASSWORDFILE=EXCLUSIVE

LOG_ARCHIVE_FORMAT=%t_%s_%r.arc

LOG_ARCHIVE_MAX_PROCESSES=3

?

FAL_SERVER=standby

DB_FILE_NAME_CONVERT='/u01/app/oracle/oradata/standby/disk3','/u01/app/oracle/oradata/PROD/disk3','/u01/app/oracle/oradata/standby/disk4','/u01/app/oracle/oradata/PROD/disk4','/u01/app/oracle/oradata/standby/disk5','/u01/app/oracle/oradata/PROD/disk5'

LOG_FILE_NAME_CONVERT=

'/u01/app/oracle/oradata/standby/disk1','/u01/app/oracle/oradata/PROD/disk1','/u01/app/oracle/oradata/standby/disk2','/u01/app/oracle/oradata/PROD/disk2'

STANDBY_FILE_MANAGEMENT=AUTO

?

2.4 Create aControl File for the Standby Database

SQL> STARTUP MOUNT;

SQL> ALTER DATABASECREATE STANDBY CONTROLFILE AS '/home/oracle/std_control01.ctl';

?

2.5 Create a ParameterFile for the Standby Database

将主库写好的pfile传输到备库

修改pfile

?

例子：

*.db_name='PROD'

*.db_recovery_file_dest_size=4294967296

*.db_recovery_file_dest='/u01/app/oracle/flash'

*.diagnostic_dest='/u01/app/oracle/oradata/standby/dump'

*.DISPATCHERS='(PROTOCOL=TCP)(DISPATCHERS=3)'

*.job_queue_processes=15

*.local_listener=''

*.max_dispatchers=10

*.max_shared_servers=30

*.processes=150

*.recyclebin='on'

*.sessions=300

*.shared_server_sessions=200

*.undo_retention=5400

*.undo_tablespace='undotbs'

*.utl_file_dir='/u01/app/oracle/utl'

?

DB_UNIQUE_NAME=standby

LOG_ARCHIVE_CONFIG='DG_CONFIG=(primary,standby)'

?

LOG_ARCHIVE_DEST_1=

'LOCATION=/u01/app/oracle/arch

VALID_FOR=(ALL_LOGFILES,ALL_ROLES)

DB_UNIQUE_NAME=standby'

?

LOG_ARCHIVE_DEST_2=

'SERVICE=primary SYNC AFFIRM NET_TIMEOUT=30

VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE)

DB_UNIQUE_NAME=primary'

LOG_ARCHIVE_DEST_STATE_1=ENABLE

LOG_ARCHIVE_DEST_STATE_2=ENABLE

REMOTE_LOGIN_PASSWORDFILE='EXCLUSIVE'

LOG_ARCHIVE_FORMAT=%t_%s_%r.arc

LOG_ARCHIVE_MAX_PROCESSES=3

?

FAL_SERVER=primary

DB_FILE_NAME_CONVERT='/u01/app/oracle/oradata/PROD/disk3','/u01/app/oracle/oradata/standby/disk3','/u01/app/oracle/oradata/PROD/disk4','/u01/app/oracle/oradata/standby/disk4','/u01/app/oracle/oradata/PROD/disk5','/u01/app/oracle/oradata/standby/disk5'

LOG_FILE_NAME_CONVERT='/u01/app/oracle/oradata/PROD/disk1','/u01/app/oracle/oradata/standby/disk1','/u01/app/oracle/oradata/PROD/disk2','/u01/app/oracle/oradata/standby/disk2'

STANDBY_FILE_MANAGEMENT=AUTO

?

2.6 Copy Files from thePrimary System to the Standby System

?

将standby controlfile,数据文件和密码文件拷贝到备库(注意密码文件名称要对应SID)

?

3.配置监听和TNS

?

Listener：

LISTENER=

(DESCRIPTION=

(ADDRESS_LIST=

(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.8.152)(PORT=1521))

(ADDRESS=(PROTOCOL=ipc)(KEY=extproc))

)

)

SID_LIST_LISTENER=

(SID_LIST=

(SID_DESC=

(SID_NAME=plsextproc)

(ORACLE_HOME=/u01/app/oracle/product/11.2.0/db_1)

(PROGRAM=extproc)

)

)

?

TNS：

primary=

(DESCRIPTION=

(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.8.150)(PORT=1521))

(CONNECT_DATA=

(SERVICE_NAME=PRIMARY)

(SERVER=DEDICATED)

)

)

?

standby=

(DESCRIPTION=

(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.8.152)(PORT=1521))

(CONNECT_DATA=

(SERVICE_NAME=STANDBY)

(SERVER=DEDICATED)

)

)

两边启动到MOUNT开启监听,用sqlplus sys/oracle@primary as sysdb测试是否可以连通

?

4.添加standby redo log