SELECT t.name AS TB_NAME, d.file# as DFILEID, d.name AS DF_NAME, b.status
FROM V$DATAFILE d, V$TABLESPACE t, V$BACKUP b
WHERE d.TS#=t.TS#
AND b.FILE#=d.FILE#
AND b.STATUS='ACTIVE'
Over all 17+ years IT Experience as Principal/Sr. Database Administrator / Golden gate Expert / ODI, OBIEE, WEBLOGIC admin / DevOps/SRE and Architect progressively responsible positions in diversified and very large production and development environments in various domains and vast experience in database administration, coding/programing, performance engineering and software cost optimization.
Monday, April 27, 2009
DB Files in backup mode
To verify which datafiles are currently included in a tablespace that have been placed in backup mode:
Labels:
Dbfiles
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment