跳过归档日志的非常规恢复(一)
来源:互联网 发布:java图片转换成base64 编辑:程序博客网 时间:2024/05/22 08:10
跳过归档日志的非常规恢复(二)http://www.itpub.net/thread-1700523-1-2.html
步骤一、首先创建测试环境:
复制代码
- SQL> select name from v$dbfile;
- NAME
- --------------------------------------------------------------------------------
- /u01/app/oracle/oradata/huateng/users01.dbf
- /u01/app/oracle/oradata/huateng/undotbs01.dbf
- /u01/app/oracle/oradata/huateng/sysaux01.dbf
- /u01/app/oracle/oradata/huateng/system01.dbf
- /u01/app/oracle/oradata/huateng/example01.dbf
- SQL> create tablespace htyansp datafile '/u01/app/oracle/oradata/huateng/htyansp01.dbf' size 10m;
- Tablespace created.
- SQL> create user htyansp identified by htyansp;
- User created.
- SQL> alter user htyansp default tablespace htyansp;
- User altered.
- SQL> grant dba to htyansp;
- Grant succeeded.
- SQL> alter system switch logfile;
- System altered.
- SQL> archive log list
- Database log mode Archive Mode
- Automatic archival Enabled
- Archive destination /archivelog
- Oldest online log sequence 5
- Next log sequence to archive 7
- Current log sequence 7
上面创建了一个用户htyansp及其相应的表空间htyansp,当前的日志序列号是7。
步骤二、对数据库做一个全备份
- [oracle@db2server ~]$ rman target /
- Recovery Manager: Release 11.2.0.1.0 - Production on Tue Jul 31 00:09:04 2012
- Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
- connected to target database: HUATENG (DBID=2134565240)
- RMAN> backup database;
- Starting backup at 2012-07-31 00:09:14
- using target database control file instead of recovery catalog
- allocated channel: ORA_DISK_1
- channel ORA_DISK_1: SID=36 device type=DISK
- channel ORA_DISK_1: starting full datafile backup set
- channel ORA_DISK_1: specifying datafile(s) in backup set
- input datafile file number=00001 name=/u01/app/oracle/oradata/huateng/system01.dbf
- input datafile file number=00002 name=/u01/app/oracle/oradata/huateng/sysaux01.dbf
- input datafile file number=00005 name=/u01/app/oracle/oradata/huateng/example01.dbf
- input datafile file number=00003 name=/u01/app/oracle/oradata/huateng/undotbs01.dbf
- input datafile file number=00006 name=/u01/app/oracle/oradata/huateng/htyansp01.dbf
- input datafile file number=00004 name=/u01/app/oracle/oradata/huateng/users01.dbf
- channel ORA_DISK_1: starting piece 1 at 2012-07-31 00:09:16
- channel ORA_DISK_1: finished piece 1 at 2012-07-31 00:10:41
- piece handle=/u01/app/oracle/flash_recovery_area/HUATENG/backupset/2012_07_31/o1_mf_nnndf_TAG20120731T000915_81fdfg00_.bkp tag=TAG20120731T000915 comment=NONE
- channel ORA_DISK_1: backup set complete, elapsed time: 00:01:25
- channel ORA_DISK_1: starting full datafile backup set
- channel ORA_DISK_1: specifying datafile(s) in backup set
- including current control file in backup set
- including current SPFILE in backup set
- channel ORA_DISK_1: starting piece 1 at 2012-07-31 00:10:45
- channel ORA_DISK_1: finished piece 1 at 2012-07-31 00:10:46
- piece handle=/u01/app/oracle/flash_recovery_area/HUATENG/backupset/2012_07_31/o1_mf_ncsnf_TAG20120731T000915_81fdj56h_.bkp tag=TAG20120731T000915 comment=NONE
- channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01
- Finished backup at 2012-07-31 00:10:46
- RMAN>
步骤三、创建测试数据
- SQL> archive log list
- Database log mode Archive Mode
- Automatic archival Enabled
- Archive destination /archivelog
- Oldest online log sequence 5
- Next log sequence to archive 7
- Current log sequence 7
- SQL> conn htyansp/htyansp
- Connected.
- SQL> create table test(seq varchar2(20));
- Table created.
- SQL> insert into test values('sequence 7');
- 1 row created.
- SQL> commit;
- Commit complete.
- SQL> alter system switch logfile;
- System altered.
当前的日志文件序列号是7,:因此上面的记录将会存放到日志序列号为7的归档日志中。
- SQL> insert into test values('sequence 8');
- 1 row created.
- SQL> commit;
- Commit complete.
- SQL> alter system switch logfile;
- System altered.
- SQL> insert into test values('sequence 9');
- 1 row created.
- SQL> commit;
- Commit complete.
- SQL> alter system switch logfile;
- System altered.
- SQL> insert into test values('sequence 10');
- 1 row created.
- SQL> commit;
- Commit complete.
- SQL> alter system switch logfile;
- System altered.
- SQL> insert into test values('sequence 11');
- 1 row created.
- SQL> commit;
- Commit complete.
- SQL> alter system switch logfile;
- System altered.
- SQL> select * from htyansp.test;
- SEQ
- --------------------
- sequence 7
- sequence 8
- sequence 9
- sequence 10
- sequence 11
每次插入一条记录切换一次日志,上面的记录每条记录存放到一个日志文件中。
步骤4、模拟错误
- [oracle@db2server archivelog]$ ls -ltrh
- 总计 572K
- -rw-r----- 1 oracle oinstall 506K 07-31 00:08 1_6_789791289.dbf
- -rw-r----- 1 oracle oinstall 39K 07-31 00:14 1_7_789791289.dbf
- -rw-r----- 1 oracle oinstall 3.5K 07-31 00:14 1_8_789791289.dbf
- -rw-r----- 1 oracle oinstall 5.0K 07-31 00:14 1_9_789791289.dbf
- -rw-r----- 1 oracle oinstall 3.0K 07-31 00:15 1_10_789791289.dbf
- -rw-r----- 1 oracle oinstall 3.5K 07-31 00:15 1_11_789791289.dbf
- 我们删掉日志文件1_9_789791289.dbf 及其表空间htyansp的数据文件。
- [oracle@db2server archivelog]$ rm -rf 1_9_789791289.dbf
- [oracle@db2server archivelog]$ rm -rf /u01/app/oracle/oradata/huateng/htyansp01.dbf
- [oracle@db2server archivelog]$ ls -ltr
- 总计 568
- -rw-r----- 1 oracle oinstall 518144 07-31 00:08 1_6_789791289.dbf
- -rw-r----- 1 oracle oinstall 39424 07-31 00:14 1_7_789791289.dbf
- -rw-r----- 1 oracle oinstall 3584 07-31 00:14 1_8_789791289.dbf
- -rw-r----- 1 oracle oinstall 5120 07-31 00:14 1_10_789791289.dbf
- -rw-r----- 1 oracle oinstall 3584 07-31 00:15 1_11_789791289.dbf
- 此时数据库不能正常关闭
- SQL> shutdown immediate
- ORA-01116: error in opening database file 6
- ORA-01110: data file 6: '/u01/app/oracle/oradata/huateng/htyansp01.dbf'
- ORA-27041: unable to open file
- Linux Error: 2: No such file or directory
- Additional information: 3
- SQL> shutdown abort
- ORACLE instance shut down.
- SQL>
- 需要采用shutdown abort的方式关闭数据库。
- 再次启动数据库将会报错。
- SQL> startup
- ORACLE instance started.
- Total System Global Area 506368000 bytes
- Fixed Size 1337520 bytes
- Variable Size 322963280 bytes
- Database Buffers 176160768 bytes
- Redo Buffers 5906432 bytes
- Database mounted.
- ORA-01157: cannot identify/lock data file 6 - see DBWR trace file
- ORA-01110: data file 6: '/u01/app/oracle/oradata/huateng/htyansp01.dbf'
- SQL>
步骤5、探讨RECOVER需要修改的文件头信息
还原数据文件
- [oracle@db2server ~]$ rman target /
- Recovery Manager: Release 11.2.0.1.0 - Production on Tue Jul 31 00:22:13 2012
- Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
- connected to target database: HUATENG (DBID=2134565240, not open)
- RMAN> restore datafile 6;
- Starting restore at 2012-07-31 00:22:20
- using target database control file instead of recovery catalog
- allocated channel: ORA_DISK_1
- channel ORA_DISK_1: SID=17 device type=DISK
- channel ORA_DISK_1: starting datafile backup set restore
- channel ORA_DISK_1: specifying datafile(s) to restore from backup set
- channel ORA_DISK_1: restoring datafile 00006 to /u01/app/oracle/oradata/huateng/htyansp01.dbf
- channel ORA_DISK_1: reading from backup piece /u01/app/oracle/flash_recovery_area/HUATENG/backupset/2012_07_31/o1_mf_nnndf_TAG20120731T000915_81fdfg00_.bkp
- channel ORA_DISK_1: piece handle=/u01/app/oracle/flash_recovery_area/HUATENG/backupset/2012_07_31/o1_mf_nnndf_TAG20120731T000915_81fdfg00_.bkp tag=TAG20120731T000915
- channel ORA_DISK_1: restored backup piece 1
- channel ORA_DISK_1: restore complete, elapsed time: 00:00:01
- Finished restore at 2012-07-31 00:22:23
- RMAN>
- SQL> recover datafile 6;
- ORA-00279: change 849630 generated at 07/31/2012 00:09:16 needed for thread 1
- ORA-00289: suggestion : /archivelog/1_7_789791289.dbf
- ORA-00280: change 849630 for thread 1 is in sequence #7
- Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
- /archivelog/1_7_789791289.dbf
- ORA-00279: change 849781 generated at 07/31/2012 00:14:17 needed for thread 1
- ORA-00289: suggestion : /archivelog/1_8_789791289.dbf
- ORA-00280: change 849781 for thread 1 is in sequence #8
- Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
注意此时我们暂时先不应用归档日志序列号为8的文件。
我们采用BBED先记录此时的数据文件头的信息。
- [oracle@db2server ~]$ bbed filename=/u01/app/oracle/oradata/huateng/htyansp01.dbf
- Password:
- BBED: Release 2.0.0.0.0 - Limited Production on Tue Jul 31 00:24:44 2012
- Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
- ************* !!! For Oracle Internal Use only !!! ***************
- BBED> p kcvfh
- struct kcvfh, 860 bytes @0
- struct kcvfhbfh, 20 bytes @0
- ub1 type_kcbh @0 0x0b
- ub1 frmt_kcbh @1 0xa2
- ub1 spare1_kcbh @2 0x00
- ub1 spare2_kcbh @3 0x00
- ub4 rdba_kcbh @4 0x01800001
- ub4 bas_kcbh @8 0x00000000
- ub2 wrp_kcbh @12 0x0000
- ub1 seq_kcbh @14 0x01
- ub1 flg_kcbh @15 0x04 (KCBHFCKV)
- ub2 chkval_kcbh @16 0xc785
- ub2 spare3_kcbh @18 0x0000
- struct kcvfhhdr, 76 bytes @20
- ub4 kccfhswv @20 0x00000000
- ub4 kccfhcvn @24 0x0b200000
- ub4 kccfhdbi @28 0x7f3ae178
- text kccfhdbn[0] @32 H
- text kccfhdbn[1] @33 U
- text kccfhdbn[2] @34 A
- text kccfhdbn[3] @35 T
- text kccfhdbn[4] @36 E
- text kccfhdbn[5] @37 N
- text kccfhdbn[6] @38 G
- text kccfhdbn[7] @39
- ub4 kccfhcsq @40 0x00000325
- ub4 kccfhfsz @44 0x00000500
- s_blkz kccfhbsz @48 0x00
- ub2 kccfhfno @52 0x0006
- ub2 kccfhtyp @54 0x0003
- ub4 kccfhacid @56 0x00000000
- ub4 kccfhcks @60 0x00000000
- text kccfhtag[0] @64
- text kccfhtag[1] @65
- text kccfhtag[2] @66
- text kccfhtag[3] @67
- text kccfhtag[4] @68
- text kccfhtag[5] @69
- text kccfhtag[6] @70
- text kccfhtag[7] @71
- text kccfhtag[8] @72
- text kccfhtag[9] @73
- text kccfhtag[10] @74
- text kccfhtag[11] @75
- text kccfhtag[12] @76
- text kccfhtag[13] @77
- text kccfhtag[14] @78
- text kccfhtag[15] @79
- text kccfhtag[16] @80
- text kccfhtag[17] @81
- text kccfhtag[18] @82
- text kccfhtag[19] @83
- text kccfhtag[20] @84
- text kccfhtag[21] @85
- text kccfhtag[22] @86
- text kccfhtag[23] @87
- text kccfhtag[24] @88
- text kccfhtag[25] @89
- text kccfhtag[26] @90
- text kccfhtag[27] @91
- text kccfhtag[28] @92
- text kccfhtag[29] @93
- text kccfhtag[30] @94
- text kccfhtag[31] @95
- ub4 kcvfhrdb @96 0x00000000
- struct kcvfhcrs, 8 bytes @100
- ub4 kscnbas @100 0x000cf590
- ub2 kscnwrp @104 0x0000
- ub4 kcvfhcrt @108 0x2f1715c8
- ub4 kcvfhrlc @112 0x2f134239
- struct kcvfhrls, 8 bytes @116
- ub4 kscnbas @116 0x000b8338
- ub2 kscnwrp @120 0x0000
- ub4 kcvfhbti @124 0x00000000
- struct kcvfhbsc, 8 bytes @128
- ub4 kscnbas @128 0x00000000
- ub2 kscnwrp @132 0x0000
- ub2 kcvfhbth @136 0x0000
- ub2 kcvfhsta @138 0x0000 (NONE)
- struct kcvfhckp, 36 bytes @484
- struct kcvcpscn, 8 bytes @484
- ub4 kscnbas @484 0x000cf775
- ub2 kscnwrp @488 0x0000
- ub4 kcvcptim @492 0x2f171759
- ub2 kcvcpthr @496 0x0001
- union u, 12 bytes @500
- struct kcvcprba, 12 bytes @500
- ub4 kcrbaseq @500 0x00000008
- ub4 kcrbabno @504 0x00000002
- ub2 kcrbabof @508 0x0000
- 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
- ub4 kcvfhcpc @140 0x00000004
- ub4 kcvfhrts @144 0x2f171995
- ub4 kcvfhccc @148 0x00000003
- struct kcvfhbcp, 36 bytes @152
- struct kcvcpscn, 8 bytes @152
- ub4 kscnbas @152 0x00000000
- ub2 kscnwrp @156 0x0000
- ub4 kcvcptim @160 0x00000000
- ub2 kcvcpthr @164 0x0000
- union u, 12 bytes @168
- struct kcvcprba, 12 bytes @168
- ub4 kcrbaseq @168 0x00000000
- ub4 kcrbabno @172 0x00000000
- ub2 kcrbabof @176 0x0000
- ub1 kcvcpetb[0] @180 0x00
- ub1 kcvcpetb[1] @181 0x00
- ub1 kcvcpetb[2] @182 0x00
- ub1 kcvcpetb[3] @183 0x00
- ub1 kcvcpetb[4] @184 0x00
- ub1 kcvcpetb[5] @185 0x00
- ub1 kcvcpetb[6] @186 0x00
- ub1 kcvcpetb[7] @187 0x00
- ub4 kcvfhbhz @312 0x00000000
- struct kcvfhxcd, 16 bytes @316
- ub4 space_kcvmxcd[0] @316 0x00000000
- ub4 space_kcvmxcd[1] @320 0x00000000
- ub4 space_kcvmxcd[2] @324 0x00000000
- ub4 space_kcvmxcd[3] @328 0x00000000
- sword kcvfhtsn @332 7
- ub2 kcvfhtln @336 0x0007
- text kcvfhtnm[0] @338 H
- text kcvfhtnm[1] @339 T
- text kcvfhtnm[2] @340 Y
- text kcvfhtnm[3] @341 A
- text kcvfhtnm[4] @342 N
- text kcvfhtnm[5] @343 S
- text kcvfhtnm[6] @344 P
- text kcvfhtnm[7] @345
- text kcvfhtnm[8] @346
- text kcvfhtnm[9] @347
- text kcvfhtnm[10] @348
- text kcvfhtnm[11] @349
- text kcvfhtnm[12] @350
- text kcvfhtnm[13] @351
- text kcvfhtnm[14] @352
- text kcvfhtnm[15] @353
- text kcvfhtnm[16] @354
- text kcvfhtnm[17] @355
- text kcvfhtnm[18] @356
- text kcvfhtnm[19] @357
- text kcvfhtnm[20] @358
- text kcvfhtnm[21] @359
- text kcvfhtnm[22] @360
- text kcvfhtnm[23] @361
- text kcvfhtnm[24] @362
- text kcvfhtnm[25] @363
- text kcvfhtnm[26] @364
- text kcvfhtnm[27] @365
- text kcvfhtnm[28] @366
- text kcvfhtnm[29] @367
- ub4 kcvfhrfn @368 0x00000006
- struct kcvfhrfs, 8 bytes @372
- ub4 kscnbas @372 0x00000000
- ub2 kscnwrp @376 0x0000
- ub4 kcvfhrft @380 0x00000000
- struct kcvfhafs, 8 bytes @384
- ub4 kscnbas @384 0x00000000
- ub2 kscnwrp @388 0x0000
- ub4 kcvfhbbc @392 0x00000000
- ub4 kcvfhncb @396 0x00000000
- ub4 kcvfhmcb @400 0x00000000
- ub4 kcvfhlcb @404 0x00000000
- ub4 kcvfhbcs @408 0x00000000
- ub2 kcvfhofb @412 0x0000
- ub2 kcvfhnfb @414 0x0000
- ub4 kcvfhprc @416 0x296a3120
- struct kcvfhprs, 8 bytes @420
- ub4 kscnbas @420 0x00000001
- ub2 kscnwrp @424 0x0000
- struct kcvfhprfs, 8 bytes @428
- ub4 kscnbas @428 0x00000000
- ub2 kscnwrp @432 0x0000
- ub4 kcvfhtrt @444 0x00000000
- BBED>
将上面打印出来的信息保存为recover_sequence7.txt
再次回到原来的recovery界面,应用归档日志序列号为8的文件。
如下:
- SQL> recover datafile 6;
- ORA-00279: change 849630 generated at 07/31/2012 00:09:16 needed for thread 1
- ORA-00289: suggestion : /archivelog/1_7_789791289.dbf
- ORA-00280: change 849630 for thread 1 is in sequence #7
- Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
- /archivelog/1_7_789791289.dbf
- ORA-00279: change 849781 generated at 07/31/2012 00:14:17 needed for thread 1
- ORA-00289: suggestion : /archivelog/1_8_789791289.dbf
- ORA-00280: change 849781 for thread 1 is in sequence #8
- Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
- /archivelog/1_8_789791289.dbf
- ORA-00279: change 849798 generated at 07/31/2012 00:14:43 needed for thread 1
- ORA-00289: suggestion : /archivelog/1_9_789791289.dbf
- ORA-00280: change 849798 for thread 1 is in sequence #9
- Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
再次用BBED查询此时的数据文件头信息,如下所示:
- [oracle@db2server ~]$ bbed filename=/u01/app/oracle/oradata/huateng/htyansp01.dbf
- Password:
- BBED: Release 2.0.0.0.0 - Limited Production on Tue Jul 31 00:29:32 2012
- Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
- ************* !!! For Oracle Internal Use only !!! ***************
- BBED> show
- FILE# 0
- BLOCK# 1
- OFFSET 0
- DBA 0x00000000 (0 0,1)
- FILENAME /u01/app/oracle/oradata/huateng/htyansp01.dbf
- BIFILE bifile.bbd
- LISTFILE
- BLOCKSIZE 8192
- MODE Browse
- EDIT Unrecoverable
- IBASE Dec
- OBASE Dec
- WIDTH 80
- COUNT 512
- LOGFILE log.bbd
- SPOOL No
- BBED> p kcvfh
- struct kcvfh, 860 bytes @0
- struct kcvfhbfh, 20 bytes @0
- ub1 type_kcbh @0 0x0b
- ub1 frmt_kcbh @1 0xa2
- ub1 spare1_kcbh @2 0x00
- ub1 spare2_kcbh @3 0x00
- ub4 rdba_kcbh @4 0x01800001
- ub4 bas_kcbh @8 0x00000000
- ub2 wrp_kcbh @12 0x0000
- ub1 seq_kcbh @14 0x01
- ub1 flg_kcbh @15 0x04 (KCBHFCKV)
- ub2 chkval_kcbh @16 0xc404
- ub2 spare3_kcbh @18 0x0000
- struct kcvfhhdr, 76 bytes @20
- ub4 kccfhswv @20 0x00000000
- ub4 kccfhcvn @24 0x0b200000
- ub4 kccfhdbi @28 0x7f3ae178
- text kccfhdbn[0] @32 H
- text kccfhdbn[1] @33 U
- text kccfhdbn[2] @34 A
- text kccfhdbn[3] @35 T
- text kccfhdbn[4] @36 E
- text kccfhdbn[5] @37 N
- text kccfhdbn[6] @38 G
- text kccfhdbn[7] @39
- ub4 kccfhcsq @40 0x00000327
- ub4 kccfhfsz @44 0x00000500
- s_blkz kccfhbsz @48 0x00
- ub2 kccfhfno @52 0x0006
- ub2 kccfhtyp @54 0x0003
- ub4 kccfhacid @56 0x00000000
- ub4 kccfhcks @60 0x00000000
- text kccfhtag[0] @64
- text kccfhtag[1] @65
- text kccfhtag[2] @66
- text kccfhtag[3] @67
- text kccfhtag[4] @68
- text kccfhtag[5] @69
- text kccfhtag[6] @70
- text kccfhtag[7] @71
- text kccfhtag[8] @72
- text kccfhtag[9] @73
- text kccfhtag[10] @74
- text kccfhtag[11] @75
- text kccfhtag[12] @76
- text kccfhtag[13] @77
- text kccfhtag[14] @78
- text kccfhtag[15] @79
- text kccfhtag[16] @80
- text kccfhtag[17] @81
- text kccfhtag[18] @82
- text kccfhtag[19] @83
- text kccfhtag[20] @84
- text kccfhtag[21] @85
- text kccfhtag[22] @86
- text kccfhtag[23] @87
- text kccfhtag[24] @88
- text kccfhtag[25] @89
- text kccfhtag[26] @90
- text kccfhtag[27] @91
- text kccfhtag[28] @92
- text kccfhtag[29] @93
- text kccfhtag[30] @94
- text kccfhtag[31] @95
- ub4 kcvfhrdb @96 0x00000000
- struct kcvfhcrs, 8 bytes @100
- ub4 kscnbas @100 0x000cf590
- ub2 kscnwrp @104 0x0000
- ub4 kcvfhcrt @108 0x2f1715c8
- ub4 kcvfhrlc @112 0x2f134239
- struct kcvfhrls, 8 bytes @116
- ub4 kscnbas @116 0x000b8338
- ub2 kscnwrp @120 0x0000
- ub4 kcvfhbti @124 0x00000000
- struct kcvfhbsc, 8 bytes @128
- ub4 kscnbas @128 0x00000000
- ub2 kscnwrp @132 0x0000
- ub2 kcvfhbth @136 0x0000
- ub2 kcvfhsta @138 0x0000 (NONE)
- struct kcvfhckp, 36 bytes @484
- struct kcvcpscn, 8 bytes @484
- ub4 kscnbas @484 0x000cf786
- ub2 kscnwrp @488 0x0000
- ub4 kcvcptim @492 0x2f171773
- ub2 kcvcpthr @496 0x0001
- union u, 12 bytes @500
- struct kcvcprba, 12 bytes @500
- ub4 kcrbaseq @500 0x00000009
- ub4 kcrbabno @504 0x00000002
- ub2 kcrbabof @508 0x0000
- 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
- ub4 kcvfhcpc @140 0x00000004
- ub4 kcvfhrts @144 0x2f171ace
- ub4 kcvfhccc @148 0x00000003
- struct kcvfhbcp, 36 bytes @152
- struct kcvcpscn, 8 bytes @152
- ub4 kscnbas @152 0x00000000
- ub2 kscnwrp @156 0x0000
- ub4 kcvcptim @160 0x00000000
- ub2 kcvcpthr @164 0x0000
- union u, 12 bytes @168
- struct kcvcprba, 12 bytes @168
- ub4 kcrbaseq @168 0x00000000
- ub4 kcrbabno @172 0x00000000
- ub2 kcrbabof @176 0x0000
- ub1 kcvcpetb[0] @180 0x00
- ub1 kcvcpetb[1] @181 0x00
- ub1 kcvcpetb[2] @182 0x00
- ub1 kcvcpetb[3] @183 0x00
- ub1 kcvcpetb[4] @184 0x00
- ub1 kcvcpetb[5] @185 0x00
- ub1 kcvcpetb[6] @186 0x00
- ub1 kcvcpetb[7] @187 0x00
- ub4 kcvfhbhz @312 0x00000000
- struct kcvfhxcd, 16 bytes @316
- ub4 space_kcvmxcd[0] @316 0x00000000
- ub4 space_kcvmxcd[1] @320 0x00000000
- ub4 space_kcvmxcd[2] @324 0x00000000
- ub4 space_kcvmxcd[3] @328 0x00000000
- sword kcvfhtsn @332 7
- ub2 kcvfhtln @336 0x0007
- text kcvfhtnm[0] @338 H
- text kcvfhtnm[1] @339 T
- text kcvfhtnm[2] @340 Y
- text kcvfhtnm[3] @341 A
- text kcvfhtnm[4] @342 N
- text kcvfhtnm[5] @343 S
- text kcvfhtnm[6] @344 P
- text kcvfhtnm[7] @345
- text kcvfhtnm[8] @346
- text kcvfhtnm[9] @347
- text kcvfhtnm[10] @348
- text kcvfhtnm[11] @349
- text kcvfhtnm[12] @350
- text kcvfhtnm[13] @351
- text kcvfhtnm[14] @352
- text kcvfhtnm[15] @353
- text kcvfhtnm[16] @354
- text kcvfhtnm[17] @355
- text kcvfhtnm[18] @356
- text kcvfhtnm[19] @357
- text kcvfhtnm[20] @358
- text kcvfhtnm[21] @359
- text kcvfhtnm[22] @360
- text kcvfhtnm[23] @361
- text kcvfhtnm[24] @362
- text kcvfhtnm[25] @363
- text kcvfhtnm[26] @364
- text kcvfhtnm[27] @365
- text kcvfhtnm[28] @366
- text kcvfhtnm[29] @367
- ub4 kcvfhrfn @368 0x00000006
- struct kcvfhrfs, 8 bytes @372
- ub4 kscnbas @372 0x00000000
- ub2 kscnwrp @376 0x0000
- ub4 kcvfhrft @380 0x00000000
- struct kcvfhafs, 8 bytes @384
- ub4 kscnbas @384 0x00000000
- ub2 kscnwrp @388 0x0000
- ub4 kcvfhbbc @392 0x00000000
- ub4 kcvfhncb @396 0x00000000
- ub4 kcvfhmcb @400 0x00000000
- ub4 kcvfhlcb @404 0x00000000
- ub4 kcvfhbcs @408 0x00000000
- ub2 kcvfhofb @412 0x0000
- ub2 kcvfhnfb @414 0x0000
- ub4 kcvfhprc @416 0x296a3120
- struct kcvfhprs, 8 bytes @420
- ub4 kscnbas @420 0x00000001
- ub2 kscnwrp @424 0x0000
- struct kcvfhprfs, 8 bytes @428
- ub4 kscnbas @428 0x00000000
- ub2 kscnwrp @432 0x0000
- ub4 kcvfhtrt
- 跳过归档日志的非常规恢复(一)
- 跳过归档日志的非常规恢复
- 跳过归档日志的非常规恢复
- 跳过归档日志的非常规恢复(二)
- Oracle非常规恢复(使用BBED跳过归档)
- Oracle非常规恢复(使用BBED跳过归档)
- 非常规数据恢复的几种场景(跳过坏块导出数据)
- oracle跳过丢失的归档恢复datafile
- BBED跳过归档恢复
- RMAN之非归档日志模式下的数据文件恢复
- Oracle 之利用BBED跳过归档日志实现恢复(二)
- Oracle 之利用BBED跳过归档日志实现恢复
- Oracle恢复(二)------非归档模式下的恢复
- 跳过丢失归档进行恢复
- 使用脚本,自动跳过丢失归档的恢复--------MODIFY SEQ
- RMAN之归档日志模式下的非关键文件恢复
- 手工完全恢复(非归档模式下,日志没有被覆盖)
- 手工不完全恢复(非归档模式下,日志被覆盖)
- linux RTC驱动
- java的HashCode方法
- http://blog.sina.com.cn/s/blog_4ac0a0d30100cp9d.html
- 密码学C语言函数库——Miracl库快速上手中文指南(VC)
- win7-64位装oracle客户端-plsql连接数据库
- 跳过归档日志的非常规恢复(一)
- hdu2841 la3720
- ARM的字对齐问题总结
- 跳过归档日志的非常规恢复(二)
- 浅谈利用RSA算法防止非法注册机的制作
- VC++中MessageBox的常见用法详解
- NHibernate 3.2以上版本Unable to load type 'NHibernate.ByteCode.Castle.ProxyFactoryFactory .
- IOS持久化数据----(保存数据的一系列方法)
- MFC使用webbrowser时navigate的url中有中文字符,在php服务器端取得的是乱码问题的解决方案