Senhores,
Estou fazendo um duplicate database for standby
abaixo esta o script que estou utilizando.
ambos ambientes em linux Redhat 5.5 32 bits Oracle 11R2.
e estou tendo o erro RMAN-04006: error from auxiliary database:
ORA-12528: TNS:listener: all appropriate instances are blocking new connections
ao se conectar pelo rman.
O detalhe é que a instance do destino esta em nomount mas não consigo conectar
pela string de conexão @st11g
e caso tento me conectar por / ele reclama com o erro
RMAN-03002: failure of Duplicate Db command at 08/24/2010 01:46:53
RMAN-06217: not connected to auxiliary database with a net service name
Recovery Manager: Release 11.1.0.6.0 - Production on Fri Jan 11 23:35:25 2008
Copyright (c) 1982, 2007, Oracle. All rights reserved.
connect target sys/ora...@db11g
connect auxiliary sys/ora...@st11g
run {
allocate channel c1 type disk;
allocate channel c2 type disk;
allocate auxiliary channel s1 type disk;
duplicate target database for standby from active database
spfile
parameter_value_convert 'db11g','st11g'
set 'db_unique_name'='st11g'
set 'db_file_name_convert'='db11g','st11g'
set log_file_name_convert='db11g','st11g'
set control_files='+DG1/st11g/control01.ctl'
set log_archive_max_processes='2'
set fal_client='st11g'
set fal_server='db11g'
set standby_file_management='AUTO'
set log_archive_config='dg_config=(db11g,st11g)'
set log_archive_dest_2='service=oradba11 LGWR ASYNC
valid_for=(ONLINE_LOGFILES,PRIMARY_ROLE) db_unique_name=st11g'
set log_archive_dest_state_2='enable'
;
sql channel c1 "alter system set
log_archive_config=''dg_config=(db11g,st11g)''";
sql channel c2 "alter system set log_archive_dest_2=''service=st11g LGWR
ASYNC valid_for=(ONLINE_LOGFILES,PRIMARY_ROLE) db_unique_name=st11g''";
sql channel c1 "alter system set log_archive_max_processes=5";
sql channel c2 "alter system set fal_client=db11g";
sql channel c1 "alter system set fal_server=st11g";
sql channel c2 "alter system set standby_file_management=AUTO";
sql channel c1 "alter system set log_archive_dest_state_2=enable";
sql channel c2 "alter system archive log current";
sql channel s1 "alter database recover managed standby database using
current logfile disconnect";
}
