Oracle Database 12c Password File

Posted on by Ahmed Abdel Fattah

Introduction: I (and we) used to see the oracle database password file under $ORACLE_HOME/dbs for both single instance and RAC databases. Example for RAC database: On node1 /u01/app/oracle/product/11.2.0/dbhome_1/dbs/orapwPROD1 On node2 /u01/app/oracle/product/11.2.0/dbhome_1/dbs/orapwPROD2 If one password file was changed in one node, then you have to copy it to all other nodes in the cluster. What is … Continue reading Oracle Database 12c Password File

How to Enable Archivelog Mode for an Oracle database

Posted on by Ahmed Abdel Fattah

This is a quick post about the steps required to enable the ARCHIVELOG mode for an oracle database (Single Instance or RAC) To check if the archive log mode is enabled or not, use the following command: SYS@XPS 01-SEP-18 SQL> archive log list Database log mode               No Archive Mode … Continue reading How to Enable Archivelog Mode for an Oracle database

Oracle Database Fast Cloning Options for Databases on Supercluster

Posted on by Ahmed Abdel Fattah

I had a question from one of my customers about the available fast cloning options for Oracle databases. This customer has a supercluster on the production site and another supercluster on the DR site. The client requirement is to be able to prepare a new Test/Dev database in minutes , not hours for their large … Continue reading Oracle Database Fast Cloning Options for Databases on Supercluster

Oracle RMAN Database Incremental Backup Script

Posted on by Ahmed Abdel Fattah

This is the third post/script in this series, the first script was Oracle RMAN Database Full Hot Backup Script The second script was Oracle RMAN Database Full Cold Backup Script The following script will incrementally backup the database while it is open (although it may be used while the database is in the mount mode also). #***************************************************************************** … Continue reading Oracle RMAN Database Incremental Backup Script

Oracle RMAN Database Full Cold Backup Script

Posted on by Ahmed Abdel Fattah

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

Posted on by Ahmed Abdel Fattah

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

Oracle Database 12c R2 Partitioning New Features – Automatic List Partitioning

Posted on by Ahmed Abdel Fattah

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