目标:Oracle RAC 只有一个历史全备(热备),无增量备份和归档备份,现需恢复到单
机上。
Oracle RAC 上 rman >backup database;会自动生成两个备份文件,自带控制文件备
份(即使 autobackup controlle 值为 o)
步骤:
1、修改 ple 启动到 nomount;
startup nomount ple=’/home/oracle/ple0803.ora’
2、恢复控制文件
restore_controlle.sh
set DBID=2256371978
run{
allocate channel t1 type disk;
allocate channel t2 type disk;
restore controlle from "/oracle/restore/1nsq509a_1_1";
release channel t1;
release channel t2;
}
3、启库到 mount;
startup mount;
4、重定向日志文件
用脚本输出 sql:
set line 500
select 'alter database rename le '||chr(39)||member||chr(39)||' to '||
chr(39)||'/oracle/weixin/redolog/'||substr(member,instr(member,'/',-1,1)+1)||
chr(39)||';'
from
(select member from v$logle)
/
5、恢复数据文件:
[oracle@test ~]$ cat restore_database.sh
catalog start with '/oracle/restore/';
run{
allocate channel t1 type disk;
allocate channel t2 type disk;
set newname for datale '+DATA1/test/datale/system.256.958225441' to
'/oracle/restore/system.256.958225441';
set newname for datale '+DATA1/test/datale/sysaux.257.958225443' to
'/oracle/restore/sysaux.257.958225443';
1
评论1