ITPUB??ì3
12月微软Hyper-V虚拟化沙龙主题征集
ITPUB论坛 » Oracle数据库管理 » 我的神呐,rman duplicate创建standby报错!!!

标题: [备份恢复] 我的神呐,rman duplicate创建standby报错!!!
离线 SingleLove
爱生活,爱老婆


来自 祖籍火星,暂住地球
精华贴数 1
个人空间 0
技术积分 5295 (257)
社区积分 2998 (463)
注册日期 2006-2-21
论坛徽章:35
会员2007贡献徽章玉石琵琶九尾狐狸嫦娥铁扇公主授权会员
2008北京奥运纪念徽章:乒乓球2008北京奥运纪念徽章:皮划艇激流回旋生肖徽章2007版:羊2008年新春纪念徽章ITPUB新首页上线纪念徽章生肖徽章:羊

发表于 2008-9-29 14:23 
我的神呐,rman duplicate创建standby报错!!!

C:\Documents and Settings\Administrator>rman target 'sys/admin@zs as sysdba' auxiliary 'sys/admin@zsdg as sysdba'

恢复管理器: Release 10.2.0.1.0 - Production on 星期一 9月 29 13:34:11 2008

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

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

RMAN> duplicate target database for standby dorecover;

启动 Duplicate Db 于 29-9月 -08
使用目标数据库控制文件替代恢复目录
分配的通道: ORA_AUX_DISK_1
通道 ORA_AUX_DISK_1: sid=650 devtype=DISK

内存脚本的内容:
{
   set until scn  17822772;
   restore clone standby controlfile;
   sql clone 'alter database mount standby database';
}
正在执行内存脚本

正在执行命令: SET until clause

启动 restore 于 29-9月 -08
使用通道 ORA_AUX_DISK_1

MAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: Duplicate Db 命令 (在 09/29/2008 13:34:21 上) 失败
RMAN-03015: 在存储的脚本Memory Script中出现错误
RMAN-06026: 有些目标没有找到 - 终止恢复
RMAN-06024: 没有找到控制文件的备份或副本来复原


主库的备份集都拷贝到从库相应的目录了啊,前面测试过那么多次都没问题,怎么今天就遇到了。。。


__________________
懂得珍惜,学会放弃,享受孤独
                               —— one day I will get what I want

-----------------------------------------------------------------------
http://singlelove1983.blog.163.com/我的BLOG
MSN:firedragon_1983@hotmail.com
QQ:7701517
只看该作者    顶部
离线 SingleLove
爱生活,爱老婆


来自 祖籍火星,暂住地球
精华贴数 1
个人空间 0
技术积分 5295 (257)
社区积分 2998 (463)
注册日期 2006-2-21
论坛徽章:35
会员2007贡献徽章玉石琵琶九尾狐狸嫦娥铁扇公主授权会员
2008北京奥运纪念徽章:乒乓球2008北京奥运纪念徽章:皮划艇激流回旋生肖徽章2007版:羊2008年新春纪念徽章ITPUB新首页上线纪念徽章生肖徽章:羊

发表于 2008-9-29 14:28 
主库备份没出什么问题:
C:\Documents and Settings\Administrator>rman nocatalog target 'sys/admin@zs as sysdba'

恢复管理器: Release 10.2.0.1.0 - Production on 星期一 9月 29 10:58:11 2008

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

连接到目标数据库: ZS (DBID=3080925109)
使用目标数据库控制文件替代恢复目录

RMAN> run{
2> allocate channel c1 type disk;
3> backup as compressed backupset database format 'F:\orabak\full%u_%s_%p';
4> sql 'alter system archive log current';
5> backup archivelog all format='F:\orabak\log%u_%s.bak';
6> copy current controlfile for standby to 'F:\orabak\sby_control01.ctl';
7> release channel c1;
8> }

分配的通道: c1
通道 c1: sid=632 devtype=DISK

启动 backup 于 29-9月 -08
通道 c1: 启动压缩的全部数据文件备份集
通道 c1: 正在指定备份集中的数据文件
输入数据文件 fno=00006 name=D:\ORACLE\PRODUCT\10.2.0\ORADATA\ZS\ZSKJ_DATA01.DBF
输入数据文件 fno=00007 name=E:\ORADATA\ZS\ZSKJ_DATA02.DBF
输入数据文件 fno=00002 name=D:\ORACLE\PRODUCT\10.2.0\ORADATA\ZS\UNDOTBS01.DBF
输入数据文件 fno=00008 name=D:\ORACLE\PRODUCT\10.2.0\ORADATA\ZS\ZS_DATA01.DBF
输入数据文件 fno=00009 name=E:\ORADATA\ZS\ZS_DATA02.DBF
输入数据文件 fno=00010 name=D:\ORACLE\PRODUCT\10.2.0\ORADATA\ZS\ZS_IDXDATA01.DBF

