Oracle数据库数据恢复、性能优化

找回密码
注册
搜索
热搜: 活动 交友 discuz
发新帖

0

积分

1

好友

29

主题
1#
发表于 2013-4-14 15:13:06 | 查看: 4659| 回复: 2
环境:
  1. SYS@PROD>select * from v$version;

  2. BANNER
  3. ----------------------------------------------------------------
  4. Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Prod
  5. PL/SQL Release 10.2.0.1.0 - Production
  6. CORE    10.2.0.1.0      Production
  7. TNS for Linux: Version 10.2.0.1.0 - Production
  8. NLSRTL Version 10.2.0.1.0 - Production
复制代码
Primary Database xxxx
Standby Database  yyyy
参照官档http://docs.oracle.com/cd/B19306_01/server.102/b14239/create_ps.htm#i63561做的实验
在执行到Standby Database
startup nomount
alter database mount standby database;
ERROR at line 1:
ORA-01665: control file is not a standby control file
alert日志中记录信息

MMNL started with pid=12, OS id=4079
Sun Apr 14 14:58:09 2013
alter database mount standby database
Sun Apr 14 14:58:14 2013
Setting recovery target incarnation to 1
ORA-1665 signalled during: alter database mount standby database...
不知道是什么引起的错误,望大神们看看
(主库能open,日志文件等都传到Standby Database中
[oracle@secdb1 disk1]$ ls
control1.ctl  log6b.rdo  log9b.rdo     redo03.log    system01.dbf
log10a.rdo    log7a.rdo  redo01_b.log  redo04_a.log  temp01.dbf
log10b.rdo    log7b.rdo  redo01.log    redo04_b.log  temp1.dbf
log11a.rdo    log8a.rdo  redo02_b.log  redo05_a.log  temp2.dbf
log11b.rdo    log8b.rdo  redo02.log    redo05_b.log  undotbs01.dbf
log6a.rdo     log9a.rdo  redo03_b.log  sysaux01.dbf  users.dbf
2#
发表于 2013-4-14 15:18:20
找到错误了,控制文件的问题,不好意思,耽误大家时间了

回复 只看该作者 道具 举报

3#
发表于 2013-4-18 15:25:31
ORA-01665: control file is not a standby control file
提示的很明显

回复 只看该作者 道具 举报

您需要登录后才可以回帖 登录 | 注册

QQ|手机版|Archiver|Oracle数据库数据恢复、性能优化

GMT+8, 2024-11-16 12:03 , Processed in 0.048760 second(s), 20 queries .

Powered by Discuz! X2.5

© 2001-2012 Comsenz Inc.

回顶部
TEL/電話+86 13764045638
Email service@parnassusdata.com
QQ 47079569