RMAN point in time restore challenge 12c

RMAN point in time pdb restore (using duplicate), gives error due issue with different pdb. Using Oracle 12.1.0.2.0 This is the restore command, I was using: rman auxiliary / catalog rmanuser/password1@CATDB run{ set UNTIL TIME "to_date('2018-07-15 00:00:01','YYYY-MM-DD HH24:MI:SS')" ; DUPLICATE DATABASE 'proddb2' TO 'NI_REST' PLUGGABLE DATABASE CUSTX_PDB; }

Error [1] faced, due to another pdb issue Skipping pluggable database CUST_PDB5 Skipping pluggable database CUST_PDB6 RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-03002: failure of Duplicate Db command at 09/06/2018 16:44:40 RMAN-05501: aborting duplication of target database RMAN-06813: could not translate pluggable database STG_CUSTYPDB

Workaround, not using catalog rman auxiliary / target sys/password2@proddb2 run{ set UNTIL TIME "to_date('2018-07-15 00:00:01','YYYY-MM-DD HH24:MI:SS')" ; DUPLICATE DATABASE TO 'NI_REST' PLUGGABLE DATABASE CUSTX_PDB; }

Error [2] now faced, due to missing arc Executing: alter database datafile 832 offline drop Executing: alter database datafile 833 offline drop Executing: alter database datafile 834 offline drop starting media recovery unable to find archived log archived log thread=1 sequence=13054 Oracle Error: ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below ORA-01194: file 3 needs more recovery to be consistent ORA-01110: data file 3: '+DATA/NI_REST/DATAFILE/sysaux.675.986210261' RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-03002: failure of Duplicate Db command at 09/07/2018 13:24:29 RMAN-05501: aborting duplication of target database RMAN-03015: error occurred in stored script Memory Script RMAN-06054: media recovery requesting unknown archived log for thread 1 with sequence 13054 and starting SCN of 7885151161 RMAN>

Workaround

1. Restored around 15 archive log, starting from above sequence (13054, also for thread 2)
2. Redone the RMAN clone command
3. Opening db gave error with control file
4. Create backup control file, used RESETLOGS block
1. Removed all non NI_REST datafiles
2. Kept only 3 LOGFILE, they do not exits on filesystem
5. Run the backup control (notice has parent db name (PRODDB2) and resetlogs)
6. Start db with open resetlog
7. Opened the pdb successfully
8. Recreated the temp file

With the above, restore was successful. exported the schema from pdb and aux db dropped.


Appendix: catalog start with /u01/oracle/product/12102_01/dbs/' noprompt; alter database backup controlfile to trace as '/home/oracle/mydb_new.ctl.txt'; STARTUP NOMOUNT CREATE CONTROLFILE REUSE DATABASE "PRODDB2" RESETLOGS ARCHIVELOG MAXLOGFILES 192 MAXLOGMEMBERS 3 MAXDATAFILES 1024 MAXINSTANCES 32 MAXLOGHISTORY 584 LOGFILE GROUP 1 '+DATA/NI_REST/ONLINELOG/group_1.262.903320613' SIZE 1024M BLOCKSIZE 512, GROUP 2 '+DATA/NI_REST/ONLINELOG/group_2.263.903320623' SIZE 1024M BLOCKSIZE 512, GROUP 3 '+DATA/NI_REST/ONLINELOG/group_3.269.903321099' SIZE 1024M BLOCKSIZE 512 -- STANDBY LOGFILE DATAFILE '+DATA/NI_REST/DATAFILE/system.693.986210261', '+DATA/NI_REST/DATAFILE/sysaux.675.986210261', '+DATA/NI_REST/DATAFILE/undotbs1.683.986210259', '+DATA/NI_REST/2B4E02B966694E2CE0533F1C6F0A31F5/DATAFILE/system.461.986212971', '+DATA/NI_REST/2B4E02B966694E2CE0533F1C6F0A31F5/DATAFILE/sysaux.467.986212969', '+DATA/NI_REST/DATAFILE/undotbs2.474.986213075', '+DATA/NI_REST/2DB32189A8D41995E0533F1C6F0A911E/DATAFILE/system.459.986212545', '+DATA/NI_REST/2DB32189A8D41995E0533F1C6F0A911E/DATAFILE/sysaux.460.986212545', '+DATA/NI_REST/2DB32189A8D41995E0533F1C6F0A911E/DATAFILE/default_pdb_ts.611.986212545', '+DATA/NI_REST/2DB32189A8D41995E0533F1C6F0A911E/DATAFILE/users.561.986213451' CHARACTER SET AL32UTF8 ; alter database OPEN RESETLOGS; alter tablespace TEMP add tempfie '+DATA' size 150m;

Appendix: error SQL> alter database open resetlogs; alter database open resetlogs * ERROR at line 1: ORA-19838: Cannot use this control file to open database