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.
Tuesday, 7 August 2012
Subscribe to:
Post Comments (Atom)
0 comments:
Post a Comment