using rman to creat oracle10g data guard standby db_with recovery
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
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/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- creating oracle10g data guard using rman(physical db)Oracle
- Oracle10g Data Guard (Standby) 理論與實踐Oracle
- Data Guard 之RMAN備份線上搭建物理standby
- Oracle10g Data Guard (Standby) 理論與實踐 2Oracle
- oracle10g data guard建立物理standby資料庫的例子Oracle資料庫
- Oracle10g Data Guard (Standby) 理論與實踐 [final]Oracle
- 【DG】Data Guard搭建(physical standby)
- oracle9i(9204)dg(data guard)_ place the standby database in manual recovery modeOracleDatabase
- Creating a Standby Database using RMAN (Recovery Manager) [ID 118409.1]Database
- [Data Guard]Oracle10g Data Guard學習筆記(一)Oracle筆記
- [Data Guard]Oracle10g Data Guard學習筆記(二)Oracle筆記
- [Data Guard]Oracle10g Data Guard學習筆記(三)Oracle筆記
- Data Guard - Snapshot Standby Database配置Database
- data guard 歸檔日誌管理 (standby)
- DATA GUARD物理STANDBY的 SWITCHOVER切換
- Creating a Data Guard Database with RMAN using Duplicate Command [ID 183570.1]Database
- Script to Collect Data Guard Physical and Active Standby Diagnostic InformationORM
- data_guard 雙standby pfile 檔案配置
- 建立Data guard logical standby database須知Database
- DATA GUARD物理STANDBY的FAILOVER切換AI
- DATA GUARD物理STANDBY的 SWITCHOVER切換[zt]
- oracle10g data guard redo transport serviceOracle
- Using RMAN Incremental Backups to Refresh a Standby DatabaseREMDatabase
- ORA-01555 on Active Data Guard Standby DatabaseDatabase
- Oracle 11g RAC Data Guard 物理standby 建立Oracle
- Data Guard學習之物理standby建立步驟
- RMAN : Consistent Backup, Restore and Recovery using RMAN (Doc ID 162855.1)REST
- Oracle 12.2 How to Generate AWRs in Active Data Guard Standby DatabasesOracleDatabase
- Standby (Data guard) 常用維護命令及相關概念
- Data Guard之Snapshot Standby資料庫功能[轉]資料庫
- 管理物理STANDBY資料庫——DATA GUARD概念和管理資料庫
- 建立物理STANDBY資料庫——DATA GUARD概念和管理資料庫
- 物理data guard備standby庫的時候報錯。
- oracle10g data guard(dg)__flashback_physical databaseOracleDatabase
- Using RMAN Incremental Backups to Roll Forward a Physical Standby DatabaseREMForwardDatabase
- Oracle Data Guard Linux 平臺 Physical Standby 搭建例項OracleLinux
- Oracle 11g Data Guard (physical standby - active dataguard) [final]Oracle
- 管理邏輯STANDBY資料庫——DATA GUARD概念和管理資料庫