Re: RMAN restore - log_file_name_convert

Posted by Roshan on Nov 21, 2016; 4:07pm
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/RMAN-restore-log-file-name-convert-tp1576p1581.html

  run {  
    allocate channel c1 device type disk;  
    allocate channel c2 device type disk;  
    allocate channel c3 device type disk;  
    allocate channel c4 device type disk;  
    set newname for database to '/data/WINSDB/%f'; # make sure, you set the parameter db_create_file_dest in your init file
     
    set newname for tempfile 1 to '/data/WINSDB/%f';
       
    restore database from '/archive/winsbackup';  
    switch datafile all;  #use when using the set command
    switch tempfile all;  #use when using set command
    recover database;  
    alter database open resetlogs;  
    release channel c1;  
    release channel c2;  
    release channel c3;  
    release channel c4;  
    }