ORACLE的ORA-07217原因

                              ORACLE的ORA-07217原因

     ora-07217表示当进oracle进程在获取环境变量的定义时得不到信息，或是返回空
就提示指信息，

1,在rman脚本很常见.变量没有正确解析

[oracle@dg2 trace]$ oerr ora 7217
07217, 00000, "sltln: environment variable cannot be evaluated."
// *Cause:  getenv call returned a null pointer.
// *Action: Set the environment variable and try again.

 

RMAN> backup datafile 1 format '$BACKUP/%S';

Starting backup at 29-AUG-13
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=258 device type=DISK
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00001 name=/u01/app/oracle/oradata/tt/DGTT/datafile/o1_mf_system_91xotmdb_.dbf
channel ORA_DISK_1: starting piece 1 at 29-AUG-13
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of backup command on ORA_DISK_1 channel at 08/29/2013 19:35:19
ORA-07217: sltln: environment variable cannot be evaluated.

定义了一个不存的$BACKUP变量，oracle无法获得此变量的值,报错

 

2,做物理备库时,定义了
db_file_name_convert='+DATA','/u01/app/oracle/oradata/tt'

sql statement: alter database mount standby database
released channel: c1
released channel: ac2
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of Duplicate Db command at 08/29/2013 20:04:46
RMAN-05501: aborting duplication of target database
RMAN-03015: error occurred in stored script Memory Script
RMAN-03009: failure of sql command on clone_default channel at 08/29/2013 20:04:46
RMAN-11003: failure during parse/execution of SQL statement: alter database mount standby database
ORA-07217: sltln: environment variable cannot be evaluated.

目前尚不清楚原因是什么，而log_file_name_convert参数受支持的.在11.2和11.1的版本中都不会出现类似的情况.