lsnrctl status LSNRCTL for IBM/AIX RISC System/6000: Version 11.2.0.2.0 - Production on 21-JUN-2012 09:13:57
Copyright (c) 1991, 2010, Oracle. All rights reserved. Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521)) STATUS of the LISTENER ------------------------ Alias LISTENER Version TNSLSNR for IBM/AIX RISC System/6000: Version 11.2.0.2.0 - Production Start Date 08-MAY-2012 12:40:27 Uptime 43 days 20 hr. 33 min. 30 sec Trace Level off Security ON: Local OS Authentication SNMP ON Listener Log File /u01/app/oracle/diag/tnslsnr/servidor/listener/alert/log.xml Listening Endpoints Summary... (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=servidor.prd.empresa.local)(PORT=1521))) Services Summary... Service "+ASM" has 1 instance(s). Instance "+ASM", status READY, has 1 handler(s) for this service... Service "DATAGUARDOK" has 1 instance(s). Instance "DATAGUARDOK", status READY, has 1 handler(s) for this service... Service "DATAGUARDOKXDB" has 1 instance(s). Instance "DATAGUARDOK", status READY, has 1 handler(s) for this service... Service "NOVADEHISTORICO" has 1 instance(s). Instance "NOVADEHISTORICO", status BLOCKED, has 1 handler(s) for this service... The command completed successfully --- Em oracle_br@yahoogrupos.com.br, "cassulcamilojacinto" <cassulcamilojacinto@...> escreveu > > Caros ilustres tenho o seguinte ambiente > > Bdproducao > > Dataguard da bdproducao ( usados para consulta apenas ) > > E preciso de fazer um duplicate do Dataguard para criar uma base de dados de > instancia única para ser uma base de dados de histórico . E o servidor > Dataguard terá o Dataguard e uma instancia normal para histórico de dados. > > > Criei a estrutura para a nova base de dados e fiz o startup nomount e tudo > ok, defini as coisas no listener e no tnsnames e ficou tudo quase ok, mas a > nova instancia ficou com o estado blocked no listener. > > Entrei no rman na boa definindo o target( Dataguard ) e o auxiliary (nova > base de dados de instancia única ) > > Ao fazer o comando duplicate database from active to novabasededados da logo > um erro, o seguinte erro > RMAN-00571: =========================================================== > RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== > RMAN-00571: =========================================================== > RMAN-03002: failure of Duplicate Db command at 06/12/2011 22:52:46 > RMAN-06174: not connected to auxiliary database > RMAN-03015: error occurred in stored script Memory Script > RMAN-04006: error from auxiliary database: ORA-12514: TNS:listener does not > currently know of service requested in connect descriptor >