Before Oracle10g, the alarm log is located in the bdump folder, but the 11g has changed this, introducing the ADR (a directory that stores the database diagnostic logs and tracking files), which corresponds
Before Oracle 10 Gb, the warning log is located in the bdump folder, but 11 GB has changed the log and introduced ADR (a directory that stores the diagnostic logs and tracking files of the database), which corresponds
Before Oracle 10 Gb, the warning log is located in the bdump folder, but 11 GB has changed the log and introduced ADR (a directory that stores the diagnostic logs and tracking files of the database ), its initialization parameter is DIAGNOSTIC_DEST. If the $ ORACLE_BASE environment variable is set, DIAGNOSTIC_DEST is equal to $ ORACLE_BASE. If $ ORACLE_BASE is not set, it is equal to $ ORACLE_HOME/log.
You can use the following statement to query the path of the 11g alarm log:
-- Display the location of DIAGNOSTIC_DEST
1. show parameter DIAGNOSTIC_DEST;
-- Query the directory of the xml file
2. select value from v $ diag_info where;
-- Query the directory of a text file
3. select value from v $ diag_info where;
4. show parameter background_dump_dest;
5. select value from v $ parameter where;
Note: Oracle 11g alarm logs are stored in two formats: xml and text.