冷备份 dd不完全恢复

湖北佛

sys@OMREP> create table t(a int) tablespace users;


Table created.

sys@OMREP> @scott 10000
old   2: for i in 1..&1 loop
new   2: for i in 1..10000 loop

PL/SQL procedure successfully completed.

sys@OMREP> commit;

Commit complete.

sys@OMREP> shutdown immediate;

dd if=/u01/app/oracle/oradata/omrep/users01.dbf of=/u01/app/oracle/oradata/omrep/users01.bak

sys@OMREP> startup

sys@OMREP> Select rowid,dbms_rowid.rowid_relative_fno(rowid)rel_fno,dbms_rowid.rowid_block_number(rowid)blockno,dbms_rowid.rowid_row_number(rowid) rowno,a from t where a=9999;

ROWID                 REL_FNO    BLOCKNO      ROWNO          A
------------------ ---------- ---------- ---------- ----------
AAADceAAEAAAFQOABi          4      21518         98       9999

sys@OMREP> update t set a=8888 where a=9999;

1 row updated.


sys@OMREP> commit;

Commit complete.

sys@OMREP> shutdown immediate;

[oracle@localhost ~]$ dd if=/u01/app/oracle/oradata/omrep/users01.bak of=/u01/app/oracle/oradata/omrep/users01.dbf bs=8192 count=1 conv=notrunc skip=21518 seek=21518

sys@OMREP> startup

sys@OMREP> select * from t where a=9999;

         A
----------
      9999

居然没有出错，