How to Install UNZIP in AIX 7.2
I found there's no unzip utility available in AIX 7.2. $ which unzip which: 0652-141 There is no unzip in /usr/bin /etc /usr/sbin /usr/ucb /home/oracle/bin… Read More »How to Install UNZIP in AIX 7.2
Compression
How to Compress RMAN Backupset
You can enable the compression feature of RMAN by the following 2 ways: One time setting RMAN> show all; RMAN configuration parameters for database with… Read More »How to Compress RMAN Backupset
How to Backup and Restore Under Encryption and Compression
If your database is running on Enterprise Edition, then you can have encryption and compression option. Let's see the version we are running first.SQL> select… Read More »How to Backup and Restore Under Encryption and Compression
2 Steps to Compress MySQL Tables
Two steps to make your table compressed.Set the server INNODB_FILE_FORMAT to Barracuda.mysql> SET GLOBAL INNODB_FILE_FORMAT=Barracuda;Alter table to compressed with 8KB key block size.mysql> ALTER TABLE `compressed table` ROW_FORMAT=COMPRESSED,… Read More »2 Steps to Compress MySQL Tables
How to Resolve Very Big Dump File of MySQL
I usually backup the database by mysqldump, but the plain SQL dump file was getting larger and larger and took most of the free space.… Read More »How to Resolve Very Big Dump File of MySQL