ORACLE TPITR 介绍.docxVIP

ORACLE TSPITR 介绍 一、??????TSPITR?架构 TSPITR?是基于表空间的时间点恢复,架构如下: 过程如下： 1创建实例(自动或者手动) 2 Restore database 只恢复(system undotbs? sysaux和指定的需要恢复的表空间) 3 recover database until time 4?使用exp从还原数据库导出 5?导入到源数据库 二、??????3种实现方式 1 Fully automated TSPITR— 全自动本机恢复,只需要设置?创建auxiliary destination? rman target / RECOVER TABLESPACE TEST until time to_date( 2012-12-09 17:05:07, yyyy-mm-dd HH24:MI:SS) AUXILIARY DESTINATION /data/auxdest/; 2 Customized TSPITR with an automatic auxiliary instance 在第一种基础上添加一些自定义控制,如: SET NEWNAME, CONFIGURE AUXNAME，初始化参数(SET AUXILIARY INSTANCE PARAMETER FILE)等 ?? rman target / RUN { ? SET NEWNAME FOR DATAFILE ?/oradata/prod/system01.dbf ??? TO /disk1/auxdest/system01.dbf; ? SET NEWNAME FOR DATAFILE ?/oradata/prod/sysaux01.dbf ??? TO /disk1/auxdest/sysaux01.dbf; ? SET NEWNAME FOR DATAFILE ?/oradata/prod/undotbs01.dbf ??? TO /disk1/auxdest/undotbs01.dbf; ? RECOVER TABLESPACE users, tools ??? UNTIL LOGSEQ 1300 THREAD 1 ??? AUXILIARY DESTINATION /disk1/auxdest; } 3 TSPITR with your own auxiliary instance 相比前两种需要手动创建auxiliary instance，并在完成后手动清理该实例 该方式步骤: 1?创建密码文件 2?创建初始化参数 3?配置tnsnames.ora?并能连接上Auxiliary Instance 4?执行恢复 rman target / auxiliary sys/syspwd@pitprod RUN { # Specify NEWNAME for recovery set data files ? SET NEWNAME FOR TABLESPACE clients ??????????????????????? TO ?/oradata/prod/rec/%b; ? # Specify NEWNAMES for some auxiliary set # data files that have a valid image copy to avoid restores: ? SET NEWNAME FOR DATAFILE ?/oradata/prod/system01.dbf ??????????????????????? TO /backups/prod/system01_monday_noon.dbf; ? SET NEWNAME FOR DATAFILE ?/oradata/prod/system02.dbf ??????????????????????? TO /backups/prod/system02_monday_noon.dbf; ? SET NEWNAME FOR DATAFILE ?/oradata/prod/sysaux01.dbf ??????????????????????? TO /backups/prod/sysaux01_monday_noon.dbf; ? SET NEWNAME FOR DATAFILE ?/oradata/prod/undo01.dbf ??????????????????????? TO /backups/prod/undo01_monday_noon.dbf; ? # Specify the types of channels to use ? ALLOCATE AUXILIARY CHANNEL c1 DEVICE TYPE DISK; ?