RMAN DUPLICATE from Active Database
Step 1: Add oratab entry in Target -------------------------- PRODDB:/app/oracle/product/12202:N Step 2: create password file in Target (should be same as Source) ------------------------------ orapwd file=orapwPRODDB password=test123 entries=20 Step 3: Create static listener for Target DB ------------------------------------- LISTENER_PRODDB = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.16.0.5)(PORT = 1524)) )) SID_LIST_LISTENER_PRODDB = (SID_LIST = (SID_DESC = (GLOBAL_DBNAME = PRODDB) (ORACLE_HOME = /app/oracle/product/12202) (SID_NAME = PRODDB) ) ) Step 4: Add TNS entry of source & target in both servers ------------------------------------------------- PRODDB_source = (DESCRIPTION = (ADDRESS = (PROT...