dbazone

Oracle database Logical and Physical Backups

Posted on April 28th, 2010 in Database Backup, Database backup and Recovery Logical Backups, Physical Backups

Oracle database backup is an important role for oracle DBA.

Physical Backups

Oracle database physical backup includes of backing up the  physical files as

• Datafiles
• Archived redo logs
• Control files
• Network files (tnsnames.ora,listener.ora,sqlnet.ora)
• Parameter file

Physical backups are made on the disk or on the tape devices.

Logical Backups

Oracle database logical backup made using export utility (using exp or expdb command ).

Logical backup contain logical objects like tables  and procedures .
These backups are in binary form and can be extracted only using import(imp or impdp command)  utility. Logical backup is an optional way to protect database.

Related posts:

1. Oracle database backup Database backup is a primary goal of an Oracle DBA...
2. Oracle database Logical structures Oracle logical structures includes oracle data blocks, extents, segments and...
3. Physical structure of oracle database The physical structure of Oracle database consists following files: One...
4. RMAN Backup Oracle Recovery manager commonly known as RMAN is a very...
5. Recovery Manager(RMAN) backup How Recovery Manager (RMAN) perform backup of target database ?...

Related posts brought to you by Yet Another Related Posts Plugin.