oraclebbed 跳过归档恢复数据库.docx
- 文档编号:4332215
- 上传时间:2022-11-29
- 格式:DOCX
- 页数:28
- 大小:26.59KB
oraclebbed 跳过归档恢复数据库.docx
《oraclebbed 跳过归档恢复数据库.docx》由会员分享,可在线阅读,更多相关《oraclebbed 跳过归档恢复数据库.docx(28页珍藏版)》请在冰豆网上搜索。
oraclebbed跳过归档恢复数据库
SQL>select*fromv$version;
BANNER
----------------------------------------------------------------
OracleDatabase10gEnterpriseEditionRelease10.2.0.5.0-64bi
PL/SQLRelease10.2.0.5.0-Production
CORE10.2.0.5.0Production
TNSforLinux:
Version10.2.0.5.0-Production
NLSRTLVersion10.2.0.5.0–Production
SQL>createtablespacewillsondatafile'/u01/oracle/oradata/orcl/willson1.dbf'size50m;
altertablespacewillsonadddatafile'/u01/oracle/oradata/orcl/willson2.dbf'size50m;
altertablespacewillsonadddatafile'/u01/oracle/oradata/orcl/willson3.dbf'size50m;
Tablespacecreated.
SQL>
Tablespacealtered.
SQL>
Tablespacealtered.
selectHXFILFile_num,substr(HXFNM,1,40)File_name,FHSCNSCN,FHSTAstatus,FHRBA_SEQSequencefromX$KCVFH;
FILE_NUMFILE_NAMESCNSTATUSSEQUENCE
-------------------------------------------------------------------------------------------
1/u01/oracle/oradata/orcl/system01.dbf948761819657
2/u01/oracle/oradata/orcl/undotbs01.dbf948761457
3/u01/oracle/oradata/orcl/sysaux01.dbf948761457
4/u01/oracle/oradata/orcl/users01.dbf948761457
5/u01/oracle/oradata/orcl/willson1.dbf949022457
6/u01/oracle/oradata/orcl/willson2.dbf949052457
7/u01/oracle/oradata/orcl/willson3.dbf949078457
7rowsselected.
SQL>createuserwillsonidentifiedbywillsondefaulttablespacewillson;
Usercreated.
SQL>grantdbatowillson;
Grantsucceeded.
SQL>createtabletest(idnumber,namevarchar2(50));
Tablecreated.
SQL>begin
foriin1..500loop
insertintotestvalues(i,'willson');
commit;
endloop;
end;23456
7/
PL/SQLproceduresuccessfullycompleted.
SQL>
SQL>selectcount(*)fromtest;
COUNT(*)
----------
500
SQL>altersystemswitchlogfile;
Systemaltered.
SQL>/
Systemaltered.
SQL>/
Systemaltered.
SQL>/
Systemaltered.
SQL>/
Systemaltered.
SQL>/
Systemaltered.
[oracle@db1archive]$ls-l
total2420
-rw-r-----1oracleoinstall2041344Feb517:
051_57_769085431.dbf
-rw-r-----1oracleoinstall1024Feb517:
051_58_769085431.dbf
-rw-r-----1oracleoinstall4096Feb517:
051_59_769085431.dbf
-rw-r-----1oracleoinstall4096Feb517:
051_60_769085431.dbf
-rw-r-----1oracleoinstall1536Feb517:
051_61_769085431.dbf
-rw-r-----1oracleoinstall1024Feb517:
051_62_769085431.dbf
-rw-r-----1oracleoinstall384000Feb517:
091_63_769085431.dbf
-rw-r-----1oracleoinstall1024Feb517:
091_64_769085431.dbf
-rw-r-----1oracleoinstall2560Feb517:
091_65_769085431.dbf
-rw-r-----1oracleoinstall1024Feb517:
091_66_769085431.dbf
-rw-r-----1oracleoinstall1024Feb517:
091_67_769085431.dbf
-rw-r-----1oracleoinstall1024Feb517:
091_68_769085431.dbf
[oracle@db1lib]$cd/u01/oracle/product/10.2.0/db_1/rdbms/lib
[oracle@db1lib]$pwd
/u01/oracle/product/10.2.0/db_1/rdbms/lib
[oracle@db1lib]$make-fins_rdbms.mk$ORACLE_HOME/rdbms/lib/bbed
LinkingBBEDutility(bbed)
rm-f/u01/oracle/product/10.2.0/db_1/rdbms/lib/bbed
gcc-o/u01/oracle/product/10.2.0/db_1/rdbms/lib/bbed-L/u01/oracle/product/10.2.0/db_1/rdbms/lib/-L/u01/oracle/product/10.2.0/db_1/lib/-L/u01/oracle/product/10.2.0/db_1/lib/stubs//u01/oracle/product/10.2.0/db_1/lib/s0main.o/u01/oracle/product/10.2.0/db_1/rdbms/lib/ssbbded.o/u01/oracle/product/10.2.0/db_1/rdbms/lib/sbbdpt.o`cat/u01/oracle/product/10.2.0/db_1/lib/ldflags`-lnsslb10-lncrypt10-lnsgr10-lnzjs10-ln10-lnnz10-lnl10/u01/oracle/product/10.2.0/db_1/rdbms/lib/defopt.o-ldbtools10-lclntsh`cat/u01/oracle/product/10.2.0/db_1/lib/ldflags`-lnsslb10-lncrypt10-lnsgr10-lnzjs10-ln10-lnnz10-lnl10-lnro10`cat/u01/oracle/product/10.2.0/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/oracle/product/10.2.0/db_1/lib/ldflags`-lnsslb10-lncrypt10-lnsgr10-lnzjs10-ln10-lnnz10-lnl10-lnro10`cat/u01/oracle/product/10.2.0/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/oracle/product/10.2.0/db_1/lib/sysliblist`-Wl,-rpath,/u01/oracle/product/10.2.0/db_1/lib-lm`cat/u01/oracle/product/10.2.0/db_1/lib/sysliblist`-ldl-lm-L/u01/oracle/product/10.2.0/db_1/lib
[oracle@db1lib]$linkbbed$ORACLE_HOME/bin/bbed
[oracle@db1oracle]$catbbed.txt
blocksize=8192
listfile=file.par
mode=edit
[oracle@db1oracle]$catfile.par
1/u01/oracle/oradata/orcl/system01.dbf482344960
2/u01/oracle/oradata/orcl/undotbs01.dbf581959680
3/u01/oracle/oradata/orcl/sysaux01.dbf209715200
4/u01/oracle/oradata/orcl/users01.dbf5242880
5/u01/oracle/oradata/orcl/willson1.dbf52428800
6/u01/oracle/oradata/orcl/willson2.dbf52428800
7/u01/oracle/oradata/orcl/willson3.dbf52428800
SQL>/
FILE_NUMFILE_NAMESCNSTATUSSEQUENCE
-------------------------------------------------------------------------------------------
1/u01/oracle/oradata/orcl/system01.dbf950093819669
2/u01/oracle/oradata/orcl/undotbs01.dbf950093469
3/u01/oracle/oradata/orcl/sysaux01.dbf950093469
4/u01/oracle/oradata/orcl/users01.dbf950093469
5/u01/oracle/oradata/orcl/willson1.dbf950093469
6/u01/oracle/oradata/orcl/willson2.dbf950093469
7/u01/oracle/oradata/orcl/willson3.dbf950093469
SQL>altersystemswitchlogfile;
Systemaltered.
SQL>/
Systemaltered.
SQL>/
Systemaltered.
SQL>selectHXFILFile_num,substr(HXFNM,1,40)File_name,FHSCNSCN,FHSTAstatus,FHRBA_SEQSequencefromX$KCVFH;
FILE_NUMFILE_NAMESCNSTATUSSEQUENCE
-------------------------------------------------------------------------------------------
1/u01/oracle/oradata/orcl/system01.dbf950658819670
2/u01/oracle/oradata/orcl/undotbs01.dbf950658470
3/u01/oracle/oradata/orcl/sysaux01.dbf950658470
4/u01/oracle/oradata/orcl/users01.dbf950658470
5/u01/oracle/oradata/orcl/willson1.dbf950658470
6/u01/oracle/oradata/orcl/willson2.dbf950658470
7/u01/oracle/oradata/orcl/willson3.dbf950658470
7rowsselected.
SQL>archiveloglist
DatabaselogmodeArchiveMode
AutomaticarchivalEnabled
Archivedestination/u01/oracle/archive
Oldestonlinelogsequence70
Nextlogsequencetoarchive72
Currentlogsequence72
SQL>!
[oracle@db1oracle]$lsarchive/
1_57_769085431.dbf1_60_769085431.dbf1_63_769085431.dbf1_66_769085431.dbf1_69_769085431.dbf
1_58_769085431.dbf1_61_769085431.dbf1_64_769085431.dbf1_67_769085431.dbf1_70_769085431.dbf
1_59_769085431.dbf1_62_769085431.dbf1_65_769085431.dbf1_68_769085431.dbf1_71_769085431.dbf
[oracle@db1oracle]$
SQL>alterdatabasedatafile5offline;
Databasealtered.
SQL>altersystemswitchlogfile;
Systemaltered.
SQL>selectHXFILFile_num,substr(HXFNM,1,40)File_name,FHSCNSCN,FHSTAstatus,FHRBA_SEQSequencefromX$KCVFH;
FILE_NUMFILE_NAMESCNSTATUSSEQUENCE
-------------------------------------------------------------------------------------------
1/u01/oracle/oradata/orcl/system01.dbf950660819671
2/u01/oracle/oradata/orcl/undotbs01.dbf950660471
3/u01/oracle/oradata/orcl/sysaux01.dbf950660471
4/u01/oracle/oradata/orcl/users01.dbf950660471
5/u01/oracle/oradata/orcl/willson1.dbf950658470
6/u01/oracle/oradata/orcl/willson2.dbf950660471
7/u01/oracle/oradata/orcl/willson3.dbf950660471
7rowsselected.
SQL>archiveloglist
DatabaselogmodeArchiveMode
AutomaticarchivalEnabled
Archivedestination/u01/oracle/archive
Oldestonlinelogsequence71
Nextlogsequencetoarchive73
Currentlogsequence73
SQL>
SQL>selectfile#,ONLINE_STATUS,ERROR,CHANGE#fromV$RECOVER_FILEorderby1;
FILE#ONLINE_ERRORCHANGE#
--------------------------------------------------------------------------------------------
5OFFLINE950658
SQL>selectname,checkpoint_change#fromv$datafile;
NAMECHECKPOINT_CHANGE#
---------------------------------------------------------------
/u01/oracle/oradata/orcl/system01.dbf950660
/u01/oracle/oradata/orcl/undotbs01.dbf950660
/u01/oracle/oradata/orcl/sysaux01.dbf950660
/u01/oracle/oradata/orcl/users01.dbf950660
/u01/oracle/oradata/orcl/willson1.dbf950658
/u01/oracle/oradata/orcl/willson2.dbf950660
/u01/oracle/oradata/orcl/willson3.dbf950660
7rowsselected.
[oracle@db1oracle]$bbedparfile=bbed.txt
Password:
BBED:
Release2.0.0.0.0-LimitedProductiononSunFeb517:
21:
222012
Copyright(c)1982,2007,Oracle.Allrightsreserved.
*************!
!
!
ForOracleInternalUseonly!
!
!
***************
BBED>setfile6
FILE#6
BBED>map/v
File:
/u01/oracle/oradata/orcl/willson2.dbf(6)
Block:
1Dba:
0x01800001
------------------------------------------------------------
DataFileHeader
structkcvfh,676bytes@0
structkcvfhbfh,20bytes@0
structkcvfhhdr,76bytes@20
ub4kcvfhrdb@96
structkcvfhcrs,8bytes@100
ub4kcvfhcrt@108
ub4kcvfhrlc@112
structkcvfhrls,8bytes@116
ub4kcvfhbti@124
structkcvfhbsc,8bytes@128
ub2kcvfhbth@136
ub2kcvfhsta@138
structkcvfhckp,36bytes@484
ub4kcvfhcpc@140
ub4kcvfhrts@144
ub4kcvfhccc@148
structkcvfhbcp,36bytes@152
ub4kcvfhbhz@312
structkcvfhxcd,16bytes@316
wordkcvfhtsn@332
ub2kcvfhtln@336
textkcvfhtnm[30]
- 配套讲稿:
如PPT文件的首页显示word图标,表示该PPT已包含配套word讲稿。双击word图标可打开word文档。
- 特殊限制:
部分文档作品中含有的国旗、国徽等图片,仅作为作品整体效果示例展示,禁止商用。设计者仅对作品中独创性部分享有著作权。
- 关 键 词:
- oracle bbed 跳过归档恢复数据库 跳过 归档 恢复 数据库