Oracle Backup and Recovery

Wichtige Views zu Backup and Recovery

V$ARCHIVE

This view contains information on redo log files in need of archiving. Each row provides information for one thread. This information is also available in V$LOG. Oracle recommends that you use V$LOG.

Column	Datatype	Description
GROUP#	NUMBER	Log file group number
THREAD#	NUMBER	Log file thread number
SEQUENCE#	NUMBER	Log file sequence number
CURRENT	VARCHAR2(3)	Archive log currently in use
FIRST_CHANGE#	NUMBER	First SCN stored in the current log

V$ARCHIVE_DEST (nur Oracle 8)

This view describes, for the current instance, all the archive log destinations, their current value, mode, and status.

ARCMODE

VARCHAR2(12)

Archiving mode:

MUST SUCCEED: This is a must-succeed destination
BEST-EFFORT: This is a best-effort destination

STATUS

VARCHAR2(8)

Status:

NORMAL: This destination is normal
DISABLED: This destination has been disabled

DESTINATION

VARCHAR2(256)

Destination text string

SQL> select * from V$ARCHIVE_DEST;

ARCMODE       STATUS   DESTINATION
------------ -------- -----------
MUST SUCCEED NORMAL   /opt/oracle/8.0.5/oradata/arc/LIX3
BEST-EFFORT   NORMAL   /opt/oracle/8.0.5/oradata/adm/dplx

Ende