HOT BACKUP and COLD BACKUP

HOT BACKUP and COLD BACKUP

HOT Backup:= without shutiing down DB we can do this

Alter tablespace users begin backup;
---copy datafiles on OS level

Alter tablespace users end backup;


select file_name from dba_data_file where table_space_name='USERS';

ALTER TABLESPACE USERS BEGIN BACKUP;
HOST
copy src dest
alter tablespace users end backup;


COLD BACKUP:= shutdown db first

select file_name from dba_data_files;
select 'cp'::filename ::'c:\oracle\pro\admin\ from dba_data_files;
set lines 130

spool mycopy.bat/
spool off