This content has been marked as final. Show 3 replies
Not by itself it won't. Sounds like you SID is ORCL and your diagnostic_dest= is set to "$ORACLE_BASE/diag/"
If 11R2 you can use active dupicate
If that's what you are using make sure these are set :
Add these to both servers
INBOUND_CONNECT_TIMEOUT_ = 120
SQLNET.INBOUND_CONNECT_TIMEOUT = 120
Also make sure you have this setup :
When duplicating from an active database, you must first have connected as SYSDBA
to the auxiliary instance by means of a net service name.
This net service name must also be available on the source database instance.
The source database instance, to which RMAN is connected as TARGET, uses this net service name
to connect directly to the auxiliary database instance.
( In other words you need an entry for the CLONE in your TNSNAMES.ORA on both servers )
Its also worth double checking DB_FILE_NAME_CONVERT and LOG_FILE_NAME_CONVERT in the clone INIT.
When I do this I create an spfile from the INIT and start NOMOUNT on the new SPFILE
DUPLICATE TARGET DATABASE TO CLONEDBNAME FROM ACTIVE DATABASE NOFILENAMECHECK;
Thank you detailed instruction on active duplicate database. I will try some time.
You are right about "you SID is ORCL and your diagnostic_dest= is set to "$ORACLE_BASE/diag/"". My question is why it has TODI after toid in
Does Oracle pickup tns name and put after .../rdbms/toid/?
DIAGNOSTIC_DEST is from 11.1 or higher. If the $ORACLE_BASE environment variable does not exist then $ORACLE_HOME is used.
It works like this :
So the Default value is Derived from the value of ORACLE_BASE.
Trace files, Alert logs, and core file live there. I use it for the text ( non-xml ) version of the alert log.