ITPub博客

首页 > Linux操作系统 > Linux操作系统 > using rman to creat oracle10g data guard standby db_with recovery

using rman to creat oracle10g data guard standby db_with recovery

原创 Linux操作系统 作者:wisdomone1 时间:2010-02-01 21:46:12 0 删除 编辑
1,请参上一节,我所述关于利用rman tool to create dg standby示例
2,唯一不同的,请在最终rman脚本上,添加如下,或者:修正如下:
  run
{--set until scn scn号;--源于主库的select max(next_change#) from v$database;
   duplicate target database for standby
   nofilenamecheck
   dorecover;
}

3,在主库生成备库控制文件,一定要采用如下脚本  --此步太重要,我就是因为此步,花一大下午的时间,最终是三思大指导,处结此事,在些感谢三思大师指点!!
    startup mount
     copy current controlfile for standby to '控制文件备份路径';
     sql 'alter database open';
     sql 'alter system archive log current';


4,附上我出错的相关错误,供备记:
RMAN> run
2> {set until scn 693020;
3> duplicate target database for standby
4> nofilenamecheck
5> dorecover;
6> }

executing command: SET until clause
using target database control file instead of recovery catalog

Starting Duplicate Db at 31-JAN-10
allocated channel: ORA_AUX_DISK_1
channel ORA_AUX_DISK_1: sid=156 devtype=DISK

contents of Memory Script.:
{
   set until scn  693020;
   restore clone standby controlfile;
   sql clone 'alter database mount standby database';
}
executing Memory Script

executing command: SET until clause

Starting restore at 31-JAN-10
using channel ORA_AUX_DISK_1

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of Duplicate Db command at 01/31/2010 03:20:21
RMAN-03015: error occurred in stored script. Memory Script
RMAN-06026: some targets not found - aborting restore
RMAN-06024: no backup or copy of the control file found to restore

来自 “ ITPUB博客 ” ,链接:https://blog.itpub.net/9240380/viewspace-626595/ ,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论
提供针对oracle初学者及进阶的数据库培训,欢迎大家咨询: 微信: wisdomone 微信公众号: lovedb 工作经历: 中国普天 北京科蓝 北京云和恩墨 北京神州新桥

注册时间:2008-04-04

  • 博文量
    2189
  • 访问量
    12689910