Running RMAN to duplicate two Oracle 12.1.0 databases, using the below, I'm faced with an error I can't seem to find an answer too.
c:\rman TARGET sys/password@TEST AUXILIARY sys/password@TEST_SDBY connected to target database: TEST (DBID=226670971) connected to auxiliary database: TEST (not mounted) RMAN> DUPLICATE TARGET DATABASE 2> FOR STANDBY 3> FROM ACTIVE DATABASE 4> DORECOVER 5> NOFILENAMECHECK;
Which gives the following errors
rman-03002: failure of duplicate Db command rman-05501: aborting duplication of target database rman--5622: password file location could not be found for the auxiliary database
Following documents online on how to create the password file, this is what I did:
cd %ORACLE_HOME%\database ORAPWD FILE=PWDTEST.ora PASSWORD=password FORCE=y
I copied it from the Primary to the Secondary and put it in the same directory on the Secondary server.
I can't seem to figure what I've done incorrectly as I've followed multiple guides on how to set up a primary / secondary server for a dataguard environment. Nothing I've seen on searches seem to point to anything other than make sure your password file is correct.