ORACLE 12c rac备份异机单实例恢复(RMAN recover database出现RMAN-06054)

1.首先在源rac 环境创造 数据，任何能体现与恢复环境不同的情况都可以。

本次模拟环境的目标机器上有一个db名与rac库一致的单实例db简略部分步骤

insert into test.table1 values('2','B');
insert into test.table1 values('3','C');
commit;

2.对源库rac环境进行备份

#!/bin/sh 
export
BACKUP_DATE=`date +%d`
RMAN_LOG_FILE=/backup/backup_test0_pdb_`date +%y%m%d`.log
TODAY=`date`
USER=`id|cut -d "(" -f2|cut -d ")" -f1`
echo "-----------------$TODAY-------------------">$RMAN_LOG_FILE
export PATH
export ORACLE_BASE=/u01/oracle/app/oracle
export ORACLE_HOME=/u01/oracle/app/oracle/product/12.1.0/db_1
export PATH=$ORACLE_HOME/bin:$PATH
export ORACLE_SID=racdb1
ORACLE_SID=racdb1
export ORACLE_SID
ORACLE_USER=oracle
export ORACLE_USER
echo "ORACLE_SID: $ORACLE_SID">>$RMAN_LOG_FILE
echo "ORACLE_HOME:$ORACLE_HOME">>$RMAN_LOG_FILE
echo "ORACLE_USER:$ORACLE_USER">>$RMAN_LOG_FILE
echo "==========================================">>$RMAN_LOG_FILE
echo "BACKUP DATABASE BEGIN......">>$RMAN_LOG_FILE
echo "                   ">>$RMAN_LOG_FILE
chmod 666 $RMAN_LOG_FILE
WEEK_DAILY=`date +%a`
echo "WARING!!!!!!!!! BEGIN TO BACKUP!!!!!!">>$RMAN_LOG_FILE
echo "Today is : $WEEK_DAILY incremental level= 0">>$RMAN_LOG_FILE

rman nocatalog target / log $RMAN_LOG_FILE  <<EOF
run{
allocate channel c1 type disk;
allocate channel c2 type disk;
allocate channel c3 type disk;
allocate channel c4 type disk;
alter system switch logfile ;
alter system switch logfile ;
alter system switch logfile ;
alter system switch logfile ;
CONFIGURE CONTROLFILE AUTOBACKUP ON;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/backup/ctl_lev0_backup_%d.%F.conf';
backup  incremental level=0 skip inaccessible filesperset 6 database format='/backup/data_lev0_%U_%T'  tag='backup_lev0';
backup filesperset 5 format '/backup/racdb_%d_%T_%s' archivelog all ; 
backup current controlfile format '/backup/ctl_lev0_%U_%T';
alter system switch logfile ;
release channel c2;
release channel c1;
release channel c3;
release channel c4;
}
allocate channel for maintenance device type disk; 
report obsolete; 
delete noprompt obsolete; 
crosscheck backup; 
delete noprompt expired backup;
list backup summary; 
release channel;
EOF

3.以更改好的pfile 文件启动数据库到nomount状态，相关pfile文件涉及的目录需要被创建及赋权 

.audi