set ORACLE_SID=test
set ORACLE_HOME=D:\oracle\product\10.2.0\db_1
set PATH=D:\oracle\product\10.2.0\db_1\bin;%PATH%
(Local Drive)H:
cd test\hot-backup
mkdir _bkp_%date:~7,2%-%date:~4,2%-%date:~10,4%
(Local Drive)D:
cd ORACLE_HOME
sqlplus sys/password@test as sysdba @ D:(location of yoursqlscript)backupscripts\hot_test.sql echo "end of hot backup "
-----hot_test.sql
alter database begin backup;
host copy D:oracle\product\10.2.0\oradata\test\ H:test\hot-backup\_bkp_%date:~7,2%-%date:~4,2%-%date:~10,4%
alter database backup controlfile to trace;
alter database end backup;
exit
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment