Arul’s Oracle Zone

~my references and inferences of Oracle

Archive for October 17th, 2007

Getting the RAC mindset

Posted by Arul Ramachandran on October 17, 2007

For an Oracle DBA who has been working on non-RAC databases for a while, when asked to work on a RAC database even if the DBA has hands-on experience with RAC and its concepts, it takes a shift in mindset to administer a RAC database.

Basic tasks that were second nature in non-RAC becomes a bit different in RAC.

For example, if the DBA has to

  • convert the database to [NO]ARCHIVELOG mode
  • recover SYSTEM tablespace due to media failure

then the instance needs to be mounted with the parameter CLUSTER_DATABASE flipped to FALSE. After performing the desired operation, the instances would need to bounced with the parameter set to TRUE. Essentially, the database is turned into a single instance database; after performing the desired operation, it is started in clustered mode.

This in contrast to a non-RAC database where you just shutdown/startup mount the database and do the the desired operation.

Well… this is just a small example to demonstrate the need for the RAC mindset… :)

Posted in RAC | Leave a Comment »