输入数据文件 fno=00011 name=E:\ORADATA\ZS\ZS_IDXDATA02.DBF
输入数据文件 fno=00012 name=D:\ORACLE\PRODUCT\10.2.0\ORADATA\ZS\ZSKJ_IDXDATA01.D
BF
输入数据文件 fno=00013 name=E:\ORADATA\ZS\ZSKJ_IDXDATA02.DBF
输入数据文件 fno=00014 name=E:\ORADATA\ZS\PERFSTAT.DBF
输入数据文件 fno=00001 name=D:\ORACLE\PRODUCT\10.2.0\ORADATA\ZS\SYSTEM01.DBF
输入数据文件 fno=00003 name=D:\ORACLE\PRODUCT\10.2.0\ORADATA\ZS\SYSAUX01.DBF
输入数据文件 fno=00005 name=D:\ORACLE\PRODUCT\10.2.0\ORADATA\ZS\EXAMPLE01.DBF
输入数据文件 fno=00004 name=D:\ORACLE\PRODUCT\10.2.0\ORADATA\ZS\USERS01.DBF
通道 c1: 正在启动段 1 于 29-9月 -08
通道 c1: 已完成段 1 于 29-9月 -08
段句柄=F:\ORABAK\FULL6DJRQ42Q_205_1 标记=TAG20080929T105834 注释=NONE
通道 c1: 备份集已完成, 经过时间:00:18:06
通道 c1: 启动压缩的全部数据文件备份集
通道 c1: 正在指定备份集中的数据文件
备份集中包括当前控制文件
在备份集中包含当前的 SPFILE
通道 c1: 正在启动段 1 于 29-9月 -08
通道 c1: 已完成段 1 于 29-9月 -08
段句柄=F:\ORABAK\FULL6EJRQ54O_206_1 标记=TAG20080929T105834 注释=NONE
通道 c1: 备份集已完成, 经过时间:00:00:02
完成 backup 于 29-9月 -08

sql 语句: alter system archive log current

启动 backup 于 29-9月 -08
当前日志已存档
通道 c1: 正在启动存档日志备份集
通道 c1: 正在指定备份集中的存档日志
输入存档日志线程 =1 序列 =370 记录 ID=276 时间戳=666606142
输入存档日志线程 =1 序列 =371 记录 ID=277 时间戳=666609042
输入存档日志线程 =1 序列 =372 记录 ID=278 时间戳=666609291
输入存档日志线程 =1 序列 =373 记录 ID=279 时间戳=666612528
输入存档日志线程 =1 序列 =374 记录 ID=280 时间戳=666623597
输入存档日志线程 =1 序列 =375 记录 ID=281 时间戳=666633961
输入存档日志线程 =1 序列 =376 记录 ID=282 时间戳=666639632
输入存档日志线程 =1 序列 =377 记录 ID=283 时间戳=666641148
输入存档日志线程 =1 序列 =378 记录 ID=284 时间戳=666651626
输入存档日志线程 =1 序列 =379 记录 ID=285 时间戳=666656064
输入存档日志线程 =1 序列 =380 记录 ID=286 时间戳=666657390
输入存档日志线程 =1 序列 =381 记录 ID=287 时间戳=666662686
输入存档日志线程 =1 序列 =382 记录 ID=288 时间戳=666697675
输入存档日志线程 =1 序列 =383 记录 ID=289 时间戳=666701744
输入存档日志线程 =1 序列 =384 记录 ID=290 时间戳=666703005
输入存档日志线程 =1 序列 =385 记录 ID=291 时间戳=666703006
通道 c1: 正在启动段 1 于 29-9月 -08
通道 c1: 已完成段 1 于 29-9月 -08
段句柄=F:\ORABAK\LOG6FJRQ54U_207.BAK 标记=TAG20080929T111646 注释=NONE
通道 c1: 备份集已完成, 经过时间:00:00:16
完成 backup 于 29-9月 -08

启动 backup 于 29-9月 -08
通道 c1: 启动数据文件副本
复制备用控制文件
输出文件名 = F:\ORABAK\SBY_CONTROL01.CTL 标记 = TAG20080929T111703 recid = 2 时
间戳 = 666703024
通道 c1: 数据文件复制完毕, 经过时间: 00:00:01
完成 backup 于 29-9月 -08

释放的通道: c1

为什么就出错勒。。。备库相应的目录都是建好了的啊。


__________________
懂得珍惜,学会放弃,享受孤独
                               —— one day I will get what I want

