您的位置: 首页  >  IT文章  >  12c pdb dg搭建 convert 参数配置 一、目标 二、测试方法 三、参数配置

12c pdb dg搭建 convert 参数配置 一、目标 二、测试方法 三、参数配置

分类: IT文章 • 2022-05-29 23:04:23

搭建12c dg 存在pdb,如果存在多个pdb的路径，如何使用convert进行转换？

主库路径

/picclife/app/oracle/oradata/orcl/

/picclife/app/oracle/oradata/orcl/pdbseed/

/picclife/app/oracle/oradata/orcl/c11pdb/

DG备库期望路径

/picclife/app/oracle/oradata/orcldg/

/picclife/app/oracle/oradata/orcl/pdbseeddg/

/picclife/app/oracle/oradata/orcl/c11pdbdg/

　　

二、测试方法

主库备份
RMAN> backup current controlfile for standby format '/home/oracle/stdby.ctl';
scp /home/oracle/stdby.ctl oracle@10.0.0.99:/home/oracle/.
备库应用
connected to target database: ORCL (not mounted)
RMAN>restore controlfile from '/home/oracle/stdby.ctl';
SQL>ALTER DATABASE MOUNT;
check
如何确认convert参数配置是否正确呢？
select member from v$logfile;
select name from v$tempfile;
select name from v$datafile;

三、参数配置

参数配置！   建议前面的CDB目录，放到最后进行转换，否则可能存在转换问题！ 

SQL> alter system set db_file_name_convert='/picclife/app/oracle/oradata/orcl/pdbseed/','/picclife/app/oracle/oradata/orcldg/pdbseeddg/',
'/picclife/app/oracle/oradata/orcl/c11pdb/','/picclife/app/oracle/oradata/orcldg/c11pdbdg/',
'/picclife/app/oracle/oradata/orcl/','/picclife/app/oracle/oradata/orcldg/' scope=spfile;

/picclife/app/oracle/oradata/orcldg/

/picclife/app/oracle/oradata/orcldg/pdbseeddg/

/picclife/app/oracle/oradata/orcldg/c11pdbdg/


DG 启动观察DB alert日志可以发现如下信息

db_file_name_convert = "/picclife/app/oracle/oradata/orcl/pdbseed/"
db_file_name_convert = "/picclife/app/oracle/oradata/orcldg/pdbseeddg/"
db_file_name_convert = "/picclife/app/oracle/oradata/orcl/c11pdb/"
db_file_name_convert = "/picclife/app/oracle/oradata/orcldg/c11pdbdg/"
db_file_name_convert = "/picclife/app/oracle/oradata/orcl/"
db_file_name_convert = "/picclife/app/oracle/oradata/orcldg/"
log_file_name_convert = "/picclife/app/oracle/oradata/orcl/"
log_file_name_convert = "/picclife/app/oracle/oradata/orcldg/"

　　

相关推荐