Unformatted text preview: anation:
Closed database backup will not cause an additional generation of redo because this type
of backup is just copying of closed datafiles on operation system level: it has nothing to
do with redo logs.
A: Open database backup (hot backup) will cause redo log activity.
C: Increased transactional activity in the database will generate additional redo log files.
D: If you change the NOLOGGING mode on frequently updated tables to LOGGING
redo logs will be definitely generated for these statements.
Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 585-591
Chapter 12: Overview of Backup and Recovery
In the view V$DATAFILE_HEADER, what does value 'YES' in the 'FUZZY'
column as specified?
A. The data file is corrupted.
B. The data file is in backup mode.
C. The data file is locally managed.
D. The data file is part of a read-only tablespace.
During checkpoints the new online redo log sequence number is written to the headers of
every datafile in Oracle, as well as to the control file. In addition to...
View Full Document
- Fall '09
- Jason S. Couchman, DBA Certification Exam, Certification Exam Guide