Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

RMAN only Point in time recovery for only 1 PDB from FULL backup

Venkadesh RajaJun 4 2019 — edited Jun 4 2019

Hi,

Is it possible to restore(Point in time recovery) only PDB from full database backup.

For instance:

i have a CDB database with 3 PDBs(PDB1,PDB2,PDB3) and i am taking a full database backup on 01-JUN-2019 using command "backup database plus archivelog".

Now today(04-JUN-2019). i want to restore only PDB2 back to 01-JUN-2019. is it possible . can i use below command to do that ?

RUN {

SET UNTIL TIME "TO_DATE('15-MAY-2019 05:45:00','DD-MON-YYYY HH24:MI:SS')";

RESTORE PLUGGABLE DATABASE PDB2;

RECOVER PLUGGABLE DATABASE PDB2 AUXILIARY DESTINATION='/u02/aux';

}

Please help

This post has been answered by Sunny kichloo on Jun 4 2019

Jump to Answer

Added on Jun 4 2019

#general-database-discussions

2 comments

1,411 views