오라클

rman set newnname 생성 PL/SQL

pat98 2018. 7. 6. 14:26

- 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.