oracle 10g r2新功能可以跨越resetlogs 恢复
上一篇 / 下一篇 2008-06-05 16:11:43 / 个人分类：oracle 10g 新技术
10g 新版本可以跨越resetlogs 用先前的备份来恢复 ,虽然有这个特性,但还是建议resetlogs 马上进行全库备份
10g 以前版本是不行的
先测试下9i
RMAN> recover database;
Starting recover at 05-JUN-08ITPUB个人空间q1iB1ga
sU
using channel ORA_DISK_1
starting media recovery
channel ORA_DISK_1: starting archive log restore to default destinationITPUB个人空间8I6];~!u:Z^L
channel ORA_DISK_1: restoring archive logITPUB个人空间_)o ? ][&aCl
archive log thread=1 sequence=22
G0o!p
j!KNH0channel ORA_DISK_1: restored backup piece 1
\5f)V? W0piece handle=D:\BACKUP\3AJI5OME_1_1 tag=TAG20080605T121510 params=NULLITPUB个人空间A^5e%H)qm_
E#R ld
channel ORA_DISK_1: restore completeITPUB个人空间w7o xC@,@\
archive log filename=D:\ARCHPAUL\PUBTEST_1_22.DBF thread=1 sequence=22
G${ ^ m7h0unable to find archive log
7h5DZ S$Gr$E0archive log thread=1 sequence=23ITPUB个人空间aR.t3P2qHKwR
RMAN-00571: ===========================================================
&QC @'x
w cPH A4u0RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============ITPUB个人空间
[3I5@c n ]"SD
RMAN-00571: ===========================================================ITPUB个人空间`O j mh A
RMAN-03002: failure of recover command at 06/05/2008 14:42:21ITPUB个人空间 B&a!tu T6Rg&\#a\
RMAN-06054: media recovery requesting unknown log: thread 1 scn 769229
RMAN> alter database open resetlogs;
database opened
RMAN> exit
8l+Mmt4uz ^v#X0Recovery 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个人空间
H rC.G"a#Jhj
Connected to:ITPUB个人空间.g Vi$T:`E7Gj
Oracle9i Enterprise Edition Release 9.2.0.8.0 - ProductionITPUB个人空间 J yQ N!S]"z j[E
With the Partitioning, OLAP and Oracle Data Mining options
)T|~A!Q,N/u&^6y0JServer Release 9.2.0.8.0 - Production
SQL> select count(*) from test;
COUNT(*)ITPUB个人空间$^6K*Q lt%Pav)p
----------ITPUB个人空间,O/D(o Gl1J8W}
Ym
64
SQL> insert into test select * from test;
64 rows created.
SQL> /
128 rows created.
SQL> commit;
Commit complete.
SQL> archive log list;ITPUB个人空间9Y;@9m v N.H t+^
Database log mode Archive ModeITPUB个人空间U:{ p2q&p }[KrW
Automatic archival Enabled
%q{1m9uvr4T
Pr)X*b/Z0Archive destination d:\archpaulITPUB个人空间hxE hdZ
Oldest online log sequence 1
;_-lEW-mI0Next log sequence to archive 1
5K i,XK ? ?S0Current log sequence 1ITPUB个人空间z,y9c'P"E p:u?;P1j:K'}
SQL> alter system switch logfile;
System altered.
SQL> archive log list;
-?.y6s ~,rm0Database log mode Archive ModeITPUB个人空间7WP0S-w }Y;b/N
Automatic archival EnabledITPUB个人空间'qm@Q DK(H a
Archive destination d:\archpaul
.E0~8Wf s%u4p Q0Oldest online log sequence 1
x"T$s9i5{!D0Next log sequence to archive 2
L(gZ3~:H,v8t0Current log sequence 2
x+wZJPd9e0SQL> select count(*) from test;
COUNT(*)ITPUB个人空间F
P5g FL*n~!PS
----------
ZT{v,v k0 256
SQL> shutdown immediate;
VZ SuFQn0Database closed.
?"QY(Kyi4b0Database dismounted.
L ?;?%`tB6a%{0ORACLE instance shut down.ITPUB个人空间r5d*g;P"^,T y7O%x9{1k
SQL> exit
"V SkTf-A4q0Disconnected from Oracle9i Enterprise Edition Release 9.2.0.8.0 - ProductionITPUB个人空间 R3c {B v5T
With the Partitioning, OLAP and Oracle Data Mining options
m;t3V"|
}/P;~/Z.Cz0JServer 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个人空间1Ij1tZ}m
\ R2~
Variable Size 75497472 bytes
*},s]
FUr M5o0Database Buffers 25165824 bytesITPUB个人空间zlVP PB
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
_3SKh\U?-R.{0allocated channel: ORA_DISK_1ITPUB个人空间*b.R f;iu]H'A%p
channel ORA_DISK_1: sid=11 devtype=DISK
3_:]1r k9g!s3s0channel ORA_DISK_1: restoring controlfileITPUB个人空间3nQ)a}fI#rH/D%w
channel ORA_DISK_1: restore completeITPUB个人空间5^z OO/Z5z SA
replicating controlfileITPUB个人空间(a+Z s@ACAp-]C
input filename=D:\ORACLE\ORADATA\PUBTEST\CONTROL01.CTLITPUB个人空间*Y/xwBc_4J/k
output filename=D:\ORACLE\ORADATA\PUBTEST\CONTROL02.CTLITPUB个人空间8TSGH`6u U
output filename=D:\ORACLE\ORADATA\PUBTEST\CONTROL03.CTLITPUB个人空间/G\2F'J_
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个人空间HL/t,^@p
channel ORA_DISK_1: starting datafile backupset restore
/aW2b*} r0Y o A2U3eW!o)M0channel ORA_DISK_1: specifying datafile(s) to restore from backup setITPUB个人空间^2p3c?+['cM,C
restoring datafile 00001 to D:\ORACLE\ORADATA\PUBTEST\SYSTEM01.DBFITPUB个人空间 NA X2} ki9v c
restoring datafile 00002 to D:\ORACLE\ORADATA\PUBTEST\UNDOTBS01.DBFITPUB个人空间)w ~:EQ8K"p#\4ySl
restoring datafile 00003 to D:\ORACLE\ORADATA\PUBTEST\EXAMPLE01.DBFITPUB个人空间+Fck~v.u
restoring datafile 00004 to D:\ORACLE\ORADATA\PUBTEST\INDX01.DBFITPUB个人空间"H3qci kF(v{
restoring datafile 00005 to D:\ORACLE\ORADATA\PUBTEST\TOOLS01.DBF
b2QF1u1Q,s0restoring datafile 00006 to D:\ORACLE\ORADATA\PUBTEST\USERS01.DBF
!qW h4Ua!v0channel ORA_DISK_1: restored backup piece 1ITPUB个人空间Ei!]6s$q3?*q
piece handle=D:\BACKUP\39JI5OL0_1_1 tag=TAG20080605T121424 params=NULLITPUB个人空间}aT TXq7T t a%e0]
channel ORA_DISK_1: restore completeITPUB个人空间
}!gr%fdf
Finished restore at 05-JUN-08
RMAN> recover database;
Starting recover at 05-JUN-08ITPUB个人空间$^r+XZJ ~-o V]
using channel ORA_DISK_1
starting media recovery
channel ORA_DISK_1: starting archive log restore to default destination
d9gJM8k l0channel ORA_DISK_1: restoring archive logITPUB个人空间-C8\TN$NS,Y+s5\ `
archive log thread=1 sequence=22
`?"dE6w `#o[&LP0channel ORA_DISK_1: restored backup piece 1
m0gU"s ^)Te V0piece handle=D:\BACKUP\3AJI5OME_1_1 tag=TAG20080605T121510 params=NULL
*b4F%OP6],i iIj"]0channel ORA_DISK_1: restore completeITPUB个人空间4~ c(f+H3l
archive log filename=D:\ARCHPAUL\PUBTEST_1_22.DBF thread=1 sequence=22
;w(J |2i0y2U9s0Z0y0unable to find archive log
a7H [ eJlL1\cm0archive log thread=1 sequence=23ITPUB个人空间6{-i ][-l8h0E$h$f
RMAN-00571: ===========================================================
.q | Kt'F ^ p0RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============ITPUB个人空间B,`?+s'@
RMAN-00571: ===========================================================
4v x,kG Lb |-H@d0RMAN-03002: failure of recover command at 06/05/2008 14:52:03ITPUB个人空间#y\;Q O+?%D1?+i5s9O`
RMAN-06054: media recovery requesting unknown log: thread 1 scn 769229
RMAN> alter database open resetlogs;
database opened
RMAN> exit
ITPUB个人空间]q\ m5z1T%h{
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个人空间!P_(z9C!T8Cb4S D6Wh
Connected to:ITPUB个人空间#T6K3F J2YF
Oracle9i Enterprise Edition Release 9.2.0.8.0 - Production
Z ?1Y3i(hu7r s^0With the Partitioning, OLAP and Oracle Data Mining optionsITPUB个人空间 ` e g h R ^(w
J%P
JServer Release 9.2.0.8.0 - Production
SQL> select count(*) from test;
COUNT(*)ITPUB个人空间$H`.[(W-~ {;DmO
----------
,|D'`(L%g0 64
还是恢复到先前备份的那种状态 后面resetlogs后新增加的数据丢失了 这是因为不能跨越resetlogs的恢复
所以9i 强烈建议 resetlogs必须全备份一次数据库
10g R2下的测试:
RMAN> alter database open resetlogs;
数据库已打开
RMAN> exit
Microsoft Windows XP [Version 5.1.2600]
Q*q })@ t c p0(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.
k:iA U4^N0Connected to:ITPUB个人空间s BoZ yu9O'W
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
]`.V.vb3eG0With the Partitioning, OLAP and Data Mining options
SQL> archive log list;ITPUB个人空间%Pk/R
bG \
Database log mode Archive Mode
4`
nu
XO0Automatic archival EnabledITPUB个人空间O:em'i
ka#a:L
Archive destination USE_DB_RECOVERY_FILE_DESTITPUB个人空间cB$?$s_/x%L0D%N
Oldest online log sequence 1ITPUB个人空间 {M-I9[ D#Vs;Q
Next log sequence to archive 1
?7HJ/A d/Y.`0Current log sequence 1
1EG0X
F ]
e8^cj;?Q0SQL> select count(*) from test;
COUNT(*)ITPUB个人空间lx6C5J:r&?3J
S5R
----------
l/Bav%a
M }
q0 45028
SQL> insert into test select * from test;
45028 rows created.
SQL> commit;
Commit complete.
SQL> select count(*) from test;
COUNT(*)ITPUB个人空间p)GK*R&R8q
----------ITPUB个人空间2U
aAD5\;b
90056
SQL> shutdown immediate;
用先前的备份恢复:
RMAN> startup nomount;
已连接到目标数据库 (未启动)ITPUB个人空间 [JR)Z(fO
Oracle 实例已启动
系统全局区域总计 289406976 字节
Fixed Size 1248576 字节
R%\*Mf;F0Variable Size 96469696 字节ITPUB个人空间.r*Kp
ZK"p
Database Buffers 184549376 字节
O!PaS"s"s-f0Redo Buffers 7139328 字节
RMAN> restore controlfile from 'D:\oracle\flash_recovery_area\ORCL\AUTOBACKUP\20ITPUB个人空间aYH9d V2g,I
08_06_05\O1_MF_S_656605042_44H17N1V_.BKP';
启动 restore 于 05-6月 -08ITPUB个人空间L_ [^"m
分配的通道: ORA_DISK_1
-a-p*a oC&V0通道 ORA_DISK_1: sid=157 devtype=DISK
通道 ORA_DISK_1: 正在复原控制文件ITPUB个人空间,BT r m9U8d1|
通道 ORA_DISK_1: 恢复完成, 用时: 00:00:03ITPUB个人空间:E F3]
^O3R1A
输出文件名=D:\ORACLE\ORADATA\ORCL\CONTROL01.CTLITPUB个人空间^)@%z` }
输出文件名=D:\ORACLE\ORADATA\ORCL\CONTROL02.CTLITPUB个人空间1N'i G9J(KS-e Q
输出文件名=D:\ORACLE\ORADATA\ORCL\CONTROL03.CTL
X~%_)l7yX0完成 restore 于 05-6月 -08
RMAN> alter database mount;
数据库已装载ITPUB个人空间KO6SB@8l3Z4hk$F {
释放的通道: ORA_DISK_1
RMAN> restore database;
启动 restore 于 05-6月 -08ITPUB个人空间F [ n"`
{%yp
启动 implicit crosscheck backup 于 05-6月 -08
`qts:|0分配的通道: ORA_DISK_1
0Q+a9u.hig0通道 ORA_DISK_1: sid=156 devtype=DISK
"]6o F _'} @ l Y M0已交叉检验的 3 对象ITPUB个人空间8{#q+F5hu dc
完成 implicit crosscheck backup 于 05-6月 -08
启动 implicit crosscheck copy 于 05-6月 -08
V F U6xyn|N$l0使用通道 ORA_DISK_1
_ E-`M*Y(q3a y0完成 implicit crosscheck copy 于 05-6月 -08
搜索恢复区域中的所有文件ITPUB个人空间:Q C4}@rq
正在编制文件目录...ITPUB个人空间)i~@'v ?*O-F S9R
目录编制完毕
已列入目录的文件的列表
AD8n's/D9r Deo%R3_0=======================
[rS}&G0文件名: D:\ORACLE\FLASH_RECOVERY_AREA\ORCL\ARCHIVELOG\2008_06_05\O1_MF_1_18_44H1ITPUB个人空间(mqx6K s xf Q
Z3FW_.ARCITPUB个人空间$k x,a.Ng;h+|
文件名: D:\ORACLE\FLASH_RECOVERY_AREA\ORCL\ARCHIVELOG\2008_06_05\O1_MF_1_19_44H1ITPUB个人空间B`Cj I R;vR
Z26L_.ARCITPUB个人空间,d;oN%x5`T9[ v
文件名: D:\ORACLE\FLASH_RECOVERY_AREA\ORCL\ARCHIVELOG\2008_06_05\O1_MF_1_1_44H26ITPUB个人空间 l_WcO YC y
3WN_.ARCITPUB个人空间 _#LY R,Y8Y f
]
文件名: D:\ORACLE\FLASH_RECOVERY_AREA\ORCL\ARCHIVELOG\2008_06_05\O1_MF_1_1_44H2FITPUB个人空间?t9\ ^e }
DQC_.ARCITPUB个人空间\xo-|@)^n%v!p,^$h
文件名: D:\ORACLE\FLASH_RECOVERY_AREA\ORCL\ARCHIVELOG\2008_06_05\O1_MF_1_20_44H1ITPUB个人空间0A;M)R;mzL c.F&ew
Z2PO_.ARCITPUB个人空间 `&k F6w0Hrzu%}9u!c:H
文件名: D:\ORACLE\FLASH_RECOVERY_AREA\ORCL\ARCHIVELOG\2008_06_05\O1_MF_1_2_44H2FITPUB个人空间O"o o$x Uc7lp$zU
D3T_.ARCITPUB个人空间0bh!I
H d2F
GA-g
文件名: D:\ORACLE\FLASH_RECOVERY_AREA\ORCL\AUTOBACKUP\2008_06_05\O1_MF_S_6566050
D
K'BG1ar042_44H17N1V_.BKPITPUB个人空间 fq%_,i.c q
文件名: D:\ORACLE\FLASH_RECOVERY_AREA\ORCL\AUTOBACKUP\2008_06_05\O1_MF_S_6566052
&C(O4tx D$W054_44H1G7SD_.BKP
j1]d/p5b.t0文件名: D:\ORACLE\FLASH_RECOVERY_AREA\ORCL\AUTOBACKUP\2008_06_05\O1_MF_S_6566052
h0|)P,l D;S } @062_44H1GJJ3_.BKPITPUB个人空间G J
I(j X'M1]e+\
文件名: D:\ORACLE\FLASH_RECOVERY_AREA\ORCL\AUTOBACKUP\2008_06_05\O1_MF_S_6566054
'i#fc7i"B1`)X(~*G019_44H1MDOK_.BKP
J3X)M(U?$G0文件名: D:\ORACLE\FLASH_RECOVERY_AREA\ORCL\AUTOBACKUP\2008_06_05\O1_MF_S_6566058
+\ | `]H6XSI$e6u015_44H1ZSFF_.BKP
DQ4G J b})N!R.D0文件名: D:\ORACLE\FLASH_RECOVERY_AREA\ORCL\AUTOBACKUP\2008_06_05\O1_MF_S_6566062
H4ZP-P6tn3T/J
}067_44H2FX5R_.BKP
t0G} |(VQ \}0文件名: D:\ORACLE\FLASH_RECOVERY_AREA\ORCL\AUTOBACKUP\2008_06_05\O1_MF_S_6566081
k,L"G WP2H9r2h1F098_44H4B85T_.BKP
*yw6[ES:[0文件名: D:\ORACLE\FLASH_RECOVERY_AREA\ORCL\AUTOBACKUP\2008_06_05\O1_MF_S_6566082ITPUB个人空间^ o/y%h6V q&w4l
49_44H4CTKM_.BKP
&c%I&EcrA-Fn Xp*j0文件名: D:\ORACLE\FLASH_RECOVERY_AREA\ORCL\BACKUPSET\2008_06_05\O1_MF_ANNNN_TAG2
jY g#g s/Q)u C00080605T142217_44H1JTVV_.BKP
V |0u'?E/?QJc7TH0文件名: D:\ORACLE\FLASH_RECOVERY_AREA\ORCL\BACKUPSET\2008_06_05\O1_MF_ANNNN_TAG2
MC7g`\+HGtw(p00080605T142336_44H1M9XC_.BKP
(x,T psN:t3]-c0文件名: D:\ORACLE\FLASH_RECOVERY_AREA\ORCL\BACKUPSET\2008_06_05\O1_MF_NNNDF_TAG2ITPUB个人空间}`3dc+B Ukt9V Y
0080605T142220_44H1JWYS_.BKP
使用通道 ORA_DISK_1
未处理数据文件 4, 因为文件是只读的ITPUB个人空间 [p9XY ~9E
未处理数据文件 5, 因为文件是只读的
]'y7P4]6WY5^0F*Q0通道 ORA_DISK_1: 正在开始恢复数据文件备份集
i*Y
Ox$X.H&i0通道 ORA_DISK_1: 正在指定从备份集恢复的数据文件
"E g |q$It4G0正将数据文件00001恢复到D:\ORACLE\ORADATA\ORCL\SYSTEM01.DBFITPUB个人空间 O0K$E8T'`z
正将数据文件00002恢复到D:\ORACLE\ORADATA\ORCL\UNDOTBS01.DBFITPUB个人空间4x&i*J!@5F&j#b.m$n
正将数据文件00003恢复到D:\ORACLE\ORADATA\ORCL\SYSAUX01.DBF
h'T#d t3O'w0通道 ORA_DISK_1: 正在读取备份段 D:\ORACLE\FLASH_RECOVERY_AREA\ORCL\BACKUPSET\200ITPUB个人空间M:WJCJ-h
8_06_05\O1_MF_NNNDF_TAG20080605T142220_44H1JWYS_.BKP
%Ey5|9]2M J7hOr0通道 ORA_DISK_1: 已恢复备份段 1
u'K
unO/H
P0段句柄 = D:\ORACLE\FLASH_RECOVERY_AREA\ORCL\BACKUPSET\2008_06_05\O1_MF_NNNDF_TAG
)H x
?/e)gj l9i020080605T142220_44H1JWYS_.BKP 标记 = TAG20080605T142220
j`:dH"l!w0S L$x0通道 ORA_DISK_1: 恢复完成, 用时: 00:00:35
8a!`(F1J-^.HF.H%L5a0完成 restore 于 05-6月 -08
RMAN> recover database;
启动 recover 于 05-6月 -08ITPUB个人空间*F? cT;`O;g c#H
使用通道 ORA_DISK_1
P1[;l$S$a5e h0未处理数据文件 4, 因为文件是只读的ITPUB个人空间0XpS(L e#S
未处理数据文件 5, 因为文件是只读的
正在开始介质的恢复
存档日志线程 1 序列 18 已作为文件 D:\ORACLE\FLASH_RECOVERY_AREA\ORCL\ARCHIVELOG\
:s2qC9Goq02008_06_05\O1_MF_1_18_44H1Z3FW_.ARC 存在于磁盘上ITPUB个人空间4UE2f;C _
存档日志线程 1 序列 19 已作为文件 D:\ORACLE\FLASH_RECOVERY_AREA\ORCL\ARCHIVELOG\
S
LB"I"@02008_06_05\O1_MF_1_19_44H1Z26L_.ARC 存在于磁盘上ITPUB个人空间']O9^~?A
存档日志线程 1 序列 20 已作为文件 D:\ORACLE\FLASH_RECOVERY_AREA\ORCL\ARCHIVELOG\
.e f
u1u#j^ ~02008_06_05\O1_MF_1_20_44H1Z2PO_.ARC 存在于磁盘上
8ZMW1Y4X)uY-O'H _f0存档日志线程 1 序列 1 已作为文件 D:\ORACLE\FLASH_RECOVERY_AREA\ORCL\ARCHIVELOG\2ITPUB个人空间,m K O0U
` yk
008_06_05\O1_MF_1_1_44H263WN_.ARC 存在于磁盘上ITPUB个人空间0}F0J QO
存档日志线程 1 序列 2 已作为文件 D:\ORACLE\FLASH_RECOVERY_AREA\ORCL\ARCHIVELOG\2ITPUB个人空间
a%m$D R0E5t&E I Ye
008_06_05\O1_MF_1_2_44H2FD3T_.ARC 存在于磁盘上ITPUB个人空间;q;n UF;|#c6W
存档日志线程 1 序列 1 已作为文件 D:\ORACLE\ORADATA\ORCL\REDO01.LOG 存在于磁盘上
Yn;Ru6TA0通道 ORA_DISK_1: 正在启动到默认目标的存档日志恢复
7spd$[ ?5J9G9P1l4A0通道 ORA_DISK_1: 正在恢复存档日志ITPUB个人空间 m k
})Y8G+_-D
存档日志线程 =1 序列=16
B6X&u M5}(Bg0通道 ORA_DISK_1: 正在恢复存档日志
~ ?~ | ? l C6a0存档日志线程 =1 序列=17ITPUB个人空间B`|USw OB9K'l
通道 ORA_DISK_1: 正在读取备份段 D:\ORACLE\FLASH_RECOVERY_AREA\ORCL\BACKUPSET\200ITPUB个人空间.DG7N&].? r)yJ
8_06_05\O1_MF_ANNNN_TAG20080605T142217_44H1JTVV_.BKP
n~*rwq s+{h K0通道 ORA_DISK_1: 已恢复备份段 1
O ^{@7p5b+bq0段句柄 = D:\ORACLE\FLASH_RECOVERY_AREA\ORCL\BACKUPSET\2008_06_05\O1_MF_ANNNN_TAG
-~Qh+dG020080605T142217_44H1JTVV_.BKP 标记 = TAG20080605T142217
b-{6R"[:^-]0通道 ORA_DISK_1: 恢复完成, 用时: 00:00:02ITPUB个人空间*h YS0yV%Rag7u
存档日志文件名 =D:\ORACLE\FLASH_RECOVERY_AREA\ORCL\ARCHIVELOG\2008_06_05\O1_MF_1ITPUB个人空间+u0bU:O2WX W
_16_44HB9609_.ARC 线程 =1 序列 =16
#@H%_DY-lq1_Jp0通道 default: 正在删除存档日志ITPUB个人空间L'V,SZ@.V&^!F
存档日志文件名 =D:\ORACLE\FLASH_RECOVERY_AREA\ORCL\ARCHIVELOG\2008_06_05\O1_MF_1
!};LK!|f [c8H(k0_16_44HB9609_.ARC 记录 ID=16 时间戳 =656614310ITPUB个人空间7X3N$W M H7~&\8gaw$}
存档日志文件名 =D:\ORACLE\FLASH_RECOVERY_AREA\ORCL\ARCHIVELOG\2008_06_05\O1_MF_1ITPUB个人空间X!L?0bhP
_17_44HB9627_.ARC 线程 =1 序列 =17
?#~$[dmZ:mr0通道 default: 正在删除存档日志ITPUB个人空间%g(|,y7j4fEDt
存档日志文件名 =D:\ORACLE\FLASH_RECOVERY_AREA\ORCL\ARCHIVELOG\2008_06_05\O1_MF_1
r
FT`:N5p0_17_44HB9627_.ARC 记录 ID=15 时间戳 =656614310ITPUB个人空间 b W#ecm
存档日志文件名 =D:\ORACLE\FLASH_RECOVERY_AREA\ORCL\ARCHIVELOG\2008_06_05\O1_MF_1
&uINwE6Vq0_18_44H1Z3FW_.ARC 线程 =1 序列 =18
VR d#O ed0存档日志文件名 =D:\ORACLE\FLASH_RECOVERY_AREA\ORCL\ARCHIVELOG\2008_06_05\O1_MF_1ITPUB个人空间 rj y LU.w
_19_44H1Z26L_.ARC 线程 =1 序列 =19
'iN
e
S$`Y ?6w)iX0存档日志文件名 =D:\ORACLE\FLASH_RECOVERY_AREA\ORCL\ARCHIVELOG\2008_06_05\O1_MF_1ITPUB个人空间`+WB^'f"s r
_20_44H1Z2PO_.ARC 线程 =1 序列 =20ITPUB个人空间+k(\h;k&u
Pk%Y
存档日志文件名 =D:\ORACLE\FLASH_RECOVERY_AREA\ORCL\ARCHIVELOG\2008_06_05\O1_MF_1ITPUB个人空间oA*{ p
~0~:}
P H
_1_44H263WN_.ARC 线程 =1 序列 =1
NM d u7a
m0存档日志文件名 =D:\ORACLE\FLASH_RECOVERY_AREA\ORCL\ARCHIVELOG\2008_06_05\O1_MF_1
B&z(F7fgN0_2_44H2FD3T_.ARC 线程 =1 序列 =2
(qT9v!Qj0存档日志文件名 =D:\ORACLE\ORADATA\ORCL\REDO01.LOG 线程 =1 序列 =1
8|/G BK0aAyV:H0创建数据文件 fno = 6 名称 = D:\UNDO01.DBFITPUB个人空间8V/Sv_2QM*T9z"xwGq
存档日志文件名 =D:\ORACLE\ORADATA\ORCL\REDO01.LOG 线程 =1 序列 =1ITPUB个人空间 W2RI:e l c
介质恢复完成, 用时: 00:00:06ITPUB个人空间(y'x,[$K5t:j%s
完成 recover 于 05-6月 -08
RMAN> alter database open resetlogs;
数据库已打开
RMAN> exit
m]d{T'P PW0恢复管理器完成。
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个人空间-b ~q O;z
连接到:
&L Q)Md,V Iq\:X Z0Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
lU`$^|1d0With the Partitioning, OLAP and Data Mining options
SQL> select count(*) from test;
COUNT(*)
S3d:Yo7J azI0----------
*Y
aK0qgQ2C0 90056
SQL>ITPUB个人空间(cR;ce!v3v-S'g$I
resetlogs后新增的数据也增加上了 数据一致
导入论坛 引用链接 收藏 分享给好友 推荐到圈子 管理 举报
TAG:
标题搜索
日历
|
|||||||||
| 日 | 一 | 二 | 三 | 四 | 五 | 六 | |||
| 1 | 2 | 3 | 4 | 5 | 6 | ||||
| 7 | 8 | 9 | 10 | 11 | 12 | 13 | |||
| 14 | 15 | 16 | 17 | 18 | 19 | 20 | |||
| 21 | 22 | 23 | 24 | 25 | 26 | 27 | |||
| 28 | 29 | 30 | 31 | ||||||
我的存档
数据统计
- 访问量: 26110
- 日志数: 312
- 图片数: 2
- 建立时间: 2007-12-11
- 更新时间: 2008-11-28
