OGG 10引入新token變量LOGCSN，對應(yīng)于oracle的scn，對此replicat可以指定開始csn

Start replicat atcsn | aftercsn

準(zhǔn)備階段

同步前需確保源庫的事務(wù)都已提交，應(yīng)反復(fù)檢查gv$transaction；

對于無法終止的事務(wù)，從其起始時間執(zhí)行extract

eg:

sql> select min(start_time) from v$transaction/gv$transaction;

MIN(START_TIME)

--------------------

02/08/13 19:21:38

The real-time extract can then be added by

ggsci> add extract tranlog begin 2013-02-08 19:20:00 --&gt> in case of standalone database

ggsci> add extract tranlog threads(number_of_threads) begin 2013-02-08 19:20:00 --&gt> in case of RAC

RMAN

假定source/target具有相同目錄結(jié)構(gòu)

--source

為source db添加supplemental日志

SQLPLUS > alter database add supplemental log data

Enable Supplemental Logging at Table Level

GGSCI> dblogin userid xxxxx password xxxxxx

GGSCI> add trandata .

添加extract/datapump進(jìn)程和trail文件

備份數(shù)據(jù)庫并查看其SCN

RMAN> backup database plus archivelog ;

RMAN> restore database preview summary;

Media recovery start SCN is 34821758

Recovery must be done beyond SCN 34822578 to clear datafile fuzziness

Finished restore at 10-OCT-10

將參數(shù)文件傳送到target

--target

Startup nomount

使用duplicate命令clone數(shù)據(jù)庫

OS> RMAN target sys/@

RMAN> connect auxiliary /

RMAN> duplicate target database to nofilenamecheck until scn ;

執(zhí)行完畢后查看alert log

RESETLOGS after incomplete recovery UNTIL CHANGE 34822578

而SCN 34822578之后的工作則由replicat執(zhí)行

啟動replicat

GGSCI> add replicat , exttrail ./dirdat/

GGSCI> start replicat , atcsn

注：對于RAC系統(tǒng)，以上步驟大同小異；

唯一需要注意的是恢復(fù)RAC期間需要cluster_database設(shè)為false

228257.1

數(shù)據(jù)泵

--source

增添supplemental log

alter database add supplemental log data ;

Enable Supplemental Logging at Table Level on source

GGSCI> dblogin userid xxxxx password xxxxxx

GGSCI> add trandata .

獲取current_scn

SQLPLUS> select current_scn from v$database ;

CURRENT_SCN

-----------------------

28318029

expdp directory=dumpdir full=y parallel=4 dumpfile=ora102_%u.dmp flashback_scn=28318029

--target

Impdp導(dǎo)入

GGSCI> add replicat , exttrail ./dirdat/

GGSCI> start replicat , aftercsn 28318029

總結(jié)

以上是生活随笔為你收集整理的oracle rman和数据泵,使用RMAN或数据泵初始化OGG目标库的全部內(nèi)容，希望文章能夠幫你解決所遇到的問題。

如果覺得生活随笔網(wǎng)站內(nèi)容還不錯，歡迎將生活随笔推薦給好友。