Introduction: This is a real data guard implementation case for one of my clients. Data Guard is implemented between two clusters that reside on two different supercluster machines. The below procedure applies between any two clusters, it doesn't matter if it is a supercluster or Exadata or normal servers. I tried to put as much … Continue reading Oracle Database Guard 12c Implementation with RAC (Step-by-Step)
via Oracle Data Guard 12c Switchover Issues
There is no excerpt because this is a protected post.
Introduction: We may classify the database services into two types of services : 1- Database Services 2- Cluster Managed Database Services Please note that: - The procedure dbms_service.start_service - used with the first type - is deprecated in databases managed by Oracle Clusterware and Oracle Restart with Release 11.2. While the procedure remains available in … Continue reading Oracle Database Services in (Oracle RAC + Oracle Data Guard) Environment
There is no excerpt because this is a protected post.
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
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
via 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
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
Ahmed AbdelFattah Blog ! 