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
run {
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
*.db_create_online_log_dest_1='+DATA1'
*.db_create_online_log_dest_2='+FRA1'
So any idea how to change online log file location?
thanks
xyz2000