A successful Duplicate database backup has been taken.
This Duplicate Database backup is to be restore to an alternate Oracle server with the same directory structureas the source Oracle server.
As per the NetVault Oracle APM documentation, all conditions and prerequisites have been met for a successful restore.
The auxiliary database (alternate) has been correctly prepared and started in NOMOUNT state.
However the restore fails with the below log messages:
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of Duplicate Db command at 02/11/2013 09:14:20
RMAN-06403: could not obtain a fully authorized session
RMAN-04006: error from auxiliary database: ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
The Oracle SID for the auxiliary database was used in the "Clone Database" tab instead of the "Oracle Net Service name".
While both SID and "Oracle Net Service name" could be the same on some environments, they may also be different values as they have different definitions.
SID:
The SID is a unique name for an Oracle database instance seen in the INSTANCE_NAME column of the instance's V$INSTANCE view.
It is also found in the instance entry in the LISTENER.ORA file and in the CONNECT_DATA section the connect descriptors in a TNSNAMES.ORA file.
Service Name:
The Oracle Net Service Name is a simple name for a service that resolves to a connect descriptor.
Users initiate a connect request by passing a username and password along with a net service name in a connect string for the service to which they wish to connect.
CONNECT username/password@net_service_name
In Windows for instance, the Service Name runs as a service for the instance and can be different from the actual SID.
In the TNSNAMES.ORA file below, "DEVDB.TEST" is the net service name and TESTORA the SID.
DEVDB.TEST =
(DESCRIPTION =
(ADDRESS =
(PROTOCOL = TCP)
(PORT = 1521)
(HOST = 10.10.10.99)
)
(CONNECT_DATA = (SID = TESTORA))
)
