Introduction to Oracle Logical backup knowledge

1, logical backup and physical backup differences

1 Physical Backup: Backup data files and control files, backup the physical structure of the entire library, mainly for media recover

2 logical backup: Back up the data structure and data of the objects in the database, as a supplement to the physical backup, not for media recover;

Used primarily for backup or data migration to a single table, but recovery can only be restored to the backup point.

2, the use of exp

(1) EMP parameter description

C:\users\cuug>exp-help

Export:release 10.2.0.1.0-production on Friday March 23 11:38:07 2012

Copyright (c) 1982, +, Oracle. All rights reserved.

Export by entering the EXP command and your username/password

Action prompts you to enter parameters:

For example: EXP Scott/tiger

Alternatively, you can control the export by entering the EXP command with various parameters

Operation mode. To specify a parameter, you can use the keyword:

Format: EXP keyword=value or keyword= (value1,value2,..., Valuen)

Example: EXP scott/tiger grants=y tables= (emp,dept,mgr)

or tables= (T1:P1,T1:P2), if T1 is a partitioned table

USERID must be the first parameter in the command line.

Keyword description (default value) keyword description (default)

--------------------------------------------------------------------------

USERID username/password Full export entire file (N)

Buffer Data buffer size owner owner user Name list

File output file (expdat.dmp) table List of tables

COMPRESS Import to a zone (Y) RecordLength IO record length

Grants Export Permission (Y) Inctype Incremental Export type

INDEXES Export Index (Y) record tracking incremental export (Y)

Direct directly path (N) triggers export trigger (Y)

Log screen output logs file STATISTICS Analysis Object (estimate)

Rows Export data row (Y) parfile parameter file name

Consistent cross table consistency (N) CONSTRAINTS export constraint (Y)

Object_consistent transactions that are set to read-only during object export (N)

FEEDBACK Show progress per x line (0)

FILESIZE the maximum size of each dump file

FLASHBACK_SCN is used to set the session snapshot back to the previous state of the SCN

Flashback_time is used to get the SCN time closest to the specified time

Select clause used by QUERY to export a subset of tables

Resumable hangs (N) when it encounters a space-related error

This article URL address: http://www.bianceng.cn/database/Oracle/201410/45558.htm

Resumable_name the text string used to identify recoverable statements

Resumable_timeout Resumable's Waiting time

Tts_full_check perform a full or partial dependency check on TTS

tablespaces List of table spaces to export

Transport_tablespace export of removable tablespace metadata (N)

TEMPLATE Call IAS-mode exported template name

The export was successfully terminated and no warning occurred.

(2) The application of exp

1) Export the entire database

[Oracle@work dat]$ exp system/oracle file=/home/oracle/dat/prod.dmp

Log=/home/oracle/dat/prod.log

Indexes=n full=y

2 Export all objects of schema

[Oracle@work dat]$ exp scott/tiger file=scott.dmp log=scott.log indexes=n Owner=scott

3) export a single table

[Oracle@work dat]$ exp scott/tiger file=emp_dept.dmp log=table.log indexes=n tables= (emp,dept);

-------to export data in a table or table by condition

[Oracle@work dat]$ exp scott/tiger file=emp_30.dmp log=emp.log indexes=n tables=emp ' where query=\ '

3, the use of IMP

(1) Imp's parameter description

C:\users\cuug>imp-help