|
Explanation: To stop automatic archiving of redo log files you need to issue the ALTER SYSTEM ARCHIVE LOG STOP command, set LOG_ARCHIVE_START to FALSE in the parameter file and restart the database. Incorrect Answers: 2: The ALTER SYSTEM SET LOG_ARCHIVE_START=FALSE command works just for session, not instance, level, so it will not stop archiving of redo log files. 3: There is no LOG_ARCHIVE_STOP parameter in the initialization file in Oracle. Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 585-591 Chapter 12: Overview of Backup and Recovery
|