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: Q27
written 19 January 2008 10:10   View profile Jonnik  Edit/Delete  Answer  Answer with quotation
Explanation:
A DBA can use the initialization parameter LOG_ARCHIVE_DEST_STATE_n set to value DEFER to disable one of the current archive destinations. The SQL query below shows current state of archive destinations. SQL> select name || ' ' || value from v$parameter where2 UPPER (name) like 'LOG_ARCHIVE_DEST_STATE%'; NAME||''||VALUE
log_archive_dest_state_1 enable
log_archive_dest_state_2 enable
log_archive_dest_state_3 enable
log_archive_dest_state_4 enable
log_archive_dest_state_5 enable
log_archive_dest_state_6 enable
log_archive_dest_state_7 enable
log_archive_dest_state_8 enable
log_archive_dest_state_9 enable
log_archive_dest_state_10 enable
Incorrect Answers:
1: ALTER SESSION SET ARCHIVE_LOG_DEST=DEFER command will not disable one of the current archive destinations because this parameter cannot be changed with option DEFER.
2: Deleting the archive destination dictionary at the operating system level will not disable one of the current archive destinations.
4: It is possible to disable archive destinations with DEFER option.
Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 583-585
Chapter 12: Overview of Backup and Recovery

Current tread:
back to list

Q27 - Go to question 10:10 19.01.08

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