Menu de navegação

[mpunganParticipante]

Pessoal esta ocorrendo o erro abaixo, estou tentando usar o duplicate do RMAN. As informações de configuração se encontram abaixo do erro. Se alguém puder dar uma força. Desde já agradeço.

[oracle@gabao dbs]$ rman target sys/teste123 AUXILIARY sys/teste123@TESTECL

Recovery Manager: Release 11.2.0.3.0 – Production on Thu May 2 11:11:01 2013

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

connected to target database: TESTE (DBID=111266568)
connected to auxiliary database: TESTECL (not mounted)

RMAN> duplicate target database to TESTECL;

Starting Duplicate Db at 02-MAY-13
using target database control file instead of recovery catalog
allocated channel: ORA_AUX_DISK_1
channel ORA_AUX_DISK_1: SID=20 device type=DISK

contents of Memory Script:
{
sql clone “create spfile from memory”;
}
executing Memory Script

sql statement: create spfile from memory

contents of Memory Script:
{
shutdown clone immediate;
startup clone nomount;
}
executing Memory Script

Oracle instance shut down

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of Duplicate Db command at 05/02/2013 11:12:42
RMAN-06174: not connected to auxiliary database
RMAN-03015: error occurred in stored script Memory Script
RMAN-04006: error from auxiliary database: ORA-01031: insufficient privileges

######################################################

Configurações do servidor principal – TESTE

LISTENER.ORA
————–

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = teste)
(ORACLE_HOME = /oracle/product/11.2.0/dbhome_1)
(SID_NAME = teste)
)
)

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.40.48.80)(PORT = 1521))
)
)

ADR_BASE_LISTENER = /oracle

TNSNAME.ORA
————–
TESTE =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.40.48.80)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = TESTE)
)
)

TESTECL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.40.48.81)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = TESTECL)(UR=A)
)
)

[oracle@gabao admin]$ tnsping testecl

TNS Ping Utility for Linux: Version 11.2.0.3.0 – Production on 02-MAY-2013 14:27:15

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

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

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

initTESTE.ora
————-
TESTE.__java_pool_size=16777216
TESTE.__large_pool_size=16777216
TESTE.__oracle_base=’/oracle’#ORACLE_BASE set from environment
TESTE.__pga_aggregate_target=671088640
TESTE.__sga_target=989855744
TESTE.__shared_io_pool_size=0
TESTE.__shared_pool_size=335544320
TESTE.__streams_pool_size=16777216
*.audit_file_dest=’/oracle/admin/TESTE/adump’
*.audit_trail=’db’
*.compatible=’11.2.0.0.0′
*.control_files=’/oracle/oradata/TESTE/control01.ctl’,’/oracle/fast_recovery_area/TESTE/control02.ctl’
*.db_block_size=8192
*.db_domain=”
*.db_name=’TESTE’
*.db_recovery_file_dest=’/oracle/fast_recovery_area’
*.db_recovery_file_dest_size=4322230272
*.diagnostic_dest=’/oracle’
*.dispatchers='(PROTOCOL=TCP) (SERVICE=TESTEXDB)’
*.log_archive_dest_1=’LOCATION=/oracle/oradata/arch/’
*.log_archive_format=’arch_%t_%s_%r.dbf’
*.memory_target=1656750080
*.open_cursors=300
*.processes=150
*.remote_login_passwordfile=’EXCLUSIVE’
*.undo_tablespace=’UNDOTBS1′

################################################

Configurações do servidor STANDBY – TESTECL

LISTENER.ORA
————–
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = testecl)
(ORACLE_HOME = /oracle/product/11.2.0/dbhome_1)
(SID_NAME = testecl)
)
)

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.40.48.81)(PORT = 1521))
)
)

ADR_BASE_LISTENER = /oracle

TNSNAMES.ORA
—————
TESTECL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.40.48.81)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = TESTECL)
)
)

TESTE =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.40.48.80)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = TESTE)
)
)

[oracle@sudao admin]$ tnsping teste

TNS Ping Utility for Linux: Version 11.2.0.3.0 – Production on 02-MAY-2013 14:27:56

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

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

Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 10.40.48.80)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = TESTE)))
OK (40 msec)

