Oracle 12.1.0.2
Oracle Linux 6.8
I'm trying to test an RMAN restore by using SCP to copy archivelog, the last full backup, and the last few days of auto backup to a remote sever with the same version of the OS and Oracle. The directory structure is the same.
I have a small script which does this first:
$ORACLE_HOME/bin/rman
CONNECT TARGET /
STARTUP NOMOUNT;
It then sets the DBID and does (or tries to) this:
RUN
{
ALLOCATE CHANNEL c1 DEVICE TYPE disk format '/u01/app/oracle/fast_recovery_area/CDBNCAR/backupset/2017_12_11/';
restore controlfile from autobackup;
ALTER DATABASE MOUNT;
RESTORE DATABASE;
RECOVER DATABASE;
release channel c1;
}
ALTER DATABASE OPEN RESETLOGS;
exit
The error I get is this:
released channel: c1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 12/11/2017 14:11:46
RMAN-06026: some targets not found - aborting restore
RMAN-06023: no backup or copy of datafile 9 found to restore
RMAN-06023: no backup or copy of datafile 8 found to restore
RMAN-06023: no backup or copy of datafile 7 found to restore
RMAN-06023: no backup or copy of datafile 5 found to restore
Validate database shows no issue with any of these files. Two of the files are pdbseed files (system and sysaux) and the other two are the SYSTEM and SYSAUX from the real pluggable. RC_BACKUP_DATAFILE in the catalog shows all of these in the backup.
I tried changing the script to get the controlfile from the backup instead of autobackup. The results are the same.
Ideas, comments and clues welcome.
mseberg