What is our objective which will be solved by this tool called as pgbadger? pgBadger is a PostgreSQL performance analyser , built for speed with fully detailed reports based on your PostgreSQL log file To get detailed view of PostgreSQL database workload , pgbadger [...]
BART is the backup and recovery tool for EDB . BART is not supported by EDB Postgres Advanced Server or PostgreSQL version 14 and later. EDB strongly recommends you move to Barman or pgBackRest as your backup recovery tool. Step 1: Install BART TOOL [...]
Control File Every oracle database has a control file.A control file is a small binary file that records the physical structure of the database .control file read only in mount stage. Min 1 or Max 8 control for single database.control file we use for recovery [...]
As an oracle dba, we need to automate things to make our life easy. So we need to monitor the below activities. 1. Alert log, place where database errors are logged. 2. File system, to check the threshold of the space where the datafiles/logfiles/control files/archive [...]
Quuntur magni dolores eos qui ratione voluptatem sequi nesciunt. Neque porro quisquam est, qui dolorem ipsum quiaolor sit amet, consectetur, adipisci velit, sed quia non numquam eius modi tempora incidunt ut labore et dolore magnam dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor [...]
Quuntur magni dolores eos qui ratione voluptatem sequi nesciunt. Neque porro quisquam est, qui dolorem ipsum quiaolor sit amet, consectetur, adipisci velit, sed quia non numquam eius modi tempora incidunt ut labore et dolore magnam dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor [...]
