Oracle RAC - OCR Backups

The backups are taken on the OCR Master node. The OCR Master can change over time. 1. The default OCR master is always the first node that's started in the cluster. 2. When OCR master (crsd.bin process) stops or restarts for whatever reason, the crsd.bin on surviving node with lowest node number will become new OCR master.

Object and Tablespace I/O

The V$SEGMENT_STATISTICS view can be used to gather the statistics you need on access patterns of database segments. To find the database segments that incur the most I/O, use a query similar to the following: select owner,object_name,tablespace_name,sum(value) as total_io_operations from v$segment_statistics where statistic_name in ('physical reads','physical reads direct', 'physical writes','physical writes direct') group by owner,object_name,tablespace_name order by total_io_operations;