Summary of Oracle Archive logs

Open the archive log

Sqlplus / as sysdbasql > shutdown immediate; sql > startup mount; # Open control file, do not open data file sql > alter database archivelog; # switch database to archive mode sql > alter database open; # Open data file sql > archivelog list; # check whether it is in archive mode at this time

View log mode

SQL > select log_mode from v$database

Check to see if the archive is started

SQL > select archiver from v$instance

two。 Disable archive log

Sql > archivelog list; # check whether it is archived sql > alter system set log_archive_start=false scope=spfile; sql > shutdown immediate; sql > startup mount; # Open control file, do not open data file sql > alter database noarchivelog; # switch database to non-archived mode sql > alter database open; # Open data file sql > archivelog list; # View is in non-archived mode at this time

3. Check whether it is the archiving method and the archiving path

Sql > archive log list; # check whether it is archived

Database log mode Archive Mode

Automatic archival Enabled

Archive destination USE_DB_RECOVERY_FILE_DEST

Oldest online log sequence 98

Next log sequence to archive 100

Current log sequence 100

Look for DB_RECOVERY_FILE_DEST according to the USE_DB_RECOVERY_FILE_DEST above

Sys@ora10g > show parameter DB_RECOVERY_FILE_DEST

NAME TYPE VALUE

Db_recovery_file_dest string / oracle/app/oracle/flash_recovery_area

4. Modify the path of the archive log

Sql > archive log list; # check whether it is archived 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 archiving path sql > alter system set log_archive_dest_1=''location=/oracle/ora9/oradata/arch2'' scope=spfile; sql > alter system set log_archive_dest_2=''location=/oracle/ora9/oradata/arch3'' scope=spfile # if 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 Archive Diary style Log switch sql > alter system switch logfile; this log switch will write the archive to two destination locations, namely / oracle/ora9/oradata/arch2 and / oracle/ora9/oradata/arch2 above

5. Check the size of the current archive log

Select sum (a.BLOCK_SIZE*a.BLOCKS) / 1024 shock 1024 from v$archived_log a where a.DELETEDRONO'

6. View the maximum size of archive logs

Show parameter db_recovery_file_dest_size

7. Set the maximum value of the archive log. The archive log is full and cannot be started.

Startup nomount;alter system set db_recovery_file_dest_size = 4G scope=both;;alter database mount;alter database on

8. View the utilization of archive logs

Select PERCENT_SPACE_USED from V$FLASH_RECOVERY_AREA_USAGE where file_type LIKE 'ARCHIVED LOG'

9. Get the utilization of the flashback area

Select sum (PERCENT_SPACE_USED) from V$RECOVERY_AREA_USAGE