ora

REDOログファイルの場所

SQL> select log.group#,log.status,logfile.member from v$log log,v$logfile logfile where log.group#=logfile.group#;
    GROUP# STATUS           MEMBER

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

         3 INACTIVE         C:\APP\XXXX\ORADATA\TE01\REDO03.LOG

         2 INACTIVE         C:\APP\XXXX\ORADATA\TE01\REDO02.LOG

         1 CURRENT          C:\APP\XXXX\ORADATA\TE01\REDO01.LOG
SQL>

SQL> desc v$log

 名前                                      NULL?    型

 -------------------------------------------------------------------------------
 GROUP#                                             NUMBER

 THREAD#                                            NUMBER

 SEQUENCE#                                          NUMBER

 BYTES                                              NUMBER

 MEMBERS                                            NUMBER

 ARCHIVED                                           VARCHAR2(3)

 STATUS                                             VARCHAR2(16)

 FIRST_CHANGE#                                      NUMBER

 FIRST_TIME                                         DATE
SQL> desc v$logfile

 名前                                      NULL?    型

 -------------------------------------------------------------------------------
 GROUP#                                             NUMBER

 STATUS                                             VARCHAR2(7)

 TYPE                                               VARCHAR2(7)

 MEMBER                                             VARCHAR2(513)

 IS_RECOVERY_DEST_FILE                              VARCHAR2(3)