Check whether the oracle database is in archive Mode
SQL> select name, log_mode from V $ database;
NAME LOG_MODE
------------------------------------------
TEST NOARCHIVELOG
SQL> archive log list
Database log mode No Archive Mode
Automatic archival Disabled
Archive destination USE_DB_RECOVERY_FILE_DEST
Oldest online log sequence 80157
Current log sequence 80163
Edit the archive mode of the configuration database in this section
1. Change non-archive mode to archive mode:
1) SQL> conn/as sysdba (connect to the database as DBA)
2) SQL> shutdown immediate; (close the database immediately)
3) SQL> startup mount (start the instance and load the database, but do not open it)
4) SQL> alter database archivelog; (change the database to archive Mode)
5) SQL> alter database open; (open the database)
6) SQL> alter system archive log start; (enable automatic archiving)
7) SQL> exit (exit)
Make a full backup because the backup logs generated in non-archive log mode are no longer available in archive mode. This step is not very important!
2. Change the archive mode to non-archive mode:
1) SQL> SHUTDOWN NORMAL/IMMEDIATE;
2) SQL> STARTUP MOUNT;
3) SQL> ALTER DATABASE NOARCHIVELOG;
4) SQL> ALTER DATABASE OPEN;
3. Archiving related commands
Archive log stop;
Archive log start;
Archive log list;
Show parameters;
Show parameters log_archive_start;
Show parameters log_archive_max_process; # Number of archiving processes
Alter system set log_archive_max_process = 5; # change the number of archiving processes to 5
Select * from v $ bgprocess; # Check the background process