環(huán)境：

Primary 數(shù)據(jù)庫：sun01

Standby 數(shù)據(jù)庫：sun02

Oracle_Sid:bnet

1. 拷貝$ORACLE_BASE 到新機器上

2. 讓Primary數(shù)據(jù)庫處于歸檔模式，對Primary數(shù)據(jù)庫做一個Rman熱備份

startup mount

alter database archivelog;

archive log list;

rman target sys/oracle

backup database format '/....';

3.創(chuàng)建Data Guard數(shù)據(jù)庫控制文件

alter database create standby controlfile as '/....ctl';

4.設置監(jiān)聽

Primary：

bnetguard =

( (DESCRIPTION =

(ADDRESS_LIST =

(ADDRESS = (PROTOCOL = TCP)(HOST = sun02)(PORT = 1522))

)

(CONNECT_DATA =

(SERVER = DEDICATED)

(SERVICE_NAME = bnet)

)

)

Standby:

listener.ora

LISTENER =

(DESCRIPTION_LIST =

(DESCRIPTION =

(ADDRESS_LIST =

(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))

)

(ADDRESS_LIST =

(ADDRESS = (PROTOCOL = TCP)(HOST = sun01)(PORT = 1522))

)

)

)

tnsname.ora

bnet =

( (DESCRIPTION =

(ADDRESS_LIST =

(ADDRESS = (PROTOCOL = TCP)(HOST = sun02)(PORT = 1522))

)

(CONNECT_DATA =

(SERVER = DEDICATED)

(SERVICE_NAME = bnet)

)

)

5. 設置主機參數(shù)

alter database force logging;

主庫強制歸檔

主機參數(shù)：

fal_client=bnetguard

fal_server=bnet

standby_file_management=auto

remote_login_passwordfile=exclusive

備機參數(shù)：

db_file_name_convert

log_file_name_convert

standby_file_management='AUTO'

standby_archive_dest=/export/home/oracle/oradata/bnet/arch

6.創(chuàng)建standby 數(shù)據(jù)庫

orapwd

sqlplus 'sys/oracle as sysdba'

startup nomount pfile='''

alter database mount standby database;

exit

rman target sys/oracle nocatalog

restore database

7.設置自動歸檔

alter system set log_archive_dest_2='server=bnetguard reopen=200'

8.啟動Data Guard自動恢復狀態(tài)

sqlplus 'sys/oracle as sysdba'<