使用oracle duplicate技术复制需要恢复的表空间到测试环境(异机)（一）

最新推荐文章于 2022-01-13 11:45:10 发布

cuijiaoru6165

最新推荐文章于 2022-01-13 11:45:10 发布

阅读量213

点赞数

文章标签：数据库

一、测试项目

使用oracle duplicate技术复制需要恢复的表空间到测试环境

二、测试目的

假定数据库有数据损坏，在flashback、灾备库、快照库无法进行恢复的情况下，使用数据库高级技术TSPITR（Tablespace Point-In-Time Recovery）进行数据恢复.

三、测试环境

目标数据库

数据库版本：oracle 9.2.0.7

系统环境：AIX 5.2

IP地址：172.16.34.33

db_name ：retc

辅助数据库

数据库版本：oracle 9.2.0.7

系统环境：AIX 5.2

IP地址：172.16.34.35

db_name ：aux

Catalog数据库

数据库版本：oracle 9.2.0.1

系统环境：windows 2003

IP地址：172.16.34.30

四、测试步骤

1. 数据库默认位置创建辅助库pfile参数文件initaux.ora

2. 数据库默认位置辅助库密码文件从目标数据库拷贝过来，然后改名为orapwaux.

3. 数据库默认位置创建辅助库listener监听器、TNS网络配置文件.

4. 从备份集里duplicate复制数据库到辅助库AUX，仅复制system、undo、tools（假定生产环境此表空间数据损坏）表空间到辅助库AUX，其他表空间skip跳过。

[@more@]

$ rman target sys@retc catalog rman/rman@rmandb auxiliary /

Recovery Manager: Release 9.2.0.7.0 - 64bit Production

Pwssord:********

connected to target database: RETC (DBID=1688860591)

connected to recovery catalog database

connected to auxiliary database: aux (not mounted)

RMAN> run {

allocate channel t1 type 'SBT_TAPE';

allocate auxiliary channel t2 type 'SBT_TAPE';

allocate auxiliary channel t3 type 'SBT_TAPE';

DUPLICATE TARGET DATABASE TO AUX

Skip tablespace ASSESSQUERY_DATA,ASSESSQUERY_IDX,CQGLOUT,DJWW,DKWW,FWZL,GHYSIZ_OUTER,HMOVEIDX,HOUSEMOVING,INDX,JSWW,JSWW_IDX,KNOWBASE,LANDSUR,MUNICIPALAPPLY,PERFORM,PLATFORM,PLPMOL,QUEST,SDE,SECOND,SECONDHAND_DATA,SECONDHAND_HIS,SECONDHAND_IDX,SHESTATE,SHGZ,SHJS,SHJSSITE,SHLZ,SHPLATFORM,SHPMGP,SHWY,TIVOLI1,TIVOLI2,USERS,VERITAS,WYCC,XDB,ZJJG_DATA,ZJJG_IDX

LOGFILE

GROUP 1 ('/u01/oradata/aux/redo01.log') SIZE 100M,

GROUP 2 ('/u01/oradata/aux/redo02.log') SIZE 100M,

GROUP 3 ('/u01/oradata/aux/redo03.log') SIZE 100M;

release channel t1;

release channel t2;

release channel t3;

}

2> 3> 4> 5> 6> 7> 8> 9> 10> 11> 12> 13> 14> 15>

allocated channel: t1

channel t1: sid=681 devtype=SBT_TAPE

channel t1: Tivoli Data Protection for Oracle: version 5.2.0.0

allocated channel: t2

channel t2: sid=10 devtype=SBT_TAPE

channel t2: Tivoli Data Protection for Oracle: version 5.2.0.0

allocated channel: t3

channel t3: sid=11 devtype=SBT_TAPE

channel t3: Tivoli Data Protection for Oracle: version 5.2.0.0

Starting Duplicate Db at 23-NOV-12

Datafile 3 skipped by request

Datafile 6 skipped by request

Datafile 7 skipped by request

Datafile 8 skipped by request

Datafile 9 skipped by request

Datafile 10 skipped by request

Datafile 11 skipped by request

Datafile 12 skipped by request

Datafile 13 skipped by request

Datafile 14 skipped by request

Datafile 15 skipped by request

Datafile 16 skipped by request

Datafile 17 skipped by request

Datafile 18 skipped by request

Datafile 19 skipped by request

Datafile 21 skipped by request

