-- Title : [ORA10g] Backup on running Archive Log Mode (Online Backup)
-- Reference : 오라클 스터디 김0오
-- Key word : oracle 아카이브 모드 백업 archive mode backup online backup
****************************************************************************************************************/
/*************************
-- Tablespace Backup
*************************/
-- set backup mode
> alter
tablespace users begin backup;
-- copy data files
$ cp /u01/oradata/ORA817/users01.dbf /home/oracle/backup/
-- confirm backup mode file
> select d.file_name,
d.tablespace_name, v.*
from v$backup v,
dba_data_files d
where
d.file_id = v.file#;
-- release backup mode
> alter
tablespace users end backup;
-- log switching(not mandatory)
> alter system switch logfile;
/*************************
-- Control file Backup
*************************/
-- using 'alter database~'
> alter database backup controlfile to '/................./ctl01.bak';
-- using trace file
> alter database backup controlfile to trace;