Restore failing for PDB when CDB in "noarchivelog" mode.
Hi, a query on restoring a pdb (of a noarchivelog cdb) results in ORA-01113 file needs recovery every time I do it.
I am running the following RMAN commands ...
RMAN> alter pluggable database ttsupp close;
RMAN> restore pluggable database ttsupp from tag "TUE-19-JUL-2016-16:19-DB";
RMAN> recover pluggable database ttsupp;
RMAN> alter pluggable database ttsupp open;
and then I get an error ....
RMAN-03002: failure of sql statement command at 07/21/2016 13:55:42
ORA-01113: file 17 needs media recovery
ORA-01110: data file 17: '/data/oradata/cdb0/ttsupp/DPU_INDEXES.dbf'
I've tried "recover" with options to"resetlogs" and "noredo" but all fail when I open PDB. CDB backup and recovery is fine. Any help would be greatly appreciated.
Tagged:
1