initTESTECL.ORA
—————-
*.__db_cache_size=656M
TESTECL.__db_cache_size=671088640
TESTECL.__java_pool_size=16777216
*.__large_pool_size=16M
TESTECL.__large_pool_size=16777216
*.__oracle_base=’/oracle’# ORACLE_BASE set from environment
TESTECL.__pga_aggregate_target=671088640
TESTECL.__sga_target=989855744
TESTECL.__shared_io_pool_size=0
TESTECL.__shared_pool_size=251658240
TESTECL.__streams_pool_size=0
*._aggregation_optimization_settings=0
*._always_anti_join=’CHOOSE’
*._always_semi_join=’CHOOSE’
*._and_pruning_enabled=TRUE
*._b_tree_bitmap_plans=TRUE
*._bloom_filter_enabled=TRUE
*._bloom_folding_enabled=TRUE
*._bloom_pruning_enabled=TRUE
*._complex_view_merging=TRUE
*._compression_compatibility=’11.2.0.0.0′
*._connect_by_use_union_all=’TRUE’
*._convert_set_to_join=FALSE
*._cost_equality_semi_join=TRUE
*._cpu_to_io=0
*._dimension_skip_null=TRUE
*._eliminate_common_subexpr=TRUE
*._enable_type_dep_selectivity=TRUE
*._fast_full_scan_enabled=TRUE
*._first_k_rows_dynamic_proration=TRUE
*._gby_hash_aggregation_enabled=TRUE
*._generalized_pruning_enabled=TRUE
*._globalindex_pnum_filter_enabled=TRUE
*._gs_anti_semi_join_allowed=TRUE
*._improved_outerjoin_card=TRUE
*._improved_row_length_enabled=TRUE
*._index_join_enabled=TRUE
*._ksb_restart_policy_times=’0′,’60’,’120′,’240’# internal update to set default
*._left_nested_loops_random=TRUE
*._local_communication_costing_enabled=TRUE
*._minimal_stats_aggregation=TRUE
*._mmv_query_rewrite_enabled=TRUE
*._new_initial_join_orders=TRUE
*._new_sort_cost_estimate=TRUE
*._nlj_batching_enabled=1
*._optim_adjust_for_part_skews=TRUE
*._optim_enhance_nnull_detection=TRUE
*._optim_new_default_join_sel=TRUE
*._optim_peek_user_binds=TRUE
*._optimizer_adaptive_cursor_sharing=TRUE
*._optimizer_better_inlist_costing=’ALL’
*._optimizer_cbqt_no_size_restriction=TRUE
*._optimizer_coalesce_subqueries=TRUE
*._optimizer_complex_pred_selectivity=TRUE
*._optimizer_compute_index_stats=TRUE
*._optimizer_connect_by_combine_sw=TRUE
*._optimizer_connect_by_cost_based=TRUE
*._optimizer_connect_by_elim_dups=TRUE
*._optimizer_correct_sq_selectivity=TRUE
*._optimizer_cost_based_transformation=’LINEAR’
*._optimizer_cost_hjsmj_multimatch=TRUE
*._optimizer_cost_model=’CHOOSE’
*._optimizer_dim_subq_join_sel=TRUE
*._optimizer_distinct_agg_transform=TRUE
*._optimizer_distinct_elimination=TRUE
*._optimizer_distinct_placement=TRUE
*._optimizer_eliminate_filtering_join=TRUE
*._optimizer_enable_density_improvements=TRUE
*._optimizer_enable_extended_stats=TRUE
*._optimizer_enable_table_lookup_by_nl=TRUE
*._optimizer_enhanced_filter_push=TRUE
*._optimizer_extend_jppd_view_types=TRUE
*._optimizer_extended_cursor_sharing=’UDO’
*._optimizer_extended_cursor_sharing_rel=’SIMPLE’
*._optimizer_extended_stats_usage_control=192
*._optimizer_false_filter_pred_pullup=TRUE
*._optimizer_fast_access_pred_analysis=TRUE
*._optimizer_fast_pred_transitivity=TRUE
*._optimizer_filter_pred_pullup=TRUE
*._optimizer_fkr_index_cost_bias=10
*._optimizer_full_outer_join_to_outer=TRUE
*._optimizer_group_by_placement=TRUE
*._optimizer_improve_selectivity=TRUE
*._optimizer_interleave_jppd=TRUE
*._optimizer_join_elimination_enabled=TRUE
*._optimizer_join_factorization=TRUE
*._optimizer_join_order_control=3
*._optimizer_join_sel_sanity_check=TRUE
*._optimizer_max_permutations=2000
*._optimizer_mode_force=TRUE
*._optimizer_multi_level_push_pred=TRUE
*._optimizer_native_full_outer_join=’FORCE’
*._optimizer_new_join_card_computation=TRUE
*._optimizer_null_aware_antijoin=TRUE
*._optimizer_or_expansion=’DEPTH’
*._optimizer_order_by_elimination_enabled=TRUE
*._optimizer_outer_join_to_inner=TRUE
*._optimizer_outer_to_anti_enabled=TRUE
*._optimizer_push_down_distinct=0
*._optimizer_push_pred_cost_based=TRUE
*._optimizer_rownum_bind_default=10
*._optimizer_rownum_pred_based_fkr=TRUE
*._optimizer_skip_scan_enabled=TRUE
*._optimizer_sortmerge_join_inequality=TRUE
*._optimizer_squ_bottomup=TRUE
*._optimizer_star_tran_in_with_clause=TRUE
*._optimizer_system_stats_usage=TRUE
*._optimizer_table_expansion=TRUE
*._optimizer_transitivity_retain=TRUE
*._optimizer_try_st_before_jppd=TRUE
*._optimizer_undo_cost_change=’11.2.0.3′
*._optimizer_unnest_corr_set_subq=TRUE
*._optimizer_unnest_disjunctive_subq=TRUE
*._optimizer_use_cbqt_star_transformation=TRUE
*._optimizer_use_feedback=TRUE
*._or_expand_nvl_predicate=TRUE
*._ordered_nested_loop=TRUE
*._parallel_broadcast_enabled=TRUE
*._partition_view_enabled=TRUE
*._pivot_implementation_method=’CHOOSE’
*._pre_rewrite_push_pred=TRUE
*._pred_move_around=TRUE
*._push_join_predicate=TRUE
*._push_join_union_view=TRUE
*._push_join_union_view2=TRUE
*._px_minus_intersect=TRUE
*._px_partition_scan_enabled=TRUE
*._px_pwg_enabled=TRUE
*._px_ual_serial_input=TRUE
*._query_rewrite_setopgrw_enable=TRUE
*._remove_aggr_subquery=TRUE
*._replace_virtual_columns=TRUE
*._right_outer_hash_enable=TRUE
*._selfjoin_mv_duplicates=TRUE
*._sql_model_unfold_forloops=’RUN_TIME’
*._subquery_pruning_enabled=TRUE
*._subquery_pruning_mv_enabled=FALSE
*._table_scan_cost_plus_one=TRUE
*._union_rewrite_for_gs=’YES_GSET_MVS’
*._unnest_subquery=TRUE
*._use_column_stats_for_function=TRUE
*.audit_file_dest=’/oracle/admin/TESTE/adump’
*.audit_trail=’DB’
*.background_dump_dest=’/oracle/diag/rdbms/testecl/TESTECL/trace’#Deprecate parameter
*.compatible=’11.2.0.0.0′
*.control_files=’/oracle/oradata/TESTE/control01.ctl’,’/oracle/fast_recovery_area/TESTE/control02.ctl’
*.core_dump_dest=’/oracle/diag/rdbms/testecl/TESTECL/cdump’
*.db_block_size=8192
*.db_domain=”
*.db_file_name_convert=’/oracle/oradata/TESTE/’,’/oracle/oradata/TESTE/’
*.db_name=’TESTECL’
*.db_recovery_file_dest=’/oracle/fast_recovery_area’
*.db_recovery_file_dest_size=4122M
*.db_unique_name=’TESTECL’#Modified by RMAN duplicate
*.diagnostic_dest=’/oracle’
*.dispatchers='(PROTOCOL=TCP) (SERVICE=TESTEXDB)’
*.log_buffer=6803456# log buffer update
*.log_file_name_convert=’/oracle/oradata/TESTE/’,’/oracle/oradata/TESTE/’
*.memory_target=1584M
*.open_cursors=300
*.optimizer_dynamic_sampling=2
*.optimizer_mode=’ALL_ROWS’
*.plsql_warnings=’DISABLE:ALL’# PL/SQL warnings at init.ora
*.processes=150
*.query_rewrite_enabled=’TRUE’
*.remote_login_passwordfile=’EXCLUSIVE’
*.result_cache_max_size=4064K
*.skip_unusable_indexes=TRUE
*.undo_tablespace=’UNDOTBS1′
*.user_dump_dest=’/oracle/diag/rdbms/testecl/TESTECL/trace’#Deprecate parameter
*.db_file_name_convert=’/oracle/oradata/TESTE’,’/oracle/oradata/TESTECL’
*.log_file_name_convert=’/oracle/oradata/TESTE’,’/oracle/oradata/TESTECL’

[Fábio PradoParticipante]

@mpungan,

Antes de executar o duplicate vc havia copiado o password file do Bd de origem p/ o bd destino?

[]s

[Autor]

Posts