11 Replies Latest reply: Jan 4, 2013 3:47 AM by 898191 RSS

    Issue in configuring Standby Database from Active database in 11g by RMAN

    898191
      POSTED THE SAME IN DATA GUARD CATEGORY UNABLE TO DELETE

      Hi All,

      I am facing issue in creating the standby database from Active database using RMAN and getting the below issue after i executed the duplicate command.

      Version of Database:11g(11.2.0.1.0)
      Operating System:Linux 5
      Error:
      RMAN-00571: ===========================================================
      RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
      RMAN-00571: ===========================================================
      RMAN-03002: failure of Duplicate Db command at 12/21/2012 17:26:52
      RMAN-03015: error occurred in stored script Memory Script
      RMAN-04006: error from auxiliary database: ORA-12514: TNS:listener does not currently know of service requested in connect descriptor

      Primary Database Entries:

      Tnsentry:

      SONYPRD =
      (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.20.131)(PORT = 1521))
      (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = sonyprd.localdomain)(UR=A)
      )
      )

      SONYPRDSTBY =
      (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.20.132)(PORT = 1521))
      (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = sonyprdstby)(UR=A)
      )
      )

      Listner Entry:
      SID_LIST_SONYPRD =
      (SID_LIST =
      (SID_DESC =
      (SID_NAME = PLSExtproc)
      (ORACLE_HOME = /u01/app/oracle/product/11.2.0/dbhome_1)
      (PROGRAM = extproc)
      )
      (SID_DESC =
      (SID_NAME = SONYPRD)
      (GLOBAL_DBNAME = SONYPRD)
      )
      )


      Auxiliary Details:

      Tns Entry:

      SONYPRD =
      (DESCRIPTION =
      # (ADDRESS = (PROTOCOL = TCP)(HOST = oracle11g.localdomain)(PORT = 1521))
      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.20.131)(PORT = 1521))
      (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = sonyprd.localdomain)
      )
      )

      SONYPRDSTBY =
      (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.20.132)(PORT = 1521))
      (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = sonyprdstby)(UR=A)
      )
      )

      Listener Entry in auxiliary:

      SID_LIST_SONYPRDSTBY =
      (SID_LIST =
      (SID_DESC =
      (GLOBAL_DBNAME = SONYPRDSTBY)
      (ORACLE_HOME = /u01/app/oracle/product/11.2.0/dbhome_1)
      (SID_NAME = SONYPRDSTBY)
      )
      )

      TNSPING from Primary DB:
      [oracle@oracle11g ~]$ tnsping sonyprdstby

      TNS Ping Utility for Linux: Version 11.2.0.1.0 - Production on 21-DEC-2012 17:39:28

      Copyright (c) 1997, 2009, Oracle. All rights reserved.

      Used parameter files:
      /u01/app/oracle/product/11.2.0/dbhome_1/network/admin/sqlnet.ora

      Used TNSNAMES adapter to resolve the alias
      Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.20.132)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = sonyprdstby)(UR=A)))
      OK (0 msec)

      TNSPING from Auxuliary server

      [oracle@oracle11gstby ~]$ tnsping sonyprd

      TNS Ping Utility for Linux: Version 11.2.0.1.0 - Production on 21-DEC-2012 17:40:19

      Copyright (c) 1997, 2009, Oracle. All rights reserved.

      Used parameter files:

      Used TNSNAMES adapter to resolve the alias
      Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.20.131)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = sonyprd.localdomain)))
      OK (10 msec)


      Script Used for duplicate:

      run {
      allocate channel prmy1 type disk;
      allocate channel prmy2 type disk;
      allocate channel prmy3 type disk;
      allocate channel prmy4 type disk;
      allocate auxiliary channel stby type disk;

      duplicate target database for standby from active database
      spfile
      parameter_value_convert 'sonyprd','sonyprdstby'
      set db_unique_name='sonyprdstby'
      set db_file_name_convert='/sonyprd/','/sonyprdstby/'
      set log_file_name_convert='/sonyprd/','/sonyprdstby/'
      set control_files='/u01/app/oracle/oradata/control01.ctl'
      set log_archive_max_processes='5'
      set fal_client='sonyprdstby'
      set fal_server='sonyprd'
      set standby_file_management='AUTO'
      set log_archive_config='dg_config=(sonyprd,sonyprdstby)'
      set log_archive_dest_2='service=sonyprd ASYNC valid_for=(ONLINE_LOGFILE,PRIMARY_ROLE) db_unique_name=sonyprd'
      ;
      }

      Tried the script from both Primary and auxiliary but no luck

      [oracle@oracle11gstby admin]$ rman target sys/welcome@sonyprd auxiliary sys/*****@sonyprdstby

      Recovery Manager: Release 11.2.0.1.0 - Production on Fri Dec 21 17:26:24 2012

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

      connected to target database: SONYPRD (DBID=3131093559)
      connected to auxiliary database: SONYPRD (not mounted)

      Listener Status from primary:

      [oracle@oracle11g ~]$ lsnrctl status

      LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 21-DEC-2012 18:08:56

      Copyright (c) 1991, 2009, Oracle. All rights reserved.

      Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
      STATUS of the LISTENER
      ------------------------
      Alias LISTENER
      Version TNSLSNR for Linux: Version 11.2.0.1.0 - Production
      Start Date 20-DEC-2012 17:42:17
      Uptime 1 days 0 hr. 26 min. 41 sec
      Trace Level off
      Security ON: Local OS Authentication
      SNMP OFF
      Listener Parameter File /u01/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora
      Listener Log File /u01/app/oracle/diag/tnslsnr/localhost/listener/alert/log.xml
      Listening Endpoints Summary...
      (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
      (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=localhost.localdomain)(PORT=1521)))
      Services Summary...
      Service "sonyprd.localdomain" has 1 instance(s).
      Instance "sonyprd", status READY, has 1 handler(s) for this service...
      Service "sonyprdXDB.localdomain" has 1 instance(s).
      Instance "sonyprd", status READY, has 1 handler(s) for this service...
      The command completed successfully


      Listener Status from Standby when database bring to Nomount state:

      [oracle@oracle11gstby admin]$ lsnrctl status

      LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 21-DEC-2012 18:11:54

      Copyright (c) 1991, 2009, Oracle. All rights reserved.

      Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
      STATUS of the LISTENER
      ------------------------
      Alias LISTENER
      Version TNSLSNR for Linux: Version 11.2.0.1.0 - Production
      Start Date 21-DEC-2012 16:13:47
      Uptime 0 days 1 hr. 58 min. 6 sec
      Trace Level off
      Security ON: Local OS Authentication
      SNMP OFF
      Listener Parameter File /u01/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora
      Listener Log File /u01/app/oracle/diag/tnslsnr/oracle11gstby/listener/alert/log.xml
      Listening Endpoints Summary...
      (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=oracle11gstby)(PORT=1521)))
      Services Summary...
      Service "sonyprdstby" has 1 instance(s).
      Instance "sonyprdstby", status BLOCKED, has 1 handler(s) for this service...
      The command completed successfully


      Please provide any work arounds to proceed further in creating the standby database.

      Thanks,
      Ram.

      Edited by: 895188 on Dec 21, 2012 5:50 PM

      Edited by: 895188 on Dec 21, 2012 6:09 PM

      Edited by: 895188 on Dec 21, 2012 6:22 PM