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