Re: Backup mode information in data dictionary

Moorthy N. Rekapalli wrote:
-

• Hello There,
  -
  
• Where in the data dictionary that I will find that the tablespace
• is in backup mode. I thought that the STATUS field of the
• DBA_TABLESPACES will show that information. I issued
  -
  
• SQLDBA> ALTER TABLESPACE USER_DATA BEGIN BACKUP;
  -
  
• After this, the status of the user_data tablespace is online. From
• this information, how can I tell that the tablespace is in backup
• mode.
  -
  
• THANKS IN ADVANCE.
  -
  
• Moorthy

Look at V$BACKUP.

-- 
Bob Swisshelm
Eli Lilly and Company
swisshelm_at_lilly.com