常用语句（一）

--查坏快
select * from v$database_block_corruption order by block#;
select * from v$database_block_corruption where file#=1 order by block#;
select file#,block#,blocks ,marked_corrupt from v$backup_corruption;

--检查坏块
D:\>rman target /
　　RMAN> backup validate datafile 2;

select * from v$database_block_corruption where file#=2;
--执行恢复
RMAN> blockrecover datafile 2 block 14 from backupset;

----重建临时表空间
select * from v$tempfile;
select * from dba_tablespaces where contents='TEMPORARY';
select * from dba_tablespaces where contents='UNDO';
select * from dba_tablespaces where contents='PERMANENT';
select * from dba_users where temporary_tablespace='TEMP01' ;

create temporary tablespace temp01 tempfile '/oracle/oradata/hmisb2/temp01.dbf' size 3072m reuse
  autoextend on next 640k maxsize 6144m;

--增加临时文件

alter  tablespace temp add tempfile 'D:\ORACLE\AUXDB\DATA\temp01.dbf' size 100m reuse
  autoextend on next 640k maxsize 200m;

alter database default temporary tablespace temp01;

drop tablespace temp including contents and datafiles;

--redo
ALTER   DATABASE   ADD   LOGFILE   GROUP   4  
  ('/oracle/oradata/hmisb2/redo04.log',  
    '/oracle/oradata/hmisb3/datafile/redo04_2.log')   size   100M   reuse; 
ALTER   DATABASE   ADD   LOGFILE   GROUP   5  
  ('/oracle/oradata/hmisb2/redo05.log',  
    '/oracle/oradata/hmisb3/datafile/redo05_2.log')   size   100M   reuse; 

alter   system   switch   logfile; 

alter   database   drop   logfile   group   1;
alter   database   drop   logfile   group   3;

select * from tdbdd.ct23;

--log
select group#,members,sequence#,status,bytes/1024/1024,first_change#  from v$log;
select member,status from v$logfile where group#=1;

--列出要备份的数据文件和控制文件
select name from v$datafile
union
select name from v$controlfile;

--列出需要恢复的数据文件
select file#,error,change# from v$recover_file;
--列出恢复要使用的归档日志
select sequence#,archive_name from v$recovery_log;