Checking the redo log [oracle@localhost OCM]$ sqlplus / as sysdba SQL*Plus: Release 11.2.0.3.0 Production on Wed Jan 29 11:43:38 2014 Copyright (c) 1982, 2011, Oracle. All rights reserved. SQL> col member for a55 SQL> select GROUP#, STATUS, TYPE, MEMBER from v$logfile; GROUP# STATUS TYPE MEMBER ———- ——- ——- ——————————————————- 3 ONLINE /u01/app/oracle/oradata/OCM/redo03.log 2 ONLINE /u01/app/oracle/oradata/OCM/redo02.log […]

Switchover   –   Role reversal between primary and standby databases. Old primary is now a standby. Used for hardware upgrades, OS upgrades, etc. ·        Failover   –   Primary is down with little hope of quick recovery (ie. hardware failure on primary machine).Once failover has been initiated , the old primary database is no longer useful. STEPS OF SWITCHOVER On primary database: Sql> […]

1. Run DBCA from a terminal login as Oracle user. You can use PUTTY from a HOST System as well by setting the DISPLAY for x-windows. Select -> Create Database   2. Select General Purpose, as this is just for testing purpose I want to use all the features of Oracle 11g and as well with the Example […]