Two steps for Oracle database backup and recovery advanced options

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

 
 

  
  
：$ 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.