一次通过bbed工具恢复ORACLE EBS 数据库的过程

最新推荐文章于 2024-04-18 19:57:46 发布
最新推荐文章于 2024-04-18 19:57:46 发布
阅读量719 收藏
点赞数
分类专栏： oracle oracle ebs 文章标签： ebs oracle
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/crpp0902/article/details/78750112
版权

安装BBED工具：

11G默认不带BBED工具，需要使用10G下的几个BBED文件进行编译（同位数同操作系统类型）

ssbbded.o

sbbdpt.o

ssbbded.o

上传三个文件到11G的$ORACLE_HOME/rdbms/lib下

11G:

cd $ORACLE_HOME/rdbms/lib

make -f ins_rdbms.mk$ORACLE_HOME/rdbms/lib/bbed

编译不报错就安装完成了


数据文件头信息：

下面两项与resetlogs相关

kcvfhrlc表示 reset logscount

kcvfhrls表示 resetlogsscn

下面四项与数据库文件scn相关

kscnbas (at offset 140) – SCN of last change to thedatafile.

kcvcptim (at offset 148) - Time of the last change to thedatafile.

kcvfhcpc (at offset 176) – Checkpoint count.

kcvfhccc (at offset 184) – Unknown, but is always 1 lessthan thecheckpoint point count.


克隆完，发现数据库里cux、spm、zs三个表空间对应的三个数据文件为offline状态，而且克隆过程中由于自动调用adcrdb.sh脚本，会重建了控制文件（自动生成的控制文件不包括这三个自定义的数据文件）及open resetlogs，导致三个文件不能recover 及online, 会出现ORA-01190或者ORA-01189之类的错误,我们通过BBED工具修改相关的数据文件头信息里的scn来达到数据文件一致来OPEN数据库.。

通过BBED修改问题数据文件头，使其SCN跟正常文件一致：

首先查看system01.dbf文件头

BBED> set filename'/u01/oracle/db/apps_st/data/system01.dbf'

       FILENAME       /u01/oracle/db/apps_st/data/system01.dbf

BBED> p kcvfhrlc

ub4 kcvfhrlc                                @112      0x39577b35

BBED> p kcvfhrls

struct kcvfhrls, 8 bytes                    @116    

  ub4 kscnbas                             @116      0xdf75ea78

  ub2 kscnwrp                             @120      0x056c

BBED> p kcvfhckp 

struct kcvfhckp, 36 bytes                   @484    

  struct kcvcpscn, 8 bytes                @484    

     ub4 kscnbas                          @484      0xdf7828f7

     ub2 kscnwrp                          @488      0x056c

  ub4 kcvcptim                            @492      0x3958cfe1

  ub2 kcvcpthr                            @496      0x0001

  union u, 12 bytes                       @500    

     struct kcvcprba, 12 bytes            @500    

        ub4 kcrbaseq                      @500      0x00000004

        ub4 kcrbabno                      @504      0x000402df

        ub2 kcrbabof                      @508      0x0010

  ub1 kcvcpetb[0]                         @512      0x02

  ub1 kcvcpetb[1]                         @513      0x00

  ub1 kcvcpetb[2]                         @514      0x00

  ub1 kcvcpetb[3]                         @515      0x00

  ub1 kcvcpetb[4]                         @516      0x00

  ub1 kcvcpetb[5]                         @517      0x00

  ub1 kcvcpetb[6]                          @518      0x00

  ub1 kcvcpetb[7]                         @519      0x00

 

BBED> p kcvfhcpc

ub4 kcvfhcpc                                @140      0x00005bf6

 

BBED> p kcvfhccc

ub4 kcvfhccc                                @148      0x00005bf5

修改问题数据文件zs01.dbf，使其SCN跟system01.dbf一致：

BBED> set filename'/u01/oracle/db/apps_st/data/zs01.dbf'

       FILENAME       /u01/oracle/db/apps_st/data/zs01.dbf

修改kcvfhrlc:

BBED> p kcvfhrlc

ub4 kcvfhrlc                                @112      0x33808d1a

注：修改之前一定要先p一下，不然不能定位到该offset.

BBED> m /x 357b5739

BBED-00215: editing not allowed in BROWSEmode

BBED> set mode edit

       MODE            Edit

BBED> m /x 357b5739

 File: /u01/oracle/db/apps_st/data/zs01.dbf (0)

 Block: 1                Offsets:  112 to 623           Dba:0x00000000

