Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

log_file_name_convert is ignored, why?

user526627Jul 3 2007 — edited Jul 4 2007
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
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 1 2007
Added on Jul 3 2007
1 comment
1,575 views