Oracle 8 - Backup And Recovery - Section 1

Front 1

The two types of recovery are?

Back 1

instance recovery and data recovery

Front 2

Type your answer below. If a power outage has caused your system to go down, what type of failure have you just experienced?

Back 2

instance

Front 3

Which type of transaction can be recovered in the event of an instance failure?

Back 3

committed

Front 4

Type your answer below. What type of failure requires data recovery?

Back 4

media

Front 5

From which type of damage is there no recovery?

Back 5

log file

Front 6

This term is used to describe a logical group of work. This group of work can consist of one or many SQL statements and must end with a commit or a rollback.

Back 6

transaction

Hint 6

This definition assumes a client/server application, so SQL*Net is necessary.

Front 7

This records all changes made to the Oracle database. The purpose is to ensure that, in the event of media failure, the database can be recovered if the datafile is lost.

Back 7

redo log

Front 8

It is recommended that all production systems be run in this mode.

Back 8

archivelog

Front 9

Archiving is enabled by running the this command & parameter in Server Manager?

Back 9

alter database archivelog;

Front 10

Archiving is disabled by running the this command & parameter in Server Manager?

Back 10

alter database noarchive;

Front 11

If you are in ARCHIVELOG mode and want to disable it for a particular startup, you can set this Oracle parameter

Back 11

log_archive_start=false

Front 12

It is recommended that you keep your online archive log files on?

Back 12

raid protected volume

Front 13

If you set this Oracle parameter, a second copy of each archive log file will be created in this directory.

Back 13

log_archive_duplex_dest

Front 14

What files are typically stored offline?

Back 14

archive log files

Front 15

contain information about the physical construction of the database

Back 15

control files

Hint 15

If lost, it might still be possible to re-create it, but it will be very difficult.

Front 16

What files contain information on the physical construction of the database?

Back 16

control files

Front 17

What files contain information on the physical construction of the database?

Back 17

reuse

Front 18

Finish the ALTER DATABASE command that will write SQL to a file that can be used to re-create the controlfiles.

Back 18

backup controlfile to trace;

Front 19

This type of backup is best because you get a consistent view of the entire database?

Back 19

full offline backup

Front 20

The full offline backup is sometimes called?

Back 20

consistent whole database backup

Hint 20

this is done when the database is shutdown cleanly.

Front 21

A full online backup is really just a combination of

Back 21

tablespace and control file backups

Front 22

Online backups are valid only if you are running in?

Back 22

archivelog mode

Front 23

a collection of disk drives configured to act as one larger disk drive.

Back 23

disk array

Front 24

disk array is a set of disk drives that make up a larger disk. This logical disk is sometimes called?

Back 24

logical volume

Front 25

The logical volume is made up of identical-sized pieces of the individual drives, called?

Back 25

stripes

Front 26

The size of the stripe is called the

Back 26

striping factor

Front 27

A typical striping factor is how many blocks? How many bytes in a block

Back 27

32, 512

Front 28

What is the term for identical-sized pieces of the individual drives within the logical volume?

Back 28

stripes

Front 29

reads to different data can occur simultaneously on different mirrored disks are referred to as?

Back 29

split reads

Hint 29

The disk with the heads closest to the requested data retrieves the data.

Front 30

with this you achieve the highest level of protection as well as the fastest disk access possible for a fault-tolerant volume?

Back 30

disk mirroring

Front 31

RAID-5 is also known as

Back 31

distributed data guarding

Front 32

With raid 5, how many I/O's are generated per read? Per Write?

Back 32

1, 4

Front 33

This RAID level has an independently computed data check?

Back 33

raid 6

Hint 33

Disk Space = (N–2) * Disk Size

Front 34

What term refers to reads that can occur simultaneously on different mirrored disks?

Back 34

split reads

Front 35

If your system needs fast disk access as well as a high level of protection, which RAID level is your best choice?

Back 35

raid 1

Front 36

Unless the write cache is protected, it is not usually recommended that write-caching be enabled on the?

Back 36

redo log volume

Front 37

What RAID level uses a parallel access method to achieve high performance?

Back 37

raid 3

Front 38

If the failure occurs on the volume containing your redo log files, you can recover only up to the last good

Back 38

archived log file

Front 39

On which volume would failure result in recovering only up to the last good archived log file?

Back 39

redo log file volume

Front 40

Because of it's good performance, this RAID level should be used at least for OS & Redo Log file volumes

Back 40

raid 1

Front 41

Three critical areas that should be protected are the?

Back 41

OS, Redo Logs and Archive Logs

Front 42

If possible, put each redo log file on a separate?

Back 42

mirrored volume

Front 43

use this RAID level on read intensive volumes?

Back 43

RAID 5

Hint 43

The performance degradation experienced when using this RAID level occurs only on writes.