------------------------------------------------------------------------

 357b5739 a39432dd 6c050000 00000000 00000000 00000000 00000400 23000000

 54a42739 22000000 00000000 0000000000000000 00000000 00000000 00000000

 0000000000000000 00000000 00000000 00000000 00000000 00000000 00000000

 00000000 00000000 00000000 00000000 0000000000000000 00000000 00000000

 00000000 00000000 00000000 00000000 0000000000000000 00000000 00000000

 00000000 00000000 00000000 00000000 0000000000000000 00000000 00000000

 00000000 00000000 00000000 00000000 0000000000000000 00000000 8d010000

 02005a53 00000000 00000000 0000000000000000 00000000 00000000 00000000

 16000000 00000000 00000000 00000000 0000000000000000 00000000 00000000

 00000000 00000000 00000000 00000000 2a8c80334d7632dd 6c050000 00000000

 00000000 00000000 00000000 00000000 0000000000000000 00000000 00000000

 00000000 00000000 00000000 00000000 00000000 a48171df 6c050000 c52f5639

 01000322 56000000 02000000 10000000 0200000000000000 00000000 00000000

 00000000 00000000 00000000 00000000 0000000000000000 00000000 00000000

 00000000 00000000 00000000 00000000 0000000000000000 00000000 00000000

 00000000 00000000 00000000 00000000 0000000000000000 00000000 00000000

 <32 bytes per line>

然后再查，发现112这个偏移量的值已经修改成跟system01.dbf一致了

BBED> p kcvfhrlc

ub4 kcvfhrlc                                @112      0x39577b35

修改kcvfhrls:

BBED> p kcvfhrls

struct kcvfhrls, 8 bytes                    @116    

  ub4 kscnbas                             @116      0xdd3294a3

  ub2 kscnwrp                             @120      0x056c

BBED> m /x 78ea75df

 File: /u01/oracle/db/apps_st/data/zs01.dbf (0)

 Block: 1                Offsets:  116 to 627           Dba:0x00000000

------------------------------------------------------------------------

 78ea75df 6c05000000000000 00000000 00000000 00000400 23000000 54a42739

 22000000 00000000 00000000 00000000 0000000000000000 00000000 00000000

 00000000 00000000 00000000 00000000 0000000000000000 00000000 00000000

 0000000000000000 00000000 00000000 00000000 00000000 00000000 00000000

 00000000 00000000 00000000 00000000 0000000000000000 00000000 00000000

 00000000 00000000 00000000 00000000 0000000000000000 00000000 00000000

 00000000 00000000 00000000 00000000 0000000000000000 8d010000 02005a53

 00000000 00000000 00000000 00000000 0000000000000000 00000000 16000000

 00000000 00000000 00000000 00000000 0000000000000000 00000000 00000000

 00000000 00000000 00000000 2a8c80334d7632dd 6c050000 00000000 00000000

 00000000 00000000 00000000 00000000 0000000000000000 00000000 00000000

 00000000 00000000 00000000 00000000 a48171df 6c050000 c52f563901000322

 56000000 02000000 10000000 02000000 0000000000000000 00000000 00000000

 00000000 00000000 00000000 00000000 0000000000000000 00000000 00000000

 00000000 00000000 00000000 00000000 0000000000000000 00000000 00000000

 00000000 00000000 00000000 00000000 0000000000000000 00000000 00000000

 <32 bytes per line>

BBED> p kcvfhrls

struct kcvfhrls, 8 bytes                    @116    

  ub4 kscnbas                             @116      0xdf75ea78

  ub2 kscnwrp                             @120      0x056c

保存：

BBED> sum

Check value for File 0, Block 1:

current = 0xd152, required = 0x5136

BBED> sum apply

Check value for File 0, Block 1:

current = 0x5136, required = 0x5136

修改kcvfhcpc：

BBED> p kcvfhcpc

ub4 kcvfhcpc                                @140      0x00000023

BBED> m /x f65b0000

BBED-00209: invalid number (f65b0000)

这个错误是这4个偏移量位置不接受这个值，我们只能2个偏移量一次次修改

BBED> m /x f65b

 File: /u01/oracle/db/apps_st/data/zs01.dbf (0)

 Block: 1                Offsets:  140 to 651           Dba:0x00000000

