Exadata backup and recovery in oracle

Exadata backup recovery is the same as that of a single machine or RAC database, but there are some optimization best practices for multiple nodes. Today, we will briefly talk about the backup and recovery of Exadata.

To fully utilize the I/O capability and multi-node advantages of Exadata, we recommend that you allocate two channels on each DB node for testing. In addition, to allow all DB nodes to participate in the backup task, you can create a failover service on each node. The following is an actual test configuration and script for your reference only.

Srvctl add service-d df-s bkup1-r df1-a df2, df3, df4
Srvctl add service-d df-s bkup2-r df2-a df1, df3, df4
Srvctl add service-d df-s bkup3-r df3-a df1, df2, df4
Srvctl add service-d df-s bkup4-r df4-a df1, df2, df3

Srvctl start service-d df

Export ORACLE_HOME
Export NLS_DATE_FORMAT = "YYYY/MM/DD HH24: MI: SS"
Begin_time_sec = 'date + % s'

Set echo on
Run
{
Configure default device type to disk;
Configure device type disk parallelism 8;

Allocate channel ch01 device type disk connect 'sys/welcome1 @ x3-scan/bkup1 ';
Allocate channel ch02 device type disk connect 'sys/welcome1 @ x3-scan/bkup2 ';
Allocate channel ch03 device type disk connect 'sys/welcome1 @ x3-scan/bkup3 ';
Allocate channel ch04 device type disk connect 'sys/welcome1 @ x3-scan/bkup4 ';
Allocate channel ch05 device type disk connect 'sys/welcome1 @ x3-scan/bkup1 ';
Allocate channel ch06 device type disk connect 'sys/welcome1 @ x3-scan/bkup2 ';
Allocate channel ch07 device type disk connect 'sys/welcome1 @ x3-scan/bkup3 ';
Allocate channel ch08 device type disk connect 'sys/welcome1 @ x3-scan/bkup4 ';
Backup
As backupset
Incremental level 0
Section size 128g
Database;
}
End_time_sec = 'date + % s'

Total_execution_time_sec = 'expr $ {end_time_sec}-$ {begin_time_sec }'

Echo "Script execution time is $ total_execution_time_secseconds"

The figure below shows a screenshot of the official data. For the original article, refer to the white paper.

As you can see from the figure above, in version 11203, with a full X2-2, the disk backup speed can reach 20-25 TB per hour. In version 11202, it can reach 17-18 TB per hour.

For recovery, the following is a reference script:
In this example, a test is performed in the 1/8 configuration environment and 16 channels are used to create a service for each node. Note that the tablespace is restored instead of the full database. You can perform full database recovery with slight modifications.

Run
{

Allocate channel ch01 device type disk connect 'sys/oracle @ bg1 ';
Allocate channel ch02 device type disk connect 'sys/oracle @ bg1 ';
Allocate channel ch03 device type disk connect 'sys/oracle @ bg1 ';
Allocate channel ch04 device type disk connect 'sys/oracle @ bg1 ';
Allocate channel ch05 device type disk connect 'sys/oracle @ bg2 ';
Allocate channel ch06 device type disk connect 'sys/oracle @ bg2 ';
Allocate channel ch07 device type disk connect 'sys/oracle @ bg2 ';
Allocate channel ch08 device type disk connect 'sys/oracle @ bg2 ';
Allocate channel ch09 device type disk connect 'sys/oracle @ bg1 ';
Allocate channel ch010 device type disk connect 'sys/oracle @ bg1 ';
Allocate channel ch011 device type disk connect 'sys/oracle @ bg1 ';
Allocate channel ch012 device type disk connect 'sys/oracle @ bg1 ';
Allocate channel ch013 device type disk connect 'sys/oracle @ bg2 ';
Allocate channel ch014 device type disk connect 'sys/oracle @ bg2 ';
Allocate channel ch015 device type disk connect 'sys/oracle @ bg2 ';
Allocate channel ch016 device type disk connect 'sys/oracle @ bg2 ';

SQL 'alter TABLESPACE eighth OFFLINE immediate ';
Restore tablespace eighth;
Recover tablespace eighth;
SQL 'alter TABLESPACE eighth Online ';

}