RMAN - Fail To Restore Oracle DB with CDB and PDB I'm having some issues restoring an Oracle 12C database from one server into another one.
After trying this procedure:
1&gt;Connect to the ORIGIN Database server
2&gt; Create an rman script file:
CROSSCHECK ARCHIVELOG ALL;
CROSSCHECK BACKUP;  
DELETE EXPIRED
ARCHIVELOG ALL;
DELETE NOPROMPT OBSOLETE RECOVERY WINDOW OF 3 DAYS;
DELETE NOPROMPT EXPIRED BACKUP;
BACKUP AS COMPRESSED BACKUPSET DATABASE PLUS ARCHIVELOG TAG DAILY_BKP DELETE INPUT MAXSETSIZE=5G KEEP UNTIL TIME 'sysdate+3';   
spool log to '&lt;bkp_logfile&gt;';
EXIT;


Run the command:
export ORACLE_SID=;rman target / @

After the backup finished, copy the files to the DESTINATION database server. Also copy the backup control files.

Connect to the DESTINATION database server

Create pfile:


     *.audit_file_dest='&lt;Path1&gt;\adump'
        *.audit_trail='db'
        *.compatible='12.2.0.0.0'
        *.control_files='&lt;Path2&gt;\control01.ctl','&lt;Path2&gt;\control02.ctl'
        *.db_block_size=8192
        *.db_domain=''
        *.db_name='CAODB01U'
        *.db_recovery_file_dest='&lt;Path2&gt;'
        *.db_recovery_file_dest_size=10737418240
        *.diagnostic_dest='&lt;PAth Diagnostic&gt;'
        *.dispatchers='(PROTOCOL=TCP) (SERVICE=CDBXDB)'
        *.enable_pluggable_database=true
        *.memory_target=2729m
        *.open_cursors=300
        *.processes=500
        *.remote_login_passwordfile='EXCLUSIVE'
        *.undo_tablespace='UNDOTBS1'


rman&gt; target /

rman&gt;startup nomount pfile='&lt; pfile &gt;'

rman&gt;restore controlfile from '&lt; Path of datafile &gt;';

rman&gt;Alter database mount;

rman&gt;catalog start with '';

rman&gt;restore database;

rman&gt;recover database;

rman&gt;alter database open resetlogs;


After the last step the message i get the message:
&gt; RMAN-00571:
&gt; =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS
&gt; =============== RMAN-00571: =========================================================== RMAN-03002: failure of sql statement command at 05/20/2021 12:21:30
&gt; ORA-01152: file 1 was not restored from a sufficiently old backup
&gt; ORA-01110: data file 1: '&lt;Path DB &gt;\SYSTEM01.DBF'

As ive seen in all the procedures to restore it, that should be the way to do it , but it doesnt seems to be working. Does anyone have an idea of what im doing wrong?
Also, when i try with
restore database;
recover database;
it tells that there are some datafiles missing, but there shouldnt be missing because its supposed to be a full backup.
The error message is a bit confusing. Normally this is solved by feeding a few extra archives to the recovery process and issue a cancel.
Do this using sqlplus.
Let it recover an archive and when it asks for the next archive issue 'cancel'. Most of the times the database will open.