Network Security Internet Technology Development Database Servers Mobile Phone Android Software Apple Software Computer Software News IT Information

In addition to Weibo, there is also WeChat

Please pay attention

WeChat public account

Shulou

Summary of Oracle Archive logs

2025-04-02 Update From: SLTechnology News&Howtos shulou NAV: SLTechnology News&Howtos > Database >

Share

Shulou(Shulou.com)06/01 Report--

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

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.

Views: 0

*The comments in the above article only represent the author's personal views and do not represent the views and positions of this website. If you have more insights, please feel free to contribute and share.

Share To

Database

Wechat

© 2024 shulou.com SLNews company. All rights reserved.

12
Report