利用rman生成备用数据库操作文档

1.准备好相应的目录结构ITPUB个人空间e8[~ Q;\-lu!l
D:\oracle\admin\copy\bdump
7Ja2C*`V0D:\oracle\admin\copy\udumpITPUB个人空间\k S cJw$O}
D:\oracle\admin\copy\cdump

D:\oracle\oradata\copy

2.创建好参数文件  initcopy.ora 文件，参照主库文件进行修改.添加和修改以下参数文件ITPUB个人空间L
JUo1qo
db_name=copy
3\m5LC9T-nR,Le0instance_name=copy
;O^4YLu%bG!r0background_dump_dest=d:\oracle\admin\copy\bdumpITPUB个人空间SGh Q;U3B;E;x
core_dump_dest=d:\oracle\admin\copy\cdumpITPUB个人空间%VDuJM!?6C
user_dump_dest=d:\oracle\admin\copy\udump
+C3u_*D_ \'g
Ll)h0control_files='D:\oracle\oradata\copy\control01.ctl','d:\oracle\oradata\copy\control02.ctl','d:\oracle\oradata\copy\control03.ctl'ITPUB个人空间q1MJU6t
DB_FILE_NAME_CONVERT=('d:\oracle\oradata\paul','E:\oracle\oradata\copy')ITPUB个人空间u2G9v&x!bb
LOG_FILE_NAME_CONVERT=('d:\oracle\oradata\paul','E:\oracle\oradata\copy')

3.ITPUB个人空间1uV8S;M"Pt+^df
使用oradim创建新的instance
R*wwM^Iz0c:\>oradim -new -sid copyITPUB个人空间 kO&m%NG;Qf}
例程已创建。

4.使用orapwd创建password文件

C:\Documents and Settings\Paul Yi>orapwd file=d:\oracle\ora92\database\pwdcopy.o
3}6qv?7m&s2Z0S0ra password=abcdefg entries=10

5.配置好监听和tnsnames，然后使用sqlplus测试连接
R4i G#c'v[ H0listener.ora文件中ITPUB个人空间 my6{Q%Bc*X
增加以下内容ITPUB个人空间!A^:LNJ
 (SID_DESC =
f&yg~
S.n$t;h:\0      (GLOBAL_DBNAME = copy)ITPUB个人空间&@A!F9yv[A
      (ORACLE_HOME = D:\oracle\ora92)
lY`%O5Pr9W!{|#Y0      (SID_NAME = copy)
pBJ0A4x&`2F0   )ITPUB个人空间mg*lo2y2G9Fp)H
tnsnames.ora文件中增加ITPUB个人空间FYi ~&eW]
copy =
^r6m8[5mi0  (DESCRIPTION =ITPUB个人空间zcD%o|
X9d
    (ADDRESS_LIST =ITPUB个人空间A#I_W/B"r6P
      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.163)(PORT = 1521))
p,o3a
r(c6aL0    )ITPUB个人空间*A'aue
x u4_(\$r
    (CONNECT_DATA =
*fFK/XI
X'v;c%h0      (SERVICE_NAME = copy)
+FE2G
s^cK&tRQ0    )
H.D2[7y)P3nQ0  )

6.重新停止监听并且重启
7J9hSrf;h(d0Service "test" has 1 instance(s).
S[.H |]6n#a:D-`rd0?/d0  Instance "test", status UNKNOWN, has 1 handler(s) for this service...ITPUB个人空间Xv
^+RTO
The command completed successfully

7.使用rman备份原库
c;?'OQf|x0C:\Documents and Settings\Paul Yi>rman target / catalogpaultest/paultest@dev89.ITPUB个人空间 }m5\ujmqT
avocado.local

Recovery Manager: Release 9.2.0.4.0 - Production

Copyright (c) 1995, 2002, Oracle Corporation.  All rights reserved.

connected to target database: PAUL (DBID=1605165889)ITPUB个人空间_!JKvJ]Un\
connected to recovery catalog database

RMAN> backup full database tag 'fullbk';

Starting backup at 24-DEC-07ITPUB个人空间D'YK
Vs6E
allocated channel: ORA_DISK_1
}^'AYc_#A4r_0channel ORA_DISK_1: sid=13 devtype=DISK
(e"wY"J]&k9w0Q0channel ORA_DISK_1: starting full datafile backupsetITPUB个人空间|V0}Z r~"f0q ?2f
channel ORA_DISK_1: specifying datafile(s) in backupset
!i`\7WT
c g0input datafile fno=00001 name=D:\ORACLE\ORADATA\PAUL\SYSTEM01.DBF
e R3o"P]l,D8z0input datafile fno=00002 name=D:\ORACLE\ORADATA\PAUL\UNDOTBS01.DBF
!D4o)J9a
Iy
P8gU0input datafile fno=00003 name=D:\ORACLE\ORADATA\PAUL\INDX01.DBFITPUB个人空间@b:KN+W
input datafile fno=00005 name=D:\ORACLE\ORADATA\PAUL\USERS01.DBF
j0M!J1UV(G;[N8K@'W0input datafile fno=00004 name=D:\ORACLE\ORADATA\PAUL\TOOLS01.DBFITPUB个人空间%K+OfyK5|
Q4?
channel ORA_DISK_1: starting piece 1 at 24-DEC-07
~YQJ7Z0Scq F0channel ORA_DISK_1: finished piece 1 at 24-DEC-07ITPUB个人空间'Wnf2s*l+gS{1c g V
piece handle=D:\BACKUP\3TJ4DISC_1_1 comment=NONE
dq[,FC,SE%~^0channel ORA_DISK_1: backup set complete, elapsed time: 00:00:45ITPUB个人空间7S~-N{!S'T@
Finished backup at 24-DEC-07

Starting Control File and SPFILE Autobackup at 24-DEC-07ITPUB个人空间'v f Zt/P Bd
piece handle=D:\BACKUP\C-1605165889-20071224-00 comment=NONEITPUB个人空间 HR3B'b$@ l;a;E
Finished Control File and SPFILE Autobackup at 24-DEC-07

8.启动备用数据库到nomount状态ITPUB个人空间.}TiR+c
C:\Documents and Settings\Paul Yi>sqlplus /nolog

SQL*Plus: Release 9.2.0.4.0 - Production on Mon Dec 24 13:42:40 2007

Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.

SQL> connsys/abcdefg@copyas sysdbaITPUB个人空间#C^4@1P,l%R:P
Connected to an idle instance.ITPUB个人空间e~z-PP$J
SQL>startup pfile='D:\oracle\ora92\database\initcopy.ora';

File created.

SQL> startup nomount;

j?DzSs09.使用rman复制数据库
Cs(o8L.\*n0C:\Documents and Settings\Paul Yi>rman target / auxiliarysys/abcdefg@copy

Recovery Manager: Release 9.2.0.4.0 - Production

Copyright (c) 1995, 2002, Oracle Corporation.  All rights reserved.

connected to target database: PAUL (DBID=1605165889)
b7V"O6kX6D6k0connected to auxiliary database: copy (not mounted)

RMAN> duplicate target database to 'copy';

Starting Duplicate Db at 24-DEC-07
bU3{akp1n
Qbx0^Ek0using target database controlfile instead of recovery catalogITPUB个人空间Xlo8B5]9H(L
allocated channel: ORA_AUX_DISK_1ITPUB个人空间n V3v4S8KV2y
channel ORA_AUX_DISK_1: sid=3 devtype=DISK

printing stored script. Memory Script
0O@:G C;A CKc
j0{
4Zzle2\Ul5q._v0   set until scn  979183;ITPUB个人空间,iJ?F2q%BRCc
   set newname for datafile  1 to
kL f2} W.e#Q
e0 "D:\ORACLE\ORADATA\COPY\SYSTEM01.DBF";
%I/bM2gi0`0   set newname for datafile  2 toITPUB个人空间`\3O'R3jx~Cp
 "D:\ORACLE\ORADATA\COPY\UNDOTBS01.DBF";ITPUB个人空间)}%X(M;v:\8x6fDb
   set newname for datafile  3 to
T-_Zya0 "D:\ORACLE\ORADATA\COPY\INDX01.DBF";ITPUB个人空间sm.tn-C0~A"O
   set newname for datafile  4 to
zOE#prV mw!l0 "D:\ORACLE\ORADATA\COPY\TOOLS01.DBF";
Gs)BIx3H z0   set newname for datafile  5 toITPUB个人空间:w3|1Q8iD/\%d
 "D:\ORACLE\ORADATA\COPY\USERS01.DBF";
tE)Q)j8r%\1P\
a0   restore
(O[ o){;ZF0   check readonlyITPUB个人空间%c CA
`GK
   clone databaseITPUB个人空间)XwO\{/w*@
   ;ITPUB个人空间 Gr3Rh6hA
}ITPUB个人空间4I.ws3J
C
executing script. Memory Script

