(转)RMAN-06004: 恢复目录数据库发生 ORACLE 错误: RMAN-20005: target database name is ambiguous

RMAN-06004: 恢复目录数据库发生 ORACLE 错误: RMAN-20005: target database name is ambiguous
数据库名称相同,并且都进行过rman,nomount恢复控制文件,,rman找不到正确的dbid,报错
http://zhaibibei.cn/oralce/manager/set-dbid/
only run the SET DBID command in the following specialized circumstances:

You are not connected to a recovery catalog and want to restore the control file or server parameter file (SPFILE)
You are connected to a recovery catalog want to restore the control file, but the database name is not unique in the recovery catalog.
The server parameter (SPFILE) file is lost and you want to restore it.
Example:

The following shell script uses the DBID to restore the control file because multiple target databases share the same DB_NAME in the catalog.

After you have restored the target control file, you can mount the database to restore the rest of the database:

rman TARGET / CATALOG rman/rman@catdb <<EOF
STARTUP FORCE NOMOUNT;
SET DBID = 862893450; # needed to distinguish target from others with same DB_NAME
RESTORE CONTROLFILE; # assuming catalog has automatic channel allocation information
ALTER DATABASE MOUNT;
EOF
If you do not set the SET DBID clause, system will report error below; “RMAN-20005: target database name is ambiguous” .

评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值