To execute this, you need to logged to SQL*
Begin Backup
> alter database begin backup; Database altered.
> select file#,status from v$backup; FILE# STATUS ---------- ------------------ 1 ACTIVE 2 ACTIVE 3 ACTIVE 4 ACTIVE
All the datafiles are in backup mode now
End Backup
> alter database end backup; Database altered.
> select file#,status from v$backup; FILE# STATUS ---------- ------------------ 1 NOT ACTIVE 2 NOT ACTIVE 3 NOT ACTIVE 4 NOT ACTIVE
All the datafiles are out of backup mode now.
