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

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.

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.