Archive mode of oracle

Oracle archive Mode 1. Check whether archive log list is archived; 2. Enable archive mode shutdown immediate; startup mount; alter database archivelog; alter database open; archive log list; ----- confirm whether archive is enabled 3. The number of ARCn processes is alter system set log_archive_max_processes = 3; (up to 10) 4. automatic archiving of alter system set log_archive_start = true; (true by default after 10 Gb) 5. STOP/start Archiving (10 Gb does not seem to work) alter system archive log stop; alter system archive log start to 'C: \ temp '; 6. Commonly Used archive operations: alter system arc Hive log current; alter system switch logfile; 7. Note related log_archive parameters: Method 1 and Method 2 cannot be used together. An error will be reported when using Method 1: alter system set log_archive_dest_1 = 'location = c: \ temp mandatory reopen = 500 '; -- mandatory must be archived successfully, optional indicates that the archive is not necessarily successful -- reopen retries once every 5 seconds -- log_archive_dest_n can be configured with up to 10, starting from 1 (or service) Alter system set log_archive_min_succeed_dest = 2; -- indicates the minimum number of successful archives. If the mandatory value is greater than this value, the mandatory prevails to Alter system set Log_archive_dest_state_3 = defer; -- defer indicates delayed enabling, enable indicates enabled, and alternate indicates optional. When other dest cannot be written, this dest is selected. View the status information of the archive destination: SELECT dest_name, status, destination FROM v $ archive_dest; STATUS DEST_NAME DESTINATION --------- ------------------ invalid VALID values/home/oracle/test/1 VALID LOG_ARCHIVE_DEST_2/home/oracle/test/2 VALID values/home/oracle/test/3 VALID values/home /oracle/test/4 INACTIVE LOG_ARCHIVE_DEST_5INACTIVE LOG_ARCHIVE_DEST_6