Profile cover photo
Profile photo
S Bayliss
8 followers
8 followers
About
Posts

Post has attachment
Mysql Enterprise Backup verison 3.11 New Feature - Optimistic Backup
A quick post.  I have also been looking at MEB 3.11 (we currently use
3.10).  There is a new feature called ‘Optimistic Backup’.  This
feature maybe worth considering as it allows you to specify tables (or a time)
that most tables were not changed during th...

Post has attachment
MySQL Enterprise Backup, Using Incrementals
As an experiment I have been testing MySQL Enterprise Backuip (MEB) and incremental backups.   The idea was to test backing up a multi terabyte database.   The plan was to test using incremental backups to try and get the backup time more manageable.  First...

Post has attachment
Oracle Upgrade plan to 12.1.0.2
I have recently been working on a project to upgrade to 12c. All of our UAT and PRODUCTION system are RAC so we need to upgrade GI and the DB. We are currently at version 11.2.0.2 with a few extra patches installed.  With premier support ending in Jan 2015,...

Post has attachment
Transportable Tablespaces 5.7
In MySQL 5.7 transportable tablespaces works at a partition level: alter table <table> discard partition <partition> tablespace; a lter table <table> import partition <partition> tablespace; This is the source database. root [(none)]> create database arcdat...

Post has attachment
Oracle Issue running 12.1.0.2 clusterware with 11.2.0.2 database
Recently been tasked with planning an upgrade from 11.2.0.2 to 12.1.0.2. After the upgrade I  needed to install another database so the cluster had two databases. Oracle Cluster = 12.1.0.2 Oracle Database = 11.2.0.2 So I ran dbca from the Oracle Database ho...

Post has attachment
Mysql Dump and partitions
Recently I was looking at archiving tools.  We finally got an agreement to keep a smaller subset of data available as long as could restore more if required. The main tools we use are MEB and mysqldump. So I created a partition table and populated it: CREAT...

Post has attachment
Oracle 12c RAC Installation on Red Hat 6
Once all the   checks are complete run runcluvfy to ensure
components are installed. During an install of Oracle 12cR1
RAC Grid Infrastructure on Red Hat or CentOS 6.2, 6.3 or 6.4, you run the runcluvfy.sh script to test node
readiness and it fails with the...

Post has attachment
MySQL 5.6 parameters
Been performing a few upgrades from 5.5 to 5.6.   It is general a straight forward process but I wanted to get some information about the MySQL 5.6 parameters. My Quick Upgrade Path Take backup of database(s) Take a backup of the my.cnf Stop the application...

Post has attachment
Oracle....the small things
I have been neglecting my blog recently and decided to devote a page to some of the small things I have done.   They are not necessarily about how something works instead some are showing syntax and others useful things.  Also this is a reminder for myself ...

Post has attachment
Silent Install of the 11gR2 Oracle Client failing
Surprising error whilst performing a silent error installing Oracle. Using paramFile: /home/oracle/Oracle/client/install/oraparam.ini Checking Temp space: must be greater than 120 MB.   Actual 2225807 MB    Passed Checking swap space: must be greater than 1...
Wait while more posts are being loaded