top of page

Program modules

Public·2 members

Admin
7 days ago · joined the group.
1 View

Oracle: REDO log manager

CerebroSQL: Oracle REDO log manager

[EN]

Redo logs: Redo logs are special files in the Oracle database, which ensure that all changes made by the session will be recorded in the logs in case there is a failure between the moment the changes are made and the moment they are written to the data files. Thus, repeat execution logs are the basis of the recovery process.


Oracle organizes its repeat execution log files into log groups, and you need to have at least two different groups of repeat execution logs and at least one member in each. At the very least, two groups will be required, because when one re-execution log is archived, the log writer process should be able to continue writing to the active re-execution log.


Although the Oracle database will work well enough with only one member in each group of repeat execution logs, Oracle strongly recommends multiplexing online repeat execution logs.…


34 Views

Oracle: logminer - user interface

CerebroSQL: Oracle logminer UI

[EN]

Logminer is a mechanism for extracting data from archived Oracle DBMS logs.


The sequence of actions:

  • Enter the path to the archive logs folder in the "Archivelog directory" field. 

If you expand the list, the information from v$parameter is selected, not the empty values of the log_archive_dest parameters_%


18 Views

Oracle: Compile invalid objects (wizard)


CerebroSQL: Oracle compile invalid onject

[EN]

The compiler allows you to fix errors, fix errors in the code, as well as view a list of errors for all objects.


Object tree (queries)

The tree of objects with the Invalid status. 

  • Root nodes are the name of the schema


14 Views

About

Welcome to the group! Connect with other members, get updates and share media.

bottom of page