随笔分类 - Oracle 11G新特性
摘要：Oracle 数据引擎ORACLE_LOADER 用户只能从外部读取表数据，但是不能将数据库中的数据卸载到操作系统文件中.ORACLE_DATAPUMP 用户不仅可以从外部表中读取数据，同时可以将数据库中复杂的数据查询后卸载到操作系统文件中.External TablesExternal tables are read-only tables stored as files on the operating outside of the Oracle database.External Table BenefitsData can be used directly from the exter
阅读全文
摘要：使用SQL*Loader可以替换已有的数据.在SQL*Loader中replace这种命令就可以.truncate与sql loader中的replace有什么区别，truncate要比replace快,使用replace 进行数据替换之前，首先得先删除原有的数据，然后再添加新的数据，replace的删除，会触发删除对应的触发器，而truncate则不会.sql loader可以过滤掉无效的数据，将不符合条件的数据排除在数据库之外.使用sql loader可以从多个数据源中加载，加载到数据库中的时候可以插入到多个数据库表中.执行sql loader的时候，需要将操作系统上的执行批量作业的功能打
阅读全文
摘要：本集视频与上集视频为一个整体，具体内容参照上片文章.
阅读全文
摘要：/*实验目的：使用impdp and expdmp实验步骤:test user ->create table -> emp1test user -> create index -> emp1create directory -> test_dir -> grantgrant create any directory to test;--授权创建目录对象create directory test_dir as '/RealData/oracle/backup/data_pump';--创建目录对象drop directory test_dir;
阅读全文
摘要：Data Pump Export using Database ControlData Pump Export Example:Basic OptionsData Pump Export Example:Advanced OptionsData Pump Export Example:FilesData Pump Export Example:ScheduleData Pump Export Example:ReviewData Pump Import Example:impdpData Pump Import:Transformations在原来的导入导出过程中，假如导出的表所在表空间为sy
阅读全文
摘要：Directory Object（目录对象）其拥有者是SYS；Directory Objects for Data PumpCreating Directory ObjectsData Pump Export and Import Clients :OverviewData Pump导出、导入原理：在导入、导出过程中，进程会创建一个Master Table来记录实时的导入、导出的状态信息，一旦导入、导出操作完成，这个Master Table便会被进程清除；Database link(DBLINK)实现Source与Target之间的直接导入导出工作.Data Pump Utility:Inte
阅读全文
摘要：数据泵与原始Imp、exp命令比较Data pump是一个服务器端的工具;数据泵可以实现暂停功能;imp、exp是一个客户端的工具;Oracle Data Pump:OverviewAs a server-based facility for high-speed data and metadata movement,Oracle Data Pump:Is callable via DBMS_DATAPUMPProvides the following toolsexpdpimpdpWeb-based interfaceProvides four data movement methodsDa
阅读全文
摘要：ObjectivesAfter completing this lesson,you should be able to:Describe ways to move dataCreate and use directory objectsUse SQL*Loader to load data from a non-Oracle database(or user files)Use external tables to move data via platform-independent filesExplain the general architecture of Oracle Data P
阅读全文
摘要：健康检查项目指标信息SQL> select name,internal_check,offline_capable,description from v$hm_check order by 2,3;NAME I O DESCRIPTION------------------------------ - - ---------------------------------------------Transaction Integrity Check N N Checks a transaction for corruptionsDict...
阅读全文
摘要：Automatic Diagnostic WorkflowAutomatic Diagnostic Repository查看ADR(Automatic Diagnositc Repository)方法有三:通过OEM support workbenchADRCI - ADR Command-Line(ADR命令行)V$DIAG_INFO(动态性能视图)The ADR Command-Line Tool(ADRCI)ADRCI procides interaction with ADR from an operating system prompt.Using ADRCI,you can vie
阅读全文
摘要：合并于上一章节:http://www.cnblogs.com/arcer/archive/2013/06/05/3119511.html
阅读全文
摘要：/* 实验目的:db_block corrupt recover*/configarchive logflashbackparametercreate tablespace---app_testbackup-rman破坏check block-dbv-rmanstartuprecover blockcheck block1、configSQL> archive log list;Database log mode Archive ModeAutomatic archival EnabledArchive destination ...
阅读全文
摘要：oracle在内存中操作数据块，达到一定条件后，往磁盘文件上去读或者写的时候，会检查是否存在坏块.db_block_checksum参数设置成off的时候，Oracle只针对系统表空间的数据块进行检查，非系统表空间则不关心.假如db_block_checksum=typical，oracle会在由内存写到磁盘的时候，会检查是否存在坏块.假如db_block_checksum=full，oracle会在执行DML操作之前，都会检查是否存在坏块.不管是内存中的还是磁盘上的块,只要发生insert，delete，update发生多少次就会检查多少次，如果是内存中的，当往磁盘中写的时候还要检查，提高了
阅读全文
摘要：What is blokc corruption?Whenver a block is read or written,a consistency check is performed.Block versionDBA(data block address) value in cache as compared to the DBA value in the block bufferBlcok-checjsum,if enabledA corrupt block is identified as being one of the following:Media corruptLogically
阅读全文
摘要：/* 说明：oracle 11g才拥有数据库恢复专家功能 实验目的：使用数据库恢复专家恢复数据库 实验步骤：tablespace--app_databackup---datafile-app_data_01.dbf-rman破坏recover-data recover advisor-rman */1、准备实验环境 创建表空间APP_DATA 创建用户TESTSQL> CREATE TABLESPACE APP_DATA DATAFILE 'D:\APP\MARYHU\ORADATA\ARCERZHANGDB\APP_DATA_01.dbf' SIZE 200M AUTO
阅读全文
摘要：数据库恢复专家，在进行修复的时候，有2个项选，其中之一是无损修复，另外一种是有损修复，可供DBA选择.执行ADVISE FAILURE与REPAIR FAILURE命令，必须是在同一个SESSION当中.修复工作，是无法并发操作的.使用数据库恢复专家，有两种途径：OEM方式及Manual方式，接下来介绍一下Manual方式Listing Data FailuresThe RMAN LIST FAILURE command lists previously executed failure assessment.Including newly diagnosed failuresRemoving
阅读全文
摘要：Data Recovery AdvisorReducing down time by eliminating confusion:Data FailuresData Failure:ExamplesNot accessible components,for example:Missing data files at the OS levelIncorrect access permissionsOffline tablespace,and so onPhysical corruptions,such as block checksum failures or invalid block hea
阅读全文
摘要：oracle 10g、11g能够做到恢复指定的、被破坏的块.ObjectivesAfter completing this lesson,you should be able to :Detect and repair database corruptionHandle block corruptionSet up Automatic Diagnostic RepositoryRun health checksData Recovery AdvisorFast detection,analysis,and repair of failuresMinimizing disruptions for
阅读全文
摘要：SQL Performance Analyzer : OverviewTarget users:DBAs,QAs,application developersHelps predict the impact of system changes on SQL workload response time.Builds different versions of SQL workload performance (that is,SQL execution plans and execution statistics)Executes SQL serially(concurrency not ho
阅读全文
摘要：SQL Access Advisor:OverviewTypical SQL Access Advisor SessionWorkload SourceRecommendation OptionsReviewing Recommendations
阅读全文
浙公网安备 33010602011771号