处理数据损坏.docx
- 文档编号:28494638
- 上传时间:2023-07-15
- 格式:DOCX
- 页数:16
- 大小:39.70KB
处理数据损坏.docx
《处理数据损坏.docx》由会员分享,可在线阅读,更多相关《处理数据损坏.docx(16页珍藏版)》请在冰豆网上搜索。
处理数据损坏
处理数据损坏
一、关于bbed
bbed用于检测坏块和处理坏块。
BBED(OracleBlockBrowerandEDitorTool),用来直接查看和修改数据文件数据的一个工具,是Oracle一款内部工具,可以直接修改Oracle数据文件块的内容,在一些极端恢复场景下比较有用。
该工具不受Oracle支持,所以默认是没有生成可执行文件的,在使用前需要重新连接。
二、编译bbed
1、进入lib目录
[oracle@zdk~]$cd$ORACLE_HOME
[oracle@zdkdb_1]$cdrdbms/lib/
[oracle@zdklib]$pwd
/u01/app/oracle/product/10.2.0.1/db_1/rdbms/lib
2、激活bbed
[oracle@zdklib]$make-fins_rdbms.mk
/u01/app/oracle/product/10.2.0.1/db_1/rdbms/lib/bbed
LinkingBBEDutility(bbed)
rm-f/u01/app/oracle/product/10.2.0.1/db_1/rdbms/lib/bbed
gcc-o/u01/app/oracle/product/10.2.0.1/db_1/rdbms/lib/bbed-L/u01/app/oracle/product/10.2.0.1/db_1/rdbms/lib/-L/u01/app/oracle/product/10.2.0.1/db_1/lib/-L/u01/app/oracle/product/10.2.0.1/db_1/lib/stubs/-L/usr/lib-lirc
/u01/app/oracle/product/10.2.0.1/db_1/lib/s0main.o/u01/app/oracle/product/10.2.0.1/db_1/rdbms/lib/ssbbded.o/u01/app/oracle/product/10.2.0.1/db_1/rdbms/lib/sbbdpt.o`cat
/u01/app/oracle/product/10.2.0.1/db_1/lib/ldflags`-lnsslb10-lncrypt10-lnsgr10-lnzjs10-ln10-lnnz10-lnl10
/u01/app/oracle/product/10.2.0.1/db_1/rdbms/lib/defopt.o-ldbtools10-lclntsh`cat
/u01/app/oracle/product/10.2.0.1/db_1/lib/ldflags`-lnsslb10-lncrypt10-lnsgr10-lnzjs10-ln10-lnnz10-lnl10-lnro10`cat
/u01/app/oracle/product/10.2.0.1/db_1/lib/ldflags`-lnsslb10-lncrypt10-lnsgr10-lnzjs10-ln10-lnnz10-lnl10-lclient10-lnnetd10-lvsn10-lcommon10-lgeneric10-lmm-lsnls10-lnls10-lcore10-lsnls10-lnls10-lcore10-lsnls10-lnls10-lxml10-lcore10-lunls10-lsnls10-lnls10-lcore10-lnls10`cat
/u01/app/oracle/product/10.2.0.1/db_1/lib/ldflags`-lnsslb10-lncrypt10-lnsgr10
-lnzjs10-ln10-lnnz10-lnl10-lnro10`cat
/u01/app/oracle/product/10.2.0.1/db_1/lib/ldflags`-lnsslb10-lncrypt10-lnsgr10-lnzjs10-ln10-lnnz10-lnl10-lclient10-lnnetd10-lvsn10-lcommon10-lgeneric10-lsnls10-lnls10-lcore10-lsnls10-lnls10-lcore10-lsnls10-lnls10-lxml10-lcore10-lunls10-lsnls10-lnls10-lcore10-lnls10-lclient10-lnnetd10-lvsn10-lcommon10-lgeneric10-lsnls10-lnls10-lcore10-lsnls10-lnls10-lcore10-lsnls10-lnls10-lxml10-lcore10-lunls10-lsnls10-lnls10-lcore10-lnls10`cat
/u01/app/oracle/product/10.2.0.1/db_1/lib/sysliblist`-Wl,-rpath,/u01/app/oracle/product/10.2.0.1/db_1/lib-lm`cat
/u01/app/oracle/product/10.2.0.1/db_1/lib/sysliblist`-ldl-lm
-L/u01/app/oracle/product/10.2.0.1/db_1/lib
3、查看bbed是否建立完成
[oracle@zdklib]$llbbed
-rwxr-xr-x1oracleoinstall536161Aug2914:
09bbed
4、对bbed进行软连接
[oracle@zdklib]$ln-s/u01/app/oracle/product/10.2.0.1/db_1/rdbms/lib/bbed
/u01/app/oracle/product/10.2.0.1/db_1/bin/bbed
5、查看bin目录下软连接是否成功
[oracle@zdkbin]$llbbed
Lrwxrwxrwx1oracleoinstall52Aug2914:
37bbed->
/u01/app/oracle/product/10.2.0.1/db_1/rdbms/lib/bbed
6、获取datafile信息
SQL>selectfile#||''||name||''||bytesfromv$datafile;
1/u01/app/oracle/oradata/zdk/system01.dbf503316480
2/u01/app/oracle/oradata/zdk/undotbs01.dbf26214400
3/u01/app/oracle/oradata/zdk/sysaux01.dbf251658240
4/u01/app/oracle/oradata/zdk/users01.dbf5242880
7、编辑文件
[oracle@zdkbbed]$vifileunix.log
1/u01/app/oracle/oradata/zdk/system01.dbf503316480
2/u01/app/oracle/oradata/zdk/undotbs01.dbf26214400
3/u01/app/oracle/oradata/zdk/sysaux01.dbf251658240
4/u01/app/oracle/oradata/zdk/users01.dbf5242880
8、编辑控制文件
[oracle@zdkbbed]$vibbed.par
blocksize=8192
listfile=/home/oracle/bbed/fileunix.log
mode=edit
9、通过控制文件启动bbed
[oracle@zdkbbed]$bbedparfile=bbed.par
Password:
(默认密码blockedit)
BBED:
Release2.0.0.0.0-LimitedProductiononWedAug2915:
43:
072012
Copyright(c)1982,2005,Oracle.Allrightsreserved.
*************!
!
!
ForOracleInternalUseonly!
!
!
***************
BBED>
10、sys用户进入数据库
[oracle@zdk007tablescript]$exportORACLE_SID=zdk
[oracle@zdk007tablescript]$sqlplus/assysdba
SQL*Plus:
Release10.2.0.1.0-ProductiononThuAug3016:
41:
582012
Copyright(c)1982,2005,Oracle.Allrightsreserved.
Connectedto:
OracleDatabase10gEnterpriseEditionRelease10.2.0.1.0-Production
WiththePartitioning,OLAPandDataMiningoptions
11、查departments表的文件号和块号
SQL>selectfile_id,block_idfromdba_extentswhere
segment_name='DEPARTMENTS';
FILE_IDBLOCK_ID
--------------------
473
12、查询FILE_ID相关的文件名
SQL>selectfile_namefromdba_data_fileswherefile_id=4;
FILE_NAME
--------------------------------------------------------------------------------
/u01/app/oracle/oradata/zdk/users01.dbf
三、RAM备份
1、检查是否属于归档状态
SQL>archiveloglist;
DatabaselogmodeNoArchiveMode
AutomaticarchivalDisabled(非归档)
Archivedestination/u01/app/oracle/product/10.2.0.1/db_1/dbs/arch
Oldestonlinelogsequence2
Currentlogsequence4
2、关闭库
SQL>shutimmediate
Databaseclosed.
Databasedismounted.
ORACLEinstanceshutdown.
3、开启到MOUNT状态
SQL>startupmount
ORACLEinstancestarted.
TotalSystemGlobalArea285212672bytes
FixedSize1218992bytes
VariableSize96470608bytes
DatabaseBuffers184549376bytes
RedoBuffers2973696bytes
Databasemounted.
4、更改归档状态
SQL>alterdatabasearchivelog;
Databasealtered.
5、启动到OPEN状态
SQL>alterdatabaseopen;
Databasealtered.
6、进入RAM进行全备
[oracle@zdk007tablescript]$rmantarget/
RecoveryManager:
Release10.2.0.1.0-ProductiononSunSep215:
08:
592012
Copyright(c)1982,2005,Oracle.Allrightsreserved.
connectedtotargetdatabase:
ZDK(DBID=3126852472)
RMAN>backupdatabaseplusarchivelogdeleteallinput;
Startingbackupat02-SEP-12
currentlogarchived
usingtargetdatabasecontrolfileinsteadofrecoverycatalog
allocatedchannel:
ORA_DISK_1
channelORA_DISK_1:
sid=133devtype=DISK
channelORA_DISK_1:
startingarchivelogbackupset
channelORA_DISK_1:
specifyingarchivelog(s)inbackupset
inputarchivelogthread=1sequence=3recid=1stamp=792947407
channelORA_DISK_1:
startingpiece1at02-SEP-12
channelORA_DISK_1:
finishedpiece1at02-SEP-12
Piecehandle=/u01/app/oracle/product/10.2.0.1/db_1/dbs/01nk6qmg_1_1
tag=TAG20120902T151008comment=NONE
channelORA_DISK_1:
backupsetcomplete,elapsedtime:
00:
00:
06
channelORA_DISK_1:
deletingarchivelog(s)
archivelogfilename=/u01/app/oracle/product/10.2.0.1/db_1/dbs/arch1_3_792437563.dbfrecid=1stamp=792947407
Finishedbackupat02-SEP-12
Startingbackupat02-SEP-12
usingchannelORA_DISK_1
channelORA_DISK_1:
startingfulldatafilebackupset
channelORA_DISK_1:
specifyingdatafile(s)inbackupset
inputdatafilefno=00001name=/u01/app/oracle/oradata/zdk/system01.dbf
inputdatafilefno=00003name=/u01/app/oracle/oradata/zdk/sysaux01.dbf
inputdatafilefno=00002name=/u01/app/oracle/oradata/zdk/undotbs01.dbf
inputdatafilefno=00004name=/u01/app/oracle/oradata/zdk/users01.dbf
channelORA_DISK_1:
startingpiece1at02-SEP-12
channelORA_DISK_1:
finishedpiece1at02-SEP-12
Piecehandle=/u01/app/oracle/product/10.2.0.1/db_1/dbs/02nk6qmm_1_1
tag=TAG20120902T151014comment=NONE
channelORA_DISK_1:
backupsetcomplete,elapsedtime:
00:
00:
56
channelORA_DISK_1:
startingfulldatafilebackupset
channelORA_DISK_1:
specifyingdatafile(s)inbackupset
includingcurrentcontrolfileinbackupset
includingcurrentSPFILEinbackupset
channelORA_DISK_1:
startingpiece1at02-SEP-12
channelORA_DISK_1:
finishedpiece1at02-SEP-12
piecehandle=/u01/app/oracle/product/10.2.0.1/db_1/dbs/03nk6qoe_1_1
tag=TAG20120902T151014comment=NONE
channelORA_DISK_1:
backupsetcomplete,elapsedtime:
00:
00:
03
Finishedbackupat02-SEP-12
Startingbackupat02-SEP-12
currentlogarchived
usingchannelORA_DISK_1
channelORA_DISK_1:
startingarchivelogbackupset
channelORA_DISK_1:
specifyingarchivelog(s)inbackupset
inputarchivelogthread=1sequence=4recid=2stamp=792947474
channelORA_DISK_1:
startingpiece1at02-SEP-12
channelORA_DISK_1:
finishedpiece1at02-SEP-12
piecehandle=/u01/app/oracle/product/10.2.0.1/db_1/dbs/04nk6qoi_1_1
tag=TAG20120902T151114comment=NONE
channelORA_DISK_1:
backupsetcomplete,elapsedtime:
00:
00:
02
channelORA_DISK_1:
deletingarchivelog(s)
archivelogfilename=/u01/app/oracle/product/10.2.0.1/db_1/dbs/arch1_4_792437563.dbfrecid=2stamp=792947474
Finishedbackupat02-SEP-12
四、坏块模拟
1、制造块损坏
[oracle@zdklabs]$./lab_07_02.sh/u01/app/oracle/oradata/zdk/users01.dbf738192
bash:
./lab_07_02.sh:
Permissiondenied
原因:
因为labs没有执行权限
2、赋予labs权限
[oracle@zdk~]$chmod-R777labs
[oracle@zdk~]$lllabs/
total300
-rwxrwxrwx1oracleoinstall976Sep152008init_sgalab.ora
-rwxrwxrwx1oracleoinstall578Sep152008lab_02_06.sql
-rwxrwxrwx1oracleoinstall515Sep152008lab_02_copy.sh
-rwxrwxrwx1oracleoinstall258Sep152008lab_04_02.sh
-rwxrwxrwx1oracleoinstall472Sep152008lab_04_05_a.sql
-rwxrwxrwx1oracleoinstall311Sep152008lab_04_05_b.sh
-rwxrwxrwx1oracleoinstall346Sep152008lab_04_05_c.sql
-rwxrwxrwx1oracleoinstall743Sep152008lab_05_01.sql
-rwxrwxrwx1oracleoinstall220Sep152008lab_06_04.sql
-rwxrwxrwx1oracleoinstall697Aug3017:
08lab_07_02.sh
-rwxrwxrwx1oracleoinstall923Sep152008lab_08_02.sql
-rwxrwxrwx1oracleoinstall911Sep152008lab_08_04.sql
-rwxrwxrwx1oracleoinstall463Sep152008lab_08_drop_javas.sql
-rwxrwxrwx1oracleoinstall577Sep152008lab_09_01.sql
-rwxrwxrwx1oracleoinstall519Sep152008lab_09_02.sql
-rwxrwxrwx1oracleoinstall639Sep152008lab_09_03.sh
-rwxrwxrwx1oracleoinstall388Sep152008lab_09_05.sql
-rwxrwxrwx1oracleoinstall483Sep152008lab_09_08.sql
-rwxrwxrwx1oracleoinstall390Sep152008lab_09_11.sql
-rwxrwxrwx1oracleoinstall352Sep152008lab_09_cleanup.sql
-rwxrwxrwx1oracleoinstall631Sep152008lab_10_01.sh
-rwxrwxrwx1oracleoinstall2306Sep152008lab_10_02.sh
-rwxrwxrwx1oracleoinstall427Sep152008lab_10_05.sh
-rwxrwxrwx1oracleoinstall469Sep152008lab_11_01.sh
-rwxrwxrwx1o
- 配套讲稿:
如PPT文件的首页显示word图标,表示该PPT已包含配套word讲稿。双击word图标可打开word文档。
- 特殊限制:
部分文档作品中含有的国旗、国徽等图片,仅作为作品整体效果示例展示,禁止商用。设计者仅对作品中独创性部分享有著作权。
- 关 键 词:
- 处理 数据 损坏