Job Seekers   Employers

dbapool: Authors | Submissions | Contact Us

Forgot password? | Sign up

Home

Discussion Forum

Articles

Interview Questions

FAQs

Scripts

Rewards

Analyzer

White Papers

Blog

Certification

Downloads

Tools

Script to perform cold backup By: Babu Uppu Sep 12 2008 Following script should be executed by dba account. This script will create batch file and will take a cold backup of your database. Shutdown and Startup will be handled by Script.   rem : rem Filename: COLDBK.SQL rem Purpose: WILL TAKE COLD BACKUP OF WHOLE DATABASE. WILL PERFORM SHUTDOWN/STARTUP AUTOMATICALLY. rem Author: Babu rem Date Submitted:12-SEP-2008 rem --------------COLDBK.SQL--------------- set term off set head off set feedback off set verify off spool c:\startcopy.bat select 'copy '||name||' c:\DBBACKUP' from v$datafile; select 'copy '||name||' c:\DBBACKUP' from v$controlfile; select 'copy '||name||' c:\DBBACKUP' from v$tempfile; select 'copy '||member||' c:\DBBACKUP' from v$logfile; spool off shutdown IMMEDIATE host c:\startcopy.bat startup host del c:\startcopy.bat set term on set head on set feedback on set verify on -------------------------------

About Us

Advertise

Terms of Use

Privacy

Newsletters

Contact Us

Home   Discussion Forum   FAQs  Articles  Jobs   Newsletters  Directory  Downloads

Our Premium Sponsor