oracle导入导出学习(3)

--------------------------------------------------------------------- temporary表空间的文件丢失: 增加新的临时文件

alter tablespace temp add tempfile

'/opt/oracle/oradata/alvin/temp02.dbf' size 10m reuse; 删除无效的临时文件的指针

alter database tempfile '/opt/oracle/oradata/alvin/temp01.dbf' drop;

--------------------------------------------------------------------- 无备份的还原和恢复: 表空间创建于归档之后，所有的日志都必须存在！！！！

根据控制文件制作空的数据文件: alter database create datafile 7; recover datafile 7;

--------------------------------------------------------------------- 热备份全库:

alter database backup controlfile to '/home/alvin/hotbk/control01.ctl';

热备份所有的数据文件:

select 'alter tablespace '||tablespace_name||' begin backup;'||chr(10)||'!cp -v '||file_name||'

/home/alvin/hotbk'||chr(10)||'alter tablespace '||tablespace_name||' end backup;'

from dba_data_files;

alter system checkpoint; alter system switch logfile;

--------------------------------------------------------------------- 主动的不完全恢复:

确定灾难产生时间点 : 日志挖掘 (log miner) select sequence#,name from v$archived_log;

--产生挖掘队列: exec

dbms_logmnr.add_logfile('/opt/oracle/flash_recovery_area/A/archivelog/2013_07_16/o1_mf_1_37_8y9cl73r_.arc',dbms_logmnr.new); exec

dbms_logmnr.add_logfile('/opt/oracle/flash_recovery_area/A/archivelog/2013_07_16/o1_mf_1_38_8y9clvvc_.arc',dbms_logmnr.addfile); exec

dbms_logmnr.add_logfile('/opt/oracle/flash_recovery_area/A/archivelog/2013_07_16/o1_mf_1_39_8y9clwh0_.arc',dbms_logmnr.addfile); --开始挖掘: exec

dbms_logmnr.start_logmnr(options=>dbms_logmnr.dict_from_online_catalog);

--查看挖掘结果:

select scn,sql_redo from v$logmnr_contents where lower(sql_redo) like 'drop%' and seg_name='T01'