Guys,
Below RMAN command give me the output,
Any got the idea, where this information is stored in the RMAN Catalog?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
For example: I can get the Unrecoverable operation SCN or TIMESTAMP from v$datafile.
Any idea from which RAMN Catalog view/ table the above can be obtained? Thanks.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.




Reply With Quote