重庆思庄Oracle、Redhat认证学习论坛

标题: RMAN复制数据库时报错 ORA-19847的处理办法 [打印本页]

作者: windjack 时间: 2020-9-30 17:30
标题: RMAN复制数据库时报错 ORA-19847的处理办法
RMAN复制数据库时报错 ORA-19847的处理办法
-----------------------------------------------------------------------------------------------------------------------

C:\Users\lg>rman target sys/oracle@localhost:1521/orcl auxiliary sys/oracle@192.168.133.120:1521/orcl

恢复管理器: Release 12.1.0.2.0 - Production on 星期三 9月 30 17:18:28 2020

Copyright (c) 1982, 2014, Oracle and/or its affiliates.  All rights reserved.

已连接到目标数据库: ORCL (DBID=1567668926)
已连接到辅助数据库: ORCL (未装载)

RMAN> duplicate target database to orcl from active database;

启动 Duplicate Db 于 30-9月 -20
使用目标数据库控制文件替代恢复目录
分配的通道: ORA_AUX_DISK_1
通道 ORA_AUX_DISK_1: SID=13 设备类型=DISK
当前日志已存档

内存脚本的内容:
{
sql clone "alter system set  db_name =
''ORCL'' comment=
''Modified by RMAN duplicate'' scope=spfile";
sql clone "alter system set  db_unique_name =
''ORCL'' comment=
''Modified by RMAN duplicate'' scope=spfile";
shutdown clone immediate;
startup clone force nomount
restore clone from service  'localhost:1521/orcl' primary controlfile;
alter clone database mount;
}
正在执行内存脚本

sql 语句: alter system set  db_name =  ''ORCL'' comment= ''Modified by RMAN duplicate'' scope=spfile

sql 语句: alter system set  db_unique_name =  ''ORCL'' comment= ''Modified by RMAN duplicate'' scope=spfile

Oracle 实例已关闭

Oracle 实例已启动

系统全局区域总计    805306368 字节

Fixed Size                   2929552 字节
Variable Size             318770288 字节
Database Buffers          478150656 字节
Redo Buffers                5455872 字节

启动 restore 于 30-9月 -20
分配的通道: ORA_AUX_DISK_1
通道 ORA_AUX_DISK_1: SID=237 设备类型=DISK

Oracle 实例已启动

系统全局区域总计    805306368 字节

Fixed Size                   2929552 字节
Variable Size             318770288 字节
Database Buffers          478150656 字节
Redo Buffers                5455872 字节

内存脚本的内容:
{
sql clone "alter system set  db_name =
''ORCL'' comment=
''Reset to original value by RMAN'' scope=spfile";
sql clone "alter system reset  db_unique_name scope=spfile";
shutdown clone immediate;
}
正在执行内存脚本

sql 语句: alter system set  db_name =  ''ORCL'' comment= ''Reset to original value by RMAN'' scope=spfile

sql 语句: alter system reset  db_unique_name scope=spfile

Oracle 实例已关闭
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: Duplicate Db 命令 (在 09/30/2020 17:19:27 上) 失败
RMAN-05501: 终止复制目标数据库
RMAN-03015: 在存储的脚本Memory Script中出现错误
RMAN-06136: 来自辅助数据库的 ORACLE 错误: ORA-19847: 无法从远程站点读取控制文件的标头
-----------------------------------------------------------------------------------------------------------------------------------------

经过检查，发现在RMAN中登录主库时采用了localhost导致，修改为主库的IP或者本地命名连接串都行。

欢迎光临重庆思庄Oracle、Redhat认证学习论坛 (http://bbs.cqsztech.com/)