5 Replies Latest reply: Nov 2, 2013 2:15 AM by sb92075 RSS

    How could I find specified date of REDO log and archive REDO log ?

      we use Oracle11gr2 on win2008R2.

       

      1

      How could I find specified date of REDO log(2013/10/17,etc) and archive REDO log ?

      2

      What is the format of archive REDO log.? (zipped file ?)

        • 1. Re: How could I find specified date of REDO log and archive REDO log ?
          sb92075

          840105 wrote:

           

          we use Oracle11gr2 on win2008R2.

           

          1How could I find specified date of REDO log(2013/10/17,etc) and archive REDO log ?

          2What is the format of archive REDO log.? (zipped file ?)

           

          1) look at OS file system timestamp

          2) same as active REDO file; which is Oracle internal & proprietary.

          DBMS_LOGMNR  can be used to observe the content of both the REDO & archived REDO files.

          • 2. Re: How could I find specified date of REDO log and archive REDO log ?
            user12075536123

            1)
            select * from v$archived_log;
            select * from v$log_history;

            but there is a possibility there is no old data


            • 3. Re: How could I find specified date of REDO log and archive REDO log ?
              sb92075

              user12075536123 wrote:

               

              1)
              select * from v$archived_log;
              select * from v$log_history;

              but there is a possibility there is no old data

               

               

              below contains no filename column

               

              SQL> desc v$log_history

              Name                                      Null?    Type

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

              RECID                                              NUMBER

              STAMP                                              NUMBER

              THREAD#                                            NUMBER

              SEQUENCE#                                          NUMBER

              FIRST_CHANGE#                                      NUMBER

              FIRST_TIME                                         DATE

              NEXT_CHANGE#                                       NUMBER

              RESETLOGS_CHANGE#                                  NUMBER

              RESETLOGS_TIME                                     DATE


              there is NO data when archive mode is disabled

              • 4. Re: How could I find specified date of REDO log and archive REDO log ?
                teradata0802

                Thank you.

                I thought that I could know the only file created time and updated time from  OS file timestamp .

                How could I find REDO log file which include the specified date of redo log ?

                • 5. Re: How could I find specified date of REDO log and archive REDO log ?
                  sb92075

                  teradata0802 wrote:

                   

                  Thank you.

                  I thought that I could know the only file created time and updated time from  OS file timestamp .

                  How could I find REDO log file which include the specified date of redo log ?

                   

                  the specified date will only fall between a single file start time & updated time (which is time when the file gets filled & closed).