创建物理备库,主要有以下几个步骤:
1、主库归档模式,并且强制日志
ALTER DATABASE ARCHIVELOG;
alter database force logging;
2、创建口令文件,或者直接拷贝主库口令文件并改名
3、初始化参数配置:
--primary database
DB_NAME=dbp
DB_UNIQUE_NAME=dbp
LOG_ARCHIVE_CONFIG='DG_CONFIG=(dbp,dbsp)'
LOG_ARCHIVE_DEST_1='LOCATION=/arch1/ VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=dbp'
LOG_ARCHIVE_DEST_2='SERVICE=dbsp ARCH ASYNC VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=dbsp'
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=dbsp
FAL_CLIENT=dbp
DB_FILE_NAME_CONVERT='dbsp','dbp'
LOG_FILE_NAME_CONVERT='dbsp','dbp'
STANDBY_FILE_MANAGEMENT=AUTO
--standby database
DB_NAME=dbp
DB_UNIQUE_NAME=dbsp
LOG_ARCHIVE_CONFIG='DG_CONFIG=(dbp,dbsp)'
LOG_ARCHIVE_DEST_1='LOCATION=/arch1/ VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=dbsp'
LOG_ARCHIVE_DEST_2='SERVICE=dbp ARCH ASYNC VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=dbp'
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=dbp
FAL_CLIENT=dbsp
DB_FILE_NAME_CONVERT='dbp','dbsp'
LOG_FILE_NAME_CONVERT='dbp','dbsp'
STANDBY_FILE_MANAGEMENT=AUTO
4、创建备库控制文件,参数文件,创建备份
ALTER DATABASE CREATE STANDBY CONTROLFILE AS '/home/oracle/stdby_control.ctl';
CREATE PFILE='/home/oracle/pfile.ora' FROM SPFILE;
5、将主库参数文件,控制文件,备份文件拷贝到备库,做数据库恢复。
6、对于使用 LGWR 传送日志的备库,需要创建备用重做日志,大小应与主库保持一致,数目为主库所有日志数+日志线程数
alter database add standby logfile group 11 ('xxx','xxx') size 100M;
7、修改之后,启动备库到mount 状态,开启日志应用
ALTER DATABASE RECOVER MANAGED STANDBY DATABASE DISCONNECT FROM SESSION;
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/24465008/viewspace-752840/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/24465008/viewspace-752840/