WEB开发网
开发学院数据库Oracle 实例讲解Oracle 9i数据坏块的处理 阅读

实例讲解Oracle 9i数据坏块的处理

 2009-03-18 13:10:40 来源:WEB开发网   
核心提示: 从以上查询中可以看出datafile 15有一次最近的全备份,有全备份以来的所有archivelog,实例讲解Oracle 9i数据坏块的处理(3),online redo log下面开始blockreocver,其实命令很简单RMAN>blockrecoverdatafile15b

从以上查询中可以看出datafile 15有一次最近的全备份,有全备份以来的所有archivelog,online redo log

下面开始blockreocver,其实命令很简单

RMAN> blockrecover datafile 15 block 18;

Starting blockrecover at 16-MAR-09
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=16 devtype=DISK


channel ORA_DISK_1: restoring block(s)
channel ORA_DISK_1: specifying block(s) to restore from backup set
restoring blocks of datafile 00015
channel ORA_DISK_1: restored block(s) from backup piece 1
piece handle=/d02/fullbackup/20090316_data_24_1 tag=TAG20090316T154352 params=NULL
channel ORA_DISK_1: block restore complete

starting media recovery

archive log thread 1 sequence 111 is already on disk as file /d02/arch/1_111.dbf
archive log thread 1 sequence 112 is already on disk as file /d02/arch/1_112.dbf
channel ORA_DISK_1: starting archive log restore to default destination
channel ORA_DISK_1: restoring archive log
archive log thread=1 sequence=109
channel ORA_DISK_1: restoring archive log
archive log thread=1 sequence=110
channel ORA_DISK_1: restored backup piece 1
piece handle=/d02/fullbackup/20090316_arch_28 tag=TAG20090316T154731 params=NULL
channel ORA_DISK_1: restore complete
media recovery complete
Finished blockrecover at 16-MAR-09

再SELECT一下表DPA_HISTORY

SQL> select * from dpa_history;

PRODLINEID BARCODE                        PA
---------- ------------------------------ --
7          S*33040-D8311050149512B        03
7          S*33040-D8311050143512B        03
7          S*33040-D8311050140512B        03
7          S*33040-D8311050144512B        03
7          S*33040-D8311050151512B        03
7          S*33040-D8311050262512B        03
7          S*33040-D8311050552512B        03
7          S*33040-D8311050345512B        03
7          S*33040-D8311050170512B        03

 

上一页  1 2 3 

Tags:实例 讲解 Oracle

编辑录入:爽爽 [复制链接] [打 印]
赞助商链接