tablespace in backup mode???
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: tablespace in backup mode???

  1. #1
    Join Date
    Oct 2000
    Posts
    103
    If you need to check to see if a tablespace is still in backup mode ( alter tablespace tablespace_name begin backup), do you check by looking at status in dba_tablespaces?

    thanks
    SM

  2. #2
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    select df.name, b.status
    from v$backup b, v$datafile df
    where df.file#=b.file#

    will give you the datafile and whether it is being backed up or not (in backup mode). "NOT ACTIVE" means that the tablespace is not in backup mode, where "ACTIVE" means that it is.
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width