------------------------------------------------------------------------

 f65b0000 54a4273922000000 00000000 00000000 00000000 00000000 00000000

 00000000 00000000 00000000 00000000 0000000000000000 00000000 00000000

 00000000 00000000 00000000 00000000 0000000000000000 00000000 00000000

 00000000 00000000 00000000 00000000 0000000000000000 00000000 00000000

 00000000 00000000 00000000 00000000 0000000000000000 00000000 00000000

 00000000 00000000 00000000 00000000 0000000000000000 00000000 00000000

 8d010000 02005a5300000000 00000000 00000000 00000000 00000000 00000000

 00000000 16000000 00000000 00000000 0000000000000000 00000000 00000000

 00000000 00000000 00000000 00000000 00000000 2a8c80334d7632dd 6c050000

 00000000 00000000 00000000 00000000 0000000000000000 00000000 00000000

 00000000 00000000 00000000 00000000 00000000 00000000 a48171df 6c050000

 c52f5639 01000322 56000000 0200000010000000 02000000 00000000 00000000

 00000000 00000000 00000000 00000000 0000000000000000 00000000 00000000

 00000000 00000000 00000000 00000000 0000000000000000 00000000 00000000

 00000000 00000000 00000000 00000000 0000000000000000 00000000 00000000

 00000000 00000000 00000000 00000000 0000000000000000 0d000d00 0d000100

 <32 bytes per line>

BBED> set offset+2

       OFFSET          142

* 偏移量+2（140+2=142）

BBED> m /x 0000

 File: /u01/oracle/db/apps_st/data/zs01.dbf (0)

 Block: 1                Offsets:  142 to 653           Dba:0x00000000

------------------------------------------------------------------------

 000054a4 27392200 00000000 0000000000000000 00000000 00000000 00000000

 00000000 00000000 00000000 00000000 0000000000000000 00000000 00000000

 00000000 00000000 00000000 00000000 0000000000000000 00000000 00000000

 00000000 00000000 00000000 00000000 0000000000000000 00000000 00000000

 00000000 00000000 00000000 00000000 0000000000000000 00000000 00000000

 00000000 00000000 00000000 00000000 0000000000000000 00000000 00008d01

 00000200 5a53000000000000 00000000 00000000 00000000 00000000 00000000

 00001600 00000000 00000000 00000000 0000000000000000 00000000 00000000

 00000000 00000000 00000000 00000000 00002a8c 80334d76 32dd6c0500000000

 00000000 00000000 00000000 00000000 0000000000000000 00000000 00000000

 00000000 00000000 00000000 00000000 00000000 0000a481 71df6c05 0000c52f

 56390100 03225600 00000200 00001000 00000200 0000000000000000 00000000

 00000000 00000000 00000000 00000000 0000000000000000 00000000 00000000

 00000000 00000000 00000000 00000000 0000000000000000 00000000 00000000

 00000000 00000000 00000000 00000000 0000000000000000 00000000 00000000

 00000000 00000000 00000000 00000000 0000000000000d00 0d000d00 01000000

 <32 bytes per line>

BBED> p kcvfhcpc

ub4 kcvfhcpc                                @140      0x00005bf6

修改kcvfhccc：

BBED> p kcvfhccc

ub4 kcvfhccc                                @148      0x00000022

BBED> m /x f55b0000

BBED-00209: invalid number (f55b0000)

理由同上

BBED> m /x f55b

 File: /u01/oracle/db/apps_st/data/zs01.dbf (0)

 Block: 1                Offsets:  148 to 659           Dba:0x00000000

------------------------------------------------------------------------

 f55b0000 00000000 00000000 00000000 0000000000000000 00000000 00000000

 00000000 00000000 00000000 00000000 0000000000000000 00000000 00000000

 00000000 00000000 00000000 00000000 0000000000000000 00000000 00000000

 00000000 00000000 00000000 00000000 0000000000000000 00000000 00000000

 00000000 00000000 00000000 00000000 0000000000000000 00000000 00000000

 00000000 00000000 00000000 00000000 0000000000000000 8d010000 02005a53

 00000000 00000000 00000000 00000000 0000000000000000 00000000 16000000

 00000000 00000000 00000000 00000000 0000000000000000 00000000 00000000

 00000000 00000000 00000000 2a8c80334d7632dd 6c050000 0000000000000000

 00000000 00000000 00000000 00000000 0000000000000000 00000000 00000000

 00000000 00000000 00000000 00000000 a48171df 6c050000 c52f563901000322

 56000000 02000000 10000000 02000000 0000000000000000 00000000 00000000

 00000000 00000000 00000000 00000000 0000000000000000 00000000 00000000

 00000000 00000000 00000000 00000000 0000000000000000 00000000 00000000

 00000000 00000000 00000000 00000000 0000000000000000 00000000 00000000

 00000000 00000000 00000000 00000000 0d000d000d000100 00000000 00000000

 <32 bytes per line>

