oracle data guard 环境搭建记录(未整理)
时间:2011-05-13 来源:RyanBomb
通过一个礼拜的时间,终于将dataguard 搭建好了,默认的最大性能模式,通过手动切换,可用
以下是我的一些记录,还没完全整理,先放放 呵呵
primary 192.168.170.1 primary
standby 192.168.170.2 standby
alter database archivelog
alter database force logging;
alter system set db_unique_name ="primary" scope=spfile;
alter system set log_archive_config='dg_config=(primary,standby)' scope=spfile;
ALTER SYSTEM SET log_archive_dest_1 = "location=C:\FRA\arch" SCOPE=SPFILE;
ALTER SYSTEM SET log_archive_dest_2 = "service=standby valid_for=(online_logfiles,primary_role) arch async NOAFFIRM db_unique_name=standby" SCOPE=SPFILE;
ALTER SYSTEM SET log_archive_dest_state_1 = "ENABLE" SCOPE=SPFILE;
ALTER SYSTEM SET log_archive_dest_state_2 = "ENABLE" SCOPE=SPFILE;
ALTER SYSTEM SET fal_client = "primary" SCOPE=SPFILE;
ALTER SYSTEM SET fal_server = "standby" SCOPE=SPFILE;
ALTER SYSTEM SET standby_file_management = "AUTO" SCOPE=SPFILE;
create pfile from spfile;
backup full database format='c:\rmanbak\%d_%s.dbf' plus archivelog delete input;
alter database create standby controlfile as 'c:\rmanbak\control01.ctl';
修改listener.ora
增加
C:\oracle\product\10.2.0\db_1
standby数据库配置
创建实例,注意数据库名字要一致,sid=primary
将primary服务器的ramn备份文件拷贝至standby服务器相同的位置
将primary服务器的控制文件control01.ctl
修改pfile文件,控制文件的名字与指向
*.db_unique_name='standby'
*.fal_client='standby'
*.fal_server='primary'
*.log_archive_dest_2='service=orcl valid_for=(online_logfiles,primary_role) arch async NOAFFIRM db_unique_name=primary'
删除 *.dispatchers='(PROTOCOL=TCP) (SERVICE=orclXDB)'
删除 (如果备库不存在flash目录则删除)
*.db_recovery_file_dest='。。。。。'
删除(如果备库不存在flash目录则删除)
rman恢复数据库
startup mount;
recovery databae;
alter database recover managed standby database disconnect from session;
select process,status from v$managed_standby;
*******************************************
select process,status from v$managed_standby; --查看进程
RFS - 远程文件接收进程
MRP0 - 日志应用进程
*******************************************
select name,SEQUENCE#,APPLIED from v$archived_log order by sequence#; -查看是否有归档日志
*********************************************
alter database recover managed standby database disconnect from session;
--开始应用日志恢复,使备库处于日志恢复模式(备用模式)。
*********************************************
alter database recover managed standby database cancel;
停止日志恢复模式
*********************************************
alter database open read only
打开数据库只读模式