Rman Unrecoverable
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: Rman Unrecoverable

Hybrid View

  1. #1
    Join Date
    Apr 2001
    Location
    Bangalore, India
    Posts
    727

    Rman Unrecoverable

    Guys,

    Below RMAN command give me the output,
    Code:
    RMAN> report unrecoverable;
    
    Report of files that need backup due to unrecoverable operations
    File Type of Backup Required Name
    ---- ----------------------- -----------------------------------
    4    full                    D:\ORACLE\ORADATA\TEST10G\USERS01.DBF
    Any got the idea, where this information is stored in the RMAN Catalog?

    For example: I can get the Unrecoverable operation SCN or TIMESTAMP from v$datafile.
    Code:
    SQL> select file#,UNRECOVERABLE_CHANGE# from v$datafile;
    
         FILE# UNRECOVERABLE_CHANGE#
    ---------- ---------------------
             1                     0
             2                     0
             3                     0
             4               7014659
             5                     0
             6                     0
             7                     0
             8                     0
    
    8 rows selected.
    Any idea from which RAMN Catalog view/ table the above can be obtained? Thanks.
    Thomas Saviour(royxavier@yahoo.com)
    Technical Lead (Databases)
    Thomson Reuters (Markets)

    http://ora600tom.wordpress.com/

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,331
    doesnt it get that from the database and not the catalog (i.e. not stored in the catalog)

  3. #3
    Join Date
    Apr 2001
    Location
    Bangalore, India
    Posts
    727
    Thanks.

    So are you trying to say that "report unrecoverable" is fetching from the TARGET database and not from the catalog?
    Thomas Saviour(royxavier@yahoo.com)
    Technical Lead (Databases)
    Thomson Reuters (Markets)

    http://ora600tom.wordpress.com/

  4. #4
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,331
    Im saying that might certainly be the case, ill research it a lil more

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