Oracle 11g Dataguard 物理备库配置Duplicate配置
来源:互联网 发布:淘宝推广工具有哪些 编辑:程序博客网 时间:2024/05/22 03:14
alter system set instance_name='prd' scope=spfile;
alter system set db_unique_name='prd' scope=spfile;
alter system set local_listener='prd' scope=spfile;
alter system set log_archive_config='DG_CONFIG=(prd,pra)';
alter system set log_archive_dest_1='LOCATION=/u01/arch valid_for=(all_logfiles,all_roles) db_unique_name=prd' scope=spfile;
alter system set log_archive_dest_2='SERVICE=pra lgwr async valid_for=(online_logfiles,primary_role) db_unique_name=pra' scope=spfile;
alter system set log_archive_format='arch_%r_%t_%s.arc' scope=spfile;
alter system set fal_client='prd' scope=spfile;
alter system set fal_server='pra' scope=spfile;
alter system set standby_file_management=AUTO;
alter database add standby logfile group 4 '/u01/app/oracle/oradata/prd/standby04.log' size 50M;
alter database add standby logfile group 5 '/u01/app/oracle/oradata/prd/standby05.log' size 50M;
alter database add standby logfile group 6 '/u01/app/oracle/oradata/prd/standby06.log' size 50M;
alter database add standby logfile group 7 '/u01/app/oracle/oradata/prd/standby07.log' size 50M;
run {
allocate channel c1 type disk;
allocate channel c2 type disk;
allocate auxiliary channel stby type disk;
duplicate target database for standby nofilenamecheck from active database
dorecover
spfile
parameter_value_convert 'prd','pra'
set instance_name='pra'
set db_unique_name='pra'
set local_listener='pra'
set db_file_name_convert='/u01/app/oracle/oradata/prd/','/u01/app/oracle/oradata/pra/'
set log_file_name_convert='/u01/app/oracle/oradata/prd/','/u01/app/oracle/oradata/pra/'
set control_files='/u01/app/oracle/oradata/pra/control01.ctl','/u01/app/oracle/oradata/pra/control02.ctl','/u01/app/oracle/oradata/pra/control03.ctl'
set log_archive_dest_1='LOCATION=/u01/arch valid_for=(all_logfiles,all_roles) db_unique_name=pra'
set log_archive_dest_2='SERVICE=prd lgwr async valid_for=(online_logfile,primary_role) db_unique_name=prd'
set log_archive_max_processes='5'
set standby_file_management='AUTO'
set fal_client='pra'
set fal_server='prd';
release channel c1;
release channel c2;
release channel stby;
}
alter system set db_unique_name='prd' scope=spfile;
alter system set local_listener='prd' scope=spfile;
alter system set log_archive_config='DG_CONFIG=(prd,pra)';
alter system set log_archive_dest_1='LOCATION=/u01/arch valid_for=(all_logfiles,all_roles) db_unique_name=prd' scope=spfile;
alter system set log_archive_dest_2='SERVICE=pra lgwr async valid_for=(online_logfiles,primary_role) db_unique_name=pra' scope=spfile;
alter system set log_archive_format='arch_%r_%t_%s.arc' scope=spfile;
alter system set fal_client='prd' scope=spfile;
alter system set fal_server='pra' scope=spfile;
alter system set standby_file_management=AUTO;
alter database add standby logfile group 4 '/u01/app/oracle/oradata/prd/standby04.log' size 50M;
alter database add standby logfile group 5 '/u01/app/oracle/oradata/prd/standby05.log' size 50M;
alter database add standby logfile group 6 '/u01/app/oracle/oradata/prd/standby06.log' size 50M;
alter database add standby logfile group 7 '/u01/app/oracle/oradata/prd/standby07.log' size 50M;
run {
allocate channel c1 type disk;
allocate channel c2 type disk;
allocate auxiliary channel stby type disk;
duplicate target database for standby nofilenamecheck from active database
dorecover
spfile
parameter_value_convert 'prd','pra'
set instance_name='pra'
set db_unique_name='pra'
set local_listener='pra'
set db_file_name_convert='/u01/app/oracle/oradata/prd/','/u01/app/oracle/oradata/pra/'
set log_file_name_convert='/u01/app/oracle/oradata/prd/','/u01/app/oracle/oradata/pra/'
set control_files='/u01/app/oracle/oradata/pra/control01.ctl','/u01/app/oracle/oradata/pra/control02.ctl','/u01/app/oracle/oradata/pra/control03.ctl'
set log_archive_dest_1='LOCATION=/u01/arch valid_for=(all_logfiles,all_roles) db_unique_name=pra'
set log_archive_dest_2='SERVICE=prd lgwr async valid_for=(online_logfile,primary_role) db_unique_name=prd'
set log_archive_max_processes='5'
set standby_file_management='AUTO'
set fal_client='pra'
set fal_server='prd';
release channel c1;
release channel c2;
release channel stby;
}
0 0
- Oracle 11g Dataguard 物理备库配置Duplicate配置
- Oracle 11g DataGuard物理standby配置
- Oracle 11g DataGuard 物理备库配置及Active DataGuard测试
- Oracle 11G 通过 duplicate 配置单实例DataGuard
- Oracle 11g DataGuard 配置
- oracle 11g dataguard配置
- oracle-11g-配置dataguard
- DataGuard 物理备库配置
- oracle rman duplicate 创建dataguard物理备库
- 【DataGuard】Oracle 11g DataGuard 角色转换(一)物理备库Switchover
- 配置Oracle 11g Active Dataguard
- 配置Oracle 11g Active Dataguard
- Oracle-11G-DataGuard 一主库多备库详细配置
- 探索Oracle之11g DataGuard 配置
- 配置Oracle 11g Active Dataguard
- Oracle 11g DataGuard 配置详细说明
- Oracle 10g dataguard 物理备库日常维护
- ORACLE 11G dataguard安装配置手册--单实例物理standby 三种保护模式互相切换
- android studio中查看keystore的sha1和md5
- 通过反射获取类的所有属性
- Unity多人游戏与网络功能(四)- 状态同步与远程动作
- 51Nod-1418-放球游戏
- Spring源代码解析(收藏)
- Oracle 11g Dataguard 物理备库配置Duplicate配置
- [leetcode] 313. Super Ugly Number
- Qt小项目(3):秒表计时
- “在XML文件中给代码加注释”请注意
- CSS样式表和JavaScript
- 开始搭建第一个JavaWeb应用
- [leetcode] 300. Longest Increasing Subsequence
- LeetCode--No.9--Palindrome Number
- [leetcode] 48. Rotate Image