Datafile 22 skipped by request

Datafile 23 skipped by request

Datafile 24 skipped by request

Datafile 26 skipped by request

Datafile 27 skipped by request

Datafile 28 skipped by request

Datafile 29 skipped by request

Datafile 30 skipped by request

Datafile 31 skipped by request

Datafile 32 skipped by request

Datafile 33 skipped by request

Datafile 34 skipped by request

Datafile 35 skipped by request

Datafile 36 skipped by request

Datafile 37 skipped by request

Datafile 38 skipped by request

Datafile 39 skipped by request

Datafile 40 skipped by request

Datafile 41 skipped by request

Datafile 42 skipped by request

Datafile 43 skipped by request

Datafile 44 skipped by request

Datafile 45 skipped by request

Datafile 46 skipped by request

Datafile 47 skipped by request

Datafile 48 skipped by request

Datafile 49 skipped by request

Datafile 50 skipped by request

Datafile 51 skipped by request

Datafile 52 skipped by request

Datafile 53 skipped by request

Datafile 54 skipped by request

Datafile 55 skipped by request

Datafile 56 skipped by request

Datafile 57 skipped by request

Datafile 58 skipped by request

Datafile 59 skipped by request

Datafile 60 skipped by request

Datafile 61 skipped by request

Datafile 62 skipped by request

Datafile 63 skipped by request

Datafile 64 skipped by request

Datafile 65 skipped by request

printing stored script: Memory Script

{

set until scn 30616330474;

set newname for datafile 1 to

"/u01/oradata/aux/rwsw_system";

set newname for datafile 2 to

"/u01/oradata/aux/rwsw_undotbs1";

set newname for datafile 4 to

"/u01/oradata/aux/rwsw_tools";

set newname for datafile 5 to

"/u01/oradata/aux/rwsw_undotbs2";

set newname for datafile 20 to

"/u01/oradata/aux/rwsw_undotbs1_02";

set newname for datafile 25 to

"/u01/oradata/aux/rwsw_undotbs2_02";

restore

check readonly

clone database

skip tablespace ZJJG_IDX,

ZJJG_DATA,

XDB,

WYCC,

VERITAS,

USERS,

TIVOLI2,

TIVOLI1,

SHWY,

SHPMGP,

SHPLATFORM,

SHLZ,

SHJSSITE,

SHJS,

SHGZ,

SHESTATE,

SECONDHAND_IDX,

SECONDHAND_HIS,

SECONDHAND_DATA,

SECOND,

SDE,

QUEST,

PLPMOL,

PLATFORM,

PERFORM,

MUNICIPALAPPLY,

LANDSUR,

KNOWBASE,

JSWW_IDX,

JSWW,

INDX,

HOUSEMOVING,

HMOVEIDX,

GHYSIZ_OUTER,

FWZL,

DKWW,

DJWW,

CQGLOUT,

ASSESSQUERY_IDX,

ASSESSQUERY_DATA ;

}

executing script: Memory Script

executing command: SET until clause

executing command: SET NEWNAME

Starting restore at 23-NOV-12

channel t2: starting datafile backupset restore

channel t2: specifying datafile(s) to restore from backup set

restoring datafile 00001 to /u01/oradata/aux/rwsw_system

restoring datafile 00020 to /u01/oradata/aux/rwsw_undotbs1_02

channel t3: starting datafile backupset restore

channel t3: specifying datafile(s) to restore from backup set

restoring datafile 00002 to /u01/oradata/aux/rwsw_undotbs1

restoring datafile 00004 to /u01/oradata/aux/rwsw_tools

restoring datafile 00005 to /u01/oradata/aux/rwsw_undotbs2

restoring datafile 00025 to /u01/oradata/aux/rwsw_undotbs2_02

channel t3: restored backup piece 1

piece handle=67nqh0oo_1_1 tag=TAG20121117T053026 params=NULL

channel t2: restored backup piece 1

piece handle=66nqgpjj_1_1 tag=TAG20121117T053026 params=NULL

channel t3: restored backup piece 2

piece handle=67nqh0oo_2_1 tag=TAG20121117T053026 params=NULL

channel t3: restore complete

channel t2: restored backup piece 2

piece handle=66nqgpjj_2_1 tag=TAG20121117T053026 params=NULL

channel t2: restore complete

Finished restore at 23-NOV-12

