Copy Datafile from one diskgroup to another using RMAN


TAKE TABLESPACES OFFLINEset echo on
set timing on
spool 1_offline_tblsp.lst
alter tablespace POL_IMG_2006_Q2 offline;
alter tablespace ATTUNITY_Q2 offline;
alter tablespace POL_XML_2006_Q2 offline;
alter tablespace COM_XML_2006_Q2 offline;
spool off

COPY DATAFILE TO ALTERNATE DISKGROUP USING RMAN
copy datafile '+DG_DATA/DBDOC/datafile/attunity_q2.330.594123977' to '+DG_EDOC_PD501';
copy datafile '+DG_DATA/DBDOC/datafile/attunity_q2.384.594123991' to '+DG_EDOC_PD501';
copy datafile '+DG_DATA/DBDOC/datafile/attunity_q2.479.594124003' to '+DG_EDOC_PD501';
copy datafile '+DG_DATA/DBDOC/datafile/attunity_q2.486.594124013' to '+DG_EDOC_PD501';
copy datafile '+DG_DATA/DBDOC/datafile/com_xml_2006_q2.625.594124423' to '+DG_EDOC_PD501';
copy datafile '+DG_DATA/DBDOC/datafile/pol_img_2006_q2.420.593888097' to '+DG_EDOC_PD501';
copy datafile '+DG_DATA/DBDOC/datafile/pol_img_2006_q2.419.593894551' to '+DG_EDOC_PD501';
RENAME DATAFILE USING SQLPLUSalter database rename file '+DG_DATA/DBDOC/datafile/attunity_q2.330.594123977'  to '<new location>';
alter database rename file '+DG_DATA/DBDOC/datafile/attunity_q2.384.594123991'  to '<new location>';
alter database rename file '+DG_DATA/DBDOC/datafile/attunity_q2.479.594124003'  to '<new location>';
alter database rename file '+DG_DATA/DBDOC/datafile/attunity_q2.486.594124013'  to '<new location>';
alter database rename file '+DG_DATA/DBDOC/datafile/com_xml_2006_q2.625.594124423'  to '<new location>';
alter database rename file '+DG_DATA/DBDOC/datafile/pol_img_2006_q2.420.593888097'  to '<new location>';
alter database rename file '+DG_DATA/DBDOC/datafile/pol_img_2006_q2.419.593894551'  to '<new location>';

ONLINE THE TABLESPACES AFTER VERIFICATION
spool 5_online_tblsp.lst
alter tablespace POL_IMG_2006_Q2 online;
alter tablespace ATTUNITY_Q2 online;
alter tablespace POL_XML_2006_Q2 online;
alter tablespace COM_XML_2006_Q2 online;
spool off


No comments:

Post a Comment