English Русский Contacts Site map Add to favorites
Registration
Login
Master braindump list
New braindumps
Submit a dump
Get latest dump
braindumps.com.ua
flame
3COM (7)
Adobe (1)
BEA (1)
Checkpoint (22)
Cisco (20)
Citrix (21)
CIW (15)
Compaq (0)
CompTIA (51)
CWNA (2)
EMC (2)
Exin (4)
GEJOS (4)
HDI (1)
HP (4)
IBM (13)
Juniper (5)
Linux Prof Institute (LPI) (2)
Lotus (11)
Microsoft (2462)
Network Appliance (2)
Novell (16)
Oracle (423)
PLSQL (1)
PMI (5)
SAS (1)
Sun (87)
Teradata (4)
Login:
Password:
RSS feed

Contacts
Certification links
Links
Authorized users can post comments.
Please log in or sign up.

back to list
Back to main forum
Backup and Recovery 

АвторSubject: Q57
written 19 January 2008 10:10   View profile Jonnik  Edit/Delete  Answer  Answer with quotation
Explanation:
You need to restore just damaged files to minimize data log if no log switch has occurred once the last backup. When media failure occurs on the database in NOARCHIVELOG mode, you must restore all datafiles, redo log files, and control files from your backup in order to recover the database, even if only one file on disk was lost. This is because all datafiles, redo logs, and control files must be synchronized in order for the database to open. One exception to this rule is when your database experiences media failure and no online redo log has been overwritten by LGWR. In this case, you need only restore the datafile lost by media failure and let Oracle handle crash recovery.
Incorrect Answers:
1: You can restore only damaged files if no log switch has occurred once the last backup. In other case, when LGWR rewrote redo logs, you need to restore all datafiles, redo logs, and control files.
3: Not only consistent datafiles need to be restored, but redo logs, and control files also.
4: Not only datafiles need to be restored, but redo logs, and control files also.
Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 666-671
Chapter 14: Database Failure and Recovery

Current tread:
back to list

Q57 - Go to question 10:10 19.01.08

back to list
Up ^ gen. 0.052 Server date 03:55 10-01-2009 Developed by Zip © 2006 Up ^
Forum
Start online exam simulation
Master braindump
User braindumps
Main forum
Question comments