Manual Switchover involving RAC 11g using SQL*Plus

Posted by oraclue on April 22, 2010 · 5 Comments 

1.    Verify that it is possible to perform a switchover operation. On the primary query the switchover_status column of v$database to verify that switchover to standby is possible. SQL> select switchover_status from v$database; SWITCHOVER_STATUS —————— TO STANDBY ( or SESSIONS ACTIVE is also ok) SESSIONS ACTIVE – Indicates that there are active SQL sessions attached … Read more

Filed under HA

OEM 11g Grid Control Release 1

Posted by oraclue on April 19, 2010 · Leave a Comment 

Oracle is releasing OEM 11g  on April 22nd.However OEM 11g R 1 is available to download from Oracle E-Delivery site ( 3 files total 4.2 Gb – Linux x86-64 ) http://edelivery.oracle.com Also you can register for Webcast to watch this live event: http://www.oracle.com/enterprisemanager11g/index.html http://www.oracle.com/webapps/events/EventsDetail.jsp?p_eventId=110011&src=6773871&src=6773871&Act=45 Oracle originally  had OEM 11g R1 documentation available online but it’s removed .It … Read more

Filed under Performance

Snapshot Standby

Posted by oraclue on April 8, 2010 · 8 Comments 

Converting physical standby to snapshot standby Depens on Data guard configuration change protection mode: On Primary database: SQL> ALTER DATABASE SET STANDBY DATABASE TO MAXIMIZE  PERFORMANCE ; SQL>  alter system archive log current; Use these queries to check synchronization between primary and standby: Primary: SQL> select thread#, max(sequence#) “Last Primary Seq Generated” from v$archived_log val, … Read more

Filed under HA