-----------------------------------------------------------------------
http://singlelove1983.blog.163.com/我的BLOG
MSN:firedragon_1983@hotmail.com
QQ:7701517
只看该作者    顶部
离线 SingleLove
爱生活,爱老婆


来自 祖籍火星,暂住地球
精华贴数 1
个人空间 0
技术积分 5295 (257)
社区积分 2998 (463)
注册日期 2006-2-21
论坛徽章:35
会员2007贡献徽章玉石琵琶九尾狐狸嫦娥铁扇公主授权会员
2008北京奥运纪念徽章:乒乓球2008北京奥运纪念徽章:皮划艇激流回旋生肖徽章2007版:羊2008年新春纪念徽章ITPUB新首页上线纪念徽章生肖徽章:羊

发表于 2008-9-29 14:39 
alert.log里面报错信息:
PING[ARC1]: Heartbeat failed to connect to standby 'zsdg'. Error is 1034.
Mon Sep 29 13:03:47 2008
Error 1034 received logging on to the standby
Mon Sep 29 13:03:47 2008
Errors in file d:\oracle\product\10.2.0\admin\zs\bdump\zs_arc1_3704.trc:
ORA-01034: ORACLE not available

PING[ARC1]: Heartbeat failed to connect to standby 'zsdg'. Error is 1034.
Mon Sep 29 13:08:47 2008
Error 1034 received logging on to the standby
Mon Sep 29 13:08:47 2008
Errors in file d:\oracle\product\10.2.0\admin\zs\bdump\zs_arc1_3704.trc:
ORA-01034: ORACLE not available

zs_arc1_3704.trc错误信息:
Dump file d:\oracle\product\10.2.0\admin\zs\bdump\zs_arc1_3704.trc
Mon Sep 29 12:52:52 2008
ORACLE V10.2.0.1.0 - Production vsnsta=0
vsnsql=14 vsnxtr=3
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
Windows Server 2003 Version V5.2 Service Pack 1
CPU                 : 16 - type 586, 4 Physical Cores
Process Affinity    : 0x00000000
Memory (Avail/Total): Ph:3236M/8188M, Ph+PgF:7268M/12086M, VA:1086M/3071M
Instance name: zs

Redo thread mounted by this instance: 1

Oracle process number: 18

Windows thread id: 3704, image: ORACLE.EXE (ARC1)


