9 Replies Latest reply: Apr 16, 2013 4:54 AM by Thunder2777 RSS

    ARCHIVE FILE NAME DIFFERS IN DATA GUARD 10G

    Thunder2777
      Hi All

      I have configured Data Guard on Oracle 10g (10.2.0.4) 64 bits on windows 2007 server.

      But When I see Names of archive file they are Different but their Numbers are Same as shown below

      On Primary DB side (PRMDB):

      C:\oracle\product\10.2.0\flash_recovery_area\PRMDB\ARCHIVELOG\

      Name Type Size
      ARC00003_0812811011.001 001 File 16,046 KB
      ARC00004_0812811011.001 001 File 1 KB
      ARC00005_0812811011.001 001 File 8 KB
      ARC00006_0812811011.001 001 File 623 KB

      On Standby DB side (STLDB): (on SAME / LOCAL Machine)

      D:\ORACLE\FRA\STLDB\ARCHIVELOG\

      Name Type Size
      1_3_812811011.ARC ARC File 16,046 KB
      1_4_812811011.ARC ARC File 1 KB
      1_5_812811011.ARC ARC File 8 KB
      1_6_812811011.ARC ARC File 623 KB


      Any Comments

      Regards
      Thunder2777
        • 1. Re: ARCHIVE FILE NAME DIFFERS IN DATA GUARD 10G
          Seberg
          You will get better results if you read this before posting:

          https://wikis.oracle.com/display/Forums/Forums+FAQ
          • 2. Re: ARCHIVE FILE NAME DIFFERS IN DATA GUARD 10G
            Mahir M. Quluzade
            Thunder2777 wrote:
            Hi All

            I have configured Data Guard on Oracle 10g (10.2.0.4) 64 bits on windows 2007 server.

            But When I see Names of archive file they are Different but their Numbers are Same as shown below

            On Primary DB side (PRMDB):

            C:\oracle\product\10.2.0\flash_recovery_area\PRMDB\ARCHIVELOG\

            Name Type Size
            ARC00003_0812811011.001 001 File 16,046 KB
            ARC00004_0812811011.001 001 File 1 KB
            ARC00005_0812811011.001 001 File 8 KB
            ARC00006_0812811011.001 001 File 623 KB

            On Standby DB side (STLDB): (on SAME / LOCAL Machine)

            D:\ORACLE\FRA\STLDB\ARCHIVELOG\

            Name Type Size
            1_3_812811011.ARC ARC File 16,046 KB
            1_4_812811011.ARC ARC File 1 KB
            1_5_812811011.ARC ARC File 8 KB
            1_6_812811011.ARC ARC File 623 KB


            Any Comments

            Regards
            Thunder2777
            Hi,

            As you know, transport service is not transport archived file physically,
            Transport service transport rode content from redo buffer or archived redo log via LNS (Log Network Server).
            On standby side receive generated redo from primary RFS (Remote File Server) . RFS write all redo to standby log files.



            This files different, because, there running different threads and Different ARC processes and log_archive_format is different, too.
            Same this files only Sequences : 3, 4, 5, 6 in your case.

            Regards
            Mahir M. Quluzade
            http://www.mahir-quluzade.com
            • 3. Re: ARCHIVE FILE NAME DIFFERS IN DATA GUARD 10G
              Thunder2777
              Thanks Mahir

              It means my Log Achives are Right as Both have same Sequence No
              but different Naming Architecture.

              Regards
              Thunder2777
              • 4. Re: ARCHIVE FILE NAME DIFFERS IN DATA GUARD 10G
                Hemant K Chitale
                different Naming Architecture
                Look at the LOG_ARCHIVE_FORMAT parameter that defines the file name format. The Primary and Standby can have different values.


                Hemant K Chitale
                • 5. Re: ARCHIVE FILE NAME DIFFERS IN DATA GUARD 10G
                  Thunder2777
                  Thanks Hemant K Chitale

                  I have checked Both Format as follows and Change Them:

                  LOG Format at Primary DB:

                  SQL> show parameter LOG_ARCHIVE_FORMAT

                  NAME TYPE VALUE
                  ------------------------------------ ----------- ------------------------------
                  log_archive_format string ARC%S_%R.%T

                  SQL> alter system set LOG_ARCHIVE_FORMAT='arc_s%S_r%R_t%T.arc' scope=spfile;               System altered.

                  LOG Format at Standby DB

                  SQL> show parameter LOG_ARCHIVE_FORMAT

                  NAME TYPE VALUE
                  ------------------------------------ ----------- ------------------------------
                  log_archive_format string %t_%s_%r.arc

                  SQL> alter system set LOG_ARCHIVE_FORMAT='arc_s%S_r%R_t%T.arc' scope=spfile; System altered.

                  Further comments

                  Regards
                  Thunder2777
                  • 6. Re: ARCHIVE FILE NAME DIFFERS IN DATA GUARD 10G
                    Thunder2777
                    Well I have the Archive Format in SPFILEs of both Database as follow

                    *.LOG_ARCHIVE_FORMAT='ARC%S_%R_%T.ARC'

                    Now I am getting Archive Files like that

                    ARC_S00016_R0812811011_T001.ARC

                    IS it Right or Not? and will the Database will use it for Recovery or not as I have Changed the Default
                    format?

                    Regards
                    Thunder2777
                    • 7. Re: ARCHIVE FILE NAME DIFFERS IN DATA GUARD 10G
                      Hemant K Chitale
                      Oracle can use any (non-default) file name format. It stores the actual file name of each archivelog.

                      Hemant K Chitale
                      • 8. Re: ARCHIVE FILE NAME DIFFERS IN DATA GUARD 10G
                        Mahir M. Quluzade
                        Thunder2777 wrote:
                        Well I have the Archive Format in SPFILEs of both Database as follow

                        *.LOG_ARCHIVE_FORMAT='ARC%S_%R_%T.ARC'

                        Now I am getting Archive Files like that

                        ARC_S00016_R0812811011_T001.ARC

                        IS it Right or Not? and will the Database will use it for Recovery or not as I have Changed the Default
                        format?

                        Regards
                        Thunder2777
                        It is not problem for recovery of database archived log file name.
                        If archived log file is registered, then you can use this archived log
                        for recovery.


                        Thanks
                        Mahir M. Quluzade
                        • 9. Re: ARCHIVE FILE NAME DIFFERS IN DATA GUARD 10G
                          Thunder2777
                          Thanks to Both of you.

                          Regards
                          Thuder2777