oracle忘记账号密码怎么办An Issue of Duplicate Database

An Issue of Duplicate Database

oracle账号

在做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'