1 2 Previous Next 21 Replies Latest reply: Dec 3, 2012 11:38 PM by mseberg RSS

    RMAN Duplicate Standby failing to no AUTOBACKUP found for SPFILE

    975078
      Hi all, trying to duplicate a DB for Dataguard Standby via RMAN. It's not seeming to find the SPFILE. Any help would be appreciated, Thank you!
      rman target sys/XXXXXXX@ECPMT1 auxiliary sys/XXXXXXX@ECPMTSB
      
      Recovery Manager: Release 11.1.0.7.0 - Production on Mon Dec 3 19:07:13 2012
      
      Copyright (c) 1982, 2007, Oracle.  All rights reserved.
      
      connected to target database: ECPMT (DBID=3935765344)
      connected to auxiliary database: ECPMT (not mounted)
      
      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;
      }
      
      
      OUTPUT:
      
      using target database control file instead of recovery catalog
      allocated channel: prmy1
      channel prmy1: SID=83 instance=ECPMT1 device type=DISK
      
      allocated channel: prmy2
      channel prmy2: SID=43 instance=ECPMT1 device type=DISK
      
      allocated channel: prmy3
      channel prmy3: SID=56 instance=ECPMT1 device type=DISK
      
      allocated channel: prmy4
      channel prmy4: SID=47 instance=ECPMT1 device type=DISK
      
      allocated channel: stby
      channel stby: SID=170 device type=DISK
      
      Starting Duplicate Db at 03-DEC-12
      
      contents of Memory Script:
      {
         backup as copy reuse
         file  '/opt/app/oracle/product/11.1.0/db_1/dbs/orapwECPMT1' auxiliary format
       '/data/oracle/app/oracle/product/11.1.0/db_1/dbs/orapwECPMTSB'   ;
      }
      executing Memory Script
      
      Starting backup at 03-DEC-12
      Finished backup at 03-DEC-12
      
      contents of Memory Script:
      {
         backup as copy current controlfile for standby auxiliary format  '+DG_01/ecpmtsb/controlfile/current.2717.769883873';
         restore clone controlfile to  '+FRA_DG_01/ecpmsbt/controlfile/current.4804.769883873' from
       '+DG_01/ecpmtsb/controlfile/current.2717.769883873';
         sql clone 'alter database mount standby database';
      }
      executing Memory Script
      
      Starting backup at 03-DEC-12
      channel prmy1: starting datafile copy
      copying standby control file
      output file name=/opt/app/oracle/product/11.1.0/db_1/dbs/snapcf_ECPMT1.f tag=TAG20121203T190721 RECID=22 STAMP=801083242
      channel prmy1: datafile copy complete, elapsed time: 00:00:07
      Finished backup at 03-DEC-12
      
      Starting restore at 03-DEC-12
      
      channel stby: no AUTOBACKUP in 7 days found
      released channel: prmy1
      released channel: prmy2
      released channel: prmy3
      released channel: prmy4
      released channel: stby
      RMAN-00571: ===========================================================
      RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
      RMAN-00571: ===========================================================
      Edited by: BostonDBA on Dec 3, 2012 2:36 PM
        • 1. Re: RMAN Duplicate Standby failing to no AUTOBACKUP found for SPFILE
          975078
          more information:
          RMAN> show all;
          
          RMAN configuration parameters for database with db_unique_name ECPMT are:
          CONFIGURE RETENTION POLICY TO REDUNDANCY 1;
          CONFIGURE BACKUP OPTIMIZATION ON;
          CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default
          CONFIGURE CONTROLFILE AUTOBACKUP OFF; # default
          CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '+FRA_DG_01/ECPMT/BACKUPSET/%F.c_bku';
          CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO BACKUPSET; # default
          CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
          CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
          CONFIGURE MAXSETSIZE TO UNLIMITED; # default
          CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
          CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
          CONFIGURE COMPRESSION ALGORITHM 'BZIP2'; # default
          CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
          CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/opt/app/oracle/product/11.1.0/db_1/dbs/snapcf_ECPMT1.f'; # default
          
          from ECPMT (RAC)
          
          SQL> show parameter spfile
          
          NAME                                 TYPE        VALUE
          ------------------------------------ ----------- ------------------------------
          spfile                               string      +DG_01/ecpmt/spfileecpmt.ora
          
          
          RMAN> list backup of controlfile summary;
          
          
          List of Backups
          ===============
          Key     TY LV S Device Type Completion Time #Pieces #Copies Compressed Tag
          ------- -- -- - ----------- --------------- ------- ------- ---------- ---
          35      B  F  A DISK        03-DEC-12       1       1       NO         TAG20121203T190548
          
          RMAN> list backup of spfile summary;
          
          
          List of Backups
          ===============
          Key     TY LV S Device Type Completion Time #Pieces #Copies Compressed Tag
          ------- -- -- - ----------- --------------- ------- ------- ---------- ---
          35      B  F  A DISK        03-DEC-12       1       1       NO         TAG20121203T190548
          
          RMAN> list backup of spfile;
          
          
          List of Backup Sets
          ===================
          
          
          BS Key  Type LV Size       Device Type Elapsed Time Completion Time
          ------- ---- -- ---------- ----------- ------------ ---------------
          35      Full    22.80M     DISK        00:00:03     03-DEC-12
                  BP Key: 35   Status: AVAILABLE  Compressed: NO  Tag: TAG20121203T190548
                  Piece Name: +FRA_DG_01/ecpmt/backupset/2012_12_03/ncsnf0_tag20121203t190548_0.7392.801083297
            SPFILE Included: Modification time: 03-DEC-12
            SPFILE db_unique_name: ECPMT
          
          From ASM:
          
          ASMCMD> ls -ltr +FRA_DG_01/ecpmt/backupset/2012_12_03/ncsnf0_tag20121203t190548_0.7392.801083297
          Type       Redund  Striped  Time             Sys  Name
          BACKUPSET  UNPROT  COARSE   DEC 03 19:00:00  Y    ncsnf0_tag20121203t190548_0.7392.801083297
          Edited by: BostonDBA on Dec 3, 2012 2:38 PM
          • 2. Re: RMAN Duplicate Standby failing to no AUTOBACKUP found for SPFILE
            Niket Kumar
            copying standby control file
            output file name=/opt/app/oracle/product/11.1.0/db_1/dbs/snapcf_ECPMT1.f tag=TAG20121203T190721 RECID=22 STAMP=801083242
            your standby control file backup is going on above location as specified by output file name.

            it should be go to below location:
            +DG_01/ecpmtsb/controlfile/current.2717.769883873
            do one thing...

            chnage this in rman rules
            CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/opt/app/oracle/product/11.1.0/db_1/dbs/snapcf_ECPMT1.f'; # default
            to
             CONFIGURE SNAPSHOT CONTROLFILE NAME TO '+DG_01/ecpmtsb/controlfile/'
            • 3. Re: RMAN Duplicate Standby failing to no AUTOBACKUP found for SPFILE
              Shivananda Rao
              Hello,

              Can you please post your standby pfile contents ?


              Regards,
              Shivananda
              • 4. Re: RMAN Duplicate Standby failing to no AUTOBACKUP found for SPFILE
                975078
                Thanks Niket for your help, I really appreciate it.

                So just to be clear, ECPMT is RAC Primary and ECPMTSB is the Standby (standalone on another server).

                I'm not sure if the parameters you requested changed are for target (ECPMT) or are for aux (ECPMTSB


                rman target sys/*******@ECPMT auxiliary sys/*******@ECPMTSB
                
                connected to target database: ECPMT (DBID=3935765344)
                connected to auxiliary database: ECPMT (not mounted)
                
                RMAN> CONFIGURE SNAPSHOT CONTROLFILE NAME TO '+DG_01/ecpmtsb/controlfile/'
                2> ;
                
                old RMAN configuration parameters:
                CONFIGURE SNAPSHOT CONTROLFILE NAME TO '+DG_01/ECPMT/CONTROLFILE';
                new RMAN configuration parameters:
                CONFIGURE SNAPSHOT CONTROLFILE NAME TO '+DG_01/ecpmtsb/controlfile/';
                new RMAN configuration parameters are successfully stored
                
                RMAN> run {
                         allocate channel prmy1 type disk;
                2>          allocate channel prmy2 type disk;
                3> 4>          allocate channel prmy3 type disk;
                         allocate channel prmy4 type disk;
                5>          allocate auxiliary channel stby type disk;
                duplicate target database for standby from active database;
                6> }7> 8>
                
                allocated channel: prmy1
                channel prmy1: SID=83 instance=ECPMT1 device type=DISK
                
                allocated channel: prmy2
                channel prmy2: SID=38 instance=ECPMT1 device type=DISK
                
                allocated channel: prmy3
                channel prmy3: SID=44 instance=ECPMT1 device type=DISK
                
                allocated channel: prmy4
                channel prmy4: SID=43 instance=ECPMT1 device type=DISK
                
                allocated channel: stby
                channel stby: SID=151 device type=DISK
                
                Starting Duplicate Db at 03-DEC-12
                
                contents of Memory Script:
                {
                   backup as copy reuse
                   file  '/opt/app/oracle/product/11.1.0/db_1/dbs/orapwECPMT1' auxiliary format
                 '/data/oracle/app/oracle/product/11.1.0/db_1/dbs/orapwECPMTSB'   ;
                }
                executing Memory Script
                
                Starting backup at 03-DEC-12
                Finished backup at 03-DEC-12
                
                contents of Memory Script:
                {
                   backup as copy current controlfile for standby auxiliary format  '+DG_01/ecpmtsb/controlfile/current.2717.769883873';
                   restore clone controlfile to  '+FRA_DG_01/ecpmsbt/controlfile/current.4804.769883873' from
                 '+DG_01/ecpmtsb/controlfile/current.2717.769883873';
                   sql clone 'alter database mount standby database';
                }
                executing Memory Script
                
                Starting backup at 03-DEC-12
                channel prmy1: starting datafile copy
                copying standby control file
                released channel: prmy1
                released channel: prmy2
                released channel: prmy3
                released channel: prmy4
                released channel: stby
                RMAN-00571: ===========================================================
                RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
                RMAN-00571: ===========================================================
                RMAN-03002: failure of Duplicate Db command at 12/03/2012 20:02:48
                RMAN-03015: error occurred in stored script Memory Script
                RMAN-03009: failure of backup command on prmy1 channel at 12/03/2012 20:02:48
                ORA-01580: error creating control backup file +DG_01/ecpmtsb/controlfile/
                ORA-17502: ksfdcre:4 Failed to create file +DG_01/ecpmtsb/controlfile/
                ORA-15173: entry 'ecpmtsb' does not exist in directory '/'
                
                RMAN> show all;
                
                RMAN configuration parameters for database with db_unique_name ECPMT are:
                CONFIGURE RETENTION POLICY TO REDUNDANCY 1;
                CONFIGURE BACKUP OPTIMIZATION ON;
                CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default
                CONFIGURE CONTROLFILE AUTOBACKUP OFF; # default
                CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '+FRA_DG_01/ECPMT/BACKUPSET/%F.c_bku';
                CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO BACKUPSET; # default
                CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
                CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
                CONFIGURE MAXSETSIZE TO UNLIMITED; # default
                CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
                CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
                CONFIGURE COMPRESSION ALGORITHM 'BZIP2'; # default
                CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
                CONFIGURE SNAPSHOT CONTROLFILE NAME TO '+DG_01/ecpmtsb/controlfile/';
                • 5. Re: RMAN Duplicate Standby failing to no AUTOBACKUP found for SPFILE
                  975078
                  Also, why is it trying to pull from AUTOBACKUP if it's OFF in the parameters?
                  • 6. Re: RMAN Duplicate Standby failing to no AUTOBACKUP found for SPFILE
                    975078
                    Hi Shivanda, thanks for your help in advance as well.

                    Pfile for Standby:
                    20:26:31 nolog> show parameter
                    
                    O7_DICTIONARY_ACCESSIBILITY          boolean     FALSE
                    active_instance_count                integer
                    aq_tm_processes                      integer     0
                    archive_lag_target                   integer     0
                    asm_diskgroups                       string
                    asm_diskstring                       string
                    asm_power_limit                      integer     1
                    asm_preferred_read_failure_groups    string
                    audit_file_dest                      string      /data/oracle/app/oracle/admin/
                                                                     ECPMTSB/adump
                    audit_sys_operations                 boolean     FALSE
                    audit_syslog_level                   string
                    audit_trail                          string      NONE
                    background_core_dump                 string      partial
                    background_dump_dest                 string      /data/oracle/app/oracle/diag/r
                                                                     dbms/ecpmtsb/ECPMTSB/trace
                    backup_tape_io_slaves                boolean     FALSE
                    bitmap_merge_area_size               integer     1048576
                    blank_trimming                       boolean     FALSE
                    buffer_pool_keep                     string
                    buffer_pool_recycle                  string
                    cell_offload_compaction              string      ADAPTIVE
                    cell_offload_parameters              string
                    cell_offload_plan_display            string      AUTO
                    cell_offload_processing              boolean     TRUE
                    cell_partition_large_extents         string      DEFAULT
                    circuits                             integer
                    client_result_cache_lag              big integer 3000
                    client_result_cache_size             big integer 0
                    cluster_database                     boolean     FALSE
                    cluster_database_instances           integer     1
                    cluster_interconnects                string
                    commit_logging                       string
                    commit_point_strength                integer     1
                    commit_wait                          string
                    commit_write                         string
                    compatible                           string      11.1.0.0.0
                    control_file_record_keep_time        integer     7
                    control_files                        string      +DG_01/ecpmtsb/controlfile/cur
                                                                     rent.2717.769883873, +FRA_DG_0
                                                                     1/ecpmsbt/controlfile/current.
                                                                     4804.769883873
                    control_management_pack_access       string      DIAGNOSTIC+TUNING
                    core_dump_dest                       string      /data/oracle/app/oracle/diag/r
                                                                     dbms/ecpmtsb/ECPMTSB/cdump
                    cpu_count                            integer     12
                    create_bitmap_area_size              integer     8388608
                    create_stored_outlines               string
                    cursor_sharing                       string      EXACT
                    cursor_space_for_time                boolean     FALSE
                    db_16k_cache_size                    big integer 0
                    db_2k_cache_size                     big integer 0
                    db_32k_cache_size                    big integer 0
                    db_4k_cache_size                     big integer 0
                    db_8k_cache_size                     big integer 0
                    db_block_buffers                     integer     0
                    db_block_checking                    string      FALSE
                    db_block_checksum                    string      TYPICAL
                    db_block_size                        integer     8192
                    db_cache_advice                      string      ON
                    db_cache_size                        big integer 0
                    db_create_file_dest                  string      +DG_01
                    db_create_online_log_dest_1          string
                    db_create_online_log_dest_2          string
                    db_create_online_log_dest_3          string
                    db_create_online_log_dest_4          string
                    db_create_online_log_dest_5          string
                    db_domain                            string
                    db_file_multiblock_read_count        integer     128
                    db_file_name_convert                 string      +DG_01/ecpmt, +DG_01/ecpmtsb
                    db_files                             integer     200
                    db_flashback_retention_target        integer     1440
                    db_keep_cache_size                   big integer 0
                    db_lost_write_protect                string      NONE
                    db_name                              string      ECPMT
                    db_recovery_file_dest                string      +FRA_DG_01
                    db_recovery_file_dest_size           big integer 15G
                    db_recycle_cache_size                big integer 0
                    db_securefile                        string      PERMITTED
                    db_ultra_safe                        string      OFF
                    db_unique_name                       string      ECPMTSB
                    db_writer_processes                  integer     2
                    dbwr_io_slaves                       integer     0
                    ddl_lock_timeout                     integer     0
                    dg_broker_config_file1               string      +DG_01/ecpmtsb/dgbroker/dg_con
                                                                     fig_file1.dat
                    dg_broker_config_file2               string      +FRA_DG_01/ecpmtsb/dgbroker/dg
                                                                     _config_file2.dat
                    dg_broker_start                      boolean     FALSE
                    diagnostic_dest                      string      /data/oracle/app/oracle
                    disk_asynch_io                       boolean     TRUE
                    dispatchers                          string      (PROTOCOL=TCP) (SERVICE=ECPMTX
                                                                     DB)
                    distributed_lock_timeout             integer     60
                    dml_locks                            integer     748
                    drs_start                            boolean     FALSE
                    enable_ddl_logging                   boolean     FALSE
                    event                                string
                    fal_client                           string      ECPMTSB
                    
                    fal_server                           string      ECPMT
                    fast_start_io_target                 integer     0
                    fast_start_mttr_target               integer     0
                    fast_start_parallel_rollback         string      LOW
                    file_mapping                         boolean     FALSE
                    fileio_network_adapters              string
                    filesystemio_options                 string      none
                    fixed_date                           string
                    gc_files_to_locks                    string
                    gcs_server_processes                 integer     0
                    global_context_pool_size             string
                    global_names                         boolean     FALSE
                    global_txn_processes                 integer     1
                    hash_area_size                       integer     131072
                    hi_shared_memory_address             integer     0
                    hs_autoregister                      boolean     TRUE
                    ifile                                file
                    instance_groups                      string
                    instance_name                        string      ECPMTSB
                    instance_number                      integer     0
                    instance_type                        string      RDBMS
                    java_jit_enabled                     boolean     TRUE
                    java_max_sessionspace_size           integer     0
                    java_pool_size                       big integer 0
                    java_soft_sessionspace_limit         integer     0
                    job_queue_processes                  integer     1000
                    large_pool_size                      big integer 0
                    ldap_directory_access                string      NONE
                    ldap_directory_sysauth               string      no
                    license_max_sessions                 integer     0
                    license_max_users                    integer     0
                    license_sessions_warning             integer     0
                    local_listener                       string      LISTENER_STANDBY
                    lock_name_space                      string
                    lock_sga                             boolean     FALSE
                    log_archive_config                   string      DG_CONFIG=(ECPMT,ECPMTSB)
                    log_archive_dest                     string
                    log_archive_dest_1                   string      LOCATION=USE_DB_RECOVERY_FILE_
                                                                     DEST  VALID_FOR=(ONLINE_LOGFIL
                                                                     ES,ALL_ROLES) DB_UNIQUE_NAME=E
                                                                     CPMTSB
                    log_archive_dest_10                  string
                    log_archive_dest_2                   string      SERVICE=CDPMT VALID_FOR=(ONLIN
                                                                     E_LOGFILES,PRIMARY_ROLE) DB_UN
                                                                     IQUE_NAME=CDPMTSB
                    log_archive_dest_3                   string
                    log_archive_dest_4                   string
                    log_archive_dest_5                   string
                    log_archive_dest_6                   string
                    log_archive_dest_7                   string
                    log_archive_dest_8                   string
                    log_archive_dest_9                   string
                    log_archive_dest_state_1             string      ENABLE
                    log_archive_dest_state_10            string      enable
                    log_archive_dest_state_2             string      DEFER
                    log_archive_dest_state_3             string      enable
                    log_archive_dest_state_4             string      enable
                    log_archive_dest_state_5             string      enable
                    log_archive_dest_state_6             string      enable
                    log_archive_dest_state_7             string      enable
                    log_archive_dest_state_8             string      enable
                    log_archive_dest_state_9             string      enable
                    log_archive_duplex_dest              string
                    log_archive_format                   string      %t_%s_%r.dbf
                    log_archive_local_first              boolean     TRUE
                    log_archive_max_processes            integer     30
                    log_archive_min_succeed_dest         integer     1
                    log_archive_start                    boolean     FALSE
                    log_archive_trace                    integer     0
                    log_buffer                           integer     7744512
                    log_checkpoint_interval              integer     0
                    log_checkpoint_timeout               integer     1800
                    log_checkpoints_to_alert             boolean     FALSE
                    log_file_name_convert                string      +FRA_DG_01/ecpmt, +FRA_DG_01/e
                                                                     cpmtsb, +DG_01/ecpmt, +DG_01/e
                                                                     cpmtsb
                    max_commit_propagation_delay         integer     0
                    max_dispatchers                      integer
                    max_dump_file_size                   string      unlimited
                    max_enabled_roles                    integer     150
                    max_shared_servers                   integer
                    memory_max_target                    big integer 0
                    memory_target                        big integer 0
                    nls_calendar                         string
                    nls_comp                             string      BINARY
                    nls_currency                         string
                    nls_date_format                      string
                    nls_date_language                    string
                    nls_dual_currency                    string
                    nls_iso_currency                     string
                    nls_language                         string      AMERICAN
                    nls_length_semantics                 string      BYTE
                    nls_nchar_conv_excp                  string      FALSE
                    nls_numeric_characters               string
                    nls_sort                             string
                    nls_territory                        string      AMERICA
                    nls_time_format                      string
                    nls_time_tz_format                   string
                    nls_timestamp_format                 string
                    
                    nls_timestamp_tz_format              string
                    object_cache_max_size_percent        integer     10
                    object_cache_optimal_size            integer     102400
                    olap_page_pool_size                  big integer 0
                    open_cursors                         integer     300
                    open_links                           integer     4
                    open_links_per_instance              integer     4
                    optimizer_capture_sql_plan_baselines boolean     FALSE
                    optimizer_dynamic_sampling           integer     2
                    optimizer_features_enable            string      11.1.0.7
                    optimizer_index_caching              integer     0
                    optimizer_index_cost_adj             integer     100
                    optimizer_mode                       string      ALL_ROWS
                    optimizer_secure_view_merging        boolean     TRUE
                    optimizer_use_invisible_indexes      boolean     FALSE
                    optimizer_use_pending_statistics     boolean     FALSE
                    optimizer_use_sql_plan_baselines     boolean     TRUE
                    os_authent_prefix                    string      ops$
                    os_roles                             boolean     FALSE
                    parallel_adaptive_multi_user         boolean     TRUE
                    parallel_automatic_tuning            boolean     FALSE
                    parallel_execution_message_size      integer     2152
                    parallel_instance_group              string
                    parallel_io_cap_enabled              boolean     FALSE
                    parallel_max_servers                 integer     135
                    parallel_min_percent                 integer     0
                    parallel_min_servers                 integer     0
                    parallel_server                      boolean     FALSE
                    parallel_server_instances            integer     1
                    parallel_threads_per_cpu             integer     2
                    pga_aggregate_target                 big integer 164M
                    plscope_settings                     string      IDENTIFIERS:NONE
                    plsql_ccflags                        string
                    plsql_code_type                      string      INTERPRETED
                    plsql_debug                          boolean     FALSE
                    plsql_native_library_dir             string
                    plsql_native_library_subdir_count    integer     0
                    plsql_optimize_level                 integer     2
                    plsql_v2_compatibility               boolean     FALSE
                    plsql_warnings                       string      DISABLE:ALL
                    pre_page_sga                         boolean     FALSE
                    processes                            integer     150
                    query_rewrite_enabled                string      TRUE
                    query_rewrite_integrity              string      enforced
                    rdbms_server_dn                      string
                    read_only_open_delayed               boolean     FALSE
                    recovery_parallelism                 integer     0
                    recyclebin                           string      on
                    redo_transport_user                  string
                    remote_dependencies_mode             string      TIMESTAMP
                    remote_listener                      string
                    remote_login_passwordfile            string      EXCLUSIVE
                    remote_os_authent                    boolean     FALSE
                    remote_os_roles                      boolean     FALSE
                    replication_dependency_tracking      boolean     TRUE
                    resource_limit                       boolean     FALSE
                    resource_manager_cpu_allocation      integer     12
                    resource_manager_plan                string
                    result_cache_max_result              integer     5
                    result_cache_max_size                big integer 2560K
                    result_cache_mode                    string      MANUAL
                    result_cache_remote_expiration       integer     0
                    resumable_timeout                    integer     0
                    rollback_segments                    string
                    sec_case_sensitive_logon             boolean     FALSE
                    sec_max_failed_login_attempts        integer     10
                    sec_protocol_error_further_action    string      CONTINUE
                    sec_protocol_error_trace_action      string      TRACE
                    sec_return_server_release_banner     boolean     FALSE
                    serial_reuse                         string      disable
                    service_names                        string      ECPMTSB
                    session_cached_cursors               integer     50
                    session_max_open_files               integer     10
                    sessions                             integer     170
                    sga_max_size                         big integer 496M
                    sga_target                           big integer 496M
                    shadow_core_dump                     string      partial
                    shared_memory_address                integer     0
                    shared_pool_reserved_size            big integer 15099494
                    shared_pool_size                     big integer 0
                    shared_server_sessions               integer
                    shared_servers                       integer     1
                    skip_unusable_indexes                boolean     TRUE
                    smtp_out_server                      string      10.1.120.2:25
                    sort_area_retained_size              integer     0
                    sort_area_size                       integer     65536
                    spfile                               string
                    sql92_security                       boolean     FALSE
                    sql_trace                            boolean     FALSE
                    sql_version                          string      NATIVE
                    sqltune_category                     string      DEFAULT
                    standby_archive_dest                 string      ?/dbs/arch
                    standby_file_management              string      AUTO
                    star_transformation_enabled          string      FALSE
                    statistics_level                     string      TYPICAL
                    streams_pool_size                    big integer 0
                    tape_asynch_io                       boolean     TRUE
                    thread                               integer     1
                    timed_os_statistics                  integer     0
                    
                    timed_statistics                     boolean     TRUE
                    trace_enabled                        boolean     TRUE
                    tracefile_identifier                 string
                    transactions                         integer     187
                    transactions_per_rollback_segment    integer     5
                    undo_management                      string      AUTO
                    undo_retention                       integer     900
                    undo_tablespace                      string      UNDOTBS1
                    use_indirect_data_buffers            boolean     FALSE
                    user_dump_dest                       string      /data/oracle/app/oracle/diag/r
                                                                     dbms/ecpmtsb/ECPMTSB/trace
                    utl_file_dir                         string
                    workarea_size_policy                 string      AUTO
                    xml_db_events                        string      enable
                    Edited by: BostonDBA on Dec 3, 2012 3:26 PM
                    • 7. Re: RMAN Duplicate Standby failing to no AUTOBACKUP found for SPFILE
                      Shivananda Rao
                      Hello,

                      I suspect the problem to be at the control_files parameter. In the pfile of standby database, set the control_files parameter as:
                      control_files='+DG_01','+FRA_DG_01'
                      Regards,
                      Shivananda
                      • 8. Re: RMAN Duplicate Standby failing to no AUTOBACKUP found for SPFILE
                        975078
                        20:46:25 nolog> show parameter control
                        
                        NAME                                 TYPE        VALUE
                        ------------------------------------ ----------- ------------------------------
                        control_file_record_keep_time        integer     7
                        control_files                        string      +DG_01, +FRA_DG_01
                        control_management_pack_access       string      DIAGNOSTIC+TUNING
                        
                        
                        
                        Starting backup at 03-DEC-12
                        channel prmy1: starting datafile copy
                        copying standby control file
                        released channel: prmy1
                        released channel: prmy2
                        released channel: prmy3
                        released channel: prmy4
                        released channel: stby
                        RMAN-00571: ===========================================================
                        RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
                        RMAN-00571: ===========================================================
                        RMAN-03002: failure of Duplicate Db command at 12/03/2012 20:44:42
                        RMAN-03015: error occurred in stored script Memory Script
                        RMAN-03009: failure of backup command on prmy1 channel at 12/03/2012 20:44:42
                        ORA-01580: error creating control backup file +DG_01/ecpmtsb/controlfile/
                        ORA-17502: ksfdcre:4 Failed to create file +DG_01/ecpmtsb/controlfile/
                        ORA-15173: entry 'ecpmtsb' does not exist in directory '/'
                        
                        
                        On second try:
                        
                        RMAN> show all;
                        
                        RMAN-00571: ===========================================================
                        RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
                        RMAN-00571: ===========================================================
                        RMAN-03002: failure of Duplicate Db command at 12/03/2012 20:49:29
                        RMAN-03015: error occurred in stored script Memory Script
                        RMAN-03009: failure of backup command on prmy1 channel at 12/03/2012 20:49:29
                        ORA-01580: error creating control backup file +DG_01/ecpmtsb/controlfile/
                        ORA-17502: ksfdcre:3 Failed to create file +DG_01/ecpmtsb/controlfile/
                        ORA-15113: alias name 'CONTROLFILE' refers to a directory
                        
                        
                        RMAN configuration parameters for database with db_unique_name ECPMT are:
                        CONFIGURE RETENTION POLICY TO REDUNDANCY 1;
                        CONFIGURE BACKUP OPTIMIZATION ON;
                        CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default
                        CONFIGURE CONTROLFILE AUTOBACKUP OFF; # default
                        CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '+FRA_DG_01/ECPMT/BACKUPSET/%F.c_bku';
                        CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO BACKUPSET; # default
                        CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
                        CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
                        CONFIGURE MAXSETSIZE TO UNLIMITED; # default
                        CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
                        CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
                        CONFIGURE COMPRESSION ALGORITHM 'BZIP2'; # default
                        CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
                        CONFIGURE SNAPSHOT CONTROLFILE NAME TO '+DG_01/ecpmtsb/controlfile/';
                        Edited by: BostonDBA on Dec 3, 2012 3:50 PM
                        • 9. Re: RMAN Duplicate Standby failing to no AUTOBACKUP found for SPFILE
                          mseberg
                          Hello;

                          Check out this note quick and see if it relates to your issue :

                          ORA-15204: database version 11.2.0.1.0 is incompatible with diskgroup DATA [ID 1487320.1]

                          Best Regards

                          mseberg
                          • 10. Re: RMAN Duplicate Standby failing to no AUTOBACKUP found for SPFILE
                            975078
                            Thanks MSEBerg, checked out the Note. We've been able to duplicate between these two machines via ASM before though, which is what's disconcerting.

                            I would like to understand why it's failing on a Duplicate considering I'm not asking it to look for SPFILE from autobackup as autobackup is OFF in the Rman env settings for ECPMT (Prim). Also, for the Primary database Rman settings (source database being cloned), should this setting be pointing to a standby directory?
                            CONFIGURE SNAPSHOT CONTROLFILE NAME TO '+DG_01/ecpmtsb/controlfile/';
                            This worked the other day for my colleagues using the same RMAN script, then to make sure it was a solid procedure, we blew away the instance and files and now it's not allowing us to do the duplicate claiming to not be able to access AUTOBACKUP files.

                            Any help or input Mseberg would be incredibly appreciated. Thank you !
                            • 11. Re: RMAN Duplicate Standby failing to no AUTOBACKUP found for SPFILE
                              mseberg
                              OK
                              control_files                        string      +DG_01/ecpmtsb/controlfile/current.2717.769883873, +FRA_DG_01/ecpmsbt/controlfile/current.4804.769883873
                              init.ora file for the auxiliary database includes hard-coded subdirectory

                              See

                              Rman Duplicate From Active Database To ASM Failed With ORA-1503, ORA-200, ORA-202, ORA-17502 and ORA-15113 [ID 1302857.1]

                              Thanks for all the details

                              Best Regards

                              mseberg
                              • 12. Re: RMAN Duplicate Standby failing to no AUTOBACKUP found for SPFILE
                                Shivananda Rao
                                Hello,
                                ORA-17502: ksfdcre:4 Failed to create file +DG_01/ecpmtsb/controlfile/ 
                                ORA-15173: entry 'ecpmtsb' does not exist in directory '/'
                                Connect to the ASM instance, and add the directory "ecpmtsb" to diskgroup DG_01 and then try to perform the duplication.


                                Refer this http://shivanandarao.wordpress.com/2012/07/13/ora-17502-ksfdcre4-failed-to-create-file-file-name-ora-15173-entry-string-does-not-exist-in-directory-string/


                                Regards,
                                Shivananda
                                • 13. Re: RMAN Duplicate Standby failing to no AUTOBACKUP found for SPFILE
                                  975078
                                  Thanks Mseberg,

                                  I had changed that after being recommended to do the same:
                                  21:25:05 nolog> show parameter control
                                  
                                  NAME                                 TYPE        VALUE
                                  ------------------------------------ ----------- ------------------------------
                                  control_file_record_keep_time        integer     7
                                  control_files                        string      +DG_01, +FRA_DG_01
                                  control_management_pack_access       string      DIAGNOSTIC+TUNING
                                  
                                  
                                  rman target sys/******@ECPMT auxiliary sys/********@ECPMTSB
                                  
                                  Recovery Manager: Release 11.1.0.7.0 - Production on Mon Dec 3 21:26:50 2012
                                  
                                  Copyright (c) 1982, 2007, Oracle.  All rights reserved.
                                  
                                  connected to target database: ECPMT (DBID=3935765344)
                                  connected to auxiliary database: ECPMT (not mounted)
                                  
                                  RMAN> show all;
                                  
                                  using target database control file instead of recovery catalog
                                  RMAN configuration parameters for database with db_unique_name ECPMT are:
                                  CONFIGURE RETENTION POLICY TO REDUNDANCY 1;
                                  CONFIGURE BACKUP OPTIMIZATION ON;
                                  CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default
                                  CONFIGURE CONTROLFILE AUTOBACKUP OFF; # default
                                  CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '+FRA_DG_01/ECPMT/BACKUPSET/%F.c_bku';
                                  CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO BACKUPSET; # default
                                  CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
                                  CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
                                  CONFIGURE MAXSETSIZE TO UNLIMITED; # default
                                  CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
                                  CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
                                  CONFIGURE COMPRESSION ALGORITHM 'BZIP2'; # default
                                  CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
                                  CONFIGURE SNAPSHOT CONTROLFILE NAME TO '+DG_01/ecpmtsb/controlfile/';
                                  
                                  RMAN> run {
                                  2>          allocate channel prmy1 type disk;
                                           allocate channel prmy2 type disk;
                                  3>          allocate channel prmy3 type disk;
                                  4>          allocate channel prmy4 type disk;
                                  5>          allocate auxiliary channel stby type disk;
                                  duplicate target database for standby from active database;
                                  6> 7> }8>
                                  
                                  allocated channel: prmy1
                                  channel prmy1: SID=48 instance=ECPMT1 device type=DISK
                                  
                                  allocated channel: prmy2
                                  channel prmy2: SID=83 instance=ECPMT1 device type=DISK
                                  
                                  allocated channel: prmy3
                                  channel prmy3: SID=38 instance=ECPMT1 device type=DISK
                                  
                                  allocated channel: prmy4
                                  channel prmy4: SID=71 instance=ECPMT1 device type=DISK
                                  
                                  allocated channel: stby
                                  channel stby: SID=148 device type=DISK
                                  
                                  Starting Duplicate Db at 03-DEC-12
                                  
                                  contents of Memory Script:
                                  {
                                     backup as copy reuse
                                     file  '/opt/app/oracle/product/11.1.0/db_1/dbs/orapwECPMT1' auxiliary format
                                   '/data/oracle/app/oracle/product/11.1.0/db_1/dbs/orapwECPMTSB'   ;
                                  }
                                  executing Memory Script
                                  
                                  Starting backup at 03-DEC-12
                                  Finished backup at 03-DEC-12
                                  
                                  contents of Memory Script:
                                  {
                                     backup as copy current controlfile for standby auxiliary format  '+DG_01';
                                     restore clone controlfile to  '+FRA_DG_01' from
                                   '+DG_01';
                                     sql clone 'alter database mount standby database';
                                  }
                                  executing Memory Script
                                  
                                  Starting backup at 03-DEC-12
                                  channel prmy1: starting datafile copy
                                  copying standby control file
                                  released channel: prmy1
                                  released channel: prmy2
                                  released channel: prmy3
                                  released channel: prmy4
                                  released channel: stby
                                  RMAN-00571: ===========================================================
                                  RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
                                  RMAN-00571: ===========================================================
                                  RMAN-03002: failure of Duplicate Db command at 12/03/2012 21:27:23
                                  RMAN-03015: error occurred in stored script Memory Script
                                  RMAN-03009: failure of backup command on prmy1 channel at 12/03/2012 21:27:23
                                  ORA-01580: error creating control backup file +DG_01/ecpmtsb/controlfile/
                                  ORA-17502: ksfdcre:3 Failed to create file +DG_01/ecpmtsb/controlfile/
                                  ORA-15113: alias name 'CONTROLFILE' refers to a directory
                                  
                                  RMAN>
                                  Also, is the setting for this RMAN env correct?:
                                  SNAPSHOT CONTROLFILE NAME TO '+DG_01/ecpmtsb/controlfile
                                  Edited by: BostonDBA on Dec 3, 2012 4:30 PM
                                  • 14. Re: RMAN Duplicate Standby failing to no AUTOBACKUP found for SPFILE
                                    mseberg
                                    Hello again;

                                    No I think it wants it to use only the diskgroup for the CONTROL_FILES parameter :

                                    +DG_01

                                    control_files='+DG_01'

                                    Best Regards

                                    mseberg
                                    1 2 Previous Next