Hello,
I have a situation or I can say a scenario. It's purely for testing basis. Database is on 12.1.0.1 on Linux machine using ASM (OMF).
Standby is created on other machine with same platform and that too uses ASM (OMF) and is in sync with the primary. Now, suppose I create a PDB on the primary from SEED and it gets created successfully.
After a couple of log switches, the redo gets transmitted to the standby, but MRP fails due to naming conventions. Agreed with this !! Now, on the primary, I remove the newly created PDB (Dropped the newly created PDB). Again a couple of log switches which gets transmitted to the standby. Of course, the standby is still out of sync.
Now, how do I get back my standby in sync with the primary ? I cannot go for roll forward method as the required datafile (new PDB) does not exist on the primary site as well. I get the following error:
RMAN> recover database from service prim noredo using compressed backupset;
Starting recover at 08-NOV-15
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=70 instance=stby device type=DISK
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 11/08/2015 18:55:32
ORA-19846: cannot read header of datafile 21 from remote site
Any clues on how do I go ahead ? Of course, recreating standby is an option as its purely on testing basis, but I do not want to with the recreation.
Thanks.