Support.dbagenesis.com

DBA Genesis Support Linux, Database, Cloud articles

WebThis article demonstrates MySQL installation on Cent OS Linux 7 version. Installation of MySQL Install wget to download MySQL repository Get free access to DBA Genesis …

Actived: 1 days ago

URL: https://support.dbagenesis.com/

How to check database backups

WebChecking Database backups is one of the main focus areas of a DBA. From time to time, DBA needs to check database backup status and see if it's completed, failed, running, …

Category: Health Go Health

Check Oracle database size

WebFor very big databases where the size run into multiple GB or TB, below command will help you get a bird’s eye view on the database size, used space and free space.

Category: Health Go Health

Oracle Database Health Check

WebDaily DB Health Checks. Below are daily checks which are to be performed by a DBA: 2. Check ALERT log errors. 3. Capacity planning – Tablespace space checking&Archive …

Category: Health Go Health

Oracle ASM Queries

WebThe fastest way to administer ASM is via sqlplus / as sysasm. Here are some of my favorite ASM queries that will help you quickly understand its configuration. Query to Find ASM …

Category: Health Go Health

Senior Oracle DBA Interview Questions

Web3+ Years of DBA Experience Interview Questions. Below are the senior Oracle DBA interview questions for people who are projecting 3+ years of DBA experience. Explain …

Category: Health Go Health

Automate RMAN Backup using Shell Script

WebSchedule Backup Under Crontab. Give execute permissions on the shell script. chmod 775 /u01/rman/full_backup.sh. Now you can go ahead and schedule the backup under the …

Category: Health Go Health

Miscellaneous DBA Genesis Support

WebArchived Oracle database articles to administer previous releases of Oracle database. Administer Oracle 9i, 10g, 11g and 12c versions of database with these scripts.

Category: Health Go Health

RMAN Incremental Backup & Recovery

WebStart Database Recovery. Take RMAN Incremental Backup. Connect to the target DB and catalog. Take level 0 backup. RMAN> backup incremental level 0 database plus …

Category: Health Go Health

Oracle CRSCTL Commands List

WebStart entire cluster on all nodes. ./crsctl start cluster –all. Start cluster (CRS + HAS) on remote node. ./crsctl start cluster –n rac2. ENABLE – DISABLE CLUSTER AUTO …

Category: Health Go Health

Scheduling Jobs with DBMS_SCHEDULER

WebSTEP 1 – Create program. STEP 2 – Create schedule. STEP 3 – Create job. Important Queries. Note: DBMS_SCHEDULER has introduced many benefits yet, many DBAs still …

Category: Health Go Health