There is no excerpt because this is a protected post.
Oracle Database 12c Password File
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
Oracle Database Fast Cloning Options for Databases on Supercluster
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
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
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
Protected: Oracle RAC 12c Installation on Two Linux Virtual Machines
There is no excerpt because this is a protected post.
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
How do Nologging Operations affect Recovery and Data Guard?
What is Redo Information: Each Oracle Database instance has redo logs, which consists of two or more preallocated files that store all changes made to the database as they occur. Every instance of an Oracle Database has an associated redo log to protect the database in case of an instance failure. What is Nologging: NOLOGGING can be used to prevent bulk operations from … Continue reading How do Nologging Operations affect Recovery and Data Guard?
Ahmed AbdelFattah Blog ! 