ITPub博客

首页 > Linux操作系统 > Linux操作系统 > oracle 10g r2新功能可以跨越resetlogs 恢复

oracle 10g r2新功能可以跨越resetlogs 恢复

原创 Linux操作系统 作者:zhengbao_jun 时间:2009-02-13 16:09:55 0 删除 编辑

10g 新版本可以跨越resetlogs 用先前的备份来恢复 ,虽然有这个特性,但还是建议resetlogs 马上进行全库备份

10g 以前版本是不行的

先测试下9i

RMAN> recover database;

Starting recover at 05-JUN-08ITPUB个人空间3@6J)X(]R#xi
using channel ORA_DISK_1

starting media recovery

channel ORA_DISK_1: starting archive log restore to default destination
!`mh(A(VF Fj8?235507channel ORA_DISK_1: restoring archive log
x eA2lt4Pe D235507archive log thread=1 sequence=22ITPUB个人空间z,c0Q2eK"@s6@y
channel ORA_DISK_1: restored backup piece 1
+Nt*A r!hb2O;G235507piece handle=D:\BACKUP\3AJI5OME_1_1 tag=TAG20080605T121510 params=NULLITPUB个人空间IS nV(VX g8~;}#g^&V
channel ORA_DISK_1: restore complete
0F"f3Tw K L\6i$O235507archive log filename=D:\ARCHPAUL\PUBTEST_1_22.DBF thread=1 sequence=22
{4`H{ _I*})[*?235507unable to find archive log
!IP A4s(V sx!V.`235507archive log thread=1 sequence=23
n:~Fu q p J/_nUE235507RMAN-00571: ===========================================================
f`5JK?*EJG235507RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
)itTD Y,|Q'JQ235507RMAN-00571: ===========================================================
U&m#EOYO xm6v,e235507RMAN-03002: failure of recover command at 06/05/2008 14:42:21ITPUB个人空间sB'\ @ I2RY r
RMAN-06054: media recovery requesting unknown log: thread 1 scn 769229

RMAN> alter database open resetlogs;

database opened

RMAN> exit


QC~#Py%r235507Recovery Manager complete.

C:\Documents and Settings\Paul Yi>sqlplus "/as sysdba"

SQL*Plus: Release 9.2.0.8.0 - Production on Thu Jun 5 14:46:46 2008

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

ITPUB个人空间9T9TH8W.s6x;d#x
Connected to:
C7V Qb7G~*Su235507Oracle9i Enterprise Edition Release 9.2.0.8.0 - Production
T i.`1v}235507With the Partitioning, OLAP and Oracle Data Mining optionsITPUB个人空间3C*gz'{ Q!i
JServer Release 9.2.0.8.0 - Production

SQL> select count(*) from test;

  COUNT(*)
,T dh4f1E0f8\odx235507----------
|/I6`9x!O4{p? }235507        64

SQL> insert into test select * from test;

64 rows created.

SQL> /

128 rows created.

SQL> commit;

Commit complete.

SQL> archive log list;ITPUB个人空间-?(qq1D4B)hy:nfT
Database log mode              Archive Mode
Q1oQEV ?235507Automatic archival             EnabledITPUB个人空间*dFX-| v,\ RNaF:l A
Archive destination            d:\archpaul
:E&f e)P.QxN8` m235507Oldest online log sequence     1ITPUB个人空间;yn~Aq!F$K!s/a
Next log sequence to archive   1
*@;Da!\;H(V235507Current log sequence           1
,f!z$Dv5h0bYG3]235507SQL> alter system switch logfile;

System altered.

SQL> archive log list;
JB$f j3b&C)C)l}235507Database log mode              Archive ModeITPUB个人空间du9sdZH G K e+wcvA
Automatic archival             EnabledITPUB个人空间UQ)k/u&Q.N
Archive destination            d:\archpaulITPUB个人空间 ^F\cLSC R~
Oldest online log sequence     1ITPUB个人空间G]h_(Yr2L-S
Next log sequence to archive   2ITPUB个人空间JPk'S2S(B5U/t`
Current log sequence           2
@pw P7j235507SQL> select count(*) from test;

  COUNT(*)
w}%hHo0j235507----------ITPUB个人空间2d~!x az,Vs!u@
       256