BBED> set offset +2

       OFFSET          150

BBED> m /x 0000

 File: /u01/oracle/db/apps_st/data/zs01.dbf (0)

 Block: 1                Offsets:  150 to 661           Dba:0x00000000

------------------------------------------------------------------------

 00000000 00000000 00000000 00000000 0000000000000000 00000000 00000000

 00000000 00000000 00000000 00000000 0000000000000000 00000000 00000000

 00000000 00000000 00000000 00000000 0000000000000000 00000000 00000000

 00000000 00000000 00000000 00000000 0000000000000000 00000000 00000000

 00000000 00000000 00000000 00000000 0000000000000000 00000000 00000000

 00000000 00000000 00000000 00000000 0000000000008d01 00000200 5a530000

 00000000 00000000 00000000 00000000 0000000000000000 00001600 00000000

 00000000 00000000 00000000 00000000 0000000000000000 00000000 00000000

 00000000 00000000 00002a8c80334d76 32dd6c0500000000 00000000 00000000

 00000000 00000000 00000000 00000000 0000000000000000 00000000 00000000

 00000000 00000000 00000000 0000a481 71df6c05 0000c52f 56390100 03225600

 00000200 00001000 00000200 00000000 0000000000000000 00000000 00000000

 00000000 00000000 00000000 00000000 0000000000000000 00000000 00000000

 00000000 00000000 00000000 00000000 0000000000000000 00000000 00000000

 00000000 00000000 00000000 00000000 0000000000000000 00000000 00000000

 00000000 00000000 00000000 00000d00 0d000d0001000000 00000000 00000000

 <32 bytes per line>

BBED> p kcvfhccc

ub4 kcvfhccc                                @148      0x00005bf5

保存：

BBED> sum

Check value for File 0, Block 1:

current = 0x5136, required = 0x5134

BBED> sum apply

Check value for File 0, Block 1:

current = 0x5134, required = 0x5134

BBED> verify

DBVERIFY - Verification starting

FILE = /u01/oracle/db/apps_st/data/zs01.dbf

BLOCK = 1

DBVERIFY - Verification complete

Total Blocks Examined         : 1

Total Blocks Processed (Data) : 0

Total Blocks Failing   (Data) : 0

Total Blocks Processed (Index): 0

Total Blocks Failing   (Index): 0

Total Blocks Empty            : 0

Total Blocks Marked Corrupt   : 0

Total Blocks Influx           : 0

Message 531 not found;  product=RDBMS; facility=BBED

修改SCN:(OFFSET 484---492)

BBED> set offset 484

       OFFSET          484

BBED> m /x f72878df

BBED-00209: invalid number (f72878df)

理由同上

BBED> m /x f728

 File: /u01/oracle/db/apps_st/data/zs01.dbf (0)

 Block: 1                Offsets:  484 to 995           Dba:0x00000000

------------------------------------------------------------------------

 f72871df 6c050000 c52f5639 01000322 56000000 02000000 10000000 02000000

 00000000 00000000 00000000 00000000 0000000000000000 00000000 00000000

 00000000 00000000 00000000 00000000 0000000000000000 00000000 00000000

 00000000 00000000 00000000 00000000 0000000000000000 00000000 00000000

 00000000 00000000 00000000 00000000 0000000000000000 00000000 00000000

 0d000d00 0d000100 00000000 00000000 0000000002008005 00000000 00000000

 00000000 00000000 00000000 00000000 0000000000000000 00000000 00000000

 00000000 00000000 00000000 00000000 0000000000000000 00000000 00000000

 00000000 00000000 00000000 00000000 0000000000000000 00000000 00000000

 00000000 00000000 00000000 00000000 0000000000000000 00000000 00000000

 00000000 00000000 00000000 00000000 0000000000000000 00000000 00000000

 00000000 00000000 00000000 00000000 0000000000000000 00000000 00000000

 00000000 00000000 00000000 00000000 0000000000000000 00000000 00000000

 00000000 00000000 00000000 00000000 0000000000000000 00000000 00000000

 00000000 00000000 00000000 00000000 0000000000000000 00000000 00000000

 00000000 00000000 00000000 00000000 0000000000000000 00000000 00000000

 <32 bytes per line>

BBED> set offset +2

       OFFSET          486

