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 (422)
PLSQL (1)
PMI (4)
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
Oracle 9i: Database Fundamentals II 

АвторSubject: Q185
written 12 January 2008 13:03   View profile Jonnik  Edit/Delete  Answer  Answer with quotation
Explanation:
To minimize both downtime and data loss you need to restore the SYSTEM table space data file from Sunday’s backup, and all the archive log files from Monday and Tuesday. After that recover database. If there is no loss of online redo logs you can recover database without any data loss. Incorrect Answer:
1: You need also some archived log files, because the database consists only 10 redo log groups, but from Sunday it happened 17 log switches, so some redo logs have been overwritten already.
3: You cannot restart database with corrupted SYSTEM table space. You can just put corrupted non-SYSTEM table space offline to restart the database to allow users back onto the database and after that recover this table space.
4: To minimize the downtime you don’t need to restore ALL the data files from Sunday’s backup: only SYSTEM table space data files should be restored and recovered using archiving redo logs.
Reference:
OCP Oracle 9i Database: Fundamentals II Exam Guide, Rama Velpuri, p. 303
Chapter 12: User-Managed Complete Recovery

Current tread:
back to list

Q185 - Go to question 13:03 12.01.08

back to list
Up ^ gen. 0.069 Server date 07:41 08-01-2009 Developed by Zip © 2006 Up ^
Forum
Start online exam simulation
Master braindump
User braindumps
Main forum
Question comments