網(wǎng)名Roger，超過8年的Oracle 致力于技 ACOUG和數(shù)據(jù)庫大 者者oPhone:云和恩墨者OCM專家，同時(shí)具備MySQL和DB2oracleoracleoracle數(shù)據(jù)oraclexoracle集中oracle財(cái)務(wù)oraclehpuxoraclehpuxoracle老電hpuxoracle全文SunoracleCPU處理效率提升Network處理速度提升Bus處理速度提升Disk處理速度提升

8-7-數(shù)據(jù)邏輯遷移(Exp/ExpdpRealApplicationDatabase SQL 通過SPM(SQLT)穩(wěn)定SQL已知數(shù)據(jù)庫相關(guān)特性或

DB

驟驟Oracle9i只能通過10046trace進(jìn)行抓取Oracle10g+可以抓取AWR數(shù)據(jù)及OracleOracle

數(shù)據(jù)庫版本：10.2.0.5(RAC)操作系統(tǒng):AIX5.3從AIX(RAW)遷移至Downtime<從10gR2遷移升級(jí)至案例-XTTS支持Oracle10.2

XTTSRMAN

必須借助Blockchangetracking案例-HowtodoXTTS

xttdriver.pl-產(chǎn)生

xttdriver.pl-cxttdriver.pl-$ORACLE_HOME/perl/bin/perlxttdriver.pl-r-

HowtodoXTTSIncremental?1、convertconvert tform'AIX-BasedSystems(64-datafile'/.../lv_vg06_20g_065'format'+DG_DATA01/.../%N_%f.dbf'parallelismn;2、backuprunallocatechannelt1typediskbackupincrementalfromscnN releasechannel

format

案例-HowtodoXTTS sys.dbms_backup_restore.backupBackupPiece(bpname=>'/.../ACCTA_xxx_1.bak',fname=>'/.../ACCTA_xxx_con_1.bak',...,pltfrmfr=>6);3、convertsys.dbms_backup_restore.backupBackupPiece(bpname=>'/.../ACCTA_xxx_1.bak',fname=>'/.../ACCTA_xxx_con_1.bak',...,pltfrmfr=>6);4、applydevtype:=sys.dbms_backup_restore.deviceAllocate;sys.dbms_backup_restore.applySetDatafile(check_logical=>FALSE,cleanup=>FALSE);sys.dbms_backup_restore.applyDatafileTo(dfnumber=>sys.dbms_backup_restore.restoreSetPiece(handle=>'/.../ACCTA_feq2rmd4_con_1.bak',tag=>null,...);

6,tonamesys.dbms_backup_restore.restoreBackupPiece(done=>耗時(shí)Rman8ConvertRman5XttsmetadataOtherobjectsXttsmetadataOtherobjects對(duì)象核對(duì)(編譯<<1、

channelORA_DISK_1:startingdatafileinputfilename=/test/oracle/accta/oradata/vgacctdb01/lv_vg01_10g_001RMAN-00569:===============ERRORMESSAGESTACKFOLLOWS===============RMAN-03009:failureofconversionattargetcommandonORA_DISK_1ORA-19602:cannotbackuporcopyactivefileinNOARCHIVELOG4、增量備份在開啟Blockchangetracking :BLOCKCHANGETRACKINGNOTUSEDFORINCREMENTAL -BCTisnotusedinRACwhenatleastoneinstanceis

ORA-39126:WorkerunexpectedfatalerrorinKUPW$WORKER.UNLOAD_METADATA[PLUGTS_BLK]ORA-00904:"Q"."TABOBJ_NUM":invalididentifierORA-06512:at"SYS.DBMS_SYS_ERROR",line95