Exam 15: Backup and Recovery

____ failure is rare because of many modern striping and mirroring utilities using specialized hardware such as RAID arrays.

A(n)_________________________ is a sequential number applied to every logged change to a database.

A point that a recovery is processed up to,is represented in the controlfile as a(n)____________________ (SCN).

The ____________________ process is essentially the application of redo log entries,from both redo log files and archive log files,back into the datafiles.

A hot backup is not necessarily a consistent backup across all the files in the backup (if the entire database is backed up in this manner).

A ____ backup creates both DDL commands and DML commands,to re-create a database object (it uses the database SQL engine).

All of datafiles,archive logs,and redo logs can be recovered from a backup,but preferably not all.

____________________ environments consisting of multiple nodes can be useful if one node fails,in which case another node assumes the node of both the failed node and of itself.

A ____ standby database passes newly created archive log files to a standby database server computer.Those archive logs are then applied on the standby database computer to the standby database.

In a ____ replicated database architecture,any changes made to any one of the databases are replicated to all other databases in the replication architectural structure.

The export utility is capable of recovering individual objects using log entries.

Archive log files contain older records of transactions performed in the database.

The UNDO and TEMP tablespaces are usually only backed up during a ____ backup because of the flexible nature of their contents.

The export utility cannot be used to create a consistent backup.

Making a consistent copy of redo log files during a(n)____________________ backup is pointless,as a consistent snapshot of inactive redo log files is not possible.

A(n)____________________ backup is often made to make infrequent but extremely reliable copies of an Oracle database,most often when a database is periodically inactive and generally small in physical size.

____ failure can sometimes be the result of a bug or an overload applied to the database itself.

Typically OLTP databases are customer facing,whereas a data warehouse contains historical information.

You can create a backup that is ____________________ (recoverable)by applying log entries to datafiles,based on SCN matches between datafiles,controlfiles,and redo log entries.

Restoring of redo log files or archive log files means simply placing copies back into their respective ____________________,within the database structure in the operating system.