场景:单点,rman异地备份恢复,源端和目标端路径和实例名均不一样
参数文件和控制文件恢复后,mount库报错,重启库后也没能解决。
报错如下:
RMAN> sql ‘alter database mount’;
using target database control file instead of recovery catalog
sql statement: alter database mount
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of sql command on default channel at 08/03/2023 18:17:19
RMAN-11003: failure during parse/execution of SQL statement: alter database mount
ORA-01103: database name ‘DHH’ in control file is not ‘DHHNEW’
–查看实例信息
idle 03-AUG-23> col instance_name for a30
idle 03-AUG-23> col status for a30
idle 03-AUG-23> set lin 1000
idle 03-AUG-23> select instance_name,status from v$instance;
INSTANCE_NAME STATUS
dhhnew STARTED