RMAN Clone Example




shutdown immediate; 



startup mount exclusive restrict; 



drop database; 





shutdown abort; 

startup nomount; 



restore controlfile from '/rman/slaps/tlaps/c-1478977222-20200109-01'; 



-- Change DB name in init to tlaps 



alter database mount; 



catalog start with '/rman/slaps/tlaps/'; 



run 

{ 

set newname for datafile   1 to '/ora/slapsdb/system_01.dbf';

set newname for datafile   2 to '/ora/slapsdb/undo_01.dbf';

set newname for datafile   3 to '/ora/slapsdb/sysaux_01.dbf';

set newname for datafile   4 to '/ora/slapsdb/users_01.dbf';

set newname for datafile   5 to '/ora/slapsdb/laps_s_01.dbf';

set newname for datafile  62 to '/ora/slapsdb/prism_m_02.dbf';

set newname for datafile  63 to '/ora/slapsdb/prism_m_03.dbf';

set newname for datafile  64 to '/ora/slapsdb/prism_m_04.dbf';

set newname for datafile  65 to '/ora/slapsdb/prism_arc_data_01.dbf';

set newname for datafile  66 to '/ora/slapsdb/prism_m_05.dbf';

set newname for tempfile   1 to '/ora/slapsdb/temp_01.dbf';

set newname for tempfile   2 to '/ora/slapsdb/temp_02.dbf';

set newname for tempfile   3 to '/ora/slapsdb/temp_03.dbf';

set newname for tempfile   4 to '/ora/slapsdb/temp_04.dbf';

restore database; 

} 



recover database; 
 


alter database open resetlogs;


shutdown immediate;


startup mount restrict; 



nid target="'/ as sysdba'" dbname=slaps setname=yes


create pfile from spfile; 



-- Change DB name in init to slaps 



shutdown immediate 



startup