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.