Rollback Segment Count settings in Oracle Database

One caveat of altering _rollback_segment_count to a higher value and reducing is that Oracle will never drop/remove newly created rollback segments. The segments will be OFFLINE after you restart the database. I just did some experiments with _rollback_segment_count in Primary/Standby environment. From Primary, we can see _rollback_segment_count is set to 0 and 11 rollback segmentsRead more about Rollback Segment Count settings in Oracle Database[…]

Oracle Standby Redo Transport SYNC mode Tracing

Standby database is replica of Primary database synchronized using redo log (archived redo log). Redo log generated in Primary is send to standby depending upon transport settings in primary. It can be send using Log Write or Archiver process. There are 3 Dataguard protection modes. They are Maximum Availability, Maximum Performance and Maximum Protection. InRead more about Oracle Standby Redo Transport SYNC mode Tracing[…]

Step by Step oracle 11gR2 Physical Standby database setup

This article steps through the process of creating a physical standby database using RMAN from a live database. Preparing the primary database for standby environment Enable Force logging It is required to place the primary database in FORCE LOGGING mode after database creation. This makes the Oracle Database to force writing of redo records evenRead more about Step by Step oracle 11gR2 Physical Standby database setup[…]