connect SYS/pwd as SYSDBA spool orashutsql.log spool oraccseacopysql.log select 'copy '||file_name|| (replace(file_name,'E:\ORACLE\ORADATA\CCSEA\',' E:\BACKUPS\ORADATA\CCSEA\')) from dba_data_files union select 'copy '||member|| (replace(member,'E:\ORACLE\ORADATA\CCSEA\',' E:\BACKUPS\ORADATA\CCSEA\')) from v$logfile union select 'copy '||name||' '|| (replace(name,'F:\ORACLE\ORADATA\CCSEA\','E:\BACKUPS\ORADATA\CCSEA\')) from v$controlfile; set echo on alter database backup controlfile to trace; shutdown immediate net stop OracleStartccsea net stop OracleServiceCCSEA COPY E:\ORACLE\ORADATA\CCSEA\CONTROL01.CTL >> E:\ORACLE\ORADATA\CCSEA\BACKUP\CONTROL01.CTL COPY E:\ORACLE\ORADATA\CCSEA\CONTROL02.CTL >> E:\ORACLE\ORADATA\CCSEA\BACKUP\CONTROL02.CTL COPY E:\ORACLE\ORADATA\CCSEA\CONTROL03.CTL >> E:\ORACLE\ORADATA\CCSEA\BACKUP\CONTROL03.CT spool off exit