Oracle database backup and recovery - Explain how to backup a database using
the export utility posted by
Babu Kunwar
Explain how to backup a database using the export utility
The logical backup in Oracle database is done by Export utility. Oracle’s Export
utility queries the database, including the data dictionary, and writes the
output to a binary file called an export dump file. The backup through export
utility can be done in four phase. These phases are commonly known as BACKUP
modes. The modes are: Full mode, Tablespace mode, User mode, and Table mode.
In Full mode, the full database is exported. The entire data dictionary is
read, and the DDL needed to re-create the full database is written to the
export dump file. This file includes creation commands for all tablespaces, all
users, and all of the objects, data, and privileges in their schemas.
In Tablespace mode, all of the objects contained in the specified tablespace(s)
will be exported, including the definition of indexes on the contained objects,
even if they are in another tablespace.
In User mode, a user’s objects are exported, as well as the data within them.
All grants and indexes created by the user on the user’s objects are also
exported. Grants and indexes created by users other than the owner are not
exported.
In Table mode, a specified table is exported. The table’s structure, indexes,
and grants are exported along with or without its data. Table mode can also
export the full set of tables owned by a user.
More links
What is Oracle Parallel Query?
Difference between Parallel Query and Parallel Server
Explain how to invoke Parallel Query
Explain how to disable Parallel Query
Can single-processor systems benefit from Parallel Query? Explain...........
|
