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.

doesnt it get that from the database and not the catalog (i.e. not stored in the catalog)

Thanks.

So are you trying to say that "report unrecoverable" is fetching from the TARGET database and not from the catalog?

Im saying that might certainly be the case, ill research it a lil more