Skip to main content

Benchmarking Oracle Database@AWS Exadata Dedicated: Backup & Restore Channel Scaling vs. Orchestration Overhead

 When designing disaster recovery (DR) architectures and tuning Recovery Point/Time Objectives (RPO/RTO) on Oracle Database@AWS (Exadata Dedicated), database administrators intuitively look to RMAN parallel channel allocation.

However, cloud-native managed database workflows wrap raw RMAN operations inside automated orchestration frameworks. Recent benchmark testing across 4-channel and 8-channel configurations reveals an important operational insight: the primary bottleneck is not RMAN data streaming, but the pre-flight and post-execution orchestration overhead.

1. Backup Performance Analysis: The 16-Minute Fixed Cost (Using ARS)

In testing full database backups, scaling channels from 4 to 8 had virtually zero impact on the end-to-end elapsed time.

Benchmark Data


Metric4 Channels 8 Channels Delta / Impact
Actual Backup Duration (RMAN)03:03:0503:06:39 (3m 34s)03:02:2503:05:57 (3m 32s)2s difference (negligible)
Total Duration (with Pre-checks)22m 12s22m 10s2s difference
Pre-Check Overhead~18m 38s~18m 38sFixed automation overhead
Backup Time Breakdown (Total: ~22 mins):  Pre-checks: ~18m 38s (84%)
                                                                         RMAN: ~3m 30s (16%                                                               

Key Observation:

  • Pre-checks dominate backup runs: The actual RMAN backup streams in under 4 minutes, but platform pre-checks introduce a consistent ~16 to 18-minute flat overhead, regardless of whether 4 or 8 channels are used.

  • I/O Bandwidth is not the constraint: For smaller or mid-sized datasets, 4 channels already saturate the required throughput; additional channel concurrency cannot optimize the fixed orchestration layer.


2. Restore & Recovery Analysis: Core I/O Gains vs. The 45-Minute Wrapper

When creating a database from backup (restore + recovery), increasing channel counts delivers tangible I/O acceleration during data streaming, but cloud wrapper orchestration remains the dominant time sink.

Database Restore Timeline

Restore and recovery comparison — 4 channels | 8 channels

Milestone

4 Channels 

8 Channels 

Create database from backup initiated

04-Sep-2026 03:45:54

05-Sep-2026 00:27:56

Datafiles restore started

04-Sep-2026 04:10:18

05-Sep-2026 00:54:20

Datafiles restore finished

04-Sep-2026 04:23:57

05-Sep-2026 01:02:39

Recovery started

04-Sep-2026 04:24:09

05-Sep-2026 01:02:48

Recovery finished

04-Sep-2026 04:27:55

05-Sep-2026 01:04:48

Create database from backup completed

04-Sep-2026 04:47:27

05-Sep-2026 01:23:43

Total time

61 minutes and 33 seconds

55 minutes and 47 seconds


Restore Time Breakdown: 
4 Channels: [ 24m 24s Pre-Checks ] [ 13m 39s Restore ] [ 3m 46s Recov ] [ 19m 32s Post-Config ] = 61m 33s 
8 Channels: [ 26m 24s Pre-Checks ] [ 8m 19s Restore ] [ 2m 00s Recov ] [ 18m 55s Post-Config ] = 55m 47s

Key Observation:

  • RMAN Scaling Works Efficiently: Doubling channels from 4 to 8 reduced raw datafile restore time from 13m 39s down to 8m 19s (a 39% speedup) and cut redo apply/recovery in half (3m 46s to 2m 00s).

  • The 45-Minute Automation Bottleneck: Pre-flight provisioning (storage, network, instance validation) takes ~24–26 minutes, and post-recovery operations (resetlogs, spfile configuration, Grid Infrastructure/CRS cluster registration, service configuration) take ~19 minutes.

  • Non-RMAN orchestration accounts for ~45 minutes (75% to 80%) of the entire 1-hour restore window.


Account for Fixed Overhead in Restore SLAs:

  • When defining realistic Recovery Time Objectives (RTO) and Recovery Point Objectives (RPO) on Oracle Database@AWS Exadata Dedicated, always factor in a ~45-minute orchestration baseline on top of projected raw data transfer rates.




Comments

Popular posts from this blog

ORA-65139: Mismatch between XML metadata file and data file

Error: CDB$ROOT@EBTUPRDC> CREATE PLUGGABLE DATABASE EBTUSPRDPDB1 using '/home/oracle/EBTUSPRDC.xml' nocopy tempfile reuse; CREATE PLUGGABLE DATABASE EBTUSPRDPDB1 using '/home/oracle/EBTUSPRDC.xml' nocopy tempfile reuse * ERROR at line 1: ORA-65139: Mismatch between XML metadata file and data file /u05/odb/ORADATA_1/EBTUSPRDC/datafile/system.1531.807800993 for value of fcpsb (2230502002 in the plug XML file, 2230505492 in the data file) Fix: Don't open Non-CDB database until we complete pdb creation other wise we will get above error. Shutdown immediate; startup mount; alter database open read only; create xml file. shutdown immediate; Connect to CDB and Create Pluggable database .

Useful OEM Queries to get Target details from OEM Repository

List Targets with TNS Listener ports configured : SELECT mgmt$target.host_name , mgmt$target.target_name , mgmt$target.target_type , mgmt$target_properties.property_name , mgmt$target_properties.property_value FROM mgmt$target , mgmt$target_properties WHERE ( mgmt$target.target_name = mgmt$target_properties.target_name ) AND ( mgmt$target.target_type = mgmt$target_properties.target_type ) and ( mgmt$target.target_type = 'oracle_listener' ) and ( mgmt$target_properties.property_name = 'Port' ); Devora02       LISTENER_ora02                       oracle_listener Port 1529 Devora01       LISTENER_ora01                       oracle_listener Port 1529 Devora04       LISTENE...

TFA-00002 : Oracle Trace File Analyzer (TFA) is not running

TFA Failed to start listening for commands on one of the Rac Node : As a root user /etc/init.d/init.tfa  start Starting TFA.. start: Job is already running: oracle-tfa Waiting up to 100 seconds for TFA to be started.. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . Successfully started TFA Process.. . . . . . TFA-00002 : Oracle Trace File Analyzer (TFA) is not running TFA Failed to start listening for commands Solution : run synctfanodes.sh  if you have root password . if no root password copy below files to TFA Failed node and try to restart TFA .. Please check whether these 4 files exist on all nodes are similar. TFA_HOME/server.jks TFA_HOME/client.jks TFA_HOME/internal/ssl.properties   TFA_HOME/internal/ portmapping.txt If not similar just copy these files to TFA Failing node and try TFA Restart ..It Worked for me .   [root@host01]# ./tfactl  -v "debug" start Starting TFA...