Archivelog | Noarchivelog   «Prev  Next»

Duplex Archivelog Mode - Exercise

Troubleshooter

Objective: Install a default database for duplex archivelog mode

Exercise scoring

This exercise is worth 10 points.

Background/overview

In this Troubleshooter, imagine that you have just installed a default Oracle8 database on a Windows NT platform and that you want to make use of duplex archivelog processing. Here is the information that is contained in your current initgl1.ora file: 
db_name = gl1
db_files = 1020
control_files = c:\oracle8\database\ctl1gl1.ora
db_file_multiblock_read_count = 8
db_block_buffers = 200
shared_pool_size = 11534336
log_checkpoint_interval = 8000
processes = 50
dml_locks = 100
log_buffer = 8192
sequence_cache_entries = 10
sequence_cache_hash_buckets = 10
background_dump_dest = c:\oracle8\rdbms80\trace
user_dump_dest = c:\oracle8\rdbms80\trace
db_block_size =2048
compatible = 8.0.5.0.0
sort_area_size = 65536
log_checkpoint_timeout = 0
remote_login_passwordfile = shared
max_dump_file_size = 10240

In order to implement duplex archivelog mode, you will use Server Manager and Notepad as your primary tools to implement any changes. You want your archive log files to reside in a primary directory e:\oracle8\archive and a secondary directory f:\oracle8\archive. You will use a padded log sequence number as part of the archive log file name.
Here is some preliminary information about your system.
  1. This will be a production general ledger system and your database system identifier (SID) is gl1.
  2. Your ORACLE_HOME is c:\oracle8.
  3. You have two redo log file groups with two members in each group.
  4. The disks and directories look like this:
    ORACLE_HOME\bin--location of server manager executable svrmgr30.exe
    ORACLE_HOME\database--location of all your database files
    ORACLE_HOME\database\ctl1gl1.ora--your control file
    Redo log files:
  5. Group 1:
    ORACLE_HOME\database\log1agl1.ora
    D:\oracle8\database\log1bgl1.ora
  6. Group 2:
    ORACLE_HOME\database\log2agl1.ora
    D:\oracle8\database\log2bgl1.ora.

Instructions


Please answer the following questions in the appropriate text areas. When you are finished, click the Submit button to submit your answers.
  1. Identify the major tasks to implement duplex archive log processing.

  2. Identify the changes you will make to the initgl1.ora file.

  3. Identify the commands that you will use to modify the state of the database.

  4. Identify when you should backup your database. Assume that we will do a offline physical backup.