This is the second post/script in this series, the first script is Oracle RMAN Database Full Hot Backup Script The following script will fully backup the database while it is closed (in the mount state). This backup will be a consistent backup that needs no archive logs to be recovered. # ************************************************************************************** # $Header: abc_rman_full_cold_bkp.sh * … Continue reading Oracle RMAN Database Full Cold Backup Script
Oracle RMAN Database Full Hot Backup Script
I was asked by one of my customers to develop some rman backup/restore scripts. These scripts are a modified versions from some old scripts developed by me + some enhancement from other similar scripts . Following is the first script in the series, it to fully backup the database while it is open. -- {Please … Continue reading Oracle RMAN Database Full Hot Backup Script
Installing Oracle Apex 5.1.4 on Oracle Database 12c R2
This is a quick post on how to install Oracle Apex version 5.1.4 on Oracle Database 12.2 on Windows platform. 12cR2 Update: From Oracle Database 12c Release 2 (12.2) onward APEX is not installed by default, so you no longer need to worry about uninstalling APEX before creating PDBs. The software is still shipped with … Continue reading Installing Oracle Apex 5.1.4 on Oracle Database 12c R2
Oracle Database 12c R2 Partitioning New Features – Automatic List Partitioning
Oracle Database 12.2 introduces new nice and powerful partitioning features. This post will introduce one of them “Automatic List Partitioning”. We may talk about other features in future posts. Before 12.2, if you have a list partitioned table in specific discrete values, and there is a need to add a new list value, then you … Continue reading Oracle Database 12c R2 Partitioning New Features – Automatic List Partitioning