Oracle notes: RAC Crosschecking

When you use Crosschecking on multiple nodes, you can configure the cluster so that each node in the cluster can access all Database backups, regardless of who generated the database backup. If your cluster is configured like this, you can allocate channels on any node during restore or crosscheck operations ).

If you do not CONFIGURE the cluster as mentioned above, you must use the CONNECT option of the configure channel command to allocate channels on multiple nodes during restore or crosscheck operations ), so that each backup can be accessed by at least one node in the cluster.
If no channel is configured for access to these backups during the crosscheck operation, these backups will be marked as EXPIRED.

Node 1 and node 2 both use the default configuration and perform a full backup on node 1.

[SQL]

1. -- Rac1
2. RMAN> crosscheck backup;
4. Crosschecked backup piece: foundToBe'Available'
5. Backup piece handle =/Oracle/backup/racdb_09n0hqle_1_1_12 recid = 8 stamp = 772336302
7. -- Rac2
8. RMAN> crosscheck backup;
10. Crosschecked backup piece: foundToBe'Expired' -- It is marked as EXPIRED on rac2.
11. Backup piece handle =/oracle/backup/racdb_09n0hqle_1_1_12 recid = 8 stamp = 772336302

Configure the degree of parallelism to 2 (number of nodes) on node 2, configure the channel, and then verify again

[SQL]

1. -- Rac2
2. RMAN> configure device type disk parallelism 2;
4. New RMAN configuration parameters:
5. Configure device type disk parallelism 2 BACKUP TYPETOBACKUPSET;
6. New RMAN configuration parameters are successfully stored
8. -- Racdb indicates the service name. You can also configure a single instance.
9. RMAN> configure channel device type diskConnect='Sys/oracle @ racdb';
11. New RMAN configuration parameters:
12. CONFIGURE CHANNEL DEVICE TYPE DISKCONNECT '*';
13. New RMAN configuration parameters are successfully stored
15. RMAN> crosscheck backup;
16. Crosschecked backup piece: foundToBe'Available' -- This is marked as AVAILABLE.
17. Backup piece handle =/oracle/backup/racdb_09n0hqle_1_1_12 recid = 8 stamp = 772336302