How to clear alert log
This article introduces you how to remove alert log, the content is very detailed, interested friends can refer to, hope to be helpful to you.
1. Delete log_ × × .xml manually, and oracle will automatically create a new log.xml file after deleting the file.
two。 You can also delete alert log using the ADRCI tool.
1. Manually delete log_ × ×. Xml in OS
[oracle@dbserver alert] $ll
Total 4
-rw-r- 1 oracle oinstall 307 Aug 9 08:59 log.xml
[oracle@dbserver alert] $rm log.xml
[oracle@dbserver alert] $ll
Total 0
SQL > shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
[oracle@dbserver alert] $ll
Total 12
-rw-r- 1 oracle oinstall 10150 Aug 9 09:01 log.xml
two。 You can also delete alert log using the ADRCI tool.
[oracle@dbserver alert] $ll
Total 36
-rw-r- 1 oracle oinstall 33420 Aug 8 16:23 log.xml
[oracle@dbserver ~] $adrci
ADRCI: Release 11.2.0.2.0-Production on Wed Aug 8 16:37:19 2012
Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
ADR base = "/ testcase/adr_test"
Adrci > show homes
ADR Homes:
Diag/rdbms/orcl/orcl
Adrci > set homepath diag/rdbms/orcl/orcl
Adrci > show alert-tail
2012-08-08 16 purl 18 purl 18.935000 + 08:00
Replication_dependency_tracking turned off (no async multimaster replication found)
Starting background process QMNC
QMNC started with pid=24, OS id=20503
2012-08-08 16 1820.445000 + 08:00
ARC2: Archival started
ARC3: Archival started
ARC0: STARTING ARCH PROCESSES COMPLETE
ARC0: Becoming the heartbeat ARCH
2012-08-08 16 purl 18 purl 23.428000 + 08:00
Db_recovery_file_dest_size of 4002 MB is 2.00% used. This is a
User-specified limit on the amount of space that will be used by this
Database for recovery-related files, and does not reflect the amount of
Space available in the underlying filesystem or ASM diskgroup.
Starting background process CJQ0
2012-08-08 16 purl 18purl 24.451000 + 08:00
CJQ0 started with pid=25, OS id=20519
Completed: ALTER DATABASE OPEN
2012-08-08 16 2315 21.740000 + 08:00
Starting background process SMCO
SMCO started with pid=26, OS id=20637
Adrci > purge-age 1-type alert
Adrci > show alert-tail
Adrci > exit
[oracle@dbserver alert] $ll
Total 0
The log file for the new Oracle database is under $ORACLE_BASE/diag/rdbms, for example: / opt/oracle/oradb/diag/rdbms/ORACLE_SID/ORACLE_SID/trace.
Alert log XML file location:
SQL > select value from v$diag_info where name = 'Diag Alert'
VALUE
/ opt/oracle/diag/rdbms/orcl/orcl/alert
SQL >
Alert log text file location:
SQL > select value from v$diag_info where name = 'Diag Trace'
VALUE
/ opt/oracle/diag/rdbms/orcl/orcl/trace
On how to clear alert log to share here, I hope that the above content can be of some help to you, can learn more knowledge. If you think the article is good, you can share it for more people to see.
