Aug 13, 2008

Backing up data files

Backing up data files

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



ALTER TABLESPACE ts1 BEGIN BACKUP;

<<>>

ALTER TABLESPACE ts1 END BACKUP;

/* control file backup */

ALTER DATABASE BACKUP CONTROLFILE TO 'filename' REUSE;

No comments:

Post a Comment

Popular Posts