Disabling Automatic Archiving for Oracle 10g

Disable automatic archiving for Oracle 10g.

1. Make sure you have sysdba administrator privileges, and close the database.
2. Enter:

   alter database ARCHIVELOG MANUAL;

3. To verify that log archiving is disabled, enter:

   select log_mode from v$database;

   If MANUAL is returned, then automatic log archiving is disabled.