当前位置:操作系统 > Unix/Linux >>

An Issue of Duplicate Database

An Issue of Duplicate Database
 
在做Duplicate数据库的时候,编辑initSID.ora文件发现db_file_name_convert的值是有先后顺序的,要先写子目录的对应关系,后写父目录的对应关系,否则会出错的。
 
下面这个写法是正常的
db_file_name_convert=
'/u01/app/oracle/oradata/PROD/Disk1','/u01/app/oracle/oradata/SBDB',
'/u01/app/oracle/oradata/PROD/Disk2','/u01/app/oracle/oradata/SBDB',
'/u01/app/oracle/oradata/PROD/Disk3','/u01/app/oracle/oradata/SBDB',
'/u01/app/oracle/oradata/PROD','/u01/app/oracle/oradata/SBDB'
 
下面这个写法会出错。
 
db_file_name_convert=
'/u01/app/oracle/oradata/PROD','/u01/app/oracle/oradata/SBDB',
'/u01/app/oracle/oradata/PROD/Disk1','/u01/app/oracle/oradata/SBDB',
'/u01/app/oracle/oradata/PROD/Disk2','/u01/app/oracle/oradata/SBDB',
'/u01/app/oracle/oradata/PROD/Disk3','/u01/app/oracle/oradata/SBDB'
 
CopyRight © 2012 站长网 编程知识问答 www.zzzyk.com All Rights Reserved
部份技术文章来自网络,