Learning Oracle Integration Cloud Services SOA | BPM

Oracle Data Guard -- Manual Switch Over ON PRIMARY DATABASE: Step # 1 Check Role of Primary Database SQL> Select Database_role from v$database; It will return "Primary". Step # 2 Now check Switchover status of the database. SQL> Select switchover_status from v$database; It will return "Session Active" Step # 3 Now perform manual switchover. SQL> Alter Database commit to switchover to physical standby with session shutdown; Database Altered. Your Database has become Physical Standby. Step # 4 You can verify this by querying Database_role of v$database, this time it will return "Physical Standby". Shutdown the database and again start it to mount stage. SQL> Shutdown Immediate; SQL> Startup Mount; SQL> Select Database_role from v$database; DATABASE_ROLE ------------------------- PHYSICAL STANDBY ON STANDBY DATABASE: Step # 1 Check Role of Standby Database SQL> Select Database_role f...

Basic Information of Machines 1. Primary DB: Database Name: ORCL Unique Name: Primary Machine IP: 192.168.0.1 TNS Service Name: toStandby 2. Standby DB: Database Name: ORCL Unique Name: Standby Machine IP: 192.168.0.2 TNS Service Name: toPrimary Configuring For Remote Installation To configure Secure Shell: 1. Create the public and private keys on all nodes: [PrimaryDB]$ /usr/bin/ssh-keygen -t dsa [StandbyDB]$ /usr/bin/ssh-keygen -t dsa 2. Concatenate id_dsa.pub for all nodes into the authorized_keys file on the first node: [PrimaryDB]$ ssh 192.168.0.1 "cat ~/.ssh/id_dsa.pub" >> ~/.ssh/authorized_keys [PrimaryDB]$ ssh 192.168.0.2 "cat ~/.ssh/id_dsa.pub" >> ~/.ssh/authorized_keys 3. Copy the authorized_keys file to the other nodes: [PrimaryDB]$ scp ~/.ssh/authorized_keys 192.168.0.2:/home/oracle/.ssh/ 4. Copy ~/.ss...