oracle coldbackup (offline backup)

A cold backup, also called an offline backup, is a database backup when the database is offline
and thus not accessible for updating. This is the safest way to back up because it avoids the risk
of copying data that may be in the process of being updated. However, a cold backup involve
downtime because users cannot use the database while it is being backed up.



First shutdown safely and make database consistent

go to disc where database is created


mkdir e:\backup


copy *dbf e:\backup
copy *log e:\backup
copy *ctl e:\backup

set oracle_sid=test
sqlplus / a sysdba
shutdown immediate;

del * from where data is located

sqlplus / a sysdba
pfile still exists so db will get mount


shutdown

copy e:\backup\* .

startup ;