Cold backup in Oracle Database with Example

Backing up data files

A "cold" backup is the most widely used method for backing up Oracle data.

ALTER TABLESPACE ts1 BEGIN BACKUP;

   << backup files, within O/S >>

ALTER TABLESPACE ts1 END BACKUP;

/* control file backup */

ALTER DATABASE BACKUP CONTROLFILE TO 'filename' REUSE;