modifying Oracle to archive mode

1. Check whether it is an archive mode

SQL>log  list; Database Log Mode           No Archive modeautomatic Archival           disabledarchive destination           log sequence       Current log sequence           

2. Close the database

SQL>log  list; Database Log Mode           No Archive modeautomatic Archival           disabledarchive destination           log sequence       Current log sequence           

3. Start the database to mount mode

SQL>  startup  3290345472  bytesfixed Size            2217832  Bytesvariable Size         1795164312  bytesDatabase buffers     1476395008  Bytesredo buffers           16568320  bytesDatabase mounted.

4. Modify the database to archive mode

SQL>  alterdatabase  archivelog; Database altered.

5. Open Database Library

SQL>alterdatabaseopen; Database altered.

6. Check whether it is an archive mode

SQL>log  list; Database Log Mode           Archive modeautomatic Archival           enabledarchive destination           log sequence      Next Log  to archive-current   log sequence           

7. View the path and directory of archived logs

SQL>  show parameter db_recovery_file_dest;name                     TYPE     VALUE-------------- ---------------------------------------------------------------db_recovery_file_dest             string     / usr/oracle/app/flash_recovery_areadb_recovery_file_dest_size          integer 3882M

modifying Oracle to archive mode