Recovery Manager:

The recovery manager or RMAN is the recommended method of backing up your Oracle database.

Secured Oracle Backup:

Oracle secure backup complements existing functionality by adding backup to tape and backup of operating system files.

Protect Your Data with BDRSuite

Cost-Effective Backup Solution for VMs, Servers, Endpoints, Cloud VMs & SaaS applications. Supports On-Premise, Remote, Hybrid and Cloud Backup, including Disaster Recovery, Ransomware Defense & more!

User-managed backup:

The user-managed backups are based on scripts that a DBA must write. This option is being phased out because it is more labor intensive.

The target database contains data files. The Fast recovery area makes use of the backup data for redundant archive log files. The archive log files are stored either as images copies or backup pieces.

Oracle Secure Backup:

Oracle’s current backup and recovery product for the database is Recovery Manager. Oracle Secure Backup complements existing functionality in the following ways:

Download Banner

Complete backup solution:

Oracle secure backup provides data protection for the database and non database data to protect the entire Oracle environment.

Media management:

Oracle secure backup provides the media management layer for RMAN database backups to tape. Before Oracle secure backup, customers had to purchase expensive third-party media management products offering integration with RMAN tape backups.

Backup anywhere on the network:

Oracle secure backup backs up data from multiple network-attached computer systems to tertiary storage resources on the network. Oracle secure backup supports diverse configurations of servers, clients, network attached storage or NAS servers, and tertiary storage devices and protects network storage environments.

The combination of RMAN and Oracle secure backup provides an end-to-end backup solution for Oracle environments that is entirely within the Oracle product stack.

A user-managed backup can be performed interactively. However, this often entails writing scripts to perform the backup. There are several scenarios that can be run, and scripts must be written to handle them.

A typical user-managed scenario:

Is a manual process of tracking backup needs and status uses your own written scripts requires that database files be put in the correct mode for backup, and  relies on operating system commands to make backups of files. Some actions that scripts must take include.

  • Querying V$DATAFILE to determine the data files that need to be backed up and their current state.
  • Querying V$LOGFILE to identify the online redo log files.
  • Querying V$CONTROLFILE to identify the control file to backup  placing each tablespace in online backup mode.
  • Querying V$BACKUP to see what data files are part of a tablespace that has been placed in online backup mode.
  • Issuing operating system copy commands to copy the data files to the backup location, and bringing each tablespace out of online backup mode.
Rate this post