executing command: SET until clause

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

Starting restore at 24-DEC-07

using channel ORA_AUX_DISK_1ITPUB个人空间#~rT$p!BUsw*Wz"O
channel ORA_AUX_DISK_1: starting datafile backupset restoreITPUB个人空间/\*v!Hmuq"k
channel ORA_AUX_DISK_1: specifying datafile(s) to restore from backup setITPUB个人空间5ss1Z)J(m
restoring datafile 00001 to D:\ORACLE\ORADATA\COPY\SYSTEM01.DBFITPUB个人空间o5FA I
H.]
restoring datafile 00002 to D:\ORACLE\ORADATA\COPY\UNDOTBS01.DBFITPUB个人空间qg6[?I%a
restoring datafile 00003 to D:\ORACLE\ORADATA\COPY\INDX01.DBF
,d,W2CVM0restoring datafile 00004 to D:\ORACLE\ORADATA\COPY\TOOLS01.DBF
kiL8lGI.^,n0restoring datafile 00005 to D:\ORACLE\ORADATA\COPY\USERS01.DBF
?0FKTHU\0channel ORA_AUX_DISK_1: restored backup piece 1ITPUB个人空间6kkch1_|/o;lqE}
piece handle=D:\BACKUP\3MJ454NL_1_1 tag=TAG20071221T084645 params=NULLITPUB个人空间N5sGeWyj'm
channel ORA_AUX_DISK_1: restore completeITPUB个人空间 |Bmb]x.h~
Finished restore at 24-DEC-07
Y5M,M R2~9m0sql statement: CREATE CONTROLFILE REUSE SET DATABASE "copy" RESETLOGS ARCHIVELOG

  MAXLOGFILES      5
