冷备份 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;
$ 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
居然没有出错，
页:
[1]