- 博客(3)
- 收藏
- 关注
原创 create control file 测试3种情况
Case 1: 正常关闭的DB-create control file noresetlogsCase 2: Abort关闭的DB-create control file noresetlogsCase 3: 正常关闭的DB-create control file resetlogs -->Case 1: 正常关闭的DB-create control file noresetlog
2013-07-05 17:40:58 1291
原创 利用flashback_transaction_query表撤销已提交的修改
select versions_xid, versions_operation from test versions between scn minvalue and maxvalue; --SCNselect versions_starttime, versions_endtime, versions_xid, versions_op
2013-07-05 16:40:03 648
原创 修复 block corruption
select dbms_rowid.rowid_relative_fno(t.rowid),dbms_rowid.rowid_block_number(t.rowid) from test t;select * from dba_extents t where t.FILE_ID=4 and 131 between t.BLOCK_ID and t.BLOCK_ID+t.BLOCKS-1;
2013-07-05 10:19:06 728
空空如也
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人