Study your flashcards anywhere!

Download the official Cram app for free >

  • Shuffle
    Toggle On
    Toggle Off
  • Alphabetize
    Toggle On
    Toggle Off
  • Front First
    Toggle On
    Toggle Off
  • Both Sides
    Toggle On
    Toggle Off
  • Read
    Toggle On
    Toggle Off
Reading...
Front

How to study your flashcards.

Right/Left arrow keys: Navigate between flashcards.right arrow keyleft arrow key

Up/Down arrow keys: Flip the card between the front and back.down keyup key

H key: Show hint (3rd side).h key

A key: Read text to speech.a key

image

Play button

image

Play button

image

Progress

1/54

Click to flip

54 Cards in this Set

  • Front
  • Back
  • 3rd side (hint)
What type of backup should be performed on unrecoverable operations in a 7x24 shop?
full offline backup
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
x=1, y=2
If you set this number too high, you might cause additional overhead.
In reference to instance recovery, what does the number of disk drives and CPUs determine?
degree of parallelism
Which of the following are necessary components when recovering from operator error?
backup files, archive files, large temporary space
concentrate on parallel recovery when using this recovery option?
instance recovery
Planning should allow for a large disk space to temporarily recover the database
operator error recovery
What SQL script must be run before a backup can be performed through Recovery Manager?
CATRMAN.SQL
Which order should these steps be taken. 1)run catman.sql 2)create data file 3)create user 4)create table space
4,2,3,1
Mark the beginning of the tablespace backup using the following SQL command:
alter tablespace (tablespace name) begin backup;
Which is the most straightforward type of backup when using OS facilities?
full database
Where does Oracle divert writes to during a tablespace backup?
sga
Which databases can be backed up with the NT Backup Utility?
local databases only
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.
recovery
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.
restoration
manual operation requiring operator intervention
If the failure causes no data loss, Oracle can recover itself; this is referred to as an?
instance recovery
If data has been lost, data must be restored from a previous backup and then recovered; this is referred to as?
media recovery
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?
point-in-time recovery
If a system failure has caused no loss of data, which type of recovery occurs?
instance recovery
If data has been lost due to the accidental deletion of a table, which type of recovery needs to occur?
point-in-time recovery
With an Instance recovery, every transaction that was in the process of being committed is referred to as?
in flight transaction
Instance recovery time depends upon?
number of dirty buffers in sga
The number of dirty buffers in SGA when instance restore is needed depends on?
time since last checkpoint and number of data modifications
In the case of media failure, what does the amount of time spent in recovery depend on?
time since last backup and data modified
True or False. When using Enterprise Manager's Backup Manager for media recovery, database recovery is an option if the instance is running.
False
Tablespace and datafile recovery can be performed only if the RDBMS is
archivelog mode
Provided with Oracle for Windows NT?
The NT Recovery Utility
Allows you to select the channels to be used during recovery?
backup manager
Must be run with the tablespace offline
os facilities
You cannot restore from the loss of this?
log file
It is recommended that you use RAID mirroring on the
redo log files
This type of recovery can be dangerous? A full backup should be done first.
Point-in-time recovery
If a log file is damaged, which files are used in its recovery?
None, must do full backup recovery
If your system fails due to operator error, which type of recovery would you need to perform?
point-in-time
Completely recovers the database upon startup
Instance Recovery
Should be done after a full backup of the database
point-in-time recovery
Uses Oracle8 utilities to aid the recovery process
Media Recovery
Cannot recover specific tablespaces
point-in-time recovery
Requires no operator intervention
instance recovery
a complete copy of your primary database that is constantly in recovery mode.
standby database
In the event of a failure on the primary system, you can archive the current log files using the
alter system archive log current
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.
In the event of media failure on the volume containing the read-only tablespace, you must restore the damaged datafiles, but not the?
instance
Uses the ALTER SYSTEM ARCHIVE LOG CURRENT command
standby database
Can be modified through Storage Manager?
read-only tablespaces
Are brought up-to-date when a log switch occurs
standby database
facility that allows you to copy database data to multiple local and remote systems.
replication
This basic method of replication allows you to copy a table to a remote site as a read-only table.
read-only table snapshot
Any updates to the table must be made on the master database.
it is possible for all replicated objects to be updated.
advanced replication
much more complex than the read-only table snapshot because conflict resolution must be programmed.
The Oracle advanced replication option is sometimes known as?
symmetric replication or updateable snapshots
When advanced data replication propagates immediately, it is known as?
synchronous data propagation
Which replication option updates objects immediately?
Synchronous data propagation
This propagation of fresh replicated data is called the?
snapshot refresh
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).
snapshot group
Which snapshot refresh mode applies only changes to the replicated snapshot?
fast refresh
Which snapshot option allows tables to be linked together?
snapshot group