*** 2008-09-29 12:52:52.796
*** SERVICE NAME) 2008-09-29 12:52:52.625
*** SESSION ID650.1) 2008-09-29 12:52:52.625
kcrrwkx: work to do 0x1 (start)
kcrrwkx: nothing to do (end)
*** 2008-09-29 12:53:42.156
kcrrwkx: nothing to do (end)
*** 2008-09-29 12:54:42.156
kcrrwkx: nothing to do (end)
*** 2008-09-29 12:55:42.156
kcrrwkx: nothing to do (end)
*** 2008-09-29 12:56:42.187
kcrrwkx: nothing to do (end)
*** 2008-09-29 12:57:42.187
kcrrwkx: nothing to do (end)
*** 2008-09-29 12:58:42.187
tkcrrxmp: Stopping ARC4 to reduce ARCH processes from 5 to 4
Redo shipping client performing standby login
OCISessionBegin failed -1
.. Detailed OCI error val is 1034 and errmsg is 'ORA-01034: ORACLE not available
'
*** 2008-09-29 12:58:47.296 60680 kcrr.c
Error 1034 received logging on to the standby
Error 1034 connecting to destination LOG_ARCHIVE_DEST_2 standby host 'zsdg'
Error 1034 attaching to destination LOG_ARCHIVE_DEST_2 standby host 'zsdg'
ORA-01034: ORACLE not available
*** 2008-09-29 12:58:47.296 60680 kcrr.c
PING[ARC1]: Heartbeat failed to connect to standby 'zsdg'. Error is 1034.
*** 2008-09-29 12:58:47.296 58942 kcrr.c
kcrrfail: dest:2 err:1034 force:0 blast:1
kcrrwkx: nothing to do (end)
*** 2008-09-29 12:59:47.375
kcrrwkx: nothing to do (end)
*** 2008-09-29 13:00:47.437
kcrrwkx: nothing to do (end)
*** 2008-09-29 13:01:47.484
kcrrwkx: nothing to do (end)
*** 2008-09-29 13:02:47.484
kcrrwkx: nothing to do (end)
*** 2008-09-29 13:03:47.515
Redo shipping client performing standby login
OCISessionBegin failed -1
.. Detailed OCI error val is 1034 and errmsg is 'ORA-01034: ORACLE not available
'
*** 2008-09-29 13:03:47.546 60680 kcrr.c
Error 1034 received logging on to the standby
Error 1034 connecting to destination LOG_ARCHIVE_DEST_2 standby host 'zsdg'
Error 1034 attaching to destination LOG_ARCHIVE_DEST_2 standby host 'zsdg'
ORA-01034: ORACLE not available
*** 2008-09-29 13:03:47.562 60680 kcrr.c
PING[ARC1]: Heartbeat failed to connect to standby 'zsdg'. Error is 1034.
*** 2008-09-29 13:03:47.562 58942 kcrr.c
kcrrfail: dest:2 err:1034 force:0 blast:1
kcrrwkx: nothing to do (end)
*** 2008-09-29 13:04:47.578
kcrrwkx: nothing to do (end)
*** 2008-09-29 13:05:47.640
kcrrwkx: nothing to do (end)
*** 2008-09-29 13:06:47.703
kcrrwkx: nothing to do (end)
*** 2008-09-29 13:07:47.734
kcrrwkx: nothing to do (end)
*** 2008-09-29 13:08:47.765
Redo shipping client performing standby login
OCISessionBegin failed -1
.. Detailed OCI error val is 1034 and errmsg is 'ORA-01034: ORACLE not available
'
*** 2008-09-29 13:08:47.796 60680 kcrr.c
Error 1034 received logging on to the standby
Error 1034 connecting to destination LOG_ARCHIVE_DEST_2 standby host 'zsdg'
Error 1034 attaching to destination LOG_ARCHIVE_DEST_2 standby host 'zsdg'
ORA-01034: ORACLE not available
*** 2008-09-29 13:08:47.796 60680 kcrr.c
PING[ARC1]: Heartbeat failed to connect to standby 'zsdg'. Error is 1034.
*** 2008-09-29 13:08:47.796 58942 kcrr.c
kcrrfail: dest:2 err:1034 force:0 blast:1
kcrrwkx: nothing to do (end)
*** 2008-09-29 13:09:47.812
kcrrwkx: nothing to do (end)
*** 2008-09-29 13:10:47.828
kcrrwkx: nothing to do (end)
*** 2008-09-29 13:11:47.843
kcrrwkx: nothing to do (end)
*** 2008-09-29 13:12:47.859
kcrrwkx: nothing to do (end)
*** 2008-09-29 13:13:37.578
kcrrwkx: nothing to do (end)
*** 2008-09-29 13:13:47.859
Redo shipping client performing standby login
OCISessionBegin failed -1
.. Detailed OCI error val is 1034 and errmsg is 'ORA-01034: ORACLE not available
'
*** 2008-09-29 13:13:47.890 60680 kcrr.c
Error 1034 received logging on to the standby
Error 1034 connecting to destination LOG_ARCHIVE_DEST_2 standby host 'zsdg'
Error 1034 attaching to destination LOG_ARCHIVE_DEST_2 standby host 'zsdg'
ORA-01034: ORACLE not available
*** 2008-09-29 13:13:47.890 60680 kcrr.c
PING[ARC1]: Heartbeat failed to connect to standby 'zsdg'. Error is 1034.
*** 2008-09-29 13:13:47.890 58942 kcrr.c
kcrrfail: dest:2 err:1034 force:0 blast:1
kcrrwkx: nothing to do (end)
*** 2008-09-29 13:14:47.890
kcrrwkx: nothing to do (end)
*** 2008-09-29 13:15:47.890
kcrrwkx: nothing to do (end)
*** 2008-09-29 13:16:47.890
kcrrwkx: nothing to do (end)
*** 2008-09-29 13:17:47.890
kcrrwkx: nothing to do (end)
*** 2008-09-29 13:18:47.890
Redo shipping client performing standby login
OCISessionBegin failed -1
.. Detailed OCI error val is 1034 and errmsg is 'ORA-01034: ORACLE not available
'
*** 2008-09-29 13:18:47.921 60680 kcrr.c
Error 1034 received logging on to the standby
Error 1034 connecting to destination LOG_ARCHIVE_DEST_2 standby host 'zsdg'
Error 1034 attaching to destination LOG_ARCHIVE_DEST_2 standby host 'zsdg'
ORA-01034: ORACLE not available
*** 2008-09-29 13:18:47.921 60680 kcrr.c
PING[ARC1]: Heartbeat failed to connect to standby 'zsdg'. Error is 1034.
*** 2008-09-29 13:18:47.921 58942 kcrr.c
kcrrfail: dest:2 err:1034 force:0 blast:1
kcrrwkx: nothing to do (end)
*** 2008-09-29 13:19:47.921
kcrrwkx: nothing to do (end)
*** 2008-09-29 13:20:47.921
kcrrwkx: nothing to do (end)
*** 2008-09-29 13:21:47.921
kcrrwkx: nothing to do (end)
*** 2008-09-29 13:22:47.921
kcrrwkx: nothing to do (end)
*** 2008-09-29 13:23:47.921
Redo shipping client performing standby login
OCISessionBegin failed -1
.. Detailed OCI error val is 1034 and errmsg is 'ORA-01034: ORACLE not available
'
*** 2008-09-29 13:23:48.000 60680 kcrr.c
Error 1034 received logging on to the standby
Error 1034 connecting to destination LOG_ARCHIVE_DEST_2 standby host 'zsdg'
Error 1034 attaching to destination LOG_ARCHIVE_DEST_2 standby host 'zsdg'
ORA-01034: ORACLE not available
*** 2008-09-29 13:23:48.000 60680 kcrr.c
PING[ARC1]: Heartbeat failed to connect to standby 'zsdg'. Error is 1034.
*** 2008-09-29 13:23:48.000 58942 kcrr.c
kcrrfail: dest:2 err:1034 force:0 blast:1
kcrrwkx: nothing to do (end)
*** 2008-09-29 13:24:48.000
kcrrwkx: nothing to do (end)
*** 2008-09-29 13:25:48.000
kcrrwkx: nothing to do (end)
*** 2008-09-29 13:26:48.000
kcrrwkx: nothing to do (end)
*** 2008-09-29 13:27:48.000
kcrrwkx: nothing to do (end)
*** 2008-09-29 13:28:48.000
Redo shipping client performing standby login
OCISessionBegin failed -1
.. Detailed OCI error val is 1034 and errmsg is 'ORA-01034: ORACLE not available
'
*** 2008-09-29 13:28:48.140 60680 kcrr.c
Error 1034 received logging on to the standby
Error 1034 connecting to destination LOG_ARCHIVE_DEST_2 standby host 'zsdg'
Error 1034 attaching to destination LOG_ARCHIVE_DEST_2 standby host 'zsdg'
ORA-01034: ORACLE not available
*** 2008-09-29 13:28:48.140 60680 kcrr.c
PING[ARC1]: Heartbeat failed to connect to standby 'zsdg'. Error is 1034.
*** 2008-09-29 13:28:48.156 58942 kcrr.c
kcrrfail: dest:2 err:1034 force:0 blast:1
kcrrwkx: nothing to do (end)
*** 2008-09-29 13:29:48.156
kcrrwkx: nothing to do (end)
*** 2008-09-29 13:30:48.156
kcrrwkx: nothing to do (end)
*** 2008-09-29 13:31:48.156
kcrrwkx: nothing to do (end)
*** 2008-09-29 13:32:48.156
kcrrwkx: nothing to do (end)
*** 2008-09-29 13:33:48.156
Redo shipping client performing standby login
*** 2008-09-29 13:33:48.203 64562 kcrr.c
Logged on to standby successfully
Client logon and security negotiation successful!
Error 16058 attaching RFS server to standby instance at host 'zsdg'
Error 16058 attaching to destination LOG_ARCHIVE_DEST_2 standby host 'zsdg'
ORA-16058: standby database instance is not mounted
*** 2008-09-29 13:33:48.250 60680 kcrr.c
PING[ARC1]: Heartbeat failed to connect to standby 'zsdg'. Error is 16058.
*** 2008-09-29 13:33:48.250 58942 kcrr.c
kcrrfail: dest:2 err:16058 force:0 blast:1
kcrrwkx: nothing to do (end)
*** 2008-09-29 13:34:48.250
kcrrwkx: nothing to do (end)
*** 2008-09-29 13:35:48.250
kcrrwkx: nothing to do (end)
*** 2008-09-29 13:36:48.250
kcrrwkx: nothing to do (end)
*** 2008-09-29 13:37:48.250
kcrrwkx: nothing to do (end)
*** 2008-09-29 13:38:48.250
Redo shipping client performing standby login
*** 2008-09-29 13:38:48.281 64562 kcrr.c
Logged on to standby successfully
Client logon and security negotiation successful!
Error 16058 attaching RFS server to standby instance at host 'zsdg'
Error 16058 attaching to destination LOG_ARCHIVE_DEST_2 standby host 'zsdg'
ORA-16058: standby database instance is not mounted
*** 2008-09-29 13:38:48.328 60680 kcrr.c
PING[ARC1]: Heartbeat failed to connect to standby 'zsdg'. Error is 16058.
*** 2008-09-29 13:38:48.328 58942 kcrr.c
kcrrfail: dest:2 err:16058 force:0 blast:1
kcrrwkx: nothing to do (end)
*** 2008-09-29 13:39:48.328
kcrrwkx: nothing to do (end)
*** 2008-09-29 13:40:48.328
kcrrwkx: nothing to do (end)
*** 2008-09-29 13:41:48.328
kcrrwkx: nothing to do (end)
*** 2008-09-29 13:42:48.328
kcrrwkx: nothing to do (end)
*** 2008-09-29 13:43:48.328
Redo shipping client performing standby login
*** 2008-09-29 13:43:48.375 64562 kcrr.c
Logged on to standby successfully
Client logon and security negotiation successful!
Error 16058 attaching RFS server to standby instance at host 'zsdg'
Error 16058 attaching to destination LOG_ARCHIVE_DEST_2 standby host 'zsdg'
ORA-16058: standby database instance is not mounted
*** 2008-09-29 13:43:48.406 60680 kcrr.c
PING[ARC1]: Heartbeat failed to connect to standby 'zsdg'. Error is 16058.
*** 2008-09-29 13:43:48.406 58942 kcrr.c
kcrrfail: dest:2 err:16058 force:0 blast:1
kcrrwkx: nothing to do (end)
*** 2008-09-29 13:44:48.406
kcrrwkx: nothing to do (end)
*** 2008-09-29 13:45:48.406
kcrrwkx: nothing to do (end)
*** 2008-09-29 13:46:48.406
kcrrwkx: nothing to do (end)
*** 2008-09-29 13:47:48.406
kcrrwkx: nothing to do (end)
*** 2008-09-29 13:48:48.406
Redo shipping client performing standby login
*** 2008-09-29 13:48:48.468 64562 kcrr.c
Logged on to standby successfully
Client logon and security negotiation successful!
Error 16058 attaching RFS server to standby instance at host 'zsdg'
Error 16058 attaching to destination LOG_ARCHIVE_DEST_2 standby host 'zsdg'
ORA-16058: standby database instance is not mounted
*** 2008-09-29 13:48:48.500 60680 kcrr.c
PING[ARC1]: Heartbeat failed to connect to standby 'zsdg'. Error is 16058.
*** 2008-09-29 13:48:48.500 58942 kcrr.c
kcrrfail: dest:2 err:16058 force:0 blast:1
kcrrwkx: nothing to do (end)
*** 2008-09-29 13:49:48.500
kcrrwkx: nothing to do (end)
*** 2008-09-29 13:50:48.500
kcrrwkx: nothing to do (end)
*** 2008-09-29 13:51:48.500
kcrrwkx: nothing to do (end)
*** 2008-09-29 13:52:48.500
kcrrwkx: nothing to do (end)
*** 2008-09-29 13:53:48.500
Redo shipping client performing standby login
*** 2008-09-29 13:53:48.562 64562 kcrr.c
Logged on to standby successfully
Client logon and security negotiation successful!
Error 16058 attaching RFS server to standby instance at host 'zsdg'
Error 16058 attaching to destination LOG_ARCHIVE_DEST_2 standby host 'zsdg'
ORA-16058: standby database instance is not mounted
*** 2008-09-29 13:53:48.593 60680 kcrr.c
PING[ARC1]: Heartbeat failed to connect to standby 'zsdg'. Error is 16058.
*** 2008-09-29 13:53:48.593 58942 kcrr.c
kcrrfail: dest:2 err:16058 force:0 blast:1
kcrrwkx: nothing to do (end)
*** 2008-09-29 13:54:48.593
kcrrwkx: nothing to do (end)
*** 2008-09-29 13:55:48.593
kcrrwkx: nothing to do (end)
*** 2008-09-29 13:56:48.593
kcrrwkx: nothing to do (end)
*** 2008-09-29 13:57:48.593
kcrrwkx: nothing to do (end)
*** 2008-09-29 13:58:48.593
Redo shipping client performing standby login
*** 2008-09-29 13:58:48.625 64562 kcrr.c
Logged on to standby successfully
Client logon and security negotiation successful!
Error 16058 attaching RFS server to standby instance at host 'zsdg'
Error 16058 attaching to destination LOG_ARCHIVE_DEST_2 standby host 'zsdg'
ORA-16058: standby database instance is not mounted
*** 2008-09-29 13:58:48.671 60680 kcrr.c
PING[ARC1]: Heartbeat failed to connect to standby 'zsdg'. Error is 16058.
*** 2008-09-29 13:58:48.671 58942 kcrr.c
kcrrfail: dest:2 err:16058 force:0 blast:1
kcrrwkx: nothing to do (end)
*** 2008-09-29 13:59:48.671
kcrrwkx: nothing to do (end)
*** 2008-09-29 14:00:48.671
kcrrwkx: nothing to do (end)
*** 2008-09-29 14:01:48.671
kcrrwkx: nothing to do (end)
*** 2008-09-29 14:02:48.671
kcrrwkx: nothing to do (end)
*** 2008-09-29 14:03:48.671
Redo shipping client performing standby login
*** 2008-09-29 14:03:48.765 64562 kcrr.c
Logged on to standby successfully
Client logon and security negotiation successful!
Error 16058 attaching RFS server to standby instance at host 'zsdg'
Error 16058 attaching to destination LOG_ARCHIVE_DEST_2 standby host 'zsdg'
ORA-16058: standby database instance is not mounted
*** 2008-09-29 14:03:48.796 60680 kcrr.c
PING[ARC1]: Heartbeat failed to connect to standby 'zsdg'. Error is 16058.
*** 2008-09-29 14:03:48.796 58942 kcrr.c
kcrrfail: dest:2 err:16058 force:0 blast:1
kcrrwkx: nothing to do (end)
*** 2008-09-29 14:04:48.796
kcrrwkx: nothing to do (end)
*** 2008-09-29 14:05:48.796
kcrrwkx: nothing to do (end)
*** 2008-09-29 14:06:48.796
kcrrwkx: nothing to do (end)
*** 2008-09-29 14:07:48.796
kcrrwkx: nothing to do (end)
*** 2008-09-29 14:08:48.796
Redo shipping client performing standby login
*** 2008-09-29 14:08:48.859 64562 kcrr.c
Logged on to standby successfully
Client logon and security negotiation successful!
Error 16058 attaching RFS server to standby instance at host 'zsdg'
Error 16058 attaching to destination LOG_ARCHIVE_DEST_2 standby host 'zsdg'
ORA-16058: standby database instance is not mounted
*** 2008-09-29 14:08:48.906 60680 kcrr.c
PING[ARC1]: Heartbeat failed to connect to standby 'zsdg'. Error is 16058.
*** 2008-09-29 14:08:48.906 58942 kcrr.c
kcrrfail: dest:2 err:16058 force:0 blast:1
kcrrwkx: nothing to do (end)
*** 2008-09-29 14:09:48.906
kcrrwkx: nothing to do (end)
*** 2008-09-29 14:10:48.906
kcrrwkx: nothing to do (end)
*** 2008-09-29 14:11:48.906
kcrrwkx: nothing to do (end)
*** 2008-09-29 14:12:48.906
kcrrwkx: nothing to do (end)
*** 2008-09-29 14:13:48.906
Redo shipping client performing standby login
*** 2008-09-29 14:13:49.031 64562 kcrr.c
Logged on to standby successfully
Client logon and security negotiation successful!
Error 16058 attaching RFS server to standby instance at host 'zsdg'
Error 16058 attaching to destination LOG_ARCHIVE_DEST_2 standby host 'zsdg'
ORA-16058: standby database instance is not mounted
*** 2008-09-29 14:13:49.078 60680 kcrr.c
PING[ARC1]: Heartbeat failed to connect to standby 'zsdg'. Error is 16058.
*** 2008-09-29 14:13:49.078 58942 kcrr.c
kcrrfail: dest:2 err:16058 force:0 blast:1
kcrrwkx: nothing to do (end)
*** 2008-09-29 14:14:49.078
kcrrwkx: nothing to do (end)
*** 2008-09-29 14:15:49.078
kcrrwkx: nothing to do (end)
*** 2008-09-29 14:16:49.078
kcrrwkx: nothing to do (end)
*** 2008-09-29 14:17:49.078
kcrrwkx: nothing to do (end)
*** 2008-09-29 14:18:49.078
Redo shipping client performing standby login
*** 2008-09-29 14:18:49.109 64562 kcrr.c
Logged on to standby successfully
Client logon and security negotiation successful!
Error 16058 attaching RFS server to standby instance at host 'zsdg'
Error 16058 attaching to destination LOG_ARCHIVE_DEST_2 standby host 'zsdg'
ORA-16058: standby database instance is not mounted
*** 2008-09-29 14:18:49.140 60680 kcrr.c
PING[ARC1]: Heartbeat failed to connect to standby 'zsdg'. Error is 16058.
*** 2008-09-29 14:18:49.140 58942 kcrr.c
kcrrfail: dest:2 err:16058 force:0 blast:1
kcrrwkx: nothing to do (end)
*** 2008-09-29 14:19:49.140
kcrrwkx: nothing to do (end)
*** 2008-09-29 14:20:49.140
kcrrwkx: nothing to do (end)
*** 2008-09-29 14:21:49.140
kcrrwkx: nothing to do (end)
*** 2008-09-29 14:22:49.140
kcrrwkx: nothing to do (end)
*** 2008-09-29 14:23:49.140
Redo shipping client performing standby login
*** 2008-09-29 14:23:49.203 64562 kcrr.c
Logged on to standby successfully
Client logon and security negotiation successful!
Error 16058 attaching RFS server to standby instance at host 'zsdg'
Error 16058 attaching to destination LOG_ARCHIVE_DEST_2 standby host 'zsdg'
ORA-16058: standby database instance is not mounted
*** 2008-09-29 14:23:49.234 60680 kcrr.c
PING[ARC1]: Heartbeat failed to connect to standby 'zsdg'. Error is 16058.
*** 2008-09-29 14:23:49.234 58942 kcrr.c
kcrrfail: dest:2 err:16058 force:0 blast:1
kcrrwkx: nothing to do (end)
*** 2008-09-29 14:24:49.234
kcrrwkx: nothing to do (end)
*** 2008-09-29 14:25:49.234
kcrrwkx: nothing to do (end)
*** 2008-09-29 14:26:49.234
kcrrwkx: nothing to do (end)
*** 2008-09-29 14:27:49.234
kcrrwkx: nothing to do (end)
*** 2008-09-29 14:28:49.234
Redo shipping client performing standby login
*** 2008-09-29 14:28:49.265 64562 kcrr.c
Logged on to standby successfully
Client logon and security negotiation successful!
Error 16058 attaching RFS server to standby instance at host 'zsdg'
Error 16058 attaching to destination LOG_ARCHIVE_DEST_2 standby host 'zsdg'
ORA-16058: standby database instance is not mounted
*** 2008-09-29 14:28:49.312 60680 kcrr.c
PING[ARC1]: Heartbeat failed to connect to standby 'zsdg'. Error is 16058.
*** 2008-09-29 14:28:49.312 58942 kcrr.c
kcrrfail: dest:2 err:16058 force:0 blast:1
kcrrwkx: nothing to do (end)
*** 2008-09-29 14:29:49.312
kcrrwkx: nothing to do (end)
*** 2008-09-29 14:30:49.312
kcrrwkx: nothing to do (end)
*** 2008-09-29 14:31:49.312
kcrrwkx: nothing to do (end)
*** 2008-09-29 14:32:49.312
kcrrwkx: nothing to do (end)
*** 2008-09-29 14:33:49.312
Redo shipping client performing standby login
*** 2008-09-29 14:33:49.406 64562 kcrr.c
Logged on to standby successfully
Client logon and security negotiation successful!
Error 16058 attaching RFS server to standby instance at host 'zsdg'
Error 16058 attaching to destination LOG_ARCHIVE_DEST_2 standby host 'zsdg'
ORA-16058: standby database instance is not mounted
*** 2008-09-29 14:33:49.437 60680 kcrr.c
PING[ARC1]: Heartbeat failed to connect to standby 'zsdg'. Error is 16058.
*** 2008-09-29 14:33:49.437 58942 kcrr.c
kcrrfail: dest:2 err:16058 force:0 blast:1
kcrrwkx: nothing to do (end)


