Oracle Backup Solutions

Backup solution

Use the following methods to perform backups:
Recovery Manager
Oracle Secure Backup
User-managed backups

Recovery Manager (RMAN)is recommended for useOracle DBbackup method.
Oracle Secure Backupcomplements existing functionality by adding backup-to-tape capabilities and network backup capabilities.
User-managed backups are script-based, soDBAyou must write a script. This approach is gradually being phased out because
It requires more labor.
Oracle Secure Backup
Oracle Secure Backupand theRMANTogether forOracleEnvironment
Provides an end-to-end backup solution:
–for file system data andOracle DBusing centralized tape backup management
–theRMANBackup uses the best Integrated media management layer
–can back up arbitrary data anywhere on the network
provide a single technical support resource for your overall backup solution to accelerate
The speed of the problem.
ensure reliable data protection with lower cost and complexity.
Oracle Secure Backup
Oraclethe products currently used for database backup and recovery areRecovery Manager. Oracle Secure BackupPass
The following methods complement the existing functionality:
A complete backup solution:Oracle Secure Backupprovides data protection for database and non-database data
Protection to protect the entireOracleenvironment.
Media Management:Oracle Secure Backupto beRMANBackup to tape database backup provides media management
Layer. When usingOracle Secure BackupPreviously, customers were required to purchase expensive, integratedRMANTapes
Third-party media management products for backup functionality.
to make a backup anywhere on the network:Oracle Secure Backupcan back up from multiple connections to the network
All data from the three-level storage resource on the network to the computer system. Oracle Secure BackupSupport for service
Client, network-attached storage(NAS)different configurations of servers and tier three storage devices, and protects network
Storage environment.
RMANand theOracle Secure Backupthe combination for the entireOracleThe product family provides end-to-end backup solutions.
BecauseOracle CorporationResponsible for the overall backup solution, so the solution provides better customer support
Service.
Oracle Secure Backup
Oraclethe products currently used for database backup and recovery areRecovery Manager. Oracle Secure Backupthrough
The following methods complement the existing functionality:
A complete backup solution:Oracle Secure Backupprovides data protection for database and non-database data
Protection to protect the entireOracleenvironment.
Media Management:Oracle Secure Backupto beRMANBackup to tape database backup provides media management
Layer. When usingOracle Secure BackupPreviously, customers were required to purchase expensive, integratedRMANTapes
Third-party media management products for backup functionality.
to make a backup anywhere on the network:Oracle Secure Backupcan back up from multiple connections to the network
All data from the three-level storage resource on the network to the computer system. Oracle Secure BackupSupport for service
Client, network-attached storage(NAS)Different configurations of servers and tier three storage devices, and protects network
Storage environment.
RMANand theOracle Secure Backupthe combination for the entireOracleThe product family provides end-to-end backup solutions.
BecauseOracle Corporationresponsible for the overall backup solution, so the solution provides better customer support
Service.

1) User-managed backup
User-managed Scenarios:
refers to the process of manually tracking backup requirements and status
typically use scripts written by users themselves
need to put the database files in the correct mode for backup
rely on operating system commands to back up files

1.1)User-managed backups
user-managed backups can be performed interactively. However, you typically need to write scripts that perform backups. Scenarios that can be run
There are many, you must write scripts to handle these scenarios.
Here are some things the script must do:
EnquiryV$datafileto determine the data file that needs to be backed up and its current state
EnquiryV$logfileto identify the online redo log file
EnquiryV$controlfileto identify the control files to be backed up
put each table space in online backup mode
EnquiryV$backupto see which data files are included in the table space in online backup mode
issue the operating system copy command to copy the data files to the backup location
To exit the online backup mode for each table space

This article is from the "9090067" blog, please be sure to keep this source http://9100067.blog.51cto.com/9090067/1894595

Oracle Backup Solutions