Standby数据库简单建立过程

建立过程：

log_archive_start = true

log_archive_dest_1 = “location=D:oracleoradataSFISarchive”

log_archive_dest_2 = “service=standby optional reopen=60”

log_archive_dest_state_1=enable

log_archive_dest_state_2=enable

log_archive_min_succeed_dest=1

standby =

(DESCRIPTION =

(ADDRESS_LIST =

(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.2)(PORT = 1521)) ------192.168.0.2 是standby db ip .

)

(CONNECT_DATA =

(SERVICE_NAME = sfis)

) )

修改 standby 上的init.ora 文件 .

log_archive_start = false

log_archive_dest_1 = "location=D:oracleoradataSFISarchive"

standby_archive_dest = "D:oracleoradataSFISarchive"

log_archive_format = "log_%S.ARC"

修改 standby 上的 Listener.ora 文件 ,並開啟standby 的Listener .

LISTENER =

(DESCRIPTION_LIST =

(DESCRIPTION =

(ADDRESS = (PROTOCOL = TCP)(HOST = 172.24.16.24)(PORT = 1521)))

(DESCRIPTION =

(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.2)(PORT = 1521))) )

在 standby 上的開啟監聽器, 並開啟, mount standby 數據庫. .

SQL>lsnrctl start;

SQL>lsnrctl status;

SQL>startup nomount pfile=d:oracleadminsfispfileinit.ora﹔

SQL>alter database mount standby database;

SQL>recovery automatic standby database;

SQL>recovery managed standby database;

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/35489/viewspace-84459/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/35489/viewspace-84459/