recover 时需要检查的信息-凯发app官方网站

set lin 200 pages 1000
col next_change# for 999999999999999
col checkpoint_change# for 999999999999999
col member for a55
col name for a65
col file_name for a65
col error for a20
set markup html on
alter session set nls_date_format='yyyy-mm-dd hh24:mi:ss';
spool /tmp/recover_info.html
select dbid,name,open_mode,created,log_mode,checkpoint_change#,controlfile_type ctl_type,controlfile_created ctl_created,controlfile_time ctl_time,resetlogs_change#,resetlogs_time from v$database;
select ts#,file# ,creation_change# ,creation_time,status, enabled, checkpoint_change#, checkpoint_time last_time ,
offline_change#, online_change#, online_time, round(bytes/1024/1024) bytes_m, blocks, create_bytes, block_size, name file_name from v$datafile order by ts#,file#;
select ts#,file#,status,error,format,recover,fuzzy,creation_change#,creation_time,tablespace_name,resetlogs_change#,resetlogs_time,checkpoint_change#,checkpoint_time,
checkpoint_count,bytes,blocks,name,space_header,last_dealloc_change#,undo_opt_current_change# from v$datafile_header order by ts#,file#;
select * from v$recover_file order by 1;
select a.*,b.* from v$log a ,v$logfile b where a.group#=b.group#;
spool off

好大喜功

set pagesize 20000
set linesize 180
set pause off
set serveroutput on
set trims on on
set feedback on
set echo on
set numformat 999999999999999
spool recovery_info.txt
col fn for a60
col status for a15
select substr(name, 1, 50) fn, status from v$datafile;
select substr(name,1,40) fn, recover, fuzzy, checkpoint_change# from v$datafile_header;
select group#,substr(member,1,60) fn from v$logfile;
col error for a30
select * from v$recover_file;
select distinct status from v$backup;
select hxfil filenumber,fhsta stat,fhscn scn,fhrba_seq sequence from x$kcvfh;
select distinct (fuzzy) from v$datafile_header;
spool off
exit

阅读(219) | 评论(0) | 转发(0) |

给主人留下些什么吧！~~

| | | | |

感谢所有关心和支持过chinaunix的朋友们