6 Replies Latest reply: Apr 17, 2012 9:10 AM by 505789 RSS

    Duplicate for standby not copying standby logs

    505789
      I am using an 11g R2 rac and I am doing a

      DUPLICATE TARGET DATABASE
      FOR STANDBY
      FROM ACTIVE DATABASE

      I have created the standby log files in primary, but they have not been copied to standby.

      Is this the normal behaviour?
        • 1. Re: Duplicate for standby not copying standby logs
          mseberg
          Hello;

          On Oracle 11 I believe this is not normal.

          There was a similar question here a week or so ago and I checked my 11 system and the standby redo was there.

          I used this command :
          duplicate target database for standby from active database NOFILENAMECHECK;
          My short notes :

          http://www.visi.com/~mseberg/standby_creation_from_active_database_using_rman.html

          Best Regards

          mseberg
          • 2. Re: Duplicate for standby not copying standby logs
            505789
            Well they were not created for me with this command.
            • 3. Re: Duplicate for standby not copying standby logs
              mseberg
              Yes, I believe cannot explain this but they are easy enough to create after the fact.

              Will post command here as insurance after I make some coffee.


              If I remember correctly you have to stop redo apply then

              Example

              alter database add standby logfile '/oracle/redo/prod1/stdby_redo03a.rdo'



              alter database recover managed standby database cancel;

              alter database add standby logfile group <n> (<filename>) size <size>;

              alter database recover managed standby database disconnect;

              h2. Gracias

              Best Regards

              mseberg

              Edited by: mseberg on Apr 5, 2012 5:44 AM

              Edited by: mseberg on Apr 5, 2012 5:51 AM

              Edited by: mseberg on Apr 5, 2012 5:53 AM
              • 4. Re: Duplicate for standby not copying standby logs
                505789
                You can create them after the standby is applying archivers?
                • 5. Re: Duplicate for standby not copying standby logs
                  505789
                  Nothing is mentioned about standby redo logs in the documentation when talking about duplicate and ASM

                  http://docs.oracle.com/cd/B28359_01/backup.111/b28270/rcmdupdb.htm#BGBEHADD

                  http://docs.oracle.com/cd/E11882_01/backup.112/e10642/rcmdupdb.htm#i1006629

                  Maybe they should always be created manually when using ASM?

                  Edited by: usersp on Apr 16, 2012 4:48 PM
                  • 6. Re: Duplicate for standby not copying standby logs
                    505789
                    I am using OMF files, this is why standby redo logs were not created as we can see in the primary alert file

                    Use the following SQL commands on the standby database to create
                    standby redo logfiles that match the primary database:
                    ALTER DATABASE ADD STANDBY LOGFILE 'srl1.f' SIZE 52428800;
                    ALTER DATABASE ADD STANDBY LOGFILE 'srl2.f' SIZE 52428800;
                    ALTER DATABASE ADD STANDBY LOGFILE 'srl3.f' SIZE 52428800;
                    ALTER DATABASE ADD STANDBY LOGFILE 'srl4.f' SIZE 52428800;
                    ALTER DATABASE ADD STANDBY LOGFILE 'srl5.f' SIZE 52428800;
                    WARNING: OMF is enabled on this database. Creating a physical
                    standby controlfile, when OMF is enabled on the primary
                    database, requires manual RMAN intervention to resolve OMF
                    datafile pathnames.
                    NOTE: Please refer to the RMAN documentation for procedures
                    describing how to manually resolve OMF datafile pathnames.