rman set newnname 생성 PL/SQL

- rman set newnname 생성 PL/SQL

set serveroutput on;

declare

    cursor df is select file#, name from v$datafile;

begin

    dbms_output.put_line('run');

    dbms_output.put_line('{');

    for dfrec in df loop

        dbms_output.put_line('set newname for datafile ' ||

            dfrec.file# || ' to ''' || dfrec.name ||''' ;');

    end loop;

    dbms_output.put_line('restore database;');

    dbms_output.put_line('switch all;');

    dbms_output.put_line('}');

end;

/

run

{

set newname for datafile 1 to '/oradata/TEST/system01.dbf' ;

set newname for datafile 2 to '/oradata/TEST/sysaux01.dbf' ;

set newname for datafile 3 to '/oradata/TEST/undotbs01.dbf' ;

set newname for datafile 4 to '/oradata/TEST/users01.dbf' ;

set newname for datafile 5 to '/oradata/TEST/test01.dbf' ;

restore database;

switch all;

}

PL/SQL procedure successfully completed.