《Oracle备份恢复之13逻辑备份ppt课件.ppt》由会员分享,可在线阅读,更多相关《Oracle备份恢复之13逻辑备份ppt课件.ppt(21页珍藏版)》请在三一办公上搜索。
1、Export and Import Utilities,Objectives,After completing this lesson, you should be able to do the following:Describe the uses of the Export and Import utilitiesDescribe Export and Import concepts and structuresPerform simple Export and Import operationsList guidelines for using Export and Import,Ora
2、cle Export and Import Utilities,Export,Import,Oracle Export and Import Utility Overview,You can use these utilities to do the following:Archive historical dataSave table definitions to protect them from user error failureMove data between machines and databases or between different versions of the O
3、racle serverTransport tablespaces between databases,Methods of Invoking the Export and Import Utilities,Command-line interfaceAn interactive dialogParameter filesOracle Enterprise Manager,Full Database ModeTables definitionsTables dataGrantsIndexesTables constraints,Export Modes,Table ModeTable defi
4、nitionsTable data (all or selected rows)Owners table grantsOwners table indexesTable constraints,User ModeTables definitionsTables dataOwners grants Owners indexesTables constraints,Tablespace ModeTable definitionsGrantsIndexesTable constraintsTriggers,Invoking Export,Syntax:Examples:,exp hr/hr TABL
5、ES=employees,departments rows=y file=exp1.dmp,exp keyword = value, value2, ,valuen,exp system/manager OWNER=hr direct=yfile=expdat.dmp,exp username/password AS SYSDBA TRANSPORT_TABLESPACE=y TABLESPACES=ts_emp log=ts_emp.log,Using the Export Wizard,Direct-Path Export Concepts,Buffercache,Generate SQL
6、commands,Write blocks,Direct Path,Dump file,Export,Export,Oracle Server,Read blocks,Evaluatingbuffer,TTCbuffer,Buffercachemanager,SQLcommandprocessing,Two-Taskcommon(TTC),Direct Path,Conventional Path,Direct-Path Export Features,The type of Export is indicated on the screen output, export dump file,
7、 and the log file.Data is already in the format that Export expects, avoiding unnecessary data conversion.Uses an optimized SQL SELECT statement.,Direct-Path Export Restrictions,The direct-path option cannot be invoked interactively.Client-side and server-side character sets must be the same.The BUF
8、FER parameter has no affect.,Specifying Direct-Path Export,As command line argument to the Export command: As a keyword in a parameter file:,exp parfile=,exp userid=hr/hr full=y direct=y,Uses of the Import Utility for Recovery,Create table definitionsExtract data from a valid Export fileImport from
9、a complete or cumulative Export fileRecover from user-error failures,Import Modes,Mode DescriptionTable Import specified tables into a schema. User Import all objects that belong to a schemaTablespace Import all definitions of the objects contained in the tablespaceFull Database Import all objects f
10、rom the export file,Invoking Import,Syntax:Examples:,imp hr/hr TABLES=employees,departments rows=y file=exp1.dmp,imp keyword = value or keyword = value, value2, value n,imp system/manager FROMUSER=hr file=exp2.dmp,imp username/password AS SYSDBA TRANSPORT_TABLESPACE=y TABLESPACES=ts_employees,Using
11、the Import Wizard,Invoking Import as SYSDBA,You need to invoke Import as SYSDBA under the following conditions:At the request of Oracle technical supportWhen importing a transportable tablespace setTo invoke Import as SYSDBA:,imp username/password AS SYSDBA,Import Process Sequence,1. New tables are
12、created2. Data is imported3.Indexes are built4. Triggers are imported5.Integrity constraints are enabled on the new tables6. Any bitmap, functional, and/or domain indexes are built,Globalization Support Considerations,The Export file identifies the character encoding scheme that is used for the char
13、acter data in the file.The Import utility translates data to the character set of its host system.A multibyte character set Export file must be imported into a system that has the same characteristics.,Summary,In this lesson, you should have learned how to:Describe the uses of Export and ImportDescribe Export and Import concepts and structuresPerform simple Export and Import operationsList guidelines for using Export and Import,Practice 18 Overview,This practice covers the following topics:Using the Export utilityUsing the Import utility,