Oracle Database Begin & End Backup

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.

SHARE

sangeethakumar

• 
• 
• 
• 
•