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