24.Oracle杂记——Oracle常用动态视图v$logfile

视图v$logfile有关实例重置日志组文件名及其位置的信息   

描述如下:

sys@PDB1> desc v$logfile;

 Name                                                                                                     Null?         Type

 ------------------------------------------------------------- ------------------------------------

 GROUP#                                                                                                                           NUMBER

 STATUS                                                                                                                            VARCHAR2(7)

 TYPE                                                                                                                                    VARCHAR2(7)

 MEMBER                                                                                                                         VARCHAR2(513)

 IS_RECOVERY_DEST_FILE                                                                                                            VARCHAR2(3)

 CON_ID                                                                                                                            NUMBER

各列含义描述如下:

GROUP#                  :日志组号

 STATUS                :日志组状态

 TYPE:日志文件类型

 MEMBER:REDO日志成员名字(日志文件具体路径)

 IS_RECOVERY_DEST_FILE:文件创建在 fastrecovery area中或否?

 CON_ID:包含数据的容器ID。