What are the oracle logs?

oracle log: 1. Warning log, also known as "alert log" file; 2. Trace log, used to store seesion tracking information; 3. Audit log, used to store audit information; 4. redo Log, used to store change information of the database; 5. Archive log, used to store historical backup of redo logs.

The operating environment of this tutorial: Windows 10 system, Oracle version 12c, Dell G3 computer.

What are the oracle logs?

There are several types of oracle log files: warning log, trace log, audit log, redo log, archive log

• Warning log:

is the alert log,

is set in the system initialization parameter file

show  parameter background_dump_dest

• trace log:

generally contains seesion tracking information,

corresponds to the system initialization parameter file parameters

show parameter user_dump_dest

• audit log:

Audit information,

corresponds to the system initialization parameter file parameter audit_file_dest, which corresponds to its location.

• redo log:

Stores the change information of the database,

select member from v$logfile;member

• Archived log:

Historical backup of redo log,

select * from v$parameter where name like 'log_archive_dest%';

Extended command:

select * from dba_users; View all users in the database

select * from v$logfile; View online log status;

select * from v$instance; View all instance information;

select * from v$dba_data_files;Data file table, you can view table space information

Recommended tutorial: "Oracle Video Tutorial"

The above is the detailed content of What are the oracle logs?. For more information, please follow other related articles on the PHP Chinese website!