6 Replies Latest reply: Jul 8, 2011 5:41 AM by 874238 RSS

    ORA-17628: Oracle error 19505 returned by remote Oracle server

    639743
      I am trying to set up 11g dataguard. I am excatly following this link.
      http://www.oracle.com/technology/pub/articles/oracle-database-11g-top-features/11g-dataguard.html

      I am running on 64 bit SLES9.0 servers.

      oracle@akr-orcl2:~/product/11.0.0/db_1/bin> ./rman target sys/****@test1 auxiliary sys/****@teststby

      Recovery Manager: Release 11.1.0.6.0 - Production on Thu Jun 12 16:54:24 2008

      Copyright (c) 1982, 2007, Oracle. All rights reserved.

      connected to target database: TEST1 (DBID=1034067526)
      connected to auxiliary database: TEST1 (not mounted)

      RMAN> run {
      allocate channel c1 type disk;
      allocate auxiliary channel s1 type disk;

      duplicate target database
      for standby
      from active database
      dorecover
      spfile
      parameter_value_convert 'test1','teststby'
      set db_unique_name='teststby'
      set db_file_name_convert='/test1/','/teststby/'
      set log_file_name_convert='/test1/','/teststby/'
      set control_files='/oradata/teststby/control01.ctl'
      set fal_client='teststby'
      set fal_server='test1'
      set standby_file_management='AUTO'
      set log_archive_config='dg_config=(test1,teststby)'
      set log_archive_dest_2='service=test1 LGWR ASYNC valid_for=(ONLINE_LOGFILES,PRIMARY_ROLE) db_unique_name=teststby'
      set log_archive_dest_state_2='enable'
      set log_archive_format='teststby_%t_%s_%r.arc'
      ;
      sql channel c1 "alter system archive log current";
      sql channel s1 "alter database recover managed standby database using current logfile disconnect";
      }2> 3> 4> 5> 6> 7> 8> 9> 10> 11> 12> 13> 14> 15> 16> 17> 18> 19> 20> 21> 22> 23> 24> 25>

      using target database control file instead of recovery catalog
      allocated channel: c1
      channel c1: SID=117 device type=DISK

      allocated channel: s1
      channel s1: SID=98 device type=DISK

      Starting Duplicate Db at 12-JUN-08

      contents of Memory Script:
      {
      backup as copy reuse
      file '/opt/oracle/product/11.0.0/db_1/dbs/orapwtest1' auxiliary format
      '/opt/oracle/product/11.0.0/db_1/dbs/orapwteststby' file
      '/opt/oracle/product/11.0.0/db_1/dbs/spfiletest1.ora' auxiliary format
      '/opt/oracle/product/11.0.0/db_1/dbs/spfileteststby.ora' ;
      sql clone "alter system set spfile= ''/opt/oracle/product/11.0.0/db_1/dbs/spfileteststby.ora''";
      }
      executing Memory Script

      Starting backup at 12-JUN-08
      Finished backup at 12-JUN-08

      sql statement: alter system set spfile= ''/opt/oracle/product/11.0.0/db_1/dbs/spfileteststby.ora''

      contents of Memory Script:
      {
      sql clone "alter system set audit_file_dest =
      ''/opt/oracle/admin/teststby/adump'' comment=
      '''' scope=spfile";
      sql clone "alter system set dispatchers =
      ''(PROTOCOL=TCP) (SERVICE=teststbyXDB)'' comment=
      '''' scope=spfile";
      sql clone "alter system set db_unique_name =
      ''teststby'' comment=
      '''' scope=spfile";
      sql clone "alter system set db_file_name_convert =
      ''/test1/'', ''/teststby/'' comment=
      '''' scope=spfile";
      sql clone "alter system set log_file_name_convert =
      ''/test1/'', ''/teststby/'' comment=
      '''' scope=spfile";
      sql clone "alter system set control_files =
      ''/oradata/teststby/control01.ctl'' comment=
      '''' scope=spfile";
      sql clone "alter system set fal_client =
      ''teststby'' comment=
      '''' scope=spfile";
      sql clone "alter system set fal_server =
      ''test1'' comment=
      '''' scope=spfile";
      sql clone "alter system set standby_file_management =
      ''AUTO'' comment=
      '''' scope=spfile";
      sql clone "alter system set log_archive_config =
      ''dg_config=(test1,teststby)'' comment=
      '''' scope=spfile";
      sql clone "alter system set log_archive_dest_2 =
      ''service=test1 LGWR ASYNC valid_for=(ONLINE_LOGFILES,PRIMARY_ROLE) db_unique_name=teststby'' comment=
      '''' scope=spfile";
      sql clone "alter system set log_archive_dest_state_2 =
      ''enable'' comment=
      '''' scope=spfile";
      sql clone "alter system set log_archive_format =
      ''teststby_%t_%s_%r.arc'' comment=
      '''' scope=spfile";
      shutdown clone immediate;
      startup clone nomount ;
      }
      executing Memory Script

      sql statement: alter system set audit_file_dest = ''/opt/oracle/admin/teststby/adump'' comment= '''' scope=spfile

      sql statement: alter system set dispatchers = ''(PROTOCOL=TCP) (SERVICE=teststbyXDB)'' comment= '''' scope=spfile

      sql statement: alter system set db_unique_name = ''teststby'' comment= '''' scope=spfile

      sql statement: alter system set db_file_name_convert = ''/test1/'', ''/teststby/'' comment= '''' scope=spfile

      sql statement: alter system set log_file_name_convert = ''/test1/'', ''/teststby/'' comment= '''' scope=spfile

      sql statement: alter system set control_files = ''/oradata/teststby/control01.ctl'' comment= '''' scope=spfile

      sql statement: alter system set fal_client = ''teststby'' comment= '''' scope=spfile

      sql statement: alter system set fal_server = ''test1'' comment= '''' scope=spfile

      sql statement: alter system set standby_file_management = ''AUTO'' comment= '''' scope=spfile

      sql statement: alter system set log_archive_config = ''dg_config=(test1,teststby)'' comment= '''' scope=spfile

      sql statement: alter system set log_archive_dest_2 = ''service=test1 LGWR ASYNC valid_for=(ONLINE_LOGFILES,PRIMARY_ROLE) db_unique_name=teststby'' comment= '''' scope=spfile

      sql statement: alter system set log_archive_dest_state_2 = ''enable'' comment= '''' scope=spfile

      sql statement: alter system set log_archive_format = ''teststby_%t_%s_%r.arc'' comment= '''' scope=spfile

      Oracle instance shut down

      connected to auxiliary database (not started)
      Oracle instance started

      Total System Global Area 217157632 bytes

      Fixed Size 2142976 bytes
      Variable Size 159386880 bytes
      Database Buffers 50331648 bytes
      Redo Buffers 5296128 bytes

      contents of Memory Script:
      {
      backup as copy current controlfile for standby auxiliary format '/oradata/teststby/control01.ctl';
      sql clone 'alter database mount standby database';
      }
      executing Memory Script

      Starting backup at 12-JUN-08
      channel c1: starting datafile copy
      copying standby control file
      released channel: c1
      RMAN-00571: ===========================================================
      RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
      RMAN-00571: ===========================================================
      RMAN-03002: failure of Duplicate Db command at 06/12/2008 16:54:57
      RMAN-03015: error occurred in stored script Memory Script
      RMAN-03009: failure of backup command on c1 channel at 06/12/2008 16:54:57
      ORA-17628: Oracle error 19505 returned by remote Oracle server


      I gave 777 permissions on spfile and also on oradata!

      Could anyone help??

      Thanks
        • 1. Re: ORA-17628: Oracle error 19505 returned by remote Oracle server
          639743
          Found a solution myself! the problem was with the path of the control file!
          • 2. Re: ORA-17628: Oracle error 19505 returned by remote Oracle server
            581663
            I am trying to duplicate production instance into another server. The produciton isntance is in one server and the duplicate instance in another server running suse linux 10.3 on oracle 11g.

            This is the error message I get , I have tried everything.,

            Recovery Manager: Release 11.1.0.6.0 - Production on Thu Aug 14 10:43:08 2008

            Copyright (c) 1982, 2007, Oracle. All rights reserved.

            RMAN> connect target sys/ @dssprod

            connected to target database: DSSPROD (DBID=1144695039)

            RMAN> connect auxiliary sys/@dupprod

            connected to auxiliary database: DUPPROD (not mounted)

            RMAN> duplicate target database to dupprod from active database;

            Starting Duplicate Db at 14-AUG-08
            using target database control file instead of recovery catalog
            allocated channel: ORA_AUX_DISK_1
            channel ORA_AUX_DISK_1: SID=152 device type=DISK

            contents of Memory Script:
            {
            set newname for datafile 1 to
            "/u01/app/oracle/oradata/dupprod/system01.dbf";
            set newname for datafile 2 to
            "/u01/app/oracle/oradata/dupprod/sysaux01.dbf";
            set newname for datafile 3 to
            "/u01/app/oracle/oradata/dupprod/undotbs01.dbf";
            set newname for datafile 4 to
            "/u01/app/oracle/oradata/dupprod/users01.dbf";
            set newname for datafile 5 to
            "/oradisk2/oradata/dupprod/OPTIMIZER_DATA01.DBF";
            set newname for datafile 6 to
            "/u01/app/oracle/oradata/dupprod/
            OPTIMIZER_INDX01.DBF";
            set newname for datafile 7 to
            "/oradisk2/oradata/dupprod/DSS_DATA_TS1.DBF";
            set newname for datafile 8 to
            "/u01/app/oracle/oradata/dupprod/DSS_INDX_TS1.DBF";
            set newname for datafile 9 to
            "/oradisk2/oradata/dupprod/ONECALL_DATA01.DBF";
            set newname for datafile 10 to
            "/u01/app/oracle/oradata/dupprod/ONECALL_INDX01.DBF";
            set newname for datafile 11 to
            "/oradisk2/oradata/dupprod/WEBTIME_DATA01.DBF";
            set newname for datafile 12 to
            "/u01/app/oracle/oradata/dupprod/WEBTIME_INDX01.DBF";
            set newname for datafile 13 to
            "/oradisk2/oradata/dupprod/ROW_DATA01.DBF";
            set newname for datafile 14 to
            "/u01/app/oracle/oradata/dupprod/ROW_INDX01.DBF";
            set newname for datafile 15 to
            "/oradisk2/oradata/dupprod/ESP_DATA01.DBF";
            set newname for datafile 16 to
            "/u01/app/oracle/oradata/dupprod/ESP_INDX01.DBF";
            set newname for datafile 17 to
            "/oradisk2/oradata/dupprod/LOTUSNOTES_DATA01.DBF";
            set newname for datafile 18 to
            "/u01/app/oracle/oradata/dupprod/
            LOTUSNOTES_INDX01.DBF";
            set newname for datafile 19 to
            "/oradisk2/oradata/dupprod/INVOICE_DATA01.DBF";
            set newname for datafile 20 to
            "/u01/app/oracle/oradata/dupprod/INVOICE_INDX01.DBF";
            backup as copy reuse
            datafile 1 auxiliary format
            "/u01/app/oracle/oradata/dupprod/system01.dbf" datafile
            2 auxiliary format
            "/u01/app/oracle/oradata/dupprod/sysaux01.dbf" datafile
            3 auxiliary format
            "/u01/app/oracle/oradata/dupprod/undotbs01.dbf" datafile
            4 auxiliary format
            "/u01/app/oracle/oradata/dupprod/users01.dbf" datafile
            5 auxiliary format
            "/oradisk2/oradata/dupprod/OPTIMIZER_DATA01.DBF" datafile
            6 auxiliary format
            "/u01/app/oracle/oradata/dupprod/
            OPTIMIZER_INDX01.DBF" datafile
            7 auxiliary format
            "/oradisk2/oradata/dupprod/DSS_DATA_TS1.DBF" datafile
            8 auxiliary format
            "/u01/app/oracle/oradata/dupprod/DSS_INDX_TS1.DBF" datafile
            9 auxiliary format
            "/oradisk2/oradata/dupprod/ONECALL_DATA01.DBF" datafile
            10 auxiliary format
            "/u01/app/oracle/oradata/dupprod/ONECALL_INDX01.DBF" datafile
            11 auxiliary format
            "/oradisk2/oradata/dupprod/WEBTIME_DATA01.DBF" datafile
            12 auxiliary format
            "/u01/app/oracle/oradata/dupprod/WEBTIME_INDX01.DBF" datafile
            13 auxiliary format
            "/oradisk2/oradata/dupprod/ROW_DATA01.DBF" datafile
            14 auxiliary format
            "/u01/app/oracle/oradata/dupprod/ROW_INDX01.DBF" datafile
            15 auxiliary format
            "/oradisk2/oradata/dupprod/ESP_DATA01.DBF" datafile
            16 auxiliary format
            "/u01/app/oracle/oradata/dupprod/ESP_INDX01.DBF" datafile
            17 auxiliary format
            "/oradisk2/oradata/dupprod/LOTUSNOTES_DATA01.DBF" datafile
            18 auxiliary format
            "/u01/app/oracle/oradata/dupprod/
            LOTUSNOTES_INDX01.DBF" datafile
            19 auxiliary format
            "/oradisk2/oradata/dupprod/INVOICE_DATA01.DBF" datafile
            20 auxiliary format
            "/u01/app/oracle/oradata/dupprod/INVOICE_INDX01.DBF" ;
            sql 'alter system archive log current';
            }
            executing Memory Script

            executing command: SET NEWNAME

            executing command: SET NEWNAME

            executing command: SET NEWNAME

            executing command: SET NEWNAME

            executing command: SET NEWNAME

            executing command: SET NEWNAME

            executing command: SET NEWNAME

            executing command: SET NEWNAME

            executing command: SET NEWNAME

            executing command: SET NEWNAME

            executing command: SET NEWNAME

            executing command: SET NEWNAME

            executing command: SET NEWNAME

            executing command: SET NEWNAME

            executing command: SET NEWNAME

            executing command: SET NEWNAME

            executing command: SET NEWNAME

            executing command: SET NEWNAME

            executing command: SET NEWNAME

            executing command: SET NEWNAME

            Starting backup at 14-AUG-08
            allocated channel: ORA_DISK_1
            channel ORA_DISK_1: SID=54 device type=DISK
            channel ORA_DISK_1: starting datafile copy
            input datafile file number=00005 name=/oradisk2/oradata/DSSPROD/OPTIMIZER_DATA01.DBF
            RMAN-03009: failure of backup command on ORA_DISK_1 channel at 08/14/2008 10:46:06
            ORA-17628: Oracle error 19505 returned by remote Oracle server
            continuing other job steps, job failed will not be re-run
            channel ORA_DISK_1: starting datafile copy
            input datafile file number=00007 name=/oradisk2/oradata/DSSPROD/DSS_DATA_TS1.DBF
            RMAN-03009: failure of backup command on ORA_DISK_1 channel at 08/14/2008 10:46:11
            ORA-17628: Oracle error 19505 returned by remote Oracle server
            continuing other job steps, job failed will not be re-run
            channel ORA_DISK_1: starting datafile copy
            input datafile file number=00006 name=/u01/app/oracle/oradata/DSSPROD/
            OPTIMIZER_INDX01.DBF
            RMAN-03009: failure of backup command on ORA_DISK_1 channel at 08/14/2008 10:46:19
            ORA-19558: error de-allocating device
            ORA-19557: device error, device type: DISK, device name:
            ORA-17627: ORA-01041: internal error. hostdef extension doesn't exist
            ORA-17627: ORA-01041: internal error. hostdef extension doesn't exist
            ORA-03113: end-of-file on communication channel
            channel ORA_DISK_1 disabled, job failed on it will be run on another channel
            RMAN-00571: ===========================================================
            RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
            RMAN-00571: ===========================================================
            RMAN-03002: failure of Duplicate Db command at 08/14/2008 10:46:19
            RMAN-03015: error occurred in stored script Memory Script

            RMAN-03009: failure of backup command on ORA_DISK_1 channel at 08/14/2008 10:46:11
            ORA-17628: Oracle error 19505 returned by remote Oracle server
            RMAN-03009: failure of backup command on ORA_DISK_1 channel at 08/14/2008 10:46:19
            ORA-19558: error de-allocating device
            ORA-19557: device error, device type: DISK, device name:
            ORA-17627: ORA-01041: internal error. hostdef extension doesn't exist
            ORA-17627: ORA-01041: internal error. hostdef extension doesn't exist
            ORA-03113: end-of-file on communication channel
            RMAN-03009: failure of backup command on ORA_DISK_1 channel at 08/14/2008 10:46:06
            ORA-17628: Oracle error 19505 returned by remote Oracle server
            • 3. Re: ORA-17628: Oracle error 19505 returned by remote Oracle server
              19426
              ORA-19505: failed to identify file "string"
              Cause: call to identify the file returned an error
              Action: check additional messages, and check if the file exists

              Does directory '=/oradisk2/oradata...' exist on the target server? Does Orace software owner have the necessary write privileges?

              Werner
              • 4. Re: ORA-17628: Oracle error 19505 returned by remote Oracle server
                Pranilesh Chand.
                Hi,

                I had the excat same issue and directories existed on the target server. However, I was issuing the duplicate command from the server on which the auxiliary instance was residing and was getting the error. When I issued the same commands from the target server by connected to target database and auxiliary database, it all worked fine without any errors.

                Pranilesh Chand
                • 5. Re: ORA-17628: Oracle error 19505 returned by remote Oracle server
                  User321378
                  hi i read your post , and even im trying the same to create active standby database in same server.

                  i do have some doubts about below parameters.

                  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 'chicago','boston'
                  set db_unique_name='boston'
                  set db_file_name_convert='/chicago/','/boston/'
                  set log_file_name_convert='/chicago/','/boston/'
                  set control_files='/u01/app/oracle/oradata/control01.ctl'
                  set log_archive_max_processes='5'
                  set fal_client='boston'
                  set fal_server='chicago'
                  set standby_file_management='AUTO'
                  set log_archive_config='dg_config=(chicago,boston)'
                  set log_archive_dest_2='service=chicago ASYNC valid_for=(ONLINE_LOGFILE,PRIMARY_ROLE) db_unique_name=chicago'
                  ;


                  why do we need LOG_ARCHIVE_DEST_2 parameter here and why we are not specifing any value for LOG_ARCHIVE_DEST_1?

                  what will be values for below parameters for standby server after sucessfully implementing.

                  1) log_archive_dest_1
                  2) log_archive_dest_2

                  waiting for you reply.

                  it will be great if you copy entire steps here.
                  • 6. Re: ORA-17628: Oracle error 19505 returned by remote Oracle server
                    874238
                    Hi All,

                    Would appreciate , if anyone of you can help me out on this ... ( Please see the errors @ step 12 and let me know if you know any work-around/solution for that )

                    My Story :

                    I was trying to implement - "RAC to Single Instance Data Guard Setup " in Oracle Solaris 10 using Oracle 11g Release 2 (grid / database ) as below-
                    -----------------------------------------
                    Suppose the primary RAC db = LIVE (LIVE1 on rac1,LIVE2 on rac2)
                    and in the desired Physical Standby System, the database would be PSTAN ( on rac3 )


                    For Primary RAC Node, Data files and logfiles are in two ASM diskgroups called +DATA_DG
                    &
                    Physical standby database (Initially Software only )will have it's files in the local file system and will be referred to as PSTAN



                    Steps-
                    1. In all Primary RAC nodes(rac1,rac2) Modify tnsnames.ora so that these will have the entry for Physical DataGuard as below -
                    # TnsNames.ora -
                    STAN =
                    (DESCRIPTION =
                    (ADDRESS = (PROTOCOL = TCP)(HOST = rac3)(PORT = 1521))
                    (CONNECT_DATA =
                    (SERVER = DEDICATED)
                    (SERVICE_NAME = PSTAN.WORLD)
                    )
                    )
                    2. In Physical Standby Node (rac3) modify tnsnames.ora , so that it would look like as below-

                    # TnsNames.ora
                    -----------------added-----
                    PRIM =
                    (DESCRIPTION =
                    (ADDRESS = (PROTOCOL = TCP)(HOST = rac-scan.localdomain)(PORT = 1521))
                    (CONNECT_DATA =
                    (SERVER = DEDICATED)
                    (SERVICE_NAME = LIVE.WORLD)
                    )
                    )
                    ------------------end --------
                    STAN =
                    (DESCRIPTION =
                    (ADDRESS = (PROTOCOL = TCP)(HOST = rac3)(PORT = 1521))
                    (CONNECT_DATA =
                    (SERVER = DEDICATED)
                    (SERVICE_NAME = PSTAN.WORLD)
                    )
                    )

                    Also, add a static listener entry to listener.ora, So that it would look like as below-

                    LISTENER =
                    (DESCRIPTION_LIST =
                    (DESCRIPTION =
                    (ADDRESS = (PROTOCOL = TCP)(HOST = rac3)(PORT = 1521))
                    (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
                    )
                    )
                    -----------ADDED ----------------------
                    SID_LIST_LISTENER =
                    (SID_LIST = (SID_DESC =(GLOBAL_DBNAME = PSTAN.WORLD)
                    (SID_NAME = PSTAN)
                    (ORACLE_HOME = /u01/app/oracle/product/11.2.0/dbhome_1)))
                    ---------- end -------------------------------------

                    ADR_BASE_LISTENER = /u01/app/oracle

                    3. Now, reload the listener like $lsnrctl reload and check
                    <i> $tnsping PRIM and $tnsping STAN
                    <ii> $lsnrctl stat if the services for PRIM and PSTAN are reflected

                    4. Now, Copy the password files in such a way so that from any node oracle can verify the password whenever required..
                    Say in rac1,

                    cp $ORACLE_HOME/dbs/orapwdLIVE1 $ORACLE_HOME/dbs/orapwdLIVE2
                    cp $ORACLE_HOME/dbs/orapwdLIVE1 $ORACLE_HOME/dbs/orapwdPSTAN

                    scp $ORACLE_HOME/dbs/orapwd* rac2:/$ORACLE_HOME/dbs/.
                    scp $ORACLE_HOME/dbs/orapwd* rac3:/$ORACLE_HOME/dbs/.

                    5. Create the necessary directories in Physical StandBy node (rac3)
                    export ORACLE_BASE=/u01/app/oracle
                    mkdir -p $ORACLE_BASE/admin/PSTAN/adump
                    mkdir -p $ORACLE_BASE/oradata/PSTAN
                    mkdir -p $ORACLE_BASE/flash_recovery_area/PSTAN

                    chown oracle:dba $ORACLE_BASE/admin/PSTAN/adump
                    chmod -Rf 777 $ORACLE_BASE/admin/PSTAN/adump

                    chown -Rf oracle:dba $ORACLE_BASE/oradata/PSTAN
                    chmod -Rf 777 $ORACLE_BASE/oradata/PSTAN

                    chown -Rf oracle:dba $ORACLE_BASE/flash_recovery_area/PSTAN
                    chmod -Rf 777 $ORACLE_BASE/flash_recovery_area/PSTAN

                    6. Create pfile for PSTAN as follows-

                    touch $ORACLE_HOME/dbs/initPSTAN.ora (as oracle user off-course)
                    echo "*.db_name=PSTAN" > $ORACLE_HOME/dbs/initPSTAN.ora

                    7. Now start the Standby Instance (will be used as AUXILIARY in RMAN ) in NOMOUNT mode,
                    SQL> startup nomount pfile=$ORACLE_HOME/dbs/initPSTAN.ora

                    8. In PRIM db, enable force logging-

                    $export ORACLE_SID=PRIM
                    $sqlpus sys/oracle@PRIM as sysdba

                    SQL> Alter Database Force Logging;

                    9. Add StandBy Logfiles ( formula:: number of existing logfile + one )

                    ALTER DATABASE ADD STANDBY LOGFILE GROUP 5 SIZE 50M;
                    ALTER DATABASE ADD STANDBY LOGFILE GROUP 6 SIZE 50M;
                    ALTER DATABASE ADD STANDBY LOGFILE GROUP 7 SIZE 50M;
                    ALTER DATABASE ADD STANDBY LOGFILE GROUP 8 SIZE 50M;
                    ALTER DATABASE ADD STANDBY LOGFILE GROUP 9 SIZE 50M;

                    Alter System set LOG_ARCHIVE_CONFIG='dg_config=(LIVE,PSTAN)';
                    ALTER SYSTEM SET LOG_ARCHIVE_DEST_2='service=STAN
                    ASYNC valid_for=(ONLINE_LOGFILE,PRIMARY_ROLE)
                    db_unique_name=PSTAN';

                    Check from:: select group#,thread#,bytes from v$standby_log
                    UNION
                    select group#,thread#,bytes from v$log;


                    10. Check if LIVE is in archive log mode, if not configure Archive Log for RAC
                    sub-steps-
                    <<-----------------------------------------------------------
                    Login on one node, and disable the cluster parameter to run the instance as a single node.
                    SQL> alter system set cluster_database = false scope=spfile sid='LIVE1';
                    Shutdown the cluster.
                    $ srvctl stop database -d LIVE
                    Startup the instance in mount mode on the local node.
                    This is the node running the sid identified in the set cluster_database statement.
                    export ORACLE_SID=LIVE1
                    sqlplus / as sysdba
                    SQL>startup mount;
                    Now the database is open as a single instance with no other nodes running.
                    SQL>alter database archivelog;
                    Having done that, set the cluster_database parameter back to true.
                    SQL>alter system set cluster_database = true scope=spfile sid='LIVE1';
                    Shutdown the local instance and bring the cluster database back online.
                    SQL>shutdown immediate;
                    $ srvctl start database -d LIVE
                    Start any additional services if any.
                    $ srvctl start service -d LIVE
                    Now you should be in archivelog mode over all instances.
                    SQL>archive log list;
                    -------------------------------------------------------------------->>
                    11. In One of the Primary RAC Node ,
                    -------------------------------------------------------

                    12. Run the below scripts in RMAN
                    run{
                    allocate channel prmy1 type disk;
                    allocate channel prmy2 type disk;
                    allocate channel prmy3 type disk;
                    allocate channel prmy4 type disk;
                    allocate channel prmy5 type disk;
                    allocate channel prmy6 type disk;
                    allocate channel prmy7 type disk;
                    allocate channel prmy8 type disk;
                    allocate channel prmy9 type disk;

                    allocate auxiliary channel STBY type disk;

                    duplicate target database for standby from active database nofilenamecheck
                    spfile

                    parameter_value_convert 'live','PSTAN','LIVE','PSTAN'

                    set 'db_unique_name'='PSTAN'
                    set db_file_name_convert= '+DATA_DG/LIVE/','/u01/app/oracle/oradata/PSTAN/'
                    set log_file_name_convert='+DATA_DG/LIVE/','/u01/app/oracle/oradata/PSTAN/'
                    set control_files='/u01/app/oracle/oradata/PSTAN/control01.ctl'
                    set log_archive_max_processes='10'
                    set fal_client='STAN'
                    set fal_server='PRIM'
                    RESET remote_listener
                    RESET local_listener
                    SET cluster_database='FALSE'
                    set standby_file_management='AUTO'
                    set log_archive_config='dg_config=(LIVE,PSTAN)'
                    set log_archive_dest_2='service=PRIM
                    ASYNC valid_for=(ONLINE_LOGFILE,PRIMARY_ROLE)
                    db_unique_name=LIVE'
                    ;
                    }

                    Here , for the above RMAN Scripts, I am getting some errors that I was not able to resolve - ( quoted only some portion )
                    .........................................
                    .........................................
                    Starting backup at 02-JUL-11
                    channel prmy1: starting datafile copy
                    input datafile file number=00001 name=+DATA_DG/live/datafile/system.280.753635435
                    channel prmy2: starting datafile copy
                    input datafile file number=00002 name=+DATA_DG/live/datafile/sysaux.281.753635437
                    channel prmy3: starting datafile copy
                    input datafile file number=00003 name=+DATA_DG/live/datafile/undotbs1.282.753635441
                    channel prmy4: starting datafile copy
                    input datafile file number=00005 name=+DATA_DG/live/datafile/undotbs2.288.753635733
                    channel prmy5: starting datafile copy
                    input datafile file number=00004 name=+DATA_DG/live/datafile/users.283.753635441
                    RMAN-03009: failure of backup command on prmy1 channel at 07/02/2011 17:47:41
                    ORA-17628: Oracle error 19505 returned by remote Oracle server
                    continuing other job steps, job failed will not be re-run
                    RMAN-03009: failure of backup command on prmy2 channel at 07/02/2011 17:47:41
                    ORA-17628: Oracle error 19505 returned by remote Oracle server
                    continuing other job steps, job failed will not be re-run
                    RMAN-03009: failure of backup command on prmy3 channel at 07/02/2011 17:47:41
                    ORA-17628: Oracle error 19505 returned by remote Oracle server
                    continuing other job steps, job failed will not be re-run
                    RMAN-03009: failure of backup command on prmy4 channel at 07/02/2011 17:47:41
                    ORA-17628: Oracle error 19505 returned by remote Oracle server
                    continuing other job steps, job failed will not be re-run
                    released channel: prmy1
                    released channel: prmy2
                    ...............................
                    ...............................
                    released channel: STBY
                    RMAN-00571: ===========================================================
                    RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
                    RMAN-00571: ===========================================================
                    RMAN-03002: failure of Duplicate Db command at 07/02/2011 17:47:43
                    RMAN-03015: error occurred in stored script Memory Script
                    RMAN-03009: failure of backup command on prmy5 channel at 07/02/2011 17:47:43
                    ORA-17628: Oracle error 19505 returned by remote Oracle server
                    RMAN>

                    Verification Steps : ( Not done as step 12 failed )
                    1. In one of the Primary RAC node,

                    select sequence#, first_time, next_time from v$archived_log;
                    Alter System Switch Logfile;
                    OR
                    alter database archive log current;

                    2. In PSTAN db,
                    Run the following statement for Real-Time Apply in PSTAN
                    SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE
                    USING CURRENT LOGFILE DISCONNECT;

                    and check below-

                    select sequence#,first_time,next_time,applied
                    from v$archived_log
                    order by sequence#;
                    <<
                    If you ever need to stop log apply services:
                    alter database recover managed standby database cancel;
                    >>
                    The sequence# from the standby database must match the sequence# from the standby database,
                    i.e. there should not be gaps in the sequence#.


                    Regards
                    Indranil Das,
                    Oracle® RAC Expert Certified (OCE) , 10g OCP DBA
                    IBM India PVT Ltd,Kolkata
                    Cell# 9433056179