ITPub博客

转载 http://blog.csdn.net/tianlesoftware/article/details/6307985

PurposeThis article describes similarities and differences between different features available for high availability and distributed systems. It contains comparison between multiple features...

表:alter table_name move tablespace new_tablespace;重建索引表分区:ALTER TABLE PART_TAB MOVE PARTITION "P_412823" TABLESPACE "HROLTPDATA412823" UPDATE INDEXES;索引:alter index indexname rebuild online;...

发现一个用户下统计信息没有生成,查询user_tab_modifications 发现变动信息也超过10%没有警告日志执行exec dbms_stats.gather_schema_stats(ownname => 'test',granularity => 'ALL',cascade => true);还是没有生成...

1. 采用高速的存储设备,提高读写能力，如：EMC 和NetApp， 2. 假如tab1表中的没有数据的话 DROP   TABLE   TAB1;CREATE   TABLE   TAB1   AS   SELECT   *   FRO...

In this DocumentPurposeScopeDetails Description Cause Expected behavior. Block Corruption. Overlapped Extents. Overlapped ASM extent. Oracle defect. Identify th...

在Oracle9i里，Oracle提供了一个内部事件，用以强制刷新Buffer Cache，其语法为:alter session set events 'immediate trace name flush_cache level 1';或者:alter session set events = 'immediate trace name...

分区:Select 'ALTER INDEX '|| index_name ||' rebuild partition ' || PARTITION_NAME || ' TABLESPACE ' || tablespace_name ||';' from USER_IND_PARTITIONS子分区:  S...

In this DocumentSymptomsCauseSolutionReferencesApplies to:Oracle Server - Enterprise Edition - Version 8.1.7.4 and laterInformation in this document applies to any platform.Applies to 8.1.7.4 onwards....

http://blog.csdn.net/tianlesoftware/article/details/4717318

设置参数 DB_FILE_NAME_CONVERT          LOG_FILE_NAME_CONVERT1 主库 startup 2 备库 startup nomount3 主库rman 连接rman target / auxiliary sys/oracle@st180 listbac...

1.restore archivelog all   恢复全部归档日志文件2 restore archivelog from logseq 5 until logseq 8;3  restore archivelog from logseq 5;4 restore archivelog from time 'sysdate-7';5 restore arch...

CATALOG ARCHIVELOG '?/oradata/archive1_30.dbf', '?/oradata/archive1_31.dbf',                  '?/oradata/archive1_32.dbf';CATALOG DATAFILECOPY '?/oradata/u...

1alter system set utl_file_dir='D:\archivelog' scope=spfile;2 重启数据库3BEGINdbms_logmnr_d.build(dictionary_filename=>'dict.ora',dictionary_location=>'D:\archivelog');END;4 增加要分析的文件&...

1  RMAN> BACKUP CHECK LOGICAL VALIDATE DATAFILE n ;select * from v?$database_block_corruption;2 dbv file=EYGLE.DBF blocksize=8192

sql 'alter tablespace users offline for recover';--可选set newname for datafile 4 to '$ORACLE_BASE/product/10.2.0/oradata/oralife/user01.dbf'; restore tablespace users;recover tablespace users;sq...

FLASHBACK TABLE sys_action_info TO BEFORE DROP;select * from  sys_action_info as of timestamp to_timestamp('2009-11-12 15:10:20','yyyy-mm-dd hh24:mi:ss');FLASHBACK TABLE sys_action_info TO to_tim...

backup validate datafile 1;backup validate check logical database;--全库检测select * from v$database_block_corruption where file#=4;blockrecover datafile 4 block 35 from backupset;如需要恢复v$...

-- 1. 检查损坏的对象 SELECT tablespace_name, segment_type, owner, segment_name             FROM dba_extents            WH...

SELECT NAME_,       MAX(DECODE(CLASS, '语文', T.SCORE, 0)) 语文,       MAX(DECODE(CLASS, '数学', T.SCORE, 0)) 数学,       MAX(DECODE(CLASS, ...