Topic 1: backup methods, OS based or Oracle’s RMAN

Discussion Topic 1: 200 Words with reference

Discussion Post:

Topic 1: backup methods, OS based or Oracle’s RMAN

dd

This command was created as a “copy and convert” utility, originally intended for converting files between the ASCII, little-endian, byte-stream world of DEC computers and the EBCDIC, big-endian, appearing at the first time on Unix Version 5. It became the de facto command utility to manipulate everything that can be mapped as a file inside your Unix-like operating system(clone a disc, backup of mbr, clone a disk as file, copy some blocks of one device file, write an image to a usb stick..), and piped to other commands, the sky is the limit. One alternative to this software is the dcfldd command.

cp

Make copy of files and directories. This is a more “higher” level of abstraction, where you can copy directories recursively, without caring about block size, file conversion, etc. It is a better tool to deal with “1-to-many” cases of file copy, ownership, symbolic link follow, recursively copy, and verbosity. However, it has it’s limitations like dealing with file changes, remote copy, and those things better handled by rsync.

RMAN

Using RMAN, you can automatically backup the database to tape.

Using RMAN Block Media Recovery, you can recover your database in the data block level. If some data blocks of huge datafiles are corrupted, you do not need to restore and recover the whole datafile. In this case, by using Block Media Recovery, only corrupted data blocks are recovered. Most production databases are big in size and change frequently. It is not the right option to backup the whole database each time (every day). By using the incremental backup functionality, you only take a backup of changed data blocks by reducing time of backup and future recover process.

Using compression, you can easily create binary compressed backup sets. Although more CPU will be used while taking such backups, the backup pieces will be smaller, reducing the requirement for disk/tape space to hold the backups.

Using the Encryption feature, you can create encrypted backup sets which will make this backup more secure. By using the correct key, these backup sets will be decrypted automatically during restore and recovery operations.

Using the cross platform tablespace conversion functionality, you can convert the tablespace which was created in one OS to another.Because RMAN does not take a backup of the temporary tablespace, during recovery it is created automatically by RMAN. It makes the DBA’s work easier.

Discussion Forum Reply:

Discussion Topic 2: 200 Words with reference

Discussion Post:

Topic 2: no backups no recoveries . . .

The previous state would be wiped away. Backups copy the data and this copy is used to restore when data loss occurs. The important parts to backup are control files and data files (“Backup”, 2020). 

A cold backup is done when there’s no user activity occurring. It is also known as an offline backup. It is taken when the database isn’t running and no users are logged in. All files are copied and no changes get made during the copy. Cold backups are nice because it’s easier to run the backup when offline. Cold backups don’t require being in archive log mode and there’s a performance gain since the database isn’t cutting archive logs to the disk (“Difference”, 2016). 

A hot backup is taken when the database is running all the time. It is an online backup. All files are copied and there may be changes during the copy. Hot backups are nice because the database stays available for use while the backup is running (“Difference”, 2016).  

References

Backup and recovery. (2020). Oracle.Com. https://docs.oracle.com/cd/B19306_01/server.102/b14220/backrec.htm

Difference between a hot backup and a cold backup in oracle. (2016). Careerride.Com. https://www.careerride.com/Oracle-difference-hot-and-cold-backup.aspx#:~:text=A%20cold%20backup%20is%20done,no%20users%20are%20logged%20in.&text=A%20hot%20backup%20is%20taken,to%20run%20all%20the%20time.

Discussion Forum Reply: