Oracle8i Reference
Release 2 (8.1.6)
Part Number A76961-01

Library
Product
Contents
Index

Go to previous page Go to beginning of chapter Go to next page

Dynamic Performance (V$) Views, 118 of 179

V$RECOVER_FILE

This view displays the status of files needing media recovery.

Column  Datatype  Description 

FILE# 

NUMBER 

File identifier number 

ONLINE 

VARCHAR2 

Online status: ONLINE, OFFLINE 

ERROR  

VARCHAR2  

Why the file needs to be recovered: NULL if reason unknown, or OFFLINE NORMAL if recovery not needed 

CHANGE# 

NUMBER 

SCN where recovery must start 

TIME 

DATE 

Time of SCN when recovery must start 

Go to previous page Go to beginning of chapter Go to next page
Oracle
Copyright © 1996-2000, Oracle Corporation.
All Rights Reserved.

Library
Product
Contents
Index