web analytics
Skip to primary content
Skip to secondary content

MemoSoup

Mix of the things I always forget

MemoSoup

Main menu

  • Home
  • About
  • Links

Tag Archives: backup

List the tablespaces in backup mode

Posted on 16/09/2009 by bigspoon
Reply

Small query to list Oracle tablespaces, that are in backup mode:

select d.tablespace_name, b.time
from dba_data_files d, v$backup b
where
d.file_id = b.FILE#
and b.STATUS = 'ACTIVE' ;

Posted in Oracle | Tagged backup, Oracle, tablespace | Leave a reply

Archives

  • March 2021
  • February 2016
  • February 2013
  • December 2012
  • May 2012
  • April 2012
  • March 2012
  • February 2012
  • January 2012
  • December 2011
  • November 2011
  • July 2011
  • April 2011
  • March 2011
  • February 2011
  • January 2011
  • December 2010
  • July 2010
  • June 2010
  • May 2010
  • April 2010
  • February 2010
  • January 2010
  • December 2009
  • November 2009
  • October 2009
  • September 2009
  • August 2009

Meta

  • Log in
Proudly powered by WordPress