Two steps for Oracle database backup and recovery advanced options

Source: Internet
Author: User

In actual operations, the Oracle database backup and recovery advanced options are mainly divided into two steps, including exporting multiple related fixed size files. And how to use N multiple fixed size files to import the actual operation steps.

Oracle database backup and recovery advanced options

1. Split into multiple files

Export using multiple fixed-size files: This method is usually used when the table data volume is large, and a single dump file may exceed the limit of the file system.

$ Exp user/pwd file = 1.dmp, 2.dmp, 3.dmp ,... Filesize = 1000 m log = xxx. log full = y

Import multiple fixed-size files

$ Imp user/pwd file = 1.dmp, 2.dmp, 3.dmp ,... Filesize = 1000 m

Tables = xxx fromuser = dbuser touser = dbuser2 commit = y ignore = y

2. incremental Export/Import

Exp no longer supports inctype after Oracle 9i

You must use SYS or SYSTEM to perform incremental export and import.

Incremental export in Oracle database backup and recovery advanced options: includes three types:

1) "completely" incremental export Complete) // back up the entire database

$ Exp user/pwd file =/dir/xxx. dmp log = xxx. log inctype = complete

2) incremental export and export the data changed after the last backup.

$ Exp user/pwd file =/dir/xxx. dmp log = xxx. log inctype = incremental

3) Cumulative incremental export only exports the changed information in the database after the last full export.

$ Exp user/pwd file =/dir/xxx. dmp log = xxx. log inctype = cumulative

Incremental import: $ imp usr/pwd FULL = y inctype = system/restore/inct ype

Where:

SYSTEM: import SYSTEM objects

RESTORE: import all user objects

3. Export/Import with SYSDBA

1) for Oracle Technical Support

2) used for tablespace Transmission

Example

 
 
  1. :$ imp \'usr/pwd@instance as sysdba\
    ' tablespaces=xx transport_tablespace=y file=xxx.
    dmp datafiles=xxx.dbf $ imp file=expdat.
    dmp userid=“”“sys/password as sysdba”“” 
    transport_tablespace=y“datafile=
    c:tempapp_data,c:tempapp_index)” 

The above is an introduction to the Oracle database backup and recovery advanced options. I hope you will have some gains.

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.