sql statement: CREATE CONTROLFILE REUSE SET DATABASE "AUX" RESETLOGS ARCHIVELOG

MAXLOGFILES 192

MAXLOGMEMBERS 3

MAXDATAFILES 1024

MAXINSTANCES 32

MAXLOGHISTORY 3403

LOGFILE

GROUP 1 ( '/u01/oradata/aux/redo01.log' ) SIZE 104857600 ,

GROUP 2 ( '/u01/oradata/aux/redo02.log' ) SIZE 104857600 ,

GROUP 3 ( '/u01/oradata/aux/redo03.log' ) SIZE 104857600

DATAFILE

'/u01/oradata/aux/rwsw_system'

CHARACTER SET WE8ISO8859P1

printing stored script: Memory Script

{

switch clone datafile all;

}

executing script: Memory Script

datafile 2 switched to datafile copy

input datafilecopy recid=1 stamp=800128303 filename=/u01/oradata/aux/rwsw_undotbs1

datafile 4 switched to datafile copy

input datafilecopy recid=2 stamp=800128303 filename=/u01/oradata/aux/rwsw_tools

datafile 5 switched to datafile copy

input datafilecopy recid=3 stamp=800128303 filename=/u01/oradata/aux/rwsw_undotbs2

datafile 20 switched to datafile copy

input datafilecopy recid=4 stamp=800128303 filename=/u01/oradata/aux/rwsw_undotbs1_02

datafile 25 switched to datafile copy

input datafilecopy recid=5 stamp=800128303 filename=/u01/oradata/aux/rwsw_undotbs2_02

printing stored script: Memory Script

{

set until scn 30616330474;

recover

clone database

delete archivelog

;

}

executing script: Memory Script

executing command: SET until clause

Starting recover at 23-NOV-12

datafile 3 not processed because file is offline

datafile 6 not processed because file is offline

datafile 7 not processed because file is offline

datafile 8 not processed because file is offline

datafile 9 not processed because file is offline

datafile 10 not processed because file is offline

datafile 11 not processed because file is offline

datafile 12 not processed because file is offline

datafile 13 not processed because file is offline

datafile 14 not processed because file is offline

datafile 15 not processed because file is offline

datafile 16 not processed because file is offline

datafile 17 not processed because file is offline

datafile 18 not processed because file is offline

datafile 19 not processed because file is offline

datafile 21 not processed because file is offline

datafile 22 not processed because file is offline

datafile 23 not processed because file is offline

datafile 24 not processed because file is offline

datafile 26 not processed because file is offline

datafile 27 not processed because file is offline

datafile 28 not processed because file is offline

datafile 29 not processed because file is offline

datafile 30 not processed because file is offline

datafile 31 not processed because file is offline

datafile 32 not processed because file is offline

datafile 33 not processed because file is offline

datafile 34 not processed because file is offline

datafile 35 not processed because file is offline

datafile 36 not processed because file is offline

datafile 37 not processed because file is offline

datafile 38 not processed because file is offline

datafile 39 not processed because file is offline

datafile 40 not processed because file is offline

datafile 41 not processed because file is offline

datafile 42 not processed because file is offline

datafile 43 not processed because file is offline

datafile 44 not processed because file is offline

datafile 45 not processed because file is offline

datafile 46 not processed because file is offline

datafile 47 not processed because file is offline

datafile 48 not processed because file is offline

datafile 49 not processed because file is offline

datafile 50 not processed because file is offline

datafile 51 not processed because file is offline

datafile 52 not processed because file is offline

datafile 53 not processed because file is offline

datafile 54 not processed because file is offline

datafile 55 not processed because file is offline

datafile 56 not processed because file is offline

datafile 57 not processed because file is offline

datafile 58 not processed because file is offline

datafile 59 not processed because file is offline

datafile 60 not processed because file is offline

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/28227905/viewspace-1059816/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/28227905/viewspace-1059816/

cuijiaoru6165

关注

0
点赞
踩
0

收藏

觉得还不错? 一键收藏
0
评论
使用oracle duplicate技术复制需要恢复的表空间到测试环境(异机)（一）

一、测试项目使用oracle duplicate技术复制需要恢复的表空间到测试环境二、测试目的假定数据库有数据损坏，在flashback、灾备库、快照库无法进行恢复的情况下，使用数据库高级技术TSPITR（Tablespace ...
复制链接

扫一扫