Author Topic: Oracle DBA Question 48  (Read 52 times)

0 Members and 1 Guest are viewing this topic.

Offline ralph0595

  • Full Member
  • *
  • Posts: 107
  • Karma: +0/-0
    • View Profile
Oracle DBA Question 48
« on: April 21, 2009, 06:41:21 AM »
Question:
You started your database with this command:
STARTUP PFILE=initSAMPLEDB.ora
One of the values in the initSAMPLEDB.ora parameter file is:
LOG_ARCHIVE_START = false
While your database is open, you issue this command to start the Archiver process:
ALTER SYSTEM ARCHIVE LOG START;
To shut down your database to take a back up and restart it using the initSAMPLEDB.ora parameter file again. When you check the status of the Archiver, you find that it is disabled.
Why is the Archiver disabled?

A. When you take a backup the Archiver process is disabled
B. The Archiver can only be started by issuing the ALTER DATABASE ARCHIVELOG command.
C. LOG_ARCHIVE_START is still set to FALSE because the PFILE is not updated when you issue the ALTER SYSTEM command.
D. The archiver can only be started by issuing the ALTER SYSTEM ARCHIVE LOG START command each time you open the database.

Answer: C

Techronnati | where technology never sleeps

Oracle DBA Question 48
« on: April 21, 2009, 06:41:21 AM »

Mountain View

 

Related Topics

  Subject / Started by Replies Last post
0 Replies
62 Views
Last post April 19, 2009, 06:01:21 AM
by ralph0595
0 Replies
64 Views
Last post April 19, 2009, 06:39:28 AM
by ralph0595
0 Replies
55 Views
Last post April 19, 2009, 06:41:37 AM
by ralph0595
0 Replies
58 Views
Last post April 19, 2009, 06:46:32 AM
by ralph0595
0 Replies
55 Views
Last post April 19, 2009, 06:51:28 AM
by ralph0595

Posting Disclaimer: Any individual may post a message in this forum and may do so anonymously. Therefore, the sole author is exclusively and entirely responsible for all opinions in that message. They do not represent the official opinions of Techronnati, its administrators or moderators or the Techronnati Management. Techronnati is merely acting as an impartial conduit for constitutionally protected free speech and is not responsible and will not be held liable for the content of such messages. All images and service logos are trademarks of their respective owners.