RMAN VIEWS (WHEN NO RECOVERY CATALOG AVAILABLE) . i have provide the example as per 11gR2.
To Display the backup details of the database (Full, Incremental & Archive log backup), when the DB is not connect with the recover catalog. (Work in Mount stage)
SQL> select session_key,
to_char(start_time,'yyyy-mm-dd hh24:mi') start_time,
to_char(end_time,'yyyy-mm-dd hh24:mi') end_time,
order by session_key asc;
Below query will display the backup piece that hold the backup of archive log, datafile in the DISK or TAPE Drive.
Query to see Backed Up Archive Logs in the database (Work in Mount stage)
SQL> select recid,set_stamp,sequence#,first_change#,next_change#
Query against the V$BACKUP_PIECE view to find backup details of a particular archive log (Work in Mount stage)
SQL> select r.sequence#, p.handle from v$backup_piece p, v$backup_redolog r
where r.set_stamp = p.set_stamp and r.set_count = p.set_count
and r.sequence# = 63
Note: 63 is the sequence number.
Query against the V$BACKUP_PIECE view to find backup details of a particular datafiles (Work in Mount stage)
SQL> select d.file#, p.handle from v$backup_piece p, v$backup_datafile d where d.set_stamp = p.set_stamp and d.set_count = p.set_count and d.file# = 3
Note: 3 is the datafile number.
SQL> select table_name from dict where table_name like 'V$%RMAN%';
8 rows selected.
V$RMAN_BACKUP_JOB_DETAILSè displays details about backup jobs.
merges similar operations within an RMAN session into a single row. For example, if there are four
BACKUP DATAFILE <n>commands, three
RECOVERY COPY OF DATAFILEcommands, and one
BACKUP RECOVERY AREAcommand, this view will contain three rows - one each for BACKUP, ROLLFORWARD, and COPY_DISK_TO_TAPE operation.
èdisplays information about RMAN backup types.
SQL> select * from V$RMAN_BACKUP_TYPE;
5 DATAFILE INCR
6 DATAFILE FULL
7 DB INCR
8 RECVR AREA
9 DB FULL
V$RMAN_COMPRESSION_ALGORITHMè provides descriptions of supported compression algorithms. It is used by the RMAN client.
V$RMAN_CONFIGURATION è Information about RMAN persistent configuration settings.
V$RMAN_ENCRYPTION_ALGORITHMSè displays supported encryption algorithms. It is used by the RMAN client to validate user-requested algorithms. This view will list AES128, AES192, and AES256 encryption algorithms for the current release. The default algorithm is AES128.
displays messages reported by RMAN. This is an in-memory view and is not recorded in the controlfile. The view can hold 32768 rows.
V$RMAN_STATUSè displays the finished and on-going RMAN jobs. For on-going jobs, this view displays progress and status. The jobs which are in progress are stored only in memory while the finished jobs are stored in the controlfile