This discussion is archived
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 Newbie
Currently Being Moderated
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 Newbie
    Currently Being Moderated
    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 Pro
    Currently Being Moderated
    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 Guru
    Currently Being Moderated
    Hello,

    Can you please post your standby pfile contents ?


    Regards,
    Shivananda
  • 4. Re: RMAN Duplicate Standby failing to no AUTOBACKUP found for SPFILE
    975078 Newbie
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Guru
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Guru
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Guru
    Currently Being Moderated
    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 Guru
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Guru
    Currently Being Moderated
    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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points