系統環境
模擬現象
先將數據庫設置為歸檔模式
SQL*Plus
create tablespace test datafile
size
default storage (initial
/
drop user test cascade;
create user test identified by test
default tablespace test;
grant connect
conn test/test
create table a(a number);
insert into a values(
insert into a select * from a;
commit;
拷貝test
insert into a select * from a;
commit;
關閉數據庫
shutdown
刪除test
重新啟動數據庫
這時
與控制文件中記載的log number不一樣
startup mount
需要recover database
C:\>svrmgrl
svrmgrl>connect internal
svrmgrl>shutdown
svrmgrl>startup mount
svrmgrl>set autorecovery on
svrmgrl>recover database;
svrmgrl>alter database open;
conn test/test select count(*) from a;
conn system/manager
alter tablespace test offline;
drop tablespace test INCLUDING CONTENTS;
From:http://tw.wingwit.com/Article/program/Oracle/201311/18828.html