Hot answers tagged

3

I write a bash script to perform the backups (RMAN, datapump and also xtrabackup and dump for MySQL in a similar way) and then call that from cron. That way you can handle the email as you want. So a simple crontab line is like this 00 18 * * 0-6 /dba/bin/rman.sh > /tmp/dba_rman_SID.log 2>&1 Then everything is done in the script. So define ...


3

tnsnames.ora doesn't "come with" anything. The key is not that file, as it is nothing but a names resolution file. And sqlplus is nothing but a CLI application. If you want to connect to an Oracle database (or ANY database) you must have, at a minimum, the client software for that particular database product. For oracle you need to download and install the ...


2

The design should be according to your requirements. If your requirement includes to store only some columnar data that are mostly required (mostly not null) then use tables with relations (foreign keys). If you just need some logging with situational tree structure data then use JSONB. For example, suppose that you store io_counters when counters are ...


2

It is possible using cgroups. Some tutorials are available as well as shell script for Ubuntu 14.04. See also Is there any option to limit mongodb memory usage? on Stack Overflow.


1

The problems got removed, when i swapped the my.cnf file, with a highly simplified version of it, which was earlier present in a machine, having MySQL 5.6. So possibly the issue was with my.cnf file. # For advice on how to change settings please see # http://dev.mysql.com/doc/refman/5.6/en/server-configuration-defaults.html [mysqld] init-connect='SET ...


1

This is the code that I came up with to get the information: #!/bin/bash ###################### ##BY: kixes ## ##Created: 4-1-2016 ## ##Version: 1.01 ## ###################### ##################### ######Variables###### ############################################################# #LogFile is where the ErrorLog dumps its filtered error log ...



Only top voted, non community-wiki answers of a minimum length are eligible