/ * Manage archive mode * /
With archive reform logs, DBA can perform the following: * Based on time recovery database * Update alternate database * Using LogMiner and other tools to get database history modification information
In an Oracle instance, you can start up to 10 ACRN processes, set by log_archive_max_processes parameters.
View Database Archive Information SQL> Archive Log List;
Change the database archive mode 1. Turn off the database 2. Set the relevant parameters in the initialization parameter file, including whether the automatic archive, archive target, archive format, archive processes are: # archive parameterslog_archive_start = true # log_archive_start = falselog_archive_DEST_1 = 'location = f: / oracle / oradata / backup / arc1'log_archive_dest_2 = 'location = f: / oracle / oradata / backup / arc2'log_archive_format = Arch_% T_% s.arc # log_archive_max_processes = 3
3.Startup Mount; 4.alter Database ArchiveLog; 5.alter Database Open;
If the auto archive is not enabled, automatic archive ALTER SYSTEM Archive log start is enabled after the instance is started;
After the instance is run, disable automatic archiving ALTER SYSTEM ARCHIVE LOG Stop; / * Manually archive * / Archive All Unmarkable online redo log files ALTER SYSTEM ARCHIVE LOG ALL;
Archive current online red log files ALTER SYSTEM Archive log current;
Archive online redo log files with specified sequence numbers ALTER SYSTEM ARCHIVE LOG SEQUENCE 15
Archive designated redo log group ALTER SYSTEM ARCHIVE LOG GROUP 2
Archive Specifies online redo log file ALTER SYSTEM Archive loglogfile 'i: /oracle/oradata/oradb01/redo0101.rdo';
Archive Information Data Dictionary V $ Archived_log All archived log information V $ archive_dest archive target information V $ archive_processes Status Information of Started Archive Process]