IP8mR!r,oWR0  MAXLOGMEMBERS      3
VxuF]*\d@ji0  MAXDATAFILES      100
w.rk B ^'Z g6dRS0  MAXINSTANCES     1ITPUB个人空间u~Sv `.K1EvU
  MAXLOGHISTORY      226
|.lVY]1NsTa0 LOGFILEITPUB个人空间H3Kd5e|}!t.w8z.`/e
  GROUP  1 ( 'D:\ORACLE\ORADATA\COPY\REDO01.LOG' ) SIZE  104857600  REUSE,
1O2E7Q'[6@ez0  GROUP  2 ( 'D:\ORACLE\ORADATA\COPY\REDO02.LOG' ) SIZE  104857600  REUSE,
Lt uT"vU6Z"`s0  GROUP  3 ( 'D:\ORACLE\ORADATA\COPY\REDO03.LOG' ) SIZE  104857600  REUSE
+O"b"\R"h+x+_B0 DATAFILE
]-k#`?g }0  'D:\ORACLE\ORADATA\COPY\SYSTEM01.DBF'ITPUB个人空间?'q7[2o/ND\/? G
 CHARACTER SET ZHS16GBK

ITPUB个人空间[5{ a:DQHj^0N,? i
printing stored script. Memory Script
%grpn$kA0{
T/Koer ]0   switch clone datafile all;ITPUB个人空间SNr(sw.`m#}%e
}ITPUB个人空间ARC0Op+X`A#?
executing script. Memory Script

datafile 2 switched to datafile copy
x6QL#aY7LP.Y*BR'P0input datafilecopy recid=1 stamp=642179779 filename=D:\ORACLE\ORADATA\COPY\UNDOTITPUB个人空间*u-Q2R%V(n2m8mS_*P9j
BS01.DBF
{v,kTxLH0datafile 3 switched to datafile copyITPUB个人空间.yb^GCf:g Q9I
input datafilecopy recid=2 stamp=642179779 filename=D:\ORACLE\ORADATA\COPY\INDX0ITPUB个人空间XvHW)mq`8n#jv\
1.DBFITPUB个人空间1Z` Y3N/G@Ex
datafile 4 switched to datafile copyITPUB个人空间ZSU
[9};Ql
input datafilecopy recid=3 stamp=642179779 filename=D:\ORACLE\ORADATA\COPY\TOOLS

l|p5@:s:M$i;@7?}*gi001.DBFITPUB个人空间6t*fXGDgeg
datafile 5 switched to datafile copy
_w)u2Q3jq)S0input datafilecopy recid=4 stamp=642179779 filename=D:\ORACLE\ORADATA\COPY\USERS
&Zk%?o)Z4ON001.DBF

