学习oracle技术,每天学一点,每天进步一点

oracle 10g R2 恢复完数据库后自动添加临时表空间数据文件

上一篇 / 下一篇  2008-05-07 12:01:55 / 个人分类:oracle 10g 新技术

我们知道在Oracle10gR2以前的版本中,如果使用RMAN恢复数据库,临时表空间的临时文件是不会自动恢复的。
+[soaT:G0我们在恢复完成之后有时忘记添加临时文件,这样导致在应用中出错时才能发现。

通过rman 恢复在alert日志中可以发现以下痕迹

Wed May 07 11:57:59 2008
!ElB'oM$vm0ARC2: Archival started
+sK.e.fZ0ARC0: STARTING ARCH PROCESSES COMPLETE
8nr ?$y+r/{0ARC0: Becoming the heartbeat ARCHITPUB个人空间 G%ix'q:b8M,|}
ARC2 started with pid=18, OS id=3652ITPUB个人空间J%tL Q.s5SQy u
Wed May 07 11:57:59 2008ITPUB个人空间)?P~;JmE|:^
SMON: enabling cache recovery
v"iPK)U0Wed May 07 11:58:00 2008
q6cYWr8Y*h,d0Successfully onlined Undo Tablespace 1.
_e4s){9JohzFu0Wed May 07 11:58:00 2008
t3| [9LRY ^0SMON: enabling tx recoveryITPUB个人空间` x1}0R'UB4U q;?g
Wed May 07 11:58:00 2008
GHvQIz0Re-creating tempfile D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\DATAFILE\O1_MF_TEMP_4221RHM1_.TMP as D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\DATAFILE\O1_MF_TEMP_422B68PG_.TMP
;t-{ q1R ^SsL-GJ&p0Database Characterset is ZHS16GBKITPUB个人空间t7t|+az5O.~/oa
replication_dependency_tracking turned off (no async multimaster replication found)
t8ZP v t)F0Starting background process QMNCITPUB个人空间(t%g/_"e$b
QMNC started with pid=19, OS id=1644ITPUB个人空间c&C~6ix0N2m!`
Wed May 07 11:58:06 2008
(D;D9e2suU0_0Completed: alter database open
SSX#{E8v9C0Wed May 07 11:58:08 2008ITPUB个人空间f-l^Z[P8@1E u
db_recovery_file_dest_size of 2048 MB is 7.69% used. This is a
3P7K3I,TC7l1IU0user-specified limit on the amount of space that will be used by thisITPUB个人空间#ur.p@ y+V*J/G
database for recovery-related files, and does not reflect the amount of
-I8a4I&D?n {0space available in the underlying filesystem or ASM diskgroup.
!C0yTfM!G[0


TAG:

 

评分:0

我来说两句

显示全部

:loveliness: :handshake :victory: :funk: :time: :kiss: :call: :hug: :lol :'( :Q :L ;P :$ :P :o :@ :D :( :)

日历

« 2008-12-02  
 123456
78910111213
14151617181920
21222324252627
28293031   

数据统计

  • 访问量: 26110
  • 日志数: 312
  • 图片数: 2
  • 建立时间: 2007-12-11
  • 更新时间: 2008-11-28

RSS订阅

Open Toolbar