Oracle database backup and recovery

database backup and recovery pdf

Selecting the Retain at least the specified number full backups for each data file as 1 1 is the default value will mark the older backup as obsolete whenever a new backup is taken.

Choose a location on disk and an upper bound for storage space, and set a retention policy that governs how long backup files are needed for recovery, and the database manages the storage used for backups, archived redo logs, and other recovery-related files for your database within that space.

Time-based recovery, also called point-in-time recovery PITRwhich recovers the data up to a specified point in time. Logical backups contain logical data such as tables and stored procedures.

RMAN automatically establishes the names and locations of all the files needed to back up. Requires explicit invocation by a user. In a recovery catalog, RMAN keeps a record containing all the essential information concerning every backup ever taken.

Backups can be combined in a variety of ways. The methods include: Recovery Manager RMAN - A component that establishes a connection with a server process and automates the movement of data for backup and recovery operations.

Media recovery has the following characteristics: Applies changes to restored backups of damaged datafiles. Flash recovery. When preparing a recovery strategy, it is critical to understand the answers to these questions: How does recovery work?

A cold or off-line backup is a backup performed while the database is off-line and unavailable to its users. Restore necessary archived redo log files.

Rated 6/10 based on 94 review
Database Backup, Restore, and Recovery