在测试环境安装了rac数据库relan实例为relan1和relan2,系统文件数据均存放在存储路径中,现有单机数据库relan需将单机数据库relan恢复至rac数据库中,在开启之前做了如下的工作
SQL> alter database archivelog; //开启归档日志
SQL> alter system set log_archive_dest_1 ='location=+DATA/RELAN/archivelog/' scope =spfile sid='relan1'; //修改归档日志路径
SQL> alter database force logging; //开启force logging
单机备份的文件是全量备份
如下是在relan1实例恢复的步骤
RMAN> restore controlfile from '/mnt/app/oracle/rmanbackup/standbycontrol'; //恢复控制文件
RMAN> alter database mount; //启动到mount状态
RMAN> catalog start with '/mnt/app/oracle/rmanbackup/';
run {
set newname for datafile '/mnt/oracle/app/oradata/RELAN/sysaux01.DBF' to '+DATA/RELAN/DATAFILE/sysaux01.DBF';
set newname for datafile '/mnt/oracle/app/oradata/RELAN/system01.DBF' to '+DATA/RELAN/DATAFILE/system01.DBF';
set newname for datafile '/mnt/oracle/app/oradata/RELAN/undotbs01.DBF' to '+DATA/RELAN/DATAFILE/undotbs01.DBF';
set newname for datafile '/mnt/oracle/app/oradata/RELAN/users01.DBF' to '+DATA/RELAN/DATAFILE/users01.DBF';
set newname for datafile '/mnt/oracle/app/oradata/RELAN/redo01.log' to '+DATA/RELAN/ONLINELOG/redo01.log';
set newname for datafile '/mnt/oracle/app/oradata/RELAN/redo02.log' to '+DATA/RELAN/ONLINELOG/redo02.log';
set newname for datafile '/mnt/oracle/app/oradata/RELAN/redo03.log' to '+DATA/RELAN/ONLINELOG/redo03.log';
set newname for datafile '/mnt/oracle/app/oradata/RELAN/relanstandby_redo01.log' to '+DATA/RELAN/ONLINELOG/relanstandby_redo01.log';
set newname for datafile '/mnt/oracle/app/oradata/RELAN/relanstandby_redo02.log' to '+DATA/RELAN/ONLINELOG/relanstandby_redo02.log';
set newname for datafile '/mnt/oracle/app/oradata/RELAN/relanstandby_redo03.log' to '+DATA/RELAN/ONLINELOG/relanstandby_redo03.log';
set newname for datafile '/mnt/oracle/app/oradata/RELAN/relanstandby_redo04.log' to '+DATA/RELAN/ONLINELOG/relanstandby_redo04.log';
................................(其余的就不展示了)
restore database;
switch datafile all;
recover database;
}
但是在执行的过程中发现
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
Starting restore at 04-AUG-23
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=3455 instance=relan1 device type=DISK
channel ORA_DISK_1: starting datafile backup set restore
channel ORA_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_DISK_1: restoring datafile 00001 to /mnt/oracle/app/oradata/RELAN/system01.dbf
channel ORA_DISK_1: restoring datafile 00002 to +DATA/RELAN/DATAFILE/LANPAY.DBF
channel ORA_DISK_1: restoring datafile 00003 to /mnt/oracle/app/oradata/RELAN/sysaux01.dbf
channel ORA_DISK_1: restoring datafile 00004 to /mnt/oracle/app/oradata/RELAN/undotbs01.dbf
channel ORA_DISK_1: restoring datafile 00005 to +DATA/RELAN/DATAFILE/KERNEL.DBF
channel ORA_DISK_1: restoring datafile 00007 to /mnt/oracle/app/oradata/RELAN/users01.dbf
这个位置还是使用的我旧的路径没有走到我 set newname 的路径
导致在我启动的时候报如下错误