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
ORACLE 12c rac备份异机单实例恢复(RMAN recover database出现RMAN-06054)
本文详细介绍了如何从Oracle 12c RAC环境中备份数据库并将其恢复到一个异机的单实例数据库,特别是在遇到RMAN-06054错误时的解决步骤。步骤包括源环境数据创建、RAC环境备份、目标环境的nomount启动、控制文件恢复、数据文件调整、数据库恢复、redo修改、新SPFILE创建、temp表空间重建等。针对RMAN-06054错误,提出了添加日志到恢复目录或进行不完全恢复的解决方案。
摘要由CSDN通过智能技术生成