关于部署DGduplicate target database 和安装ORACLE-VALIDATED的疑问!!!

shj198746

按照刘大的DG部署视频成功但有疑问 duplicate target database  备库MACDBS的数据存放路径是 '/s01/oradata/MACDBN/' 怎么改成  ‘/s01/oradata/MACDBS/'
这个脚本要怎么改

duplicate target database
for standby
from active database
DORECOVER
spfile
set db_unique_name='MACDBS'
set  log_archive_dest_1='location=+FRA  VALID_FOR=(ALL_LOGFILES,ALL_ROLES)
DB_UNIQUE_NAME=MACDBS'
set  log_archive_dest_2='SERVICE=MACDBN  ASYNC  LGWR
VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=MACDBN'
set standby_file_management='AUTO'
set fal_server='MACDBN'
set fal_client='MACDBS'
set control_files='+DATA'
set memory_target='0'
set sga_target='600M';


还有安装完ORACLE-VALIDATED后 /etc/security/limits.conf和 /etc/sysctl.conf 里没有改动

[root@test ~]# rpm -qa oracle-validated
oracle-validated-1.1.0-15.el5

系统是OEL5.8 X86_64

anbob

1，set db_file_name_convert  initialization  parameter

2，没改动说明没成功。yum?rpm? 安装

shj198746

anbob 发表于 2013-6-13 14:22
1，set db_file_name_convert  initialization  parameter

2，没改动说明没成功。yum?rpm? 安装 ...

是在脚本最后加 set db_file_name_convert  = ‘/s01/oradata/MACDBS/'  吗？

anbob

shj198746 发表于 2013-6-13 14:28
是在脚本最后加 set db_file_name_convert  = ‘/s01/oradata/MACDBS/'  吗？

这是一以前做的demo

1. [oracle@znode1 oracle]$ rman target / auxiliary sys/oracle@stdbytns
   
2. rman>
   
3. 
   
4. duplicate target database for standby from active database
   
5. spfile
   
6. parameter_value_convert 'rac','stdby','RAC','stdby'
   
7. set db_unique_name='stdby'
   
8. set db_file_name_convert='+DBDG/rac','/u02/app/oracle/oradata/stdby','+DBDG/rac/tempfile','/u02/app/oracle/oradata/stdby'
   
9. set log_file_name_convert='+FLRV/rac','/u02/app/oracle/fast_recovery_area/stdby','+DBDG/rac','/u02/app/oracle/oradata/stdby'

复制代码

shj198746

anbob 发表于 2013-6-13 14:32
这是一以前做的demo

多谢了，有空我再去试试