sql create table lost_write(t1 int) tablespace users; table created.sql sql insert into lost_write values(1);1 row created.sql commit;commit complete.sql alter system checkpoint;system altered.select dbms_rowid.rowid_block_number(rowid),db
sql> create table lost_write(t1 int) tablespace users; table created.sql> sql> insert into lost_write values(1);1 row created.sql> commit;commit complete.sql> alter system checkpoint;system altered.select dbms_rowid.rowid_block_number(rowid),dbms_rowid.rowid_relative_fno(rowid) from lost_write;dbms_rowid.rowid_block_number(rowid) dbms_rowid.rowid_relative_fno(rowid)------------------------------------ ------------------------------------ 222 6 alter system set db_lost_write_protect=typical;sql> select name from v$datafile where file#=6;name--------------------------------------------------------------------------------/s01/oradata/pdprod/datafile/o1_mf_users_b2wgb20l_.dbfupdate lost_write set t1=9999;alter system flush buffer_cache;dd if=/s01/oradata/pdprod/datafile/o1_mf_users_b2wgb20l_.dbf skip=222 bs=8192 count=1 of=222_blockdd if=222_block of=/s01/oradata/pdprod/datafile/o1_mf_users_b2wgb20l_.dbf seek=222 bs=8192 count=1 conv=notrunc
related posts:
基于行跟踪的rowdependencies ora_rowscn信息12c rman新特性restore/recover from service远程恢复【oracle database 12c新特性】32k varchar2 max_string_size【数据恢复】利用构造rowid实现无备份情况下绕过ora-1578、ora-8103、ora-1410等逻辑/物理坏块问题数据恢复：模拟2个逻辑坏块know about oracle high water mark【oracle database 12c新特性】 in-database archiving数据库内归档exadata混合列压缩如何处理insert和update为12.1 dataguard配置dgmgrl遇到ora-16698omf下restore oracle datafile的优先级问题 原文地址：about db_lost_write_protect, 感谢原作者分享。