RelationalDBDesign RelationalDBDesign

Manual | Automatic Archiving   «Prev  Next»
Lesson 4 Manual archiving
Objective Manually archive the online redo log files.

Manual archiving

If you do not set up the database to perform automatic archiving, the DBA must manually archive the redo log files. Manual archiving puts a greater burden on the DBA to manage the database. You have several options when choosing which redo log files you want to back up. The following table lists the options available to a DBA to manually archive redo log files:

In most cases you will use the archive all command. The alter system in the above commands is optional.
The following simulation takes a database in noarchivelog mode and puts it in archivelog mode with manual archiving of the log files. It archives the log files and then queries the database to determine its state. Let us start our simulation.

Setting manual archive logging

  1. Enter svrmgr30 at the DOS prompt and hit return.
  2. Connect to the database as the user internal by entering connect internal at the SVRMGR> prompt, and hitting return.
  3. At this point you would normally enter the password at the prompt. Since the password does not echo and the cursor doesn't move forward when you enter the password, just click the space after Password: and we'll move you to the next screen.
  4. Now let's specify the database orc1. Enter startup mount orc1; at the prompt and hit return.
  5. Enter alter database orc1 archivelog; at the prompt and hit return. This will sets up the database for archivelog mode.
  6. Enter alter database orc1 open; at the prompt and hit return. This opens the database so it can be accessed by the users.
  7. Enter archive log all; at the prompt and hit return. This archives the online redo logs that have not been previously archived. In our case we are archiving two log files.
  8. Enter archive log list; at the prompt and hit return. This returns our archive log information.
  9. The information for the archive log list command is displayed. You can now exit server manager by entering exit at the prompt and hitting return. This is the end of the simulation.

Manual Archiving - Exercise

Click the Exercise link below to test your understanding of the manual archive processing.
Manual Archiving - Exercise The next lesson is about automatic archiving of the redo log files.