using rman to creat oracle10g data guard standby db_with recovery

wisdomone1發表於2010-02-01
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部落格 ” ,連結:http://blog.itpub.net/9240380/viewspace-626595/,如需轉載,請註明出處,否則將追究法律責任。

相關文章