SQL> shutdown immediate;
4zr;L8qi235507Database closed.
7N7l/GD1zY*X ?%m:C235507Database dismounted.ITPUB个人空间.s(x+m!h o)?
ORACLE instance shut down.ITPUB个人空间1L U,|)_(@
SQL> exitITPUB个人空间 M0emyAn S]
Disconnected from Oracle9i Enterprise Edition Release 9.2.0.8.0 - Production
P d;E O4x8J235507With the Partitioning, OLAP and Oracle Data Mining optionsITPUB个人空间 ~g'l/j\/n
JServer Release 9.2.0.8.0 - Production

C:\Documents and Settings\Paul Yi>rman target /

Recovery Manager: Release 9.2.0.8.0 - Production

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

connected to target database (not started)

RMAN> startup nomount;

Oracle instance started

Total System Global Area     101785012 bytes

Fixed Size                      454068 bytesITPUB个人空间uth0B,br/T
Variable Size                 75497472 bytesITPUB个人空间 py&[Os'j,mm&n
Database Buffers              25165824 bytesITPUB个人空间 F3Iu Y[#w T
Redo Buffers                    667648 bytes

RMAN> restore controlfile from 'd:\backup\C-799229701-20080605-01';

Starting restore at 05-JUN-08

using target database controlfile instead of recovery catalog
1q5t3h/wY$}V235507allocated channel: ORA_DISK_1ITPUB个人空间-Ks~[%aT7}
channel ORA_DISK_1: sid=11 devtype=DISK
Y)p5h,K!Y235507channel ORA_DISK_1: restoring controlfile
C'Vq0Oit235507channel ORA_DISK_1: restore complete
/@b.S AKL"Y!}235507replicating controlfileITPUB个人空间2Hr x[5Oc[
input filename=D:\ORACLE\ORADATA\PUBTEST\CONTROL01.CTLITPUB个人空间%b"c.?N3G `G ?
output filename=D:\ORACLE\ORADATA\PUBTEST\CONTROL02.CTL
? Y&M~f(Wy235507output filename=D:\ORACLE\ORADATA\PUBTEST\CONTROL03.CTLITPUB个人空间UoXS.D%om0mY#h(n
Finished restore at 05-JUN-08

RMAN> alter database mount;

database mounted

RMAN> restore database;

Starting restore at 05-JUN-08

using channel ORA_DISK_1ITPUB个人空间/W2sb+@LMf
channel ORA_DISK_1: starting datafile backupset restore
*m%c {x#{wM235507channel ORA_DISK_1: specifying datafile(s) to restore from backup set
a Q)I4Pg%[}"b`235507restoring datafile 00001 to D:\ORACLE\ORADATA\PUBTEST\SYSTEM01.DBFITPUB个人空间 NSc*I6@
restoring datafile 00002 to D:\ORACLE\ORADATA\PUBTEST\UNDOTBS01.DBFITPUB个人空间1`@,?$e Tw X'H
restoring datafile 00003 to D:\ORACLE\ORADATA\PUBTEST\EXAMPLE01.DBF
\aGV}235507restoring datafile 00004 to D:\ORACLE\ORADATA\PUBTEST\INDX01.DBFITPUB个人空间KQA$o!t_1p#ul;e
restoring datafile 00005 to D:\ORACLE\ORADATA\PUBTEST\TOOLS01.DBFITPUB个人空间6Y D k|)d}
restoring datafile 00006 to D:\ORACLE\ORADATA\PUBTEST\USERS01.DBFITPUB个人空间)A H!A PKIW
channel ORA_DISK_1: restored backup piece 1ITPUB个人空间 ky;g"mW}jO
piece handle=D:\BACKUP\39JI5OL0_1_1 tag=TAG20080605T121424 params=NULLITPUB个人空间Z5^]H t
channel ORA_DISK_1: restore complete
{z;m)D)[4^s235507Finished restore at 05-JUN-08

RMAN> recover database;

Starting recover at 05-JUN-08
3?+p#U E*^y W235507using channel ORA_DISK_1

starting media recovery

channel ORA_DISK_1: starting archive log restore to default destination
^2_0M&y Z/?'A5Y1t z235507channel ORA_DISK_1: restoring archive logITPUB个人空间c3J l"tCW8~N
archive log thread=1 sequence=22
,Y!h:@;[${Qp235507channel ORA_DISK_1: restored backup piece 1
+WK_9sv u$r;f cH1C235507piece handle=D:\BACKUP\3AJI5OME_1_1 tag=TAG20080605T121510 params=NULL
+H#BW"a0?235507channel ORA_DISK_1: restore completeITPUB个人空间 Ll&nB'P
archive log filename=D:\ARCHPAUL\PUBTEST_1_22.DBF thread=1 sequence=22
?E'b'_-F-m4|!Wwn235507unable to find archive logITPUB个人空间'mkx2?1J#`*o
archive log thread=1 sequence=23ITPUB个人空间4r7WX^2E X
RMAN-00571: ===========================================================ITPUB个人空间Bc'@}s1ie6g w
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
p(t5UE{;}lV235507RMAN-00571: ===========================================================ITPUB个人空间#D'm.?;dw
RMAN-03002: failure of recover command at 06/05/2008 14:52:03ITPUB个人空间AC[.f{Sh*P
RMAN-06054: media recovery requesting unknown log: thread 1 scn 769229

RMAN> alter database open resetlogs;

database opened

 

RMAN> exit

ITPUB个人空间 w:u r(j5w"a
Recovery Manager complete.

C:\Documents and Settings\Paul Yi>sqlplus "/as sysdba"

SQL*Plus: Release 9.2.0.8.0 - Production on Thu Jun 5 14:52:30 2008

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

ITPUB个人空间p2G:u9f2I(gW;a
Connected to:ITPUB个人空间|av'B H'\O p2yX
Oracle9i Enterprise Edition Release 9.2.0.8.0 - Production
K7nj:N7{ wb235507With the Partitioning, OLAP and Oracle Data Mining optionsITPUB个人空间|*lG Eb0}&`
JServer Release 9.2.0.8.0 - Production

SQL> select count(*) from test;

  COUNT(*)
8dj2c(j X|:r EH%CE235507----------
\ E ]O&f @ e235507        64

还是恢复到先前备份的那种状态 后面resetlogs后新增加的数据丢失了 这是因为不能跨越resetlogs的恢复

所以9i 强烈建议 resetlogs必须全备份一次数据库

10g R2下的测试:

RMAN> alter database open resetlogs;

数据库已打开

RMAN> exit

Microsoft Windows XP [Version 5.1.2600]
.xM&rnD N4g.z(mJ?235507(C) Copyright 1985-2001 Microsoft Corp.

C:\Documents and Settings\Paul Yi>set oracle_sid=orcl

C:\Documents and Settings\Paul Yi>sqlplus "/as sysdba"

SQL*Plus: Release 9.2.0.8.0 - Production on Thu Jun 5 16:25:18 2008

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


yQnm$zlu235507Connected to:
p PY\ nw&{R$uME r235507Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - ProductionITPUB个人空间y o|2rfQ*Z
With the Partitioning, OLAP and Data Mining options

SQL> archive log list;
p7f9M:UV t U,h235507Database log mode              Archive ModeITPUB个人空间8z$m}N9Wr8L)h
Automatic archival             EnabledITPUB个人空间J|8j T]#tz
Archive destination            USE_DB_RECOVERY_FILE_DESTITPUB个人空间xf3X'ii-c B |
Oldest online log sequence     1
e\ N/{ {w/x235507Next log sequence to archive   1
me8Pz(x#\235507Current log sequence           1
M\#U'hO2o_235507SQL> select count(*) from test;

  COUNT(*)
Q.b \)^6EtQk~235507----------
+_X8N;Q.||i235507     45028

SQL> insert into test select * from test;

45028 rows created.

SQL> commit;

Commit complete.

SQL> select count(*) from test;

  COUNT(*)
/Y G*XaZ235507----------
%A$~"} oKUMEc$^2l235507     90056

SQL> shutdown immediate;

用先前的备份恢复:

RMAN> startup nomount;

已连接到目标数据库 (未启动)ITPUB个人空间;HG#}(dd
Oracle 实例已启动

系统全局区域总计     289406976 字节

Fixed Size                     1248576 字节
B}!oS)~'h235507Variable Size                 96469696 字节
_+fE}R ^-[rg235507Database Buffers             184549376 字节ITPUB个人空间Z-M/q @ _~q
Redo Buffers                   7139328 字节

RMAN> restore controlfile from 'D:\oracle\flash_recovery_area\ORCL\AUTOBACKUP\20ITPUB个人空间~ VIJzWv)\
08_06_05\O1_MF_S_656605042_44H17N1V_.BKP';

启动 restore 于 05-6月 -08
dm*Y9Z7}#d235507分配的通道: ORA_DISK_1ITPUB个人空间w6lT7O$k[6M#qF
通道 ORA_DISK_1: sid=157 devtype=DISK

通道 ORA_DISK_1: 正在复原控制文件ITPUB个人空间F)GW;wo'S
通道 ORA_DISK_1: 恢复完成, 用时: 00:00:03
`BG2` C.dZ0@235507输出文件名=D:\ORACLE\ORADATA\ORCL\CONTROL01.CTLITPUB个人空间l osdPD
输出文件名=D:\ORACLE\ORADATA\ORCL\CONTROL02.CTLITPUB个人空间|yzPF3t9H{ p\#}
输出文件名=D:\ORACLE\ORADATA\ORCL\CONTROL03.CTLITPUB个人空间2xr"ONl[ e|9a&o
完成 restore 于 05-6月 -08

RMAN> alter database mount;

数据库已装载
4v3K}A:?7L C9Wy7e235507释放的通道: ORA_DISK_1

RMAN> restore database;

启动 restore 于 05-6月 -08
2I,wj1a C^235507启动 implicit crosscheck backup 于 05-6月 -08
V.D'hf8vQ"EO| kt235507分配的通道: ORA_DISK_1
s-W]e-yYs3{;h235507通道 ORA_DISK_1: sid=156 devtype=DISK
J2k#w3Mm3C%H}235507已交叉检验的 3 对象
5f*q4RI5C M/f235507完成 implicit crosscheck backup 于 05-6月 -08

启动 implicit crosscheck copy 于 05-6月 -08ITPUB个人空间U?.Kd(C&i
使用通道 ORA_DISK_1ITPUB个人空间6UciJ0g%n j"F] P
完成 implicit crosscheck copy 于 05-6月 -08

搜索恢复区域中的所有文件ITPUB个人空间M K(`'T}J.Gp
正在编制文件目录...ITPUB个人空间F*hJ}I)b#\k4[
目录编制完毕

已列入目录的文件的列表
-vLE9k8C-P&PM235507=======================ITPUB个人空间 [U{W3b"^
文件名: D:\ORACLE\FLASH_RECOVERY_AREA\ORCL\ARCHIVELOG\2008_06_05\O1_MF_1_18_44H1
F&BDUtJt F235507Z3FW_.ARCITPUB个人空间5{A?&Yjkf)|%z7Jo
文件名: D:\ORACLE\FLASH_RECOVERY_AREA\ORCL\ARCHIVELOG\2008_06_05\O1_MF_1_19_44H1ITPUB个人空间4x9c0G1HG
Z26L_.ARC
RK } A,h235507文件名: D:\ORACLE\FLASH_RECOVERY_AREA\ORCL\ARCHIVELOG\2008_06_05\O1_MF_1_1_44H26ITPUB个人空间9f,F1Ip B+w1u0u7]
3WN_.ARC
/~?YiIt(_235507文件名: D:\ORACLE\FLASH_RECOVERY_AREA\ORCL\ARCHIVELOG\2008_06_05\O1_MF_1_1_44H2FITPUB个人空间 y E/].C+B5| x)s3H7zs
DQC_.ARCITPUB个人空间]"kGj} ~a
文件名: D:\ORACLE\FLASH_RECOVERY_AREA\ORCL\ARCHIVELOG\2008_06_05\O1_MF_1_20_44H1ITPUB个人空间)Ki{ TrN
Z2PO_.ARCITPUB个人空间lJ5I4{p [
文件名: D:\ORACLE\FLASH_RECOVERY_AREA\ORCL\ARCHIVELOG\2008_06_05\O1_MF_1_2_44H2FITPUB个人空间j2]X%FF`1t[
D3T_.ARC
NM,vNP235507文件名: D:\ORACLE\FLASH_RECOVERY_AREA\ORCL\AUTOBACKUP\2008_06_05\O1_MF_S_6566050ITPUB个人空间/W4z+ss(oB$b-GC
42_44H17N1V_.BKPITPUB个人空间"e`ShM2y5B
文件名: D:\ORACLE\FLASH_RECOVERY_AREA\ORCL\AUTOBACKUP\2008_06_05\O1_MF_S_6566052ITPUB个人空间T(o)xbN J)y2{-_
54_44H1G7SD_.BKPITPUB个人空间o X5S[%VRm;X
文件名: D:\ORACLE\FLASH_RECOVERY_AREA\ORCL\AUTOBACKUP\2008_06_05\O1_MF_S_6566052
0q$LE6ME23550762_44H1GJJ3_.BKPITPUB个人空间:~gt}!Va _(h+Ch
文件名: D:\ORACLE\FLASH_RECOVERY_AREA\ORCL\AUTOBACKUP\2008_06_05\O1_MF_S_6566054
R l5FvZ1UM8A23550719_44H1MDOK_.BKP
Q0a3N0M``7~U N235507文件名: D:\ORACLE\FLASH_RECOVERY_AREA\ORCL\AUTOBACKUP\2008_06_05\O1_MF_S_6566058
i*SXcm)zq23550715_44H1ZSFF_.BKP
elg)u X235507文件名: D:\ORACLE\FLASH_RECOVERY_AREA\ORCL\AUTOBACKUP\2008_06_05\O1_MF_S_6566062ITPUB个人空间:JUtI/CdNrx:j
67_44H2FX5R_.BKP
P7FT/HS!@[235507文件名: D:\ORACLE\FLASH_RECOVERY_AREA\ORCL\AUTOBACKUP\2008_06_05\O1_MF_S_6566081
b"A Y`Q2T?g'T23550798_44H4B85T_.BKPITPUB个人空间X+BC2ut2rl
文件名: D:\ORACLE\FLASH_RECOVERY_AREA\ORCL\AUTOBACKUP\2008_06_05\O1_MF_S_6566082ITPUB个人空间'F SwH(xL P
49_44H4CTKM_.BKPITPUB个人空间8vPG6g(j!eE
文件名: D:\ORACLE\FLASH_RECOVERY_AREA\ORCL\BACKUPSET\2008_06_05\O1_MF_ANNNN_TAG2
{$wX@ X2355070080605T142217_44H1JTVV_.BKPITPUB个人空间bq#d8DT@,n\EMp
文件名: D:\ORACLE\FLASH_RECOVERY_AREA\ORCL\BACKUPSET\2008_06_05\O1_MF_ANNNN_TAG2
QMJAa$d+M.v@2355070080605T142336_44H1M9XC_.BKP
"j? ~is:Bd,n235507文件名: D:\ORACLE\FLASH_RECOVERY_AREA\ORCL\BACKUPSET\2008_06_05\O1_MF_NNNDF_TAG2ITPUB个人空间3G;I"DZ,s qczT
0080605T142220_44H1JWYS_.BKP

使用通道 ORA_DISK_1

未处理数据文件 4, 因为文件是只读的ITPUB个人空间6u/[~+G.Z6`k
未处理数据文件 5, 因为文件是只读的
%[Eg(I.S E0ux;F235507通道 ORA_DISK_1: 正在开始恢复数据文件备份集ITPUB个人空间 S{%HucV j
通道 ORA_DISK_1: 正在指定从备份集恢复的数据文件
-e mV#w GaHk235507正将数据文件00001恢复到D:\ORACLE\ORADATA\ORCL\SYSTEM01.DBFITPUB个人空间6f d)`}8a k P
正将数据文件00002恢复到D:\ORACLE\ORADATA\ORCL\UNDOTBS01.DBFITPUB个人空间0g!V ~6Jy9C/U!J;_Q
正将数据文件00003恢复到D:\ORACLE\ORADATA\ORCL\SYSAUX01.DBF
)@0xZ Tq] J|"yo@x235507通道 ORA_DISK_1: 正在读取备份段 D:\ORACLE\FLASH_RECOVERY_AREA\ORCL\BACKUPSET\200ITPUB个人空间IK g\i%E I&_
8_06_05\O1_MF_NNNDF_TAG20080605T142220_44H1JWYS_.BKPITPUB个人空间 h4zIz#hn$|z]g!V}
通道 ORA_DISK_1: 已恢复备份段 1
U3gWw5T5bEE235507段句柄 = D:\ORACLE\FLASH_RECOVERY_AREA\ORCL\BACKUPSET\2008_06_05\O1_MF_NNNDF_TAGITPUB个人空间^nW _&c}@
20080605T142220_44H1JWYS_.BKP 标记 = TAG20080605T142220
H+sG iK%J&g {235507通道 ORA_DISK_1: 恢复完成, 用时: 00:00:35
p0{5UQ'G ^e'|^235507完成 restore 于 05-6月 -08

RMAN> recover database;

启动 recover 于 05-6月 -08ITPUB个人空间:y9['ed{o'w
使用通道 ORA_DISK_1
n N^ A D1AI235507未处理数据文件 4, 因为文件是只读的
E0_;`:mEB clI7~9CR235507未处理数据文件 5, 因为文件是只读的

正在开始介质的恢复

存档日志线程 1 序列 18 已作为文件 D:\ORACLE\FLASH_RECOVERY_AREA\ORCL\ARCHIVELOG\ITPUB个人空间@qYe:U
2008_06_05\O1_MF_1_18_44H1Z3FW_.ARC 存在于磁盘上
4M`)}B7E5j T-W4ZK235507存档日志线程 1 序列 19 已作为文件 D:\ORACLE\FLASH_RECOVERY_AREA\ORCL\ARCHIVELOG\
&Z6w t)p R1~)@{_2355072008_06_05\O1_MF_1_19_44H1Z26L_.ARC 存在于磁盘上
)d#u0l+c#r,y'?a*T235507存档日志线程 1 序列 20 已作为文件 D:\ORACLE\FLASH_RECOVERY_AREA\ORCL\ARCHIVELOG\
6ckK$u&O;sZ,q{2355072008_06_05\O1_MF_1_20_44H1Z2PO_.ARC 存在于磁盘上
d;{:~#j Gp-{ U235507存档日志线程 1 序列 1 已作为文件 D:\ORACLE\FLASH_RECOVERY_AREA\ORCL\ARCHIVELOG\2ITPUB个人空间*_QeE.h.F'KF
008_06_05\O1_MF_1_1_44H263WN_.ARC 存在于磁盘上
p_dSWhSdX4q235507存档日志线程 1 序列 2 已作为文件 D:\ORACLE\FLASH_RECOVERY_AREA\ORCL\ARCHIVELOG\2
^.^lF'ldr235507008_06_05\O1_MF_1_2_44H2FD3T_.ARC 存在于磁盘上ITPUB个人空间5\5i)FFj
存档日志线程 1 序列 1 已作为文件 D:\ORACLE\ORADATA\ORCL\REDO01.LOG 存在于磁盘上ITPUB个人空间B1K:`4t,LH+z#\Q
通道 ORA_DISK_1: 正在启动到默认目标的存档日志恢复ITPUB个人空间-c#k2n5O(F2MH'v
通道 ORA_DISK_1: 正在恢复存档日志ITPUB个人空间3THX#sG2jC
存档日志线程 =1 序列=16
#rP9A(_5Vbbl235507通道 ORA_DISK_1: 正在恢复存档日志
S{-I:]nR235507存档日志线程 =1 序列=17
AQ_.NJ"F235507通道 ORA_DISK_1: 正在读取备份段 D:\ORACLE\FLASH_RECOVERY_AREA\ORCL\BACKUPSET\200
\$[z\-]j2355078_06_05\O1_MF_ANNNN_TAG20080605T142217_44H1JTVV_.BKP
n4I1I"xC Q9B2_Qqi235507通道 ORA_DISK_1: 已恢复备份段 1
2FY*ZAz3r235507段句柄 = D:\ORACLE\FLASH_RECOVERY_AREA\ORCL\BACKUPSET\2008_06_05\O1_MF_ANNNN_TAG
-Otk0w I[)I23550720080605T142217_44H1JTVV_.BKP 标记 = TAG20080605T142217
5U1|T;]j5vi2^}235507通道 ORA_DISK_1: 恢复完成, 用时: 00:00:02
Wxe2m(P,S1a$Lt235507存档日志文件名 =D:\ORACLE\FLASH_RECOVERY_AREA\ORCL\ARCHIVELOG\2008_06_05\O1_MF_1
S:tAf-XEdA}3} ^`235507_16_44HB9609_.ARC 线程 =1 序列 =16ITPUB个人空间k!J@/yi&k.w s
通道 default: 正在删除存档日志ITPUB个人空间 Hq0l,J{)p9PXh
存档日志文件名 =D:\ORACLE\FLASH_RECOVERY_AREA\ORCL\ARCHIVELOG\2008_06_05\O1_MF_1
0V]$aZ7Q0r!H235507_16_44HB9609_.ARC 记录 ID=16 时间戳 =656614310
kh2s!ZM$z*Z235507存档日志文件名 =D:\ORACLE\FLASH_RECOVERY_AREA\ORCL\ARCHIVELOG\2008_06_05\O1_MF_1
0|!`qI?$Q-edm235507_17_44HB9627_.ARC 线程 =1 序列 =17
"v Grg.D+?{235507通道 default: 正在删除存档日志ITPUB个人空间A2jODf~r5h
存档日志文件名 =D:\ORACLE\FLASH_RECOVERY_AREA\ORCL\ARCHIVELOG\2008_06_05\O1_MF_1ITPUB个人空间(O^Hb|
_17_44HB9627_.ARC 记录 ID=15 时间戳 =656614310
+c m/Q AO9I X.c235507存档日志文件名 =D:\ORACLE\FLASH_RECOVERY_AREA\ORCL\ARCHIVELOG\2008_06_05\O1_MF_1ITPUB个人空间"~5SM(h(t mMOQ2t
_18_44H1Z3FW_.ARC 线程 =1 序列 =18
N-M6t+vF3Hp235507存档日志文件名 =D:\ORACLE\FLASH_RECOVERY_AREA\ORCL\ARCHIVELOG\2008_06_05\O1_MF_1
v/RhtwS9O235507_19_44H1Z26L_.ARC 线程 =1 序列 =19
!S0a9XXI~KQiD"C@235507存档日志文件名 =D:\ORACLE\FLASH_RECOVERY_AREA\ORCL\ARCHIVELOG\2008_06_05\O1_MF_1
?*HVB7a7u@\235507_20_44H1Z2PO_.ARC 线程 =1 序列 =20ITPUB个人空间F-|w"?,D@9l
存档日志文件名 =D:\ORACLE\FLASH_RECOVERY_AREA\ORCL\ARCHIVELOG\2008_06_05\O1_MF_1ITPUB个人空间-u5z;q;l0@VL
_1_44H263WN_.ARC 线程 =1 序列 =1
HoM#J P9RV235507存档日志文件名 =D:\ORACLE\FLASH_RECOVERY_AREA\ORCL\ARCHIVELOG\2008_06_05\O1_MF_1ITPUB个人空间IkiDDiz-^
_2_44H2FD3T_.ARC 线程 =1 序列 =2ITPUB个人空间\sS9B"S)SX!Bf
存档日志文件名 =D:\ORACLE\ORADATA\ORCL\REDO01.LOG 线程 =1 序列 =1ITPUB个人空间 tV'sWNaZ _c
创建数据文件 fno = 6 名称 = D:\UNDO01.DBF
*tw%P8J8T235507存档日志文件名 =D:\ORACLE\ORADATA\ORCL\REDO01.LOG 线程 =1 序列 =1
#V6Uf K Pu%v2?7?235507介质恢复完成, 用时: 00:00:06
\fJ,w8aE9G235507完成 recover 于 05-6月 -08

RMAN> alter database open resetlogs;

数据库已打开

RMAN> exit


,p fD!Eu5eD1HKs235507恢复管理器完成。

F:\oracle\product\10.2.0\db_1\BIN>sqlplus "/as sysdba"

SQL*Plus: Release 10.2.0.1.0 - Production on 星期四 6月 5 16:53:20 2008

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

ITPUB个人空间b8X"z fwY%dL
连接到:
Arla*a235507Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - ProductionITPUB个人空间kY cW"_I"H
With the Partitioning, OLAP and Data Mining options

SQL> select count(*) from test;

  COUNT(*)
nnw{`.P235507----------
_!h.o2I'J235507     90056

SQL>ITPUB个人空间&Mxs'@5PCz

resetlogs后新增的数据也增加上了 数据一致

 

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

请登录后发表评论 登录
全部评论

注册时间:2008-08-08

  • 博文量
    209
  • 访问量
    863848