Tuesday, 7 August 2012

How to backup mode enable/disable

ALTER DATABASE BEGIN BACKUP; -- to enter the backup mode.

select file#,status from v$backup;
FILE# STATUS
---------- ------------------
1 ACTIVE
2 ACTIVE
3 ACTIVE
4 ACTIVE

All the data files are in backup mode now


ALTER DATABASE END BACKUP; -- to exit from the backup mode.


select file#,status from v$backup;
FILE# STATUS
---------- ------------------
1 NOT ACTIVE
2 NOT ACTIVE
3 NOT ACTIVE
4 NOT ACTIVE

All the data files are out of backup mode now.

No comments:

Post a Comment