Answer Detail: RE: Identify Datafile in Backkup Mode

GeekInterview.com > Interview Questions > Oracle > Database Administration

Print |

Question: Identify Datafile in Backkup Mode

Answer: When you execute:

alter tablespace begin backup;

How can Oracle engine can identify that the corresponding datafiles are in backupmode?

September 09, 2008 09:49:15	#2
kumarmvn	Member Since: November 2006 Total Comments: 1
RE: Identify Datafile in Backkup Mode
select * from v$backup; == in this view you can check for status,if it is ACTIVE that file is still in backup mode. Hope this helps you. Thanks Kumar

Back To Question