log_file_name_convert is ignored, why?
I'm running 10.2.0.3.0 and trying to restore a database onto a box where I have no /u02 mount point. Thus, I'm attempting to use the log_file_name_convert. However, following the examples doesn't work.
I put log_file_name_convert = (/u02/,/u01/)
into my init.ora then did a
create spfile from pfile.
startup mount;
used show parameter to verify the log_file_name_convert is set. Yet the alter database open reset logs errors out because it can't find /u02. Why is the log_file_name_convert being ignored?
Screen shot below:
SQL> connect /as sysdba
Connected.
SQL> show parameter convert
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
db_file_name_convert string
log_file_name_convert string /u02/, /u01/
SQL>
RMAN> alter database open resetlogs;
RMAN-00571: ============================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS
RMAN-00571: ===========================================
RMAN-03002: failure of alter db command at 07/03/2007 18:12:50
ORA-00344: unable to re-create online log '/u02/oradata/p1/redog2m1.dbf'
ORA-27040: file create error, unable to create file
SVR4 Error: 2: No such file or directory
RMAN>
Thank you,
Jason