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: Q182
written 12 January 2008 13:03   View profile Jonnik  Edit/Delete  Answer  Answer with quotation
Explanation:
Actually there are some answers possibly correct. But based on question it looks like it was incomplete recovery performed when the log sequence number should be reset. To reset the log sequence number when opening a database after recovery and thereby create a new incarnation of the database, execute the following statement:
  1. ALTER DATABASE OPEN RESET LOGS;
Incorrect Answer:
1: This command can be used after recovery also, but only after media recovery.
2: This command can be used for clearing an unachieved log allows it to be reused without archiving it. This action makes backups unusable if they were started before the last change in the log, unless the file was taken offline prior to the first change in the log. Hence, if you need the cleared log file for recovery of a backup, then you cannot recover that backup. Also, it prevents complete recovery from backups due to the missing log
4: To preserve the log sequence number when opening a database after media recovery, execute either of the following statements:
  1. ALTER DATABASE OPEN NORESET LOGS;
  2. ALTER DATABASE OPEN;
Reference:
OCP Oracle 9i Database: Fundamentals II Exam Guide, Rama Velpuri, p. 336-337
Chapter 14: User-Managed Incomplete Recovery

Current tread:
back to list

Q182 - Go to question 13:03 12.01.08

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