用bbed修改数据文件头,跳过丢失的归档
来源:互联网 发布:淘宝网瘦身腰带 编辑:程序博客网 时间:2024/06/05 11:17
演示案例
conn lunar/lunar
create table t1 tablespace rogertbs as select * from dba_objects;
create table t2 tablespace rogertbs as select * from dba_objects;
create table t3 tablespace rogertbs as select * from dba_objects;
archive log list
SQL> conn lunar/lunar
Connected.
SQL> create table t1 tablespace rogertbs as select * from dba_objects;
Table created.
SQL> create table t2 tablespace rogertbs as select * from dba_objects;
Table created.
SQL> create table t3 tablespace rogertbs as select * from dba_objects;
Table created.
SQL> conn / as sysdba
Connected.
SQL> archive log list
Database log mode Archive Mode
Automatic archival Enabled
Archive destination /u01/archive/
Oldest online log sequence 18
Next log sequence to archive 20
Current log sequence 20
SQL> alter system switch logfile;
System altered.
SQL> archive log list
Database log mode Archive Mode
Automatic archival Enabled
Archive destination /u01/archive/
Oldest online log sequence 19
Next log sequence to archive 21
Current log sequence 21
SQL> alter system switch logfile;
/
System altered.
SQL>
System altered.
SQL>
SQL>
conn lunar/lunar
select count(*) from t1;
select count(*) from t2;
select count(*) from t3;
SQL> conn lunar/lunar
Connected.
SQL> select count(*) from t1;
COUNT(*)
17619
SQL> select count(*) from t2;
COUNT(*)
17620
SQL> select count(*) from t3;
COUNT(*)
17621
SQL>
conn lunar/lunar
delete from t2 where rownum <2;
delete from t3 where rownum <2;
commit;
conn / as sysdba
alter system switch logfile;
archive log list
SQL> conn lunar/lunar
delete from t2 where rownum <2;
delete from t3 where rownum <2;
Connected.
SQL> commit;
1 row deleted.
SQL>
1 row deleted.
SQL>
Commit complete.
SQL>
SQL> conn / as sysdba
alter system switch logfile;
Connected.
SQL> archive log list
System altered.
SQL> Database log mode Archive Mode
Automatic archival Enabled
Archive destination /u01/archive/
Oldest online log sequence 22
Next log sequence to archive 23
Current log sequence 24
SQL>
SQL>
conn lunar/lunar
delete from t1 where rownum <10001;
commit;
conn / as sysdba
alter system switch logfile;
alter system switch logfile;
alter system switch logfile;
archive log list
SQL> conn / as sysdba
alter system switch logfile;
Connected.
SQL> alter system switch logfile;
alter system switch logfile;
archive log list
System altered.
SQL>
System altered.
SQL>
System altered.
SQL> Database log mode Archive Mode
Automatic archival Enabled
Archive destination /u01/archive/
Oldest online log sequence 25
Next log sequence to archive 26
Current log sequence 27
SQL> SQL>
SQL>
SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> !
cp /test/clonedb/roger01.dbf /test/clonedb/roger01.dbf.bak
[oracle@lunar clonedb]$ ls -lrt /test/clonedb/roger01*
-rw-r—– 1 oracle oinstall 10493952 Aug 16 03:07 /test/clonedb/roger01.dbf
-rw-r—– 1 oracle oinstall 10493952 Aug 16 03:09 /test/clonedb/roger01.dbf.bak
[oracle@lunar clonedb]$
conn / as sysdba
startup
conn lunar/lunar
delete from t1 where rownum <10001;
delete from t2 where rownum <2;
delete from t3 where rownum <2;
commit;
conn / as sysdba
alter system switch logfile;
archive log list
SQL> conn / as sysdba
Connected to an idle instance.
SQL> startup
ORACLE instance started.
Total System Global Area 530288640 bytes
Fixed Size 2230024 bytes
Variable Size 167774456 bytes
Database Buffers 352321536 bytes
Redo Buffers 7962624 bytes
Database mounted.
Database opened.
SQL> conn lunar/lunar
delete from t1 where rownum <10001;
delete from t2 where rownum <2;
delete from t3 where rownum <2;
commit;
Connected.
SQL>
7619 rows deleted.
SQL>
1 row deleted.
SQL>
1 row deleted.
SQL>
Commit complete.
SQL>
SQL> conn / as sysdba
alter system switch logfile;
archive log list
Connected.
SQL>
System altered.
SQL> Database log mode Archive Mode
Automatic archival Enabled
Archive destination /u01/archive/
Oldest online log sequence 26
Next log sequence to archive 27
Current log sequence 28
SQL>
alter system switch logfile;
alter system switch logfile;
archive log list;
SQL> alter system switch logfile;
alter system switch logfile;
archive log list;
System altered.
SQL>
System altered.
SQL> Database log mode Archive Mode
Automatic archival Enabled
Archive destination /u01/archive/
Oldest online log sequence 28
Next log sequence to archive 29
Current log sequence 30
SQL> SQL>
SQL>
[oracle@lunar archive]
1_26_805707062.dbf 1_26_805858745.dbf
[oracle@lunar archive]
[oracle@lunar clonedb]
-rw-r—– 1 oracle oinstall 10493952 Aug 16 03:09 roger01.dbf.bak
[oracle@lunar clonedb]$
SQL> conn / as sysdba
Connected.
SQL> shutdown immediate
ORA-01116: error in opening database file 5
ORA-01110: data file 5: ‘/test/clonedb/roger01.dbf’
ORA-27041: unable to open file
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
[oracle@lunar ~]
SQL*Plus: Release 11.2.0.3.0 Production on Thu Aug 16 03:32:52 2012
Copyright (c) 1982, 2011, Oracle. All rights reserved.
Connected to an idle instance.
SQL> startup
ORACLE instance started.
Total System Global Area 530288640 bytes
Fixed Size 2230024 bytes
Variable Size 167774456 bytes
Database Buffers 352321536 bytes
Redo Buffers 7962624 bytes
Database mounted.
ORA-01157: cannot identify/lock data file 5 - see DBWR trace file
ORA-01110: data file 5: ‘/test/clonedb/roger01.dbf’
SQL>
SQL> recover datafile 5;
ORA-00283: recovery session canceled due to errors
ORA-01110: data file 5: ‘/test/clonedb/roger01.dbf’
ORA-01157: cannot identify/lock data file 5 - see DBWR trace file
ORA-01110: data file 5: ‘/test/clonedb/roger01.dbf’
SQL> archive log list
Database log mode Archive Mode
Automatic archival Enabled
Archive destination /u01/archive/
Oldest online log sequence 30
Next log sequence to archive 32
Current log sequence 32
SQL> select open_mode from v$database;
OPEN_MODE
MOUNTED
SQL>
set linesize112
set pages 999
col LHNAM for a35
col LHRLS for a15
select LHSEQ,LHNAM,LHRLS,LHRLC from x$kcclh;
SQL> set linesize112
SQL> set pages 999
SQL> col LHNAM for a35
SQL> col LHRLS for a15
SQL> select LHSEQ,LHNAM,LHRLS,LHRLC from x$kcclh;
LHSEQ LHNAM LHRLS LHRLC
1 /u01/archive/1_1_805858745.dbf 330515 01/28/2013 01:39:05 2 /u01/archive/1_2_805858745.dbf 330515 01/28/2013 01:39:05 3 /u01/archive/1_3_805858745.dbf 330515 01/28/2013 01:39:05 4 /u01/archive/1_4_805858745.dbf 330515 01/28/2013 01:39:05 5 /u01/archive/1_5_805858745.dbf 330515 01/28/2013 01:39:05 6 /u01/archive/1_6_805858745.dbf 330515 01/28/2013 01:39:05 7 /u01/archive/1_7_805858745.dbf 330515 01/28/2013 01:39:05 8 /u01/archive/1_8_805858745.dbf 330515 01/28/2013 01:39:05 9 /u01/archive/1_9_805858745.dbf 330515 01/28/2013 01:39:05 10 /u01/archive/1_10_805858745.dbf 330515 01/28/2013 01:39:05 11 /u01/archive/1_11_805858745.dbf 330515 01/28/2013 01:39:05 12 /u01/archive/1_12_805858745.dbf 330515 01/28/2013 01:39:05 13 /u01/archive/1_13_805858745.dbf 330515 01/28/2013 01:39:05 14 /u01/archive/1_14_805858745.dbf 330515 01/28/2013 01:39:05 15 /u01/archive/1_15_805858745.dbf 330515 01/28/2013 01:39:05 16 /u01/archive/1_16_805858745.dbf 330515 01/28/2013 01:39:05 17 /u01/archive/1_17_805858745.dbf 330515 01/28/2013 01:39:05 18 /u01/archive/1_18_805858745.dbf 330515 01/28/2013 01:39:05 19 /u01/archive/1_19_805858745.dbf 330515 01/28/2013 01:39:05 20 /u01/archive/1_20_805858745.dbf 330515 01/28/2013 01:39:05 21 /u01/archive/1_21_805858745.dbf 330515 01/28/2013 01:39:05 22 /u01/archive/1_22_805858745.dbf 330515 01/28/2013 01:39:05 23 /u01/archive/1_23_805858745.dbf 330515 01/28/2013 01:39:05 24 /u01/archive/1_24_805858745.dbf 330515 01/28/2013 01:39:05 25 /u01/archive/1_25_805858745.dbf 330515 01/28/2013 01:39:05 26 /u01/archive/1_26_805858745.dbf 330515 01/28/2013 01:39:05 27 /u01/archive/1_27_805858745.dbf 330515 01/28/2013 01:39:05 28 /u01/archive/1_28_805858745.dbf 330515 01/28/2013 01:39:05 29 /u01/archive/1_29_805858745.dbf 330515 01/28/2013 01:39:05 30 /u01/archive/1_30_805858745.dbf 330515 01/28/2013 01:39:05 31 /u01/archive/1_31_805858745.dbf 330515 01/28/2013 01:39:05
31 rows selected.
SQL>
SQL> select rtnum “thread#”,decode(bitand(rtsta,128), 128, ‘FB_ENABLED_FOR_THREAD’,’FB_DISABLED_FOR_THREAD’) “FLASHBACK” from x$kccrt;
thread# FLASHBACK
1 FB_DISABLED_FOR_THREAD
SQL> col RTCKP_SCN for a15
SQL> col RTENB for a15
SQL> l
1* select RTCKP_SCN,RTCKP_RBA_SEQ,RTCKP_RBA_BNO,RTCKP_RBA_BOF,RTSEQ,RTENB from x$kccrt
SQL> /
RTCKP_SCN RTCKP_RBA_SEQ RTCKP_RBA_BNO RTCKP_RBA_BOF RTSEQ RTENB
522089 32 2 16 32 330515
SQL>
SQL> col name for a55
SQL> select name, checkpoint_change#,to_char(checkpoint_change#,’XXXXXXXXXXXX’) from v$datafile where name like ‘%roger%’;
NAME CHECKPOINT_CHANGE# TO_CHAR(CHECKPOINT_CHANGE#
/test/clonedb/roger01.dbf 522089 7F769
SQL> select checkpoint_change# from v$database;
CHECKPOINT_CHANGE#
522089
SQL>
SQL> select RESETLOGS_CHANGE#, PRIOR_RESETLOGS_CHANGE# ,CHECKPOINT_CHANGE# , CONTROLFILE_SEQUENCE#
2 ,CONTROLFILE_CHANGE#, MIN_REQUIRED_CAPTURE_CHANGE# from v$database;
RESETLOGS_CHANGE# PRIOR_RESETLOGS_CHANGE# CHECKPOINT_CHANGE#
CONTROLFILE_SEQUENCE# CONTROLFILE_CHANGE# MIN_REQUIRED_CAPTURE_CHANGE#
330515 1 522089 821 522089
SQL>
[oracle@lunar clonedb]
[oracle@lunar ~]$ ss
SQL*Plus: Release 11.2.0.3.0 Production on Mon Feb 4 16:44:05 2013
Copyright (c) 1982, 2011, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL> recover datafile 5;
ORA-00279: change 521392 generated at 08/16/2012 03:07:34 needed for thread 1
ORA-00289: suggestion : /u01/archive/1_27_805858745.dbf
ORA-00280: change 521392 for thread 1 is in sequence #27
Specify log: {=suggested | filename | AUTO | CANCEL}
auto
ORA-00279: change 521876 generated at 08/16/2012 03:21:17 needed for thread 1
ORA-00289: suggestion : /u01/archive/1_28_805858745.dbf
ORA-00280: change 521876 for thread 1 is in sequence #28
ORA-00279: change 521884 generated at 08/16/2012 03:21:35 needed for thread 1
ORA-00289: suggestion : /u01/archive/1_29_805858745.dbf
ORA-00280: change 521884 for thread 1 is in sequence #29
Log applied.
Media recovery complete.
SQL>
[oracle@lunar ~]$ ss
SQL*Plus: Release 11.2.0.3.0 Production on Mon Feb 4 16:44:05 2013
Copyright (c) 1982, 2011, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL> recover datafile 5;
ORA-00279: change 521392 generated at 08/16/2012 03:07:34 needed for thread 1
ORA-00289: suggestion : /u01/archive/1_27_805858745.dbf
ORA-00280: change 521392 for thread 1 is in sequence #27
Specify log: {=suggested | filename | AUTO | CANCEL}
auto
ORA-00279: change 521876 generated at 08/16/2012 03:21:17 needed for thread 1
ORA-00289: suggestion : /u01/archive/1_28_805858745.dbf
ORA-00280: change 521876 for thread 1 is in sequence #28
ORA-00279: change 521884 generated at 08/16/2012 03:21:35 needed for thread 1
ORA-00289: suggestion : /u01/archive/1_29_805858745.dbf
ORA-00280: change 521884 for thread 1 is in sequence #29
Log applied.
Media recovery complete.
SQL>
[oracle@lunar ~]
[oracle@lunar ~]$
SQL> recover datafile 5;
ORA-00279: change 521392 generated at 08/16/2012 03:07:34 needed for thread 1
ORA-00289: suggestion : /u01/archive/1_27_805858745.dbf
ORA-00280: change 521392 for thread 1 is in sequence #27
Specify log: {=suggested | filename | AUTO | CANCEL}
auto
ORA-00279: change 521876 generated at 08/16/2012 03:21:17 needed for thread 1
ORA-00289: suggestion : /u01/archive/1_28_805858745.dbf
ORA-00280: change 521876 for thread 1 is in sequence #28
ORA-00308: cannot open archived log ‘/u01/archive/1_28_805858745.dbf’
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
SQL>
kscnbas/kcvcptim/kcvfhcpc/kcvfhccc
一般数据库启动会校验如下4个地方来验证数据库一致性:
1.kscnbas 数据文件最后一次检查点的SCN
2.kcvcptim 数据文件最后一次检查点的时间
3.kcvfhcpc ,检查点计数
4.kcvfhccc ,总是比检查点计数小1
BBED> p kcvfhckp
struct kcvfhckp, 36 bytes @484
struct kcvcpscn, 8 bytes @484
ub4 kscnbas @484 0x0007f694 521876
ub2 kscnwrp @488 0x0000
ub4 kcvcptim @492 0x2f2c5b2d
ub2 kcvcpthr @496 0x0001
union u, 12 bytes @500
struct kcvcprba, 12 bytes @500
ub4 kcrbaseq @500 0x0000001c
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
BBED>
BBED> p kcvfhcpc
ub4 kcvfhcpc @140 0x00000013 19 v$datafile_header.checkpoint_count
BBED> p kcvfhccc
ub4 kcvfhccc @148 0x00000012 18
BBED>
set linesize 112
set pages 999
col LHNAM for a35
col LHRLS for a15
col LHRLC for a20
select LHSEQ,LHNAM,LHRLS,LHRLC from x$kcclh;
SQL> select LHSEQ,LHNAM,LHRLS,LHRLC from x$kcclh;
LHSEQ LHNAM LHRLS LHRLC
1 /u01/archive/1_1_805858745.dbf 330515 01/28/2013 01:39:05 2 /u01/archive/1_2_805858745.dbf 330515 01/28/2013 01:39:05 3 /u01/archive/1_3_805858745.dbf 330515 01/28/2013 01:39:05 4 /u01/archive/1_4_805858745.dbf 330515 01/28/2013 01:39:05 5 /u01/archive/1_5_805858745.dbf 330515 01/28/2013 01:39:05 6 /u01/archive/1_6_805858745.dbf 330515 01/28/2013 01:39:05 7 /u01/archive/1_7_805858745.dbf 330515 01/28/2013 01:39:05 8 /u01/archive/1_8_805858745.dbf 330515 01/28/2013 01:39:05 9 /u01/archive/1_9_805858745.dbf 330515 01/28/2013 01:39:05 10 /u01/archive/1_10_805858745.dbf 330515 01/28/2013 01:39:05 11 /u01/archive/1_11_805858745.dbf 330515 01/28/2013 01:39:05 12 /u01/archive/1_12_805858745.dbf 330515 01/28/2013 01:39:05 13 /u01/archive/1_13_805858745.dbf 330515 01/28/2013 01:39:05 14 /u01/archive/1_14_805858745.dbf 330515 01/28/2013 01:39:05 15 /u01/archive/1_15_805858745.dbf 330515 01/28/2013 01:39:05 16 /u01/archive/1_16_805858745.dbf 330515 01/28/2013 01:39:05 17 /u01/archive/1_17_805858745.dbf 330515 01/28/2013 01:39:05 18 /u01/archive/1_18_805858745.dbf 330515 01/28/2013 01:39:05 19 /u01/archive/1_19_805858745.dbf 330515 01/28/2013 01:39:05 20 /u01/archive/1_20_805858745.dbf 330515 01/28/2013 01:39:05 21 /u01/archive/1_21_805858745.dbf 330515 01/28/2013 01:39:05 22 /u01/archive/1_22_805858745.dbf 330515 01/28/2013 01:39:05 23 /u01/archive/1_23_805858745.dbf 330515 01/28/2013 01:39:05 24 /u01/archive/1_24_805858745.dbf 330515 01/28/2013 01:39:05 25 /u01/archive/1_25_805858745.dbf 330515 01/28/2013 01:39:05 26 /u01/archive/1_26_805858745.dbf 330515 01/28/2013 01:39:05 27 /u01/archive/1_27_805858745.dbf 330515 01/28/2013 01:39:05 28 /u01/archive/1_28_805858745.dbf 330515 01/28/2013 01:39:05 29 /u01/archive/1_29_805858745.dbf 330515 01/28/2013 01:39:05 30 /u01/archive/1_30_805858745.dbf 330515 01/28/2013 01:39:05 31 /u01/archive/1_31_805858745.dbf 330515 01/28/2013 01:39:05
31 rows selected.
SQL>
SQL> col rtckp for a10
SQL> col rtenb for a10
SQL> l
1* select RTCKP_SCN,RTCKP_RBA_SEQ,RTCKP_RBA_BNO,RTCKP_RBA_BOF,RTSEQ,RTENB from x$kccrt
SQL> /
RTCKP_SCN RTCKP_RBA_SEQ RTCKP_RBA_BNO RTCKP_RBA_BOF RTSEQ RTENB
522089 32 2 16 32 330515
SQL>
SQL> select SEQUENCE#, RESETLOGS_CHANGE# , FIRST_CHANGE# ,NEXT_CHANGE#,NEXT_CHANGE# from v$archived_log;
SEQUENCE# RESETLOGS_CHANGE# FIRST_CHANGE# NEXT_CHANGE# NEXT_CHANGE#
1 330515 330515 337841 337841 2 330515 337841 341520 341520 3 330515 341520 346876 346876 4 330515 346876 368713 368713 5 330515 368713 374648 374648 6 330515 374648 381043 381043 7 330515 381043 387102 387102 8 330515 387102 389802 389802 9 330515 389802 394303 394303 10 330515 394303 400362 400362 11 330515 400362 405241 405241 12 330515 405241 411904 411904 13 330515 411904 418076 418076 14 330515 418076 422666 422666 15 330515 422666 445513 445513 16 330515 445513 474666 474666 17 330515 474666 495145 495145 18 330515 495145 517364 517364 19 330515 517364 520726 520726 20 330515 520726 520773 520773 21 330515 520773 520780 520780 22 330515 520780 520783 520783 23 330515 520783 520875 520875 24 330515 520875 521331 521331 25 330515 521331 521334 521334 26 330515 521334 521337 521337 27 330515 521337 521876 521876 28 330515 521876 521884 521884 29 330515 521884 521887 521887 30 330515 521887 522050 522050 31 330515 522050 522089 522089
31 rows selected.
SQL> select SEQUENCE#, RESETLOGS_CHANGE# , FIRST_CHANGE# ,NEXT_CHANGE#,NEXT_CHANGE#
from v$$archived_log where sequence#>=28;
SQL> select SEQUENCE#, RESETLOGS_CHANGE# , FIRST_CHANGE# ,NEXT_CHANGE#,NEXT_CHANGE#
2 from v$archived_log
3 where sequence#>=28
4 ;
SEQUENCE# RESETLOGS_CHANGE# FIRST_CHANGE# NEXT_CHANGE# NEXT_CHANGE#
28 330515 521876 521884 521884 29 330515 521884 521887 521887 30 330515 521887 522050 522050 31 330515 522050 522089 522089
SQL>
BBED> p kcvfhckp
struct kcvfhckp, 36 bytes @484
struct kcvcpscn, 8 bytes @484
ub4 kscnbas @484 0x0007f694 521876 改为 521884=0007F69C 9CF60700
ub2 kscnwrp @488 0x0000
ub4 kcvcptim @492 0x2f2c5b2d
ub2 kcvcpthr @496 0x0001
union u, 12 bytes @500
struct kcvcprba, 12 bytes @500
ub4 kcrbaseq @500 0x0000001c 28 改为29=1D
ub4 kcrbabno @504 0x00000002 2
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
BBED>
BBED> p kcvfhcpc
ub4 kcvfhcpc @140 0x00000013 19 v$datafile_header.checkpoint_count
BBED> p kcvfhccc
ub4 kcvfhccc @148 0x00000012 18
BBED>
BBED> m /x 9CF60700 OFFSET 484
BBED-00209: invalid number (9CF60700)
BBED> m /x 9cf6 offset 484
File: /test/clonedb/roger01.dbf (5)
Block: 1 Offsets: 484 to 995 Dba:0x01400001
9cf60700 00000000 2d5b2c2f 01000000 1c000000 02000000 0000097f 02000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
0d000d00 0d000100 00000000 00000000 00000000 02004001 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
<32 bytes per line>
BBED> m /x 0700 offset 486
File: /test/clonedb/roger01.dbf (5)
Block: 1 Offsets: 486 to 997 Dba:0x01400001
07000000 00002d5b 2c2f0100 00001c00 00000200 00000000 097f0200 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000d00
0d000d00 01000000 00000000 00000000 00000200 40010000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
<32 bytes per line>
BBED> p kcvfhckp
struct kcvfhckp, 36 bytes @484
struct kcvcpscn, 8 bytes @484
ub4 kscnbas @484 0x0007f69c
ub2 kscnwrp @488 0x0000
ub4 kcvcptim @492 0x2f2c5b2d
ub2 kcvcpthr @496 0x0001
union u, 12 bytes @500
struct kcvcprba, 12 bytes @500
ub4 kcrbaseq @500 0x0000001c
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
BBED> sum apply
Check value for File 5, Block 1:
current = 0x6498, required = 0x6498
BBED>
BBED> set count 16
COUNT 16
BBED> d
File: /test/clonedb/roger01.dbf (5)
Block: 1 Offsets: 500 to 515 Dba:0x01400001
1c000000 02000000 0000097f 02000000
<32 bytes per line>
BBED> m /x 1d
File: /test/clonedb/roger01.dbf (5)
Block: 1 Offsets: 500 to 515 Dba:0x01400001
1d000000 02000000 0000097f 02000000
<32 bytes per line>
BBED> d
File: /test/clonedb/roger01.dbf (5)
Block: 1 Offsets: 500 to 515 Dba:0x01400001
1d000000 02000000 0000097f 02000000
<32 bytes per line>
BBED> sum apply
Check value for File 5, Block 1:
current = 0x6499, required = 0x6499
BBED>
BBED> verify
DBVERIFY - Verification starting
FILE = /test/clonedb/roger01.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
BBED>
SQL> recover datafile 5;
ORA-00279: change 521884 generated at 08/16/2012 03:21:17 needed for thread 1
ORA-00289: suggestion : /u01/archive/1_29_805858745.dbf
ORA-00280: change 521884 for thread 1 is in sequence #29
Specify log: {=suggested | filename | AUTO | CANCEL}
auto
Log applied.
Media recovery complete.
SQL> alter database datafile 5 online;
Database altered.
SQL> alter database open;
Database altered.
转自:http://m.blog.csdn.net/lunar2000/article/details/8570856
- 用bbed修改数据文件头,跳过丢失的归档
- 用bbed修改数据文件头,跳过丢失的归档
- 【Oracle】使用BBED跳过丢失的归档
- 使用bbed跳过丢失的归档进行recover datafile
- BBED跳过归档恢复
- 用归档日志恢复丢失的数据文件
- 使用bbed修改文件头,推进scn,恢复offline drop的数据文件
- oracle跳过丢失的归档恢复datafile
- 利用BBED恢复数据文件头
- 使用BBED跳过归档进行恢复
- 误删数据文件后,使用bbed修改数据文件头,启动数据库
- 跳过丢失归档进行恢复
- Oracle RMAN Recover中使用BBED 跳过缺失的归档 继续 Recover 的测试
- Oracle RMAN Recover中使用BBED 跳过缺失的归档 继续 Recover 的测试 .
- Oracle RMAN Recover中使用BBED 跳过缺失的归档 继续 Recover 的测试
- Oracle RMAN Recover中使用BBED 跳过缺失的归档 继续 Recover 的测试
- 使用脚本,自动跳过丢失归档的恢复--------MODIFY SEQ
- Oracle非常规恢复(使用BBED跳过归档)
- centos 6.8 + pgsql 9.6 + pldebugger/pldbgapi
- android imageView释放内存
- java基础
- spring boot集成mybatis,枚举类型字段注册通用
- SQL LEFT JOIN 关键字
- 用bbed修改数据文件头,跳过丢失的归档
- 循环神经网络(Recurrent Neural Network)
- 微信小程序----导航栏透明渐变二
- Android动画解析(二)-----属性动画
- golang语言中map的初始化及使用
- [POJ-2387]Til the Cows Come Home
- 33. Search in Rotated Sorted Array
- SQL AND & OR (运算符)
- 按住鼠标左键直接拖动页面,横向滚动