Database Reference
In-Depth Information
You should now add the service names to the tnsnames.ora file. The entries used for this example are shown here:
CDBFSDCA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = server1.example.com ) (PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = CDBFSDCA)
)
)
CDBFSDCB =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = server2.example.com ) (PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = CDBFSDCB)
)
)
The following RMAN example will duplicate the database from the active database, in other words without an
intermediate backup. For this to work the databases must be statically registered with the listeners on each host and
for each database. A sample configuration necessary for the duplication ... from active database for the listener on
server1 is shown here:
$ cat $ORACLE_HOME/network/admin/listener.ora
[...]
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = CDBFSDCA)
(ORACLE_HOME = /u01/app/oracle/product/12.1.0.1/dbhome_1)
(SID_NAME = CDBFSDCA)
)
)
[...]
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
)
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = server1.example.com ) (PORT = 1521))
)
)
[...]
 
Search WWH ::




Custom Search