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
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
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
Protected: Oracle Database Migration to Exadata – Case Study
There is no excerpt because this is a protected post.
How to change the Apex Application from LTR to RTL?
If you are developing Arabic application using Oracle Apex and want to change the the direction of the whole application from LTR(Left-To_Right) to RTL (Right-To-Left) , heer are the quick steps: 1- Select the application Select Shared Components. then select "Globalization" Then set the "Document Direction" attribute to "Right-To-Left" That is all! ThanksAhmed
sqlcl Multi-Line Paste Issue
What is the issue? I noticed that sometimes when I copy SQL statement from web and paste it on sqlcl , it is copied on many lines and generating errors. For example, when I copied the following statement: And pasted into sqlcl running on the windows command window, it was pasted as follows: So, it … Continue reading sqlcl Multi-Line Paste Issue
Oracle tnsnames.ora Distribution Management System!
What? Does tnsnames.ora file need a Distribution Management System? In our case, the answer is yes. It is a headache to implement our client requirements without some sort of automation. What is tnsnames.ora file? tnsnames.ora is a text file that resides on the ORACLE_HOME/network/admin and contains some simple information about our databases connection information, it … Continue reading Oracle tnsnames.ora Distribution Management System!
Ahmed AbdelFattah Blog ! 