Get the App
SLTechnology News&Howtos  ›  Database  › 

How RMAN uses Mirror backup

Shulou Source: shulou.com Published: 2022-05-31 15:10:48 11月14日 Update

This article is about how RMAN uses mirror backups. The editor thinks it is very practical, so share it with you as a reference and follow the editor to have a look.

RMAN provides a more cautious backup strategy: Duplexed backup. In essence, while generating a backup set, it generates backup replication files with a specified score (no more than 4) to the specified location.

1. There are three ways to implement Duplexed backup in RMAN:

(1) specify a compound backup when executing the BACKUP command

RMAN > BACKUP COPIES 3 DATABASE

(2) use SET BACKUP COPIES command to specify compound backup in RUN block

RMAN > RUN {

SET BACKUP COPIES 2

BACKUP DEVICE TYPE DISK FORMAT'/ backup1/%U','/ backup2/%U'

TABLESPACE USERS

}

(3) use CONFIGURE command to automatically specify compound backup

RMAN > CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default

RMAN > CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default

two。 Whether to use mirror backup

The advantage of mirror backup is that multiple image files can be generated at the same time. Transferring redundant image files to different places or different machines can avoid natural disasters (such as fires, earthquakes, etc.). For those who do not have remote backup conditions, if the computer room fire occurs, even if DBA copies a lot of backup files is useless.

Of course, the probability of such a catastrophic disaster is extremely low, and when mirror replication is carried out, it will certainly increase the backup time and space.

Thank you for reading! This is the end of the article on "how to use mirror backup in RMAN". I hope the above content can be of some help to you, so that you can learn more knowledge. if you think the article is good, you can share it for more people to see!

Tags: Backup mirror file command method content at the same time remote more fire disaster article generation good practical natural disaster location score earthquake multiple Apple Docker Huawei Linux macOS MariaDB Microsoft MySQL NVidia OPPO Reno OPPO Reno Apple NVidia Shulou Technology Linux