BBED> m /x 78df

 File: /u01/oracle/db/apps_st/data/zs01.dbf (0)

 Block: 1                Offsets:  486 to 997           Dba:0x00000000

------------------------------------------------------------------------

 78df6c05 0000c52f 56390100 03225600 00000200 0000100000000200 00000000

 00000000 00000000 00000000 00000000 0000000000000000 00000000 00000000

 00000000 00000000 00000000 00000000 0000000000000000 00000000 00000000

 00000000 00000000 00000000 00000000 0000000000000000 00000000 00000000

 00000000 00000000 00000000 00000000 0000000000000000 00000000 00000d00

 0d000d00 01000000 00000000 00000000 0000020080050000 00000000 00000000

 00000000 00000000 00000000 00000000 0000000000000000 00000000 00000000

 00000000 00000000 00000000 00000000 0000000000000000 00000000 00000000

 00000000 00000000 00000000 00000000 0000000000000000 00000000 00000000

 00000000 00000000 00000000 00000000 0000000000000000 00000000 00000000

 00000000 00000000 00000000 00000000 0000000000000000 00000000 00000000

 00000000 00000000 00000000 00000000 0000000000000000 00000000 00000000

 00000000 00000000 00000000 00000000 0000000000000000 00000000 00000000

 00000000 00000000 00000000 00000000 0000000000000000 00000000 00000000

 00000000 00000000 00000000 00000000 0000000000000000 00000000 00000000

 00000000 00000000 00000000 00000000 0000000000000000 00000000 00000000

 <32 bytes per line>

BBED> p kcvfhckp

struct kcvfhckp, 36 bytes                   @484    

  struct kcvcpscn, 8 bytes                @484    

      ub4 kscnbas                           @484      0xdf7828f7

     ub2 kscnwrp                          @488      0x056c

  ub4 kcvcptim                            @492      0x39562fc5

  ub2 kcvcpthr                            @496      0x0001

  union u, 12 bytes                       @500    

     struct kcvcprba, 12 bytes            @500    

        ub4 kcrbaseq                       @500      0x00000056

        ub4 kcrbabno                      @504      0x00000002

        ub2 kcrbabof                      @508      0x0010

  ub1 kcvcpetb[0]                         @512      0x02

  ub1 kcvcpetb[1]                          @513      0x00

  ub1 kcvcpetb[2]                         @514      0x00

  ub1 kcvcpetb[3]                         @515      0x00

  ub1 kcvcpetb[4]                         @516      0x00

  ub1 kcvcpetb[5]                         @517      0x00

  ub1 kcvcpetb[6]                         @518      0x00

  ub1 kcvcpetb[7]                         @519      0x00

BBED> sum

Check value for File 0, Block 1:

current = 0x5134, required = 0xf86e

BBED> sum apply

Check value for File 0, Block 1:

current = 0xf86e, required = 0xf86e

BBED>

然后再sqlplus里执行：

selectfile#,to_char(checkpoint_change#,'999999999999'),to_char(RESETLOGS_CHANGE#,'999999999999')from v$datafile_header;

发现zs01.dbf文件的scn已经一致。

Cux01.dbf,spm01.dbf执行上述步骤

然后数据库所有数据文件都一致了。


成功的恢复三个数据文件，数据没有丢失。





