Version-12.1.0.2 OS-RHEL 6.1 RAC Primary ,Standby Single instance will be converted to RAC later on Gurus, I already have a primary CDB in active dataguard configuration, i plugged a non-cdb on primary container database and converted it PDB . I read that if active dataguard is setup then there is no need to copy files on standby, ADG will do it automatically for plugging operation.
Primary: Container database name is "OCO13C1"
SQL> show pdbs
CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
2 PDB$SEED READ ONLY NO
3 OD237PDB READ WRITE NO
4 OS237DUPPDB READ WRITE NO ---->This the PDB plugged in(nocopy option)
SQL> select name from v$datafile where con_id=3;
NAME
--------------------------------------------------------------------------------
+OCO13_DGA_DTA01/OCO13C1/2F32203AA73B8F1FE0535CD05B0A001B/DATAFILE/system.357.90
7757327
+OCO13_DGA_DTA01/OCO13C1/2F32203AA73B8F1FE0535CD05B0A001B/DATAFILE/sysaux.354.90
7757327
+OCO13_DGA_DTA01/OCO13C1/2F32203AA73B8F1FE0535CD05B0A001B/DATAFILE/users.371.907
757337
+OCO13_DGA_DTA01/OCO13C1/2F32203AA73B8F1FE0535CD05B0A001B/DATAFILE/tools.366.907
757365
NAME
--------------------------------------------------------------------------------
+OCO13_DGA_DTA01/OCO13C1/2F32203AA73B8F1FE0535CD05B0A001B/DATAFILE/sys_audit_aux
.368.907757367
SQL> select name from v$datafile where con_id=4 and rownum < 10;
NAME
--------------------------------------------------------------------------------
+OCO13_DGA_DTA01/os237dup/datafile/system01.dbf
+OCO13_DGA_DTA01/os237dup/datafile/sysaux01.dbf
+OCO13_DGA_DTA01/os237dup/datafile/users01.dbf
+OCO13_DGA_DTA01/os237dup/datafile/sys_da_01_audit01.dbf
+OCO13_DGA_DTA01/os237dup/datafile/tools01.dbf
+OCO13_DGA_DTA01/os237dup/datafile/sys_audit_aux01.dbf
+OCO13_DGA_DTA01/os237dup/datafile/ibis01_data_01.dbf
+OCO13_DGA_DTA01/os237dup/datafile/ibis01_data_02.dbf
+OCO13_DGA_DTA01/os237dup/datafile/ibis01_data_03.dbf
9 rows selected.
SQL>
Standby: Container database name is "OCO13C1S1"
SQL> alter database recover managed standby database disconnect from session using current logfile;
Database altered.
SQL> show dbs
SP2-0158: unknown SHOW option "dbs"
SQL> show pdbs
CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
2 PDB$SEED READ ONLY NO
3 OD237PDB READ ONLY NO
4 OS237DUPPDB MOUNTED
SQL>
----------------------------
MRP crashed here
---------------------------
SQL> show pdbs
CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
2 PDB$SEED READ ONLY NO
3 OD237PDB READ ONLY NO
4 OS237DUPPDB MOUNTED
SQL> select open_mode from v$database;
OPEN_MODE
--------------------
READ ONLY
alertlog of standby:
Completed: alter database recover managed standby database disconnect from session using current logfile
Recovery created pluggable database OS237DUPPDB
Recovery scanning directory ++OCO13_DGA_DTA01/OCO13C1S1/337004C514CD0265E0535CD05B0A2BFD/DATAFILE for any matching files
Errors with log +OCO13_DGA_ARC01/OCO13C1S1/ARCHIVELOG/2016_05_22/thread_3_seq_371.7070.912521475
MRP0: Background Media Recovery terminated with error 1274
Errors in file /oco13adm/oracle/diag/rdbms/oco13c1s1/OCO13C1S1N1/trace/OCO13C1S1N1_pr00_73140.trc:
ORA-01274: cannot add data file that was originally created as '+OCO13_DGA_DTA01/os237dup/datafile/system01.dbf'
ORA-01565: error in identifying file '+OCO13_DGA_DTA01'
ORA-17503: ksfdopn:2 Failed to open file +OCO13_DGA_DTA01
ORA-15045: ASM file name '+OCO13_DGA_DTA01' is not in reference form
Managed Standby Recovery not using Real Time Apply
2016-05-22 19:00:48.338000 -04:00
Recovery interrupted!
Recovered data files to a consistent state at change 22042363914
Errors in file /oco13adm/oracle/diag/rdbms/oco13c1s1/OCO13C1S1N1/trace/OCO13C1S1N1_pr00_73140.trc:
ORA-01274: cannot add data file that was originally created as '+OCO13_DGA_DTA01/os237dup/datafile/system01.dbf'
ORA-01565: error in identifying file '+OCO13_DGA_DTA01'
ORA-17503: ksfdopn:2 Failed to open file +OCO13_DGA_DTA01
ORA-15045: ASM file name '+OCO13_DGA_DTA01' is not in reference form
MRP0: Background Media Recovery process shutdown (OCO13C1S1N1)
SQL>
Please help me understand or what needs to be done to have the MRP started.
Thanks