All in Oracle database.

Saturday, July 18, 2009

Oracle Backup and Recovery Solutions

Oracle,RMAN,Backup,Recovery
For performing backup and recovery based on physical backups, you have two solutions available:
(1.) Recovery Manager, a tool (with command-line client and Enterprise Manager GUI interfaces) that integrates with sessions running on the Oracle server to perform a
range of backup and recovery activities, as well as maintaining a repository of historical data about your backups
(2.) The traditional user-managed backup and recovery, where you directly manage the files that make up your database with a mixture of host operating system commands and SQL*Plus backup and recovery-related capabilities Both methods are supported by Oracle Corporation and are fully documented.
   RMAN is, however, the preferred solution for database backup and recovery. It can perform the same types of backup and recovery available through user-managed methods more easily, provides a common interface for backup tasks across different host operating systems, and offers a number of backup techniques not available through user-managed methods.
  Most of the backup and recovery documentation set will focus on RMAN-based backup and recovery. User-managed backup and recovery techniques are covered in the later chapters of Oracle Database Backup and Recovery Advanced User's Guide.
Whether you use RMAN or user-managed methods, you can supplement your physical backups with logical backups of schema objects made using data export utilities. Data thus saved can later be imported to re-create this data after restore and
recovery. However, logical backups are for the most part beyond the scope of the backup and recovery documentation.

No comments:

Post a Comment