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

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。