5M现在有a,b,c三个数据库做了adg之后同步一切正常,a切换到b库(用switchover现在备库是主库)之后同步也正常现在模拟c数据库坏了之后想由b进行全量恢复,但是b恢复给c的时候会增加一个datafileDG的路径这个路径是没有配置过的,测试当a是正常的主库,由a库全量恢复给c的时候就是正常
c库查看到的路径配置均正常
db_file_name_convert string /mnt/oracle/app/oradata/a,/mnt/oracle/app/oradata/c/datafile,/mnt/oracle/app/oradata/b/datafile, /mnt/oracle/app/oradata/c/datafile
log_file_name_convert string
/mnt/oracle/app/oradata/a,/mnt/oracle/app/oradata/c/onlinelog, /mnt/oracle/app/oradata/b/onlinelog, /mnt/oracle/app/oradata/c/onlinelog
B库查看的路径配置均正常
db_file_name_convert string /mnt/oracle/app/oradata/a,/mnt/oracle/app/oradata/b/datafile, /mnt/oracle/app/oradata/c/datafile, /mnt/oracle/app/oradata/b/datafile
log_file_name_convert string /mnt/oracle/app/oradata/a,/mnt/oracle/app/oradata/b/onlinelog, /mnt/oracle/app/oradata/c/onlinelog, /mnt/oracle/app/oradata/b/onlinelog
A库查看的路径均正常
db_file_name_convert string
/mnt/oracle/app/oradata/b/datafile, /mnt/oracle/app/oradata/a, /mnt/oracle/app/oradata/c/datafile, /mnt/oracle/app/oradata/LAND
log_file_name_convert string
/mnt/oracle/app/oradata/b/onlinelog, /mnt/oracle/app/oradata/a, /mnt/oracle/app/oradata/c/onlinelog, /mnt/oracle/app/oradata/a
当B库为主库时使用rman在线恢复
duplicate target database for standby from active database; //使用此命令,如下是提取出来的在b库恢复c库的结果
set newname for tempfile 1 to
"/mnt/oracle/app/oradata/c/datafileDG/datafile/temp01.dbf";
switch clone tempfile all;
set newname for datafile 1 to
"/mnt/oracle/app/oradata/c/datafileDG/datafile/system01.dbf";
set newname for datafile 2 to
可以看到set newname的时候多增加了datafileDG的目录但是此目录并没有创建,想请教各位大神这样的我怎么进行排查?
墨值悬赏

评论

