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 course material, articles and scripts. All Oracle database, MySQL, MS SQL Server, Oracle Golden Gate, Oracle RAC, Oracle Enterprise Manager and cloud articles in one place.
Actived: 1 days ago
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, etc. Also, DBA must be able to get the backup start time, end time, and even the backup size for reference purposes. The below query gives answers to all the backup details
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 Diskgroup Usage. Query to Find ASM Disks Usage. Query to Find Databases Connected to ASM. Add Disk to ASM Diskgroup. ASM Disks Header and Mount Status.
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 about password file, what is stored inside password file and its use?
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 stick to OS level scripting. Before you learn how to schedule jobs via DBMS_SCHEDULER, let us compare it with cron jobs (OS level scripts)
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 crontab. For example, we are. scheduling backup to trigger at 10 am and 4 pm everyday. crontab -e. 00 10,16 * * * /u01/rman/full_backup.sh.
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 archivelog; Once backup is completed, check backup tag via below command. RMAN> list backup of database summary;TAG20170115T113749 -–> L0 Backup tag. Create New User & Table.
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 START. crsctl disable has. crsctl enable has. CRACTL utility allows you to administer cluster resources. Here are few quick commands to help you administer Oracle RAC cluster!
Top Categories
Popular Searched
› Mary washington healthcare occupational therapy
› Private full health check london
› Mississippi state department of health agencies
› My aarp medicare united health care login
› Accidental insurance vs health
› South boston health rehab fire
› Medical city healthcare remote access
› Triwest healthcare alliance wps
Recently Searched
› Essentia health wait time map
› Department of health services logo
› Amerihealth nj eligibility check
› What is primary health care needs
› Accent home health canoga park
› Highland health greenfield medical center
› Strategic health authority uk
› Unitypoint health virtual visit