crpp0902
关注
  • 0
    点赞
  • 踩
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
专栏目录
Oracle 特殊恢复工具bbed编译资源包
02-14
Oracle 特殊恢复工具bbed编译资源包，Linux 环境 32位和64位
Oracle bbed工具 包含Linux和Windows版本
06-21
Oracle bbed工具是Block Browser and Editor（块浏览编辑器）的缩写，它是Oracle数据库在安装时一起附带的工具。一般此工具倾向于仅作为Oracle内部使用，且Oracle公司并不公开此工具使用细节。由于bbed可以对Oracle数据库中的数据块进行内容修改和破坏，因此此工具功能强大同时伴有很高的使用风险。 该资源包含了windows版本和 linux版本
BBED 修改文件头 解决 ORA-01190
cizhaorun3127的博客
02-11 175
问题：ORA-01190: control file or data file 6 is from before the last RESETLOGS 1.mount状态下 点击(此处)折叠或...
Oracle bbed 实用示例-----File Header Reset
weixin_33910385的博客
01-23 107
一.查看当前环境 1.1 当前控制文件中的SCN号 [oracle@ora10 ~]$ sqlplus /nolog SQL*Plus: Release 10.2.0.1.0 - Production on Sat Jan 17 10:11:34 2015 Copyright (c) 1982, 2005, Oracle. All rights reserved. SQL&gt; ...
BBED修改数据块里面字符
09-26 138
SSH Secure Shell 3.2.9 (Build 283)Copyright (c) 2000-2003 SSH Communications Security Corp - http://www.ssh.com/Th...
ORA-01190使用bbed强制online数据文件
你好我是李白
12-18 490
ORA-01190使用bbed强制online数据文件
oracle BBED 直接修改数据库block块
chenlin5188的专栏
05-25 794
bbed就是英文block browse block edit的缩写，用来直接查看和修改数据文件数据的一个工具。 新建一个表，插入5条测试数据： create table chenlintest (id number(5) , name varchar(10))  tablespace users; SQL> insert into chenlintest values(1,'aa');
BBED的详细说明
白非马的博客
05-02 5380
一. BBED介绍 “` Thename bbed is an acronym for Block Browser and EDitor and it is shipped with thedatabase. It is intended for Oracle internal use only and the company neverpublishes any details...
Oracle EBS数据库故障与恢复
会写诗的程序猿的博客
08-15 1631
Oracle EBS数据库故障与恢复1. 数据库故障与恢复1.1. 数据库故障1.2. 数据库故障恢复策略1.3. 数据库恢复技术2. 数据库故障预防2.1. 相关基础概念2.2. 硬件架构设计2.3. 软件架构设计2.4. MAA架构 1. 数据库故障与恢复 数据库系统中常见的四种故障主要有事务内部的故障、系统故障、介质故障以及计算机病毒故障，对应于每种故障都有不同的解决方法。事务故障表明事务没...
Oracle bbed工具介绍
fashion的博客
10-24 1377
1. 工具介绍 Oracle bbed 工具 , 名称是 Block Browser and EDitor 的首字母缩写， Oracle 10G 及以前版本它随数据库软件一起提供。仅供 oracle 内部使用， oracle 公司从未发布任何关于它的细节说明。它是一个非常强大的工具，但也非常危险，因为它可以更改 或 破坏任何 oracle 数据库的数据块 。如果您使用此工具，则您需要自行承担风险。使用此工具进行的任何修改都会导致数据库不受 oracle 的支持。 bbed工具下载方法：从Oracle 10
Oracle数据库块损坏的恢复——浅析BBED在数据库恢复中的应用.pdf
10-09
Oracle数据库块损坏的恢复——浅析BBED在数据库恢复中的应用.pdf
Oracle恢复利器，bbed源码
11-17
oracle11g之后不集成bbed了，此源码是从oracle10g提取的，可以在oralce10g以后的版本中使用，内附有使用教程，可以通过oracle中dbf的block进行数据恢复
Oracle bbed工具
03-26
Oracle bbed工具是一个很强大的编辑攻击，Oracle11g以后就不在提供了，可用于当前Oracle版本
Oracle 第二章
最新发布
m0_62008384的博客
04-18 781
select * from 表名 order by 字段;desc ：从大到小排序默认是从小到大排序。
oracle imp导入详解
lc547913923的专栏
04-12 437
imp [username]/[password]@[ip]:1521/[数据库实例名 helowin] file=files.txt commit=y feedback=10000 buffer=40960000 inctype=RESTORE ignore=y FULL=y FILE=A。例如：SELECT t.BIGFILE,t.* FROM dba_tablespaces t where t.tablespace_name='TBS_GROUP_MEALS_TEST'
Oracle中的CASE WHEN语句使用详解与实例
lxz458912769的博客
04-18 190
oracle case when 新手宝典
mysql,oracle,sql server中的默认事务隔离级别查看
weixin_42672802的博客
04-12 822
mysql,oracle,sql server中的默认事务隔离级别查看
oracle guid 使用
lxz458912769的博客
04-18 170
你还可以编写一个自定义的PL/SQL函数来生成GUID。这个函数可以基于SYS_GUID()（如果可用）或其他逻辑来生成GUID。sql复制代码BEGIN之后，你可以通过以下方式调用这个函数：sql复制代码。
mybatis-puls 逻辑删除
weixin_54097396的博客
04-16 443
mybatis-puls 逻辑删除
windows oracle bbed
09-25
Windows Oracle BBED 是一个专门用于恢复数据库的工具，它是针对数据库内部的页级别编辑器。BBED 的全称是 Block Browser and Editor，它允许管理员直接访问和修改数据库的数据块。 在数据库中，数据被存储在数据块...

“相关推荐”对你有帮助么？

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值