Exam 15: Backup and Recovery

Flashback technology is potentially much faster in recovery times than traditional file restoration,combined with log entry records recovery.

A cold backup takes a snapshot of a database,or preferably a part of a database,one file or type of file at a time.

User and application errors are usually object-centric,such as the dropping of a table.

____________________ failure is storage device failure,such as when a disk fails,and denies your database access to one,some,or all of the files in your database.

The redo logs and ____ logs consist of records of all transactions made to a database.

____ is the process of rebuilding a database after some part of a database has been lost.

If a datafile is restored from a backup,then the controlfile will be behind of the datafile in time.

Recovery can be executed up to a point,but an automated recovery will use ______________________________ to determine what is updated,and up to when.

Loss of an individual table is simple to recover if you have an export.

There are other methods of performing consistent backups,such as using export utilities,which by definition are cold backups.

A type of hot backup is a ____ backup,for which you switch a tablespace into a special mode called backup mode.

A ____ backup is the same as a snapshot.The only difference is that the export utility performs a logical backup,not a physical backup.

Smaller redo log entries cause redo logs to switch more often,producing more archive logs more often.

____________________ recovery automatically passes through redo logs,archive logs,and even undo space,allowing recovery on specific parts of a database to be restored,or even locked during a period to logically restore a single table.

Loss of an application datafile includes any non-system tablespace,excluding the ____________________ and the SYSAUX tablespace.

In Oracle Database,restarting the database will always recover from a SHUTDOWN ABORT or a power failure.

A(n)____________________ backup is made of pieces of a database (different files),where those files making up a complete database backup are not recoverable to a working database as a group.

The redo log files are typically covered for backups by simply duplexing redo log groups to have multiple members in each group.

The primary function of ____________________ is controlled distribution of data over a WAN.

Redo log files should be backed up for a hot backup,when the database is completely shut down to provide a snapshot of the entire database.