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.