db_file_name_convert的用途和限制

此参数仅适用于physical standby和rman duplicate/TSPITR，对logical standby和普通rman restore无效；

 

有若干方法用于调整文件名，按照优先级从高到低：

1  set newname –用于rman脚本，配合switch datafile to copy

2  db_create_file_dest –用于OMF

3  db_file_name_convert/log_file_name_convert

 

注：如果physical standby同时设置了db_create_file_dest/db_file_name_convert，则优先使用前者

If OMF parameters are set on the standby, then new files on that standby are always created as OMF, regardless of how they were created on the primary. Therefore, if both the DB_FILE_NAME_CONVERT and DB_CREATE_FILE_DEST parameters are set on the standby, the DB_CREATE_FILE_DEST parameter takes precedence.

http://docs.oracle.com/cd/E11882_01/server.112/e25608/scenarios.htm#SBYDB00900

 

 

1

db_file_name_convert可以协同backup/convert命令使用，诸如

BACKUP AS COPY DEVICE TYPE DISK

DB_FILE_NAME_CONVERT=('/disk1/dbs/users','/newdisk1','/disk1/dbs/tools','/newdisk2')

TABLESPACE tools, users;

--Backing up tablespace with db_file_name_convert [ID 330536.1]

 

convert tablespace TSP_A,TSP_B to platform="Solaris[tm] OE (64-bit)"

DB_FILE_NAME_CONVERT=

'D:\ORACLE\USRDATA','H:\converted_datafiles',

'O:\ORACLE\USRDATA','L:\converted_datafiles'

--Using Db_file_name_convert when transporting tablespaces with multiple locations [ID 567340.1]

 

 

2

配置db_file_name_convert须注意语法，其后不可添加semicolon即'；’ ，也不可使用wildcard即通配符

DB_FILE_NAME_CONVERT=(

'/u10/orarbs/x015','/u10/orarbs/x015aux',

'/u12_tmp1/oratemp/x015','/u12_tmp1/oratemp/x015aux') ;

 

SQL> select value from v$parameter where name like '%convert%';

VALUE

--------------------------------------------------------------------------------

/u10/oradata/x015, ;

 

去除分号

SQL> select value from v$parameter where name like '%convert%';

VALUE

--------------------------------------------------------------------------------

/u10/orarbs/x015, /u10/orarbs/x015aux,u12_tmp1/oratemp/x015, /u12_tmp1/oratemp/x015aux

--

 

 

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/15480802/viewspace-762973/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/15480802/viewspace-762973/