printing stored script. Memory Script
OI@2^YH F!z0{ITPUB个人空间%O:{?j3_&Y5@
   set until scn  979183;

\(JVN8X)qT0   recover
O)_f9f([fN0   clone databaseITPUB个人空间/ez"U$^B#|
    delete archivelogITPUB个人空间igS9v?9r0re
   ;
dz6WR%^x%Tl!Bo0}ITPUB个人空间!g%{%oO.v0{
executing script. Memory Script

executing command: SET until clause

Starting recover at 24-DEC-07
h6?R,i4e;q#d]0using channel ORA_AUX_DISK_1

starting media recovery

archive log thread 1 sequence 182 is already on disk as file D:\BACKUP\1_182.DBF

archive log thread 1 sequence 183 is already on disk as file D:\ARCHPAUL\1_183.D
*D/XC!o-t6l:H0BFITPUB个人空间B'Xg$LS\2^
archive log thread 1 sequence 184 is already on disk as file D:\ARCHPAUL\1_184.DITPUB个人空间A;[4pm,I
BFITPUB个人空间;z5~#K$nb:}
archive log thread 1 sequence 185 is already on disk as file D:\ARCHPAUL\1_185.D
[g(BqG@b0BFITPUB个人空间9ZRmiMr
archive log thread 1 sequence 186 is already on disk as file D:\ARCHPAUL\1_186.D
#^;q2S.u!Z-A0BFITPUB个人空间o,r:L`q T\:`D
archive log filename=D:\BACKUP\1_182.DBF thread=1 sequence=182
^&dN!{hv*x9s{0archive log filename=D:\ARCHPAUL\1_183.DBF thread=1 sequence=183
"s*H&X*}X/E"t?W4Q$?0archive log filename=D:\ARCHPAUL\1_184.DBF thread=1 sequence=184
:@,Aqu/y@9@0archive log filename=D:\ARCHPAUL\1_185.DBF thread=1 sequence=185ITPUB个人空间yr5Zr6s^X"}B
archive log filename=D:\ARCHPAUL\1_186.DBF thread=1 sequence=186ITPUB个人空间j2@"Z?,n+k|/py
media recovery complete
8q&M.`+Q0l0Finished recover at 24-DEC-07

printing stored script. Memory Script
6~;~Hz9Zp+wf!z)V*c0{
J@)~7v)C8y6`#~0   shutdown clone;
:d*YU"m s ] nx0   startup clone nomount ;ITPUB个人空间/FoIp7d1af
}ITPUB个人空间w2h$B3`,Trp
executing script. Memory Script

database dismountedITPUB个人空间 ej!A%W4sa[a
Oracle instance shut down

connected to auxiliary database (not started)
V%\H(s^Z)`0Oracle instance started

Total System Global Area     101785252 bytes

Fixed Size                      454308 bytesITPUB个人空间#Mm ynk
Variable Size                 75497472 bytes
e(u1{i0TT{0Database Buffers              25165824 bytes
K)k6|Lj\0Redo Buffers                    667648 bytesITPUB个人空间1PU^,]Pc:LZY
sql statement: CREATE CONTROLFILE REUSE SET DATABASE "copy" RESETLOGS ARCHIVELOG

  MAXLOGFILES      5ITPUB个人空间%P8@Gwgdxb%["K D
  MAXLOGMEMBERS      3ITPUB个人空间 P:X~t$f'H
  MAXDATAFILES      100ITPUB个人空间o t7_{ XP:Iyy/~
  MAXINSTANCES     1ITPUB个人空间t N/FZ9X
  MAXLOGHISTORY      226
s8{(j2k!c
g$Pp_ R0 LOGFILE
9dwS LSm0  GROUP  1 ( 'D:\ORACLE\ORADATA\COPY\REDO01.LOG' ) SIZE  104857600  REUSE,
%g3\J3YA p'k E8Hv0  GROUP  2 ( 'D:\ORACLE\ORADATA\COPY\REDO02.LOG' ) SIZE  104857600  REUSE,ITPUB个人空间g*SY._ HQ3sy1d0JT
  GROUP  3 ( 'D:\ORACLE\ORADATA\COPY\REDO03.LOG' ) SIZE  104857600  REUSE
8|1ab'Qn6`||M Sy0 DATAFILEITPUB个人空间|P8e:a5[/V1hf
  'D:\ORACLE\ORADATA\COPY\SYSTEM01.DBF'
W7|OdVw-]EU7b0 CHARACTER SET ZHS16GBK

ITPUB个人空间
U9IPU}
printing stored script. Memory ScriptITPUB个人空间'W$o`3X-mGU
{
YXl!hk0   catalog clone datafilecopy  "D:\ORACLE\ORADATA\COPY\UNDOTBS01.DBF";
BljL7W0   catalog clone datafilecopy  "D:\ORACLE\ORADATA\COPY\INDX01.DBF";ITPUB个人空间?pUsFJ@D
   catalog clone datafilecopy  "D:\ORACLE\ORADATA\COPY\TOOLS01.DBF";ITPUB个人空间7B7U8Vfju
   catalog clone datafilecopy  "D:\ORACLE\ORADATA\COPY\USERS01.DBF";
@&b8by(]c"g8?0   switch clone datafile all;ITPUB个人空间!WS%z
jN4~i4D
o
}ITPUB个人空间!c$Aev-^.`$O+X*m
executing script. Memory Script

cataloged datafile copyITPUB个人空间c@:X^8}:})i
datafile copy filename=D:\ORACLE\ORADATA\COPY\UNDOTBS01.DBF recid=1 stamp=642180
^*{7N#a3wW0927

cataloged datafile copyITPUB个人空间N?O:]A%c
Iz
datafile copy filename=D:\ORACLE\ORADATA\COPY\INDX01.DBF recid=2 stamp=642180927

K"ipsW;Fi
r0cataloged datafile copy
](@1^ZK }y/sy0datafile copy filename=D:\ORACLE\ORADATA\COPY\TOOLS01.DBF recid=3 stamp=64218092ITPUB个人空间W"CIK-{
7

cataloged datafile copy
XV%Y7y
i0datafile copy filename=D:\ORACLE\ORADATA\COPY\USERS01.DBF recid=4 stamp=64218092
JL;M-V6i szz08

datafile 2 switched to datafile copyITPUB个人空间^&_ m pFo0B&^[
input datafilecopy recid=1 stamp=642180927 filename=D:\ORACLE\ORADATA\COPY\UNDOT
k#['Tn1u}0BS01.DBFITPUB个人空间OQxSN#c+H+r4?
datafile 3 switched to datafile copyITPUB个人空间1W1rF9m$i U5P
input datafilecopy recid=2 stamp=642180927 filename=D:\ORACLE\ORADATA\COPY\INDX0
`!s4GN"hx%`-}q01.DBF
fF;l
O?
b0datafile 4 switched to datafile copy
jE:P6Rws}0input datafilecopy recid=3 stamp=642180927 filename=D:\ORACLE\ORADATA\COPY\TOOLS

PZ'o0k odK001.DBF
:G1a KN2wom0datafile 5 switched to datafile copy
T Tp%Hd^4[0input datafilecopy recid=4 stamp=642180928 filename=D:\ORACLE\ORADATA\COPY\USERS
#{9i5`WP.SvC[2\001.DBF

printing stored script. Memory Script
/` yLw9yOI
m0{ITPUB个人空间&z%LB,a-l)v~'O&U+d
   Alter clone database open resetlogs;ITPUB个人空间V9j!|)CV-cV
}
e1@y2^/Kt:u!u0executing script. Memory Script

database opened
/j0N z ?9g,q6M'p0Finished Duplicate Db at 24-DEC-07

RMAN>

10.检查复制库的状态
~.X+D%\
C!B0SQL> select instance_name,status from v$instance;

INSTANCE_NAME    STATUSITPUB个人空间x1?;|.y"mUe#K
---------------- ------------------------
's[4F8`5p4n}g4l!og d0copy             OPEN

11.然后去掉initcopy.ora的DB_FILE_NAME_CONVERT和LOG_FILE_NAME_CONVERT参数，再使用该文件生成spfile

SQL> create spfile from pfile='D:\oracle\ora92\database\initcopy.ora';

文件已创建。ITPUB个人空间TRjGG_v
sql>startup
?t,ZA4t3{$S0over