In addition to Weibo, there is also WeChat
Please pay attention
WeChat public account
Shulou
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.
Continue with the installation of the previous hadoop.First, install zookooper1. Decompress zookoope
"Every 5-10 years, there's a rare product, a really special, very unusual product that's the most un
© 2024 shulou.com SLNews company. All rights reserved.