3 Replies Latest reply: Jun 12, 2014 1:58 PM by mseberg RSS

    duplicate active database to standby creates redolog in FRA

    user9056222

      I have a 11.2.0.1/x86-64 Linux setup to test. There are 2 servers db101 and db102 with identical directory structure

      Now when i try to duplicate the database for standby, i have my online and standby redo files getting created in the destination FRA. Standby works properly, but i don't understand why redo logs alone are created in FRA?

      What am I missing here?

       

      In the source

       

      MEMBER

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

      /oradata1/db101/redo1a.log

      /oradata1/db101/redo2a.log

      /oradata1/db101/redo1as.log

      /oradata1/db101/redo2as.log

       

       

      SQL> select name from v$datafile;

       

       

      NAME

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

      /oradata1/db101/system01.dbf

      /oradata1/db101/sysaux01.dbf

      /oradata1/db101/undotbs01.dbf

      /oradata2/db101/users01.dbf

       

      In destination standby

       

      SQL> select name from v$datafile;

       

       

      NAME

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

      /oradata1/db101/system01.dbf

      /oradata1/db101/sysaux01.dbf

      /oradata1/db101/undotbs01.dbf

      /oradata2/db101/users01.dbf

       

       

       

      SQL> select member from v$logfile;

       

       

      MEMBER

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

      /orafra1/db101/DB101S/onlinelog/o1_mf_1_9sh2g20f_.log

      /orafra1/db101/DB101S/onlinelog/o1_mf_2_9sh2g3fx_.log

      /orafra1/db101/DB101S/onlinelog/o1_mf_3_9sh2g55o_.log

      /orafra1/db101/DB101S/onlinelog/o1_mf_4_9sh2g61c_.log

       

      Duplication command is

       

      DUPLICATE TARGET DATABASE

        FOR STANDBY

        FROM ACTIVE DATABASE

        DORECOVER

        SPFILE

          SET db_unique_name='DB101S' COMMENT 'Is standby'

          SET LOG_ARCHIVE_DEST_2='SERVICE=db101 ASYNC VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=DB101'

          SET FAL_SERVER='DB101' COMMENT 'Is primary'

        NOFILENAMECHECK;