DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Is log_file_name_convert allowed in run block.

  1. #1
    Join Date
    Aug 2011
    Posts
    2

    Red face Is log_file_name_convert allowed in run block.

    Is log_file_name_convert allowed in run block.
    I have 3 log group on target(source).Each has 2 members.

    target ->aux

    u01/oradata/prod/redo01.log ->/ora1/oradata/aux//redo01.log
    /u02/oradata/prod/redo01b.log->/ora2/oradata/aux//redo0b.log


    /u01/oradata/prod/redo02.log->/ora1/oradata/aux//redo02.log
    /u02/oradata/prod/redo02b.log-/ora2/oradata/aux//redo02b.log



    /u01/oradata/prod/redo03.log->/ora1/oradata/aux//redo03.log
    /u02/oradata/prod/redo03b.log->/ora2/oradata/aux//redo03b.log


    run {
    ALLOCATE AUXILIARY CHANNEL aux1 DEVICE TYPE DISK;
    ALLOCATE AUXILIARY CHANNEL aux2 DEVICE TYPE DISK;
    ALLOCATE AUXILIARY CHANNEL aux3 DEVICE TYPE DISK;
    set until time "to_date('24-Jun-11 10:22:00','DD-MON-YY HH24:MI:SS')";
    DUPLICATE TARGET DATABASE TO "test"
    PFILE=/opt/oracle/product/10.2/db_1/dbs/inittest.ora
    DB_FILE_NAME_CONVERT='/u01/oradata/prod/', '/ora1/oradata/test/'
    log_file_name_convert='/u01/oradata/prod/','/ora1/oradata/test/','/u02/oradata/prod/','/ora2/oradata/test/'

    release channel aux1;
    release channel aux2;
    }

  2. #2
    Join Date
    Aug 2007
    Location
    Cyberjaya,kuala lumpur
    Posts
    340
    Quote Originally Posted by sksktx View Post
    DB_FILE_NAME_CONVERT='/u01/oradata/prod/', '/ora1/oradata/test/'
    log_file_name_convert='/u01/oradata/prod/','/ora1/oradata/test/','/u02/oradata/prod/','/ora2/oradata/test/'
    }
    This parameters are used in the pfile right ?

    you may please refer the below link

    http://download.oracle.com/docs/cd/B...pdb.htm#441883
    Thanks/Gopu

  3. #3
    Join Date
    Nov 2000
    Location
    Pittsburgh, PA
    Posts
    4,166
    You either use the db_file_name_convert and log_file_name_convert in the pfile, or you can use set filename/tempfile for n to '/oracle/oradata/sidname...'; and before you open the database you need to rename the online logs with an alter database rename file 'from file' tofile';

    I dynamically generate the clone script during the backup process, which makes it easier to do the cloning on any database whether I am cloning from and to a database on the same server or cloning from one server to another, even if the two servers can't talk to each other.

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