__________________
懂得珍惜,学会放弃,享受孤独
                               —— one day I will get what I want

-----------------------------------------------------------------------
http://singlelove1983.blog.163.com/我的BLOG
MSN:firedragon_1983@hotmail.com
QQ:7701517
只看该作者    顶部
离线 gy1982329
Braveheart


精华贴数 0
个人空间 300
技术积分 2090 (773)
社区积分 0 (1726601)
注册日期 2008-3-11
论坛徽章:2
2008北京奥运纪念徽章:赛艇数据库板块每日发贴之星    
      

发表于 2008-9-29 14:52 
备库控制文件生成的不对!mount下


__________________
只看该作者    顶部
离线 SingleLove
爱生活,爱老婆


来自 祖籍火星,暂住地球
精华贴数 1
个人空间 0
技术积分 5295 (257)
社区积分 2998 (463)
注册日期 2006-2-21
论坛徽章:35
会员2007贡献徽章玉石琵琶九尾狐狸嫦娥铁扇公主授权会员
2008北京奥运纪念徽章:乒乓球2008北京奥运纪念徽章:皮划艇激流回旋生肖徽章2007版:羊2008年新春纪念徽章ITPUB新首页上线纪念徽章生肖徽章:羊

发表于 2008-9-29 15:23 
楼上正解。。脑袋犯晕了在primary open状态下一起把standby的controlfile备份了。


__________________
懂得珍惜,学会放弃,享受孤独
                               —— one day I will get what I want

-----------------------------------------------------------------------
http://singlelove1983.blog.163.com/我的BLOG
MSN:firedragon_1983@hotmail.com
QQ:7701517
只看该作者    顶部
 
    

相关内容


CopyRight 1999-2006 itpub.net All Right Reserved.
北京皓辰广域网络信息技术有限公司. 版权所有
E-mail:Webmaster@itpub.net
京ICP证:010037号 联系我们 法律顾问