ITPub博客

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, ...

You have following choices to free up space from flash recovery area:1. Consider changing RMAN RETENTION POLICY. If you are using Data Guard,then consider changing RMAN ARCHIVELOG DELETION POLICY.2. B...

[三思笔记]一步一步学DataGuard.zip

ORACLE全面学习Scheduler

Applies to: Oracle Server - Enterprise Edition - Version: 10.2.0.1 to 11.2.0.3 - Release: 10.2 to 11.2Information in this document applies to any platform.Symptoms-- Problem Statement:On 10.2.0.3...

ALTER INDEX &index_name  REBUILD PARTITION &PARTITION_NAME;ALTER INDEX &index_name  REBUILD SUBPARTITION &PARTITION_NAME;

Parallel技术对于一个大的任务，一般的做法是利用一个进程，串行的执行，如果系统资源足够，可以采用parallel技术，把一个大的任务分成若干个小的任务，同时启用n个进程/线程，并行的处理这些小的任务，这些并发的进...

dump 命令dump命令模仿oracle的”alter system dump datafile”命令，解析并显示oracle的块格式。目前支持的块包括文件头（只有部分信息）、数据段头、表和索引数据块，其他的块只显示块头。这已经足够大部分情况的...

In this DocumentPurposeTroubleshooting StepsReferencesApplies to:Oracle Server - Enterprise Edition - Version 10.1.0.2 to 11.1.0.6 [Release 10.1 to 11.1]Information in this document applies to any pla...

1：HP-UNIXdmesg                        在错误日志里面收集诊断系统消息/var/adm/cron/lo...