Estava executando um duplicate para criar um Oracle Standby quando foi reportado o seguinte erro:
}2> 3> 4> 5> 6> 7> 8> 9> 10> 11> 12> 13> 14> 15> 16> 17> 18> 19> 20> using target database control file instead of recovery catalog allocated channel: D1 channel D1: SID=83 device type=DISK allocated channel: D2 channel D2: SID=81 device type=DISK allocated channel: D3 channel D3: SID=62 device type=DISK allocated channel: D4 channel D4: SID=26 device type=DISK allocated channel: AUX1 channel AUX1: SID=1 device type=DISK Starting Duplicate Db at 27-MAR-17 released channel: D1 released channel: D2 released channel: D3 released channel: D4 released channel: AUX1 RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-03002: failure of Duplicate Db command at 03/27/2017 16:41:19 RMAN-05501: aborting duplication of target database RMAN-06217: not connected to auxiliary database with a net service name
Neste caso, como é um Duplicate from Active Database é necessário a adição de uma entrada estática no arquivo Listener.ora do banco de dados auxiliar, além de utilizar a string de conexão na execução do Duplicate tanto para o banco de dados Auxiliar como para o target.
LISTENER_DG2 =
(DESCRIPTION_LIST =
(DESCRIPTION =
(GLOBAL_DBNAME = dg2)
(ORACLE_HOME = /u01/app/oracle/product/11.2.0/dbhome_1)
(SID_NAME = dg2)
(ADDRESS = (PROTOCOL = TCP)(HOST = dg32.localdomain)(PORT = 1524))
)
)
SQL*Plus: Release 11.2.0.3.0 Production on Tue Mar 28 04:56:01 2017
Copyright (c) 1982, 2011, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL> show parameters listener
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
listener_networks string
local_listener string (DESCRIPTION=(ADDRESS=(PROTOCO
L=tcp)(HOST=dg32.localdomain)(
PORT=1524))(GLOBAL_DBNAME=dg2)
(ORACLE_HOME=/u01/app/oracle/p
roduct/11.2.0/dbhome_1)(SID_NA
ME=dg2))
Depois reexecutei o duplicate e finalizou com sucesso:
[oracle@dg32 dbs]$ rman
Recovery Manager: Release 11.2.0.3.0 - Production on Mon Mar 27 18:00:33 2017
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
RMAN> connect TARGET SYS/*****@orcl
connected to target database: ORCL (DBID=1466446185)
RMAN> CONNECT AUXILIARY SYS/*****@dg2
connected to auxiliary database: ORCL (not mounted)
RMAN> RUN {
DUPLICATE TARGET DATABASE FOR STANDBY FROM ACTIVE DATABASE NOFILENAMECHECK;
}2> 3>
Starting Duplicate Db at 27-MAR-17
using target database control file instead of recovery catalog
allocated channel: ORA_AUX_DISK_1
channel ORA_AUX_DISK_1: SID=19 device type=DISK
....
Finished Duplicate Db at 27-MAR-17
*The views expressed here are my own and do not represent those of my employer.*
Hello, I’m Bruno — a dual citizen of Brazil and Sweden. I bring a global perspective shaped by experiences in both South America and Europe, with a strong focus on collaboration and innovation across cultures. I am a Computer Scientist, PhD Candidate in Information and Communication Technologies, focusing on Data Science and Artificial Intelligence, and hold dual Master’s degrees in Data Science and Cybersecurity. With over fifteen years of international experience spanning Brazil, Hungary, and Sweden, I have collaborated with global organizations such as IBM, Playtech, and Oracle, as well as contributed remotely to projects across multiple regions. My professional interests include Databases, Cybersecurity, Cloud Computing, Data Science, Data Engineering, Big Data, Artificial Intelligence, Programming, and Software Engineering, all driven by a deep passion for transforming data into strategic business value.