Close and enable archiving logs in oracle at, January 25
1. Archive Mode
1 SQL> archive log list; # Check whether the archive mode is used
2 SQL> alter system set log_archive_start = true scope = spfile; # enable active Archiving
SQL> alter system set log_archive_dest = ''location =/oracle/ora9/oradata/arch'' scope = spfile;
# Set the archiving path
SQL> alter system set log_archive_dest_1 = ''location =/oracle/ora9/oradata/arch1' scope = spfile;
SQL> alter system set log_archive_dest_2 = ''location =/oracle/ora9/oradata/arch2' scope = spfile;
# If the file is archived to two locations, you can use the above method to implement
SQL> alter system set log_archive_format = ''arch _ % d _ % t _ % r _ % s. log'' # set the archive diary style
3 SQL> shutdown immediate;
4 SQL> startup mount; # Open the control file instead of the data file
5 SQL> alter database archivelog; # Switch the database to archive Mode
6 SQL> alter database open; # open the data file
7. SQL> archive log list; # Check whether the file is in archive mode.
8. query to confirm that the database is in archivelog mode and the archiving process is running.
SQL> select log_mode from v $ database;
SQL> select archiver from v $ instance;
9 log Switching
SQL> alter system switch logfile;
10 This log switch writes archive to two destination locations,
1, that is, in step 2,/oracle/ora9/oradata/arch1 and/oracle/ora9/oradata/arch1. If you want to confirm the Directory
Run the following query in oracle:
SQL> select name from v $ archived_log;
Then, check the listed files in the operating system.
2. Set non-archive Mode
1 SQL> archive log list; # Check whether archive mode is used
2 SQL> alter system set log_archive_start = false scope = spfile; # disable automatic archiving
3 SQL> shutdown immediate;
4 SQL> startup mount; # Open the control file instead of the data file
5 SQL> alter database noarchivelog; # Switch the database to non-archive Mode
6 SQL> alter database open; # open the data file
7. SQL> archive log list; # check whether it is in non-archive mode.
3. Archive 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