DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: V$BACKUP view - CHANGE#, TIME columns

  1. #1
    Join Date
    Jan 2000
    Location
    Chester, England.
    Posts
    818
    Looking at my V$BACKUP view & I noticed that the 3 datafiles in my index TBS had entries in the CHANGE# & TIEM columns - can anyone tell me what this means???

    1 SELECT b.file#, b.status, b.change#, b.time, d.name
    2 FROM v$backup b, v$datafile d
    3 WHERE b.file# = d.file#
    4* ORDER BY d.name
    admslive> /

    FILE# STATUS CHANGE# TIME NAME
    ---------- ------------------ ---------- --------- ----------------------------------------
    20 NOT ACTIVE 0 C:\ORACLE\ADMS\LIVE\ACTAB_03LIVE.DBF
    5 NOT ACTIVE 1879585 05-MAR-02 C:\ORACLE\ADMS\LIVE\AC_IND01LIVE.DBF
    10 NOT ACTIVE 1879585 05-MAR-02 C:\ORACLE\ADMS\LIVE\AC_IND02LIVE.DBF
    17 NOT ACTIVE 1879585 05-MAR-02 C:\ORACLE\ADMS\LIVE\AC_IND03LIVE.DBF
    7 NOT ACTIVE 0 C:\ORACLE\ADMS\LIVE\AC_JN_IND01LIVE.DBF
    11 NOT ACTIVE 0 C:\ORACLE\ADMS\LIVE\AC_JN_IND02LIVE.DBF
    13 NOT ACTIVE 0 C:\ORACLE\ADMS\LIVE\AC_JN_IND03LIVE.DBF
    15 NOT ACTIVE 0 C

  2. #2
    Join Date
    Jul 2001
    Location
    Slovenia
    Posts
    422
    SCN and timestamp of their last backup.

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