5 Replies Latest reply on Feb 22, 2013 3:46 AM by user10955371

    RMAN Duplicate looking for auxiliary archives

    user10955371
      Hi Gurus,

      I'm facing a strange situation while duplicating my LIVE db to TEST db. Please see the attached TEST db alert log file.

      ****************************************************************************
      Tue Jan 22 22:44:04 GMT 2013
      alter database recover logfile '/u99/oradata/RLTEST/archive/RLTEST_1_211096_750533676.dbf'
      Tue Jan 22 22:44:04 GMT 2013
      Media Recovery Log /u99/oradata/RLTEST/archive/RLTEST_1_211096_750533676.dbf
      ORA-279 signalled during: alter database recover logfile '/u99/oradata/RLTEST/archive/RLTEST_1_211096_750533676.dbf'...
      Tue Jan 22 22:44:05 GMT 2013
      alter database recover logfile '/u99/oradata/RLTEST/archive/RLTEST_1_211097_750533676.dbf'
      Tue Jan 22 22:44:05 GMT 2013
      Media Recovery Log /u99/oradata/RLTEST/archive/RLTEST_1_211097_750533676.dbf
      ORA-279 signalled during: alter database recover logfile '/u99/oradata/RLTEST/archive/RLTEST_1_211097_750533676.dbf'...
      Tue Jan 22 22:44:06 GMT 2013
      alter database recover logfile '/u99/oradata/RLTEST/archive/RLTEST_1_211098_750533676.dbf'
      Tue Jan 22 22:44:06 GMT 2013
      Media Recovery Log /u99/oradata/RLTEST/archive/RLTEST_1_211098_750533676.dbf
      ORA-279 signalled during: alter database recover logfile '/u99/oradata/RLTEST/archive/RLTEST_1_211098_750533676.dbf'...
      Tue Jan 22 22:44:07 GMT 2013
      alter database recover logfile '/u99/oradata/RLTEST/archive/RLTEST_1_211099_750533676.dbf'
      Tue Jan 22 22:44:07 GMT 2013
      Media Recovery Log /u99/oradata/RLTEST/archive/RLTEST_1_211099_750533676.dbf
      ORA-279 signalled during: alter database recover logfile '/u99/oradata/RLTEST/archive/RLTEST_1_211099_750533676.dbf'...
      Tue Jan 22 22:44:08 GMT 2013
      alter database recover logfile '/u99/oradata/RLLIVE/archive/RLLIVE_1_211100_750533676.dbf'
      Tue Jan 22 22:44:08 GMT 2013
      Media Recovery Log /u99/oradata/RLLIVE/archive/RLLIVE_1_211100_750533676.dbf
      ORA-279 signalled during: alter database recover logfile '/u99/oradata/RLLIVE/archive/RLLIVE_1_211100_750533676.dbf'...
      Tue Jan 22 22:44:09 GMT 2013
      alter database recover logfile '/u99/oradata/RLLIVE/archive/RLLIVE_1_211101_750533676.dbf'
      Tue Jan 22 22:44:09 GMT 2013
      Media Recovery Log /u99/oradata/RLLIVE/archive/RLLIVE_1_211101_750533676.dbf
      ORA-279 signalled during: alter database recover logfile '/u99/oradata/RLLIVE/archive/RLLIVE_1_211101_750533676.dbf'...
      Tue Jan 22 22:44:10 GMT 2013
      alter database recover logfile '/u99/oradata/RLLIVE/archive/RLLIVE_1_211102_750533676.dbf'
      Tue Jan 22 22:44:10 GMT 2013
      Media Recovery Log /u99/oradata/RLLIVE/archive/RLLIVE_1_211102_750533676.dbf
      ORA-279 signalled during: alter database recover logfile '/u99/oradata/RLLIVE/archive/RLLIVE_1_211102_750533676.dbf'...
      Tue Jan 22 22:44:11 GMT 2013
      alter database recover logfile '/u99/oradata/RLLIVE/archive/RLLIVE_1_211103_750533676.dbf'
      Tue Jan 22 22:44:11 GMT 2013
      Media Recovery Log /u99/oradata/RLLIVE/archive/RLLIVE_1_211103_750533676.dbf
      ORA-279 signalled during: alter database recover logfile '/u99/oradata/RLLIVE/archive/RLLIVE_1_211103_750533676.dbf'...
      Tue Jan 22 22:44:12 GMT 2013
      alter database recover logfile '/u99/oradata/RLLIVE/archive/RLLIVE_1_211104_750533676.dbf'
      Tue Jan 22 22:44:12 GMT 2013
      Media Recovery Log /u99/oradata/RLLIVE/archive/RLLIVE_1_211104_750533676.dbf
      ORA-279 signalled during: alter database recover logfile '/u99/oradata/RLLIVE/archive/RLLIVE_1_211104_750533676.dbf'...
      Tue Jan 22 22:44:12 GMT 2013
      ----------------------------------------------------------------------------------------------------------------------

      The snippet begining is looking for archives from TEST db (which I'm duplicating) followed by LIVE db archives.

      Can somebody please clarify me on this as why my duplicate command applying archives of TEST (Auxiliary) instance.

      Regards,
      Kumar
        • 1. Re: RMAN Duplicate looking for auxiliary archives
          mseberg
          Kumar;

          Welcome to the Forums!

          What would help is if you can provided additional details without providing so much detail it takes forever to read. How about these for starters :

          Full Oracle version Ex 11.2.0.2
          OS version
          Exact duplicate command you are using.
          Type of Duplicate you are doing. Is it an active duplicate or did you move a backup to the other server? How was the backup taken if yes?
          Short purpose of duplicate. Is it a one time setup of test or do you plan to refresh using duplicate often?

          Generally your error is caused by archiveLog covering that SCN is not included in the backup that is available.

          Best Regards

          mseberg
          • 2. Re: RMAN Duplicate looking for auxiliary archives
            TSharma-Oracle
            Did you maually copy your archive logs in this test location?
            Your Duplicate command will always look for the archives under the location mentioned in your spfile's archive_log_dest parameter. Check your archive_file_dest parameter in spfile.
            • 3. Re: RMAN Duplicate looking for auxiliary archives
              user10955371
              Hi mseberg,

              Sorry..missed to provide the requried details.
              Oracle 10205
              OS Solaris 5.10

              Duplicate command snippet:
              run{
              allocate auxiliary channel;
              set newname for file 1 to '';
              nofilenamecheck;
              set until sequence <>;
              duplicate target database to RLTEST;
              }

              restoring/duplicating is happening fine and while recovering it's looking for RLTEST archives which are not supposed to be along with RLLIVE.
              Backups have been copied to remote (TEST) server and it's a frequent.

              If my sequence is not in archives, then rman will apply to the last available archives from LIVE to TEST. But in this case, it's looking for TEST archives as well.
              Please see the alert log snippet provided that media recovery is applying TEST archives then LIVE archives.

              my doubt is whether rman tries to implicitiy catalog the existing old archives on the disk or change the scn to latest recoverable ( this should be for restoring the database) or during duplicate also.

              regards,
              kumar
              • 4. Re: RMAN Duplicate looking for auxiliary archives
                mseberg
                Kumar;

                OK, thanks for the additional details.
                my doubt is whether rman tries to implicitiy catalog the existing old archives on the disk or change the scn to latest recoverable ( this should be for restoring the database) or during duplicate also.
                I no longer have an Oracle 10 database to test this. When I did I would move the current archive to the target server.

                While I cannot answer "implicitiy catalog" question, I'm thinking the worse thing that can happen is oracle will bark harmlessly.

                If your goal is to refresh a test system I have step by step for doing that here :

                http://www.visi.com/~mseberg/rman/restore_database_without_catalog.html

                You can run this process over and over. Just shutdown the remote database and rerun.

                Best Regards

                mseberg
                • 5. Re: RMAN Duplicate looking for auxiliary archives
                  user10955371
                  Thank you mseberg,

                  We have the script to refresh without catalog. But this is the first time we came across such a situation that you might see in alert log.
                  Just curious to know why oracle is looking for recent archives or auxiliary after duplicating?
                  Is it manadatory to remove any files existing on the disk before duplicating or restoring a database (controlfile/archive file/backup of archives/ etc....).


                  Regards,
                  Kumar