The graceful switch over will work only for "SELECT" statement. If a transaction uses INSERT/UPDATE statement on the Primary DB, then it will not be carried over work standby DB when it becomes production. Though the idea of having same service name pointing to primary DB and standby DB, it is of much help ful that every time you need not change the tnsnames.ora file.