4 Replies Latest reply: Mar 12, 2013 10:23 AM by Eddie Essex RSS

    Creating DR standby from RAC to single NODE

    VIKHARAHMED
      OS and Database versions Primary:

      node1:- OEL 5.7
      node2:- OEL 5.7
      inst1:- prod1 Oracle 11.2.0.3
      inst2:- prod2 Oracle 11.2.0.3

      Standby:
      OEL 5.7
      Oracle 11.2.0.3
      NOTE:- Creating Standby on Single node.


      My scenario:
      ============

      node1:- linuxdb1
      node2:- linuxdb2
      inst1:- prod1
      inst2:- prod2

      Point1:- We have 2 node RAC with ASM disk and database is okay. Now i want to make DR on single node with ASM disk created already.
      Point2:- grid and oracle users are on RAC prod database & also same grid and oracle users on SINGLE node DR
      Point3:- Took RMAN backup from prod database ( 2 node RAC ) and copied to DR as shown below:

      RMAN>backup device type disk format '/u02/stby/%U' database plus archivelog;
      RMAN>backup device type disk format '/u02/stby/%U' current controlfile for standby;
      scp -rp /u02/stby/* oracle@10.65.50.x:/u02/stby/

      Point4:- Now when i run below command on DR ( oracle@linuxdr2 )



      [oracle@linuxdr2 stby]$ rman target sys/pwd@prod1 auxiliary /

      Recovery Manager: Release 11.2.0.3.0 - Production on Sun Mar 10 13:18:20 2013

      Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.

      connected to target database: PROD (DBID=220323208)
      connected to auxiliary database: PROD (not mounted)

      RMAN> duplicate target database for standby;

      Starting Duplicate Db at 10-MAR-13
      using target database control file instead of recovery catalog
      configuration for DISK channel 2 is ignored
      allocated channel: ORA_AUX_DISK_1
      channel ORA_AUX_DISK_1: SID=1142 device type=DISK

      contents of Memory Script:
      {
      restore clone standby controlfile;
      }
      executing Memory Script

      Starting restore at 10-MAR-13
      using channel ORA_AUX_DISK_1

      channel ORA_AUX_DISK_1: starting datafile backup set restore
      channel ORA_AUX_DISK_1: restoring control file
      channel ORA_AUX_DISK_1: reading from backup piece /u02/stby/33o464m6_1_1
      RMAN-00571: ===========================================================
      RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
      RMAN-00571: ===========================================================
      RMAN-03002: failure of Duplicate Db command at 03/10/2013 13:19:22
      RMAN-05501: aborting duplication of target database
      RMAN-03015: error occurred


      Can you please help me to resolve the issue.
      Thanks,
      Vikhar
        • 1. Re: Creating DR standby from RAC to single NODE
          CKPT
          RMAN-00571: ===========================================================
          RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
          RMAN-00571: ===========================================================
          RMAN-03002: failure of Duplicate Db command at 03/10/2013 13:19:22
          RMAN-05501: aborting duplication of target database
          RMAN-03015: error occurred
          Any errors in alert log file?
          Have you tried once again ?
          Why cant you go for RMAN duplicate from active database, If you have any concerns then enable trace of RMAN and share the information
          rman target / log=/u01/test/rman_log.txt trace=/u01/test/rmantrace.log
          • 2. Re: Creating DR standby from RAC to single NODE
            Mahir M. Quluzade
            Hi,

            Can you connect auxiliary database from RMAN with SYS username password.

            [oracle@linuxdr2 stby]$ rman target sys/pwd@prod1 auxiliary sys/pwd@<auxiliary>
            Regards
            Mahir M. Quluzade
            • 3. Re: Creating DR standby from RAC to single NODE
              CKPT
              Mahir M. Quluzade wrote:
              Hi,

              Can you connect auxiliary database from RMAN with SYS username password.

              [oracle@linuxdr2 stby]$ rman target sys/pwd@prod1 auxiliary sys/pwd@<auxiliary>
              Regards
              Mahir M. Quluzade
              OP is using below command
              RMAN> duplicate target database for standby;
              When we are using "ACTIVE DUPLICATE" then it is mandatory to use with Oracle net service, when we running traditional i think we are fine with the procedure what OP is using.
              • 4. Re: Creating DR standby from RAC to single NODE
                Eddie Essex
                Is your standby started in nomount mode?

                Are you using same filenames?

                Have you tried:

                duplicate target database for standby dorecover nofilenamecheck;

                dorecover - recover the standby database
                nofilenamecheck - allow primary and standby to have the same filenames.

                PS: Active database would have been an easier option but as you have copied all your backup files across makes very little difference now.