rman backup / restore how to change online log file name
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: rman backup / restore how to change online log file name

  1. #1
    Join Date
    Jan 2001
    Posts
    191

    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

  2. #2
    Join Date
    Jan 2001
    Posts
    191
    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

  3. #3
    Join Date
    Jan 2001
    Posts
    191
    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.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width