RAC+ASM在单机上恢复的过程.docVIP

RAC+ASM在单机上恢复的过程 环境：正式环境是IBM4+IBM5(RAC)，测试环境是IBM1，两环境的OS，ORACLE等软件一样。 都是 ORACLE10203, AIX(5300-07), 备份操作放在IBM4上执行。 一 背景介绍： 1 RAC环境的备份策略 每天作两次备份，0点和12点，备份脚本一样，只是中午12点的备份，输出的msglog=backup_ccdb_inc_0_12_$today.log,以别于0点的操作。 IBM4 -crontab -l 0 0 * * * /orabak/script/rmandbbackup.sh/dev/null 21 0 12 * * * /orabak/script/rmandbbackup_12.sh/dev/null 21 IBM4 -more /orabak/script/rmandbbackup.sh export ORACLE_HOME=/oracle/product/10.2.0/db_1 export ORACLE_SID=ccdb1 export NLS_LANG=AMERICAN_AMERICA.ZHS16GBK today=`date +%Y%m%d` weekday=`date +%w` backuppath=/orabak $ORACLE_HOME/bin/rman cmdfile=$backuppath/script/backup_ccdb_inc_0.script msglog=$backuppath/rmanbacktrace/backup_ccdb_inc_0_$today.log if test $? -ne 0; then touch $backuppath/rmanbacktrace/ccdb incremental level 0 backup failed! Date: $today $ORACLE_HOME/bin/sqlplus -S / as sysdba @$backuppath/script/insertsms.sql fi; IBM4 -more $backuppath/script/backup_ccdb_inc_0.script /script/backup_ccdb_inc_0.script: No such file or directory IBM4 -more /orabak/script/backup_ccdb_inc_0.script connect target / connect catalog rman/xxxxxxxx@bi run { allocate channel d1 type disk maxpiecesize 4000m ; backup as compressed backupset incremental level = 0 database format /orabak/databackup/db_%d_%s_%p_%T plus archivelog skip inaccessible delete all input format /orabak/logbackup/log_%d_%s_%p_%T; sql alter system archive log current; release channel d1; } run { crosscheck backup; delete noprompt expired backup; delete noprompt obsolete recovery window of 7 days; } exit; IBM4 - 2 恢复前，需要将在IBM4上的备份拷贝到IBM1。由于IBM4的上备份集的保存路径为/ORABAK，而IBM1上只有/ORADATA， 拷贝过来的备份集将存在此目录下，故，恢复数据库前，需要告诉RMAN备份集的路径（步骤6）。 二 准备工作，把备份集拷贝到IBM1下 如下：备份集已经拷贝到IBM1的/oradata目录下 ibm1 -pwd /oradata ibm1 -cd orabak ibm1 -ls -lrt total 0 drwxr-xr-x 2 oracle oinstall 256 Jun 20 15:12 logbackup drwxr-xr-x 2 oracle oinstall 256 Jun 20 15:13 rmanspctlback drwxr-xr-x 2 oracle oinstall 256 Jun 20 16:37 databackup ibm1 -cd rman* ibm1 -pwd /oradata/orabak/rmanspctlback ibm1 -ls -lrt t