Oracle 8 - Backup And Recovery - Part 2

Front 1

What type of backup should be performed on unrecoverable operations in a 7x24 shop?

Back 1

full offline backup

Front 2

The number of disk drives and CPUs typically determines the degree of parallelism in your system. One rule of thumb is to use "x" process (thread) for every "y" disk drives, up to 20

Back 2

x=1, y=2

Hint 2

If you set this number too high, you might cause additional overhead.

Front 3

In reference to instance recovery, what does the number of disk drives and CPUs determine?

Back 3

degree of parallelism

Front 4

Which of the following are necessary components when recovering from operator error?

Back 4

backup files, archive files, large temporary space

Front 5

concentrate on parallel recovery when using this recovery option?

Back 5

instance recovery

Front 6

Planning should allow for a large disk space to temporarily recover the database

Back 6

operator error recovery

Front 7

What SQL script must be run before a backup can be performed through Recovery Manager?

Back 7

CATRMAN.SQL

Front 8

Which order should these steps be taken. 1)run catman.sql 2)create data file 3)create user 4)create table space

Back 8

4,2,3,1

Front 9

Mark the beginning of the tablespace backup using the following SQL command:

Back 9

alter tablespace (tablespace name) begin backup;

Front 10

Which is the most straightforward type of backup when using OS facilities?

Back 10

full database

Front 11

Where does Oracle divert writes to during a tablespace backup?

Back 11

sga

Front 12

Which databases can be backed up with the NT Backup Utility?

Back 12

local databases only

Front 13

the act of bringing the database back to where it was an instant before the failure, and refers to the process whereby Oracle rolls forward committed transactions and rolls back noncommitted transactions.

Back 13

recovery

Front 14

the act of replacing a datafile with a backup copy. You can do this only if it is not running in ARCHIVELOG mode and only if it has overwritten redo log files.

Back 14

restoration

Hint 14

manual operation requiring operator intervention

Front 15

If the failure causes no data loss, Oracle can recover itself; this is referred to as an?

Back 15

instance recovery

Front 16

If data has been lost, data must be restored from a previous backup and then recovered; this is referred to as?

Back 16

media recovery

Front 17

If some event, such as an accidental deletion of a table, has occurred, what must be performed in order to avoid repeating the mistake that caused the failure in the first place?

Back 17

point-in-time recovery

Front 18

If a system failure has caused no loss of data, which type of recovery occurs?

Back 18

instance recovery

Front 19

If data has been lost due to the accidental deletion of a table, which type of recovery needs to occur?

Back 19

point-in-time recovery

Front 20

With an Instance recovery, every transaction that was in the process of being committed is referred to as?

Back 20

in flight transaction

Front 21

Instance recovery time depends upon?

Back 21

number of dirty buffers in sga

Front 22

The number of dirty buffers in SGA when instance restore is needed depends on?

Back 22

time since last checkpoint and number of data modifications

Front 23

In the case of media failure, what does the amount of time spent in recovery depend on?

Back 23

time since last backup and data modified

Front 24

True or False. When using Enterprise Manager's Backup Manager for media recovery, database recovery is an option if the instance is running.

Back 24

False

Front 25

Tablespace and datafile recovery can be performed only if the RDBMS is

Back 25

archivelog mode

Front 26

Provided with Oracle for Windows NT?

Back 26

The NT Recovery Utility

Front 27

Allows you to select the channels to be used during recovery?

Back 27

backup manager

Front 28

Must be run with the tablespace offline

Back 28

os facilities

Front 29

You cannot restore from the loss of this?

Back 29

log file

Front 30

It is recommended that you use RAID mirroring on the

Back 30

redo log files

Front 31

This type of recovery can be dangerous? A full backup should be done first.

Back 31

Point-in-time recovery

Front 32

If a log file is damaged, which files are used in its recovery?

Back 32

None, must do full backup recovery

Front 33

If your system fails due to operator error, which type of recovery would you need to perform?

Back 33

point-in-time

Front 34

Completely recovers the database upon startup

Back 34

Instance Recovery

Front 35

Should be done after a full backup of the database

Back 35

point-in-time recovery

Front 36

Uses Oracle8 utilities to aid the recovery process

Back 36

Media Recovery

Front 37

Cannot recover specific tablespaces

Back 37

point-in-time recovery

Front 38

Requires no operator intervention

Back 38

instance recovery

Front 39

a complete copy of your primary database that is constantly in recovery mode.

Back 39

standby database

Front 40

In the event of a failure on the primary system, you can archive the current log files using the

Back 40

alter system archive log current

Hint 40

This creates an archive log file of the current redo log file. In this manner, the standby database can be made current with the primary database.

Front 41

In the event of media failure on the volume containing the read-only tablespace, you must restore the damaged datafiles, but not the?

Back 41

instance

Front 42

Uses the ALTER SYSTEM ARCHIVE LOG CURRENT command

Back 42

standby database

Front 43

Can be modified through Storage Manager?

Back 43

read-only tablespaces

Front 44

Are brought up-to-date when a log switch occurs

Back 44

standby database

Front 45

facility that allows you to copy database data to multiple local and remote systems.

Back 45

replication

Front 46

This basic method of replication allows you to copy a table to a remote site as a read-only table.

Back 46

read-only table snapshot

Hint 46

Any updates to the table must be made on the master database.

Front 47

it is possible for all replicated objects to be updated.

Back 47

advanced replication

Hint 47

much more complex than the read-only table snapshot because conflict resolution must be programmed.

Front 48

The Oracle advanced replication option is sometimes known as?

Back 48

symmetric replication or updateable snapshots

Front 49

When advanced data replication propagates immediately, it is known as?

Back 49

synchronous data propagation

Front 50

Which replication option updates objects immediately?

Back 50

Synchronous data propagation

Front 51

This propagation of fresh replicated data is called the?

Back 51

snapshot refresh

Front 52

When you define this, several different tables can be linked together so that there is transaction consistency within the snapshot (that is, the tables are in sync).

Back 52

snapshot group

Front 53

Which snapshot refresh mode applies only changes to the replicated snapshot?

Back 53

fast refresh

Front 54

Which snapshot option allows tables to be linked together?

Back 54

snapshot group