Performing Oracle User-Managed Backups - OCP: Oracle Database 12c Administrator Certified Professional - page 34

TABle 1.3 Oracle Dynamic Performance Views Associated with User-Managed Backup
and Recovery

View Name Description

V$ARCHIVE The V$ARCHIVE view provides information on redo logs that

are in need of being archived.

V$ARCHIVE_DEST The V$ARCHIVE_DEST view provides information on each indi-

vidual archive-log destination. Typically this view is used for
Oracle Data Guard.

V$ARCHIVE_DEST_STATUS The V$ARCHIVE_DEST_STATUS view provides status information

on each of the individual archive-log destination directories.

V$ARCHIVE_PROCESSES The V$ARCHIVE_PROCESSES view provides information on the

different ARCH processes running on your system.

V$ARCHIVED_LOG The V$ARCHIVED_LOG view provides information on individual

archived redo logs.

V$LOG The V$LOG view provides information on the online redo log

groups.

V$LOGFILE The V$LOGFILE view provides information on specific online

redo logs.

V$LOG_HISTORY The V$LOG_HISTORY view provides historical information on

all online/archived redo logs.

Using the V$ views is easy to do, and they can tell you a lot about the status of both
online and archived redo logs, as shown in Exercise 1.2.

exeRCiSe 1.2

Putting the v$ views to Work
The V$ views are very useful when you want to find out something about your database
related to backup or recovery. In this exercise, we will look at some V$ views related to the
database online redo logs.

1. Let's look at the current redo logs that have been archived:

SQL> select name, thread#, sequence# from v$archived_log;
NAME THREAD# SEQUENCE#
--------------------------------------------- ---------- ----------
C:\ORACLE\ARCH\ORCL\ORCL_658485967_1_2.ARC 1 2