rman backup / restore how to change online log file name
Hi, database is 10.2.0.3 ASM and RAC.
I need to move this database to another server.
But new server don't have same disk group name .
I can use
allocate channel c1 device type disk;
allocate channel c2 device type disk;
SET NEWNAME FOR DATAFILE 1 TO NEW;
SET NEWNAME FOR DATAFILE 2 TO NEW;
SET NEWNAME FOR DATAFILE 3 TO NEW;
SET NEWNAME FOR DATAFILE 4 TO NEW;
SET NEWNAME FOR DATAFILE 5 TO NEW;
SET NEWNAME FOR DATAFILE 6 TO NEW;
SET NEWNAME FOR DATAFILE 7 TO NEW;
SET NEWNAME FOR DATAFILE 8 TO NEW;
SET NEWNAME FOR DATAFILE 9 TO NEW;
SET NEWNAME FOR DATAFILE 10 TO NEW;
restore database from tag full_hot_backup;
SWITCH DATAFILE ALL;
release channel c1;
release channel c2;
to reset data file/temp file (not in this script) name. But I find I can not use this command to reset log file name.
I used LOG_FILE_NAME_CONVERT in init parameter, it did not work, Not sure about this log_file_name_convert.
Any one use LOG_FILE_NAME_CONVERT ? please let me know if it work or not.
So when I run
alter database open resetlogs, it can not create logfile . It ignore what I have in init parameters for
So any idea how to change online log file location?
by the way, duplicate will reset logfile. But I need to connect to both databases and need sys password. I don't like to do that. Just want to see if can do it using backup/restore
The DB_FILE_NAME_CONVERT and LOG_FILE_NAME_CONVERT initialization parameters cannot be used to control generation of new names for files at the duplicate which are Oracle Managed Files (OMF) at the target database. When using Oracle Managed Files at the target instance, it is not generally possible to generate valid OMF filenames for the duplicate instance by replacing a substring of the target instance OMF filename. When duplicating Oracle Managed Files and storing the duplicates in an ASM disk group, RMAN uses DB_FILE_NAME_CONVERT or LOG_FILE_NAME_CONVERT to convert the disk group name, and then generates a new, valid filename based on the converted disk group name.
You can avoid this issue by using one of the other supported options for naming datafiles being duplicated from OMF:
Use SET NEWNAME to specify names for individual datafiles
Use DB_CREATE_FILE_DEST for any datafile names not specifically renamed by SET NEWNAME, and do not specify DB_FILE_NAME_CONVERT.
The supported options for naming online logs being duplicated from OMF are to use DB_CREATE_FILE_DEST, DB_RECOVERY_FILE_DEST or DB_CREATE_ONLINE_LOG_DEST_n. Do not use the LOG_FILE_NAME_CONVERT parameter.
Click Here to Expand Forum to Full Width