Wednesday, January 9, 2019

Prerequisites and Must know Configure or integrate Online Database backup for Oracle Server Online Database

Oracle Server Online Database Backup integration/Configuration



Backup Types:

Using the Data Protector Oracle integration, you can perform the following types of backups:
  • Online backup of a whole database or parts of it
  • Online incremental backup (Oracle differential incremental backup 1 to 4)
  • Offline backup of a whole database
  • Backup of archived redo logs only
  • Backup of the Oracle database recovery catalog
  • Backup of the Oracle control files
  • Backup of recovery files residing in the flash recovery area
The following recovery files in the flash recovery area are backed up:
    • full and incremental backup sets
    • control file autobackup (SPFILE included if used)
    • archived redo logs
    • datafile copies, control file copies
Flashback logs, the current control file, and online redo logs are not backed up.
  • In Oracle Data Guard environment, backup of standby database
 Below details are captured as per Data Protector backup tool:

Considerations:

Uses the Oracle Recovery Manager (RMAN)

Using the Data Protector Oracle integration, you can perform duplication of a production database.
RMAN writes information regarding the backup either to the recovery catalog (if one is used) or to the control file of the Oracle target database.
Database files can also be managed by Automatic Storage Management (ASM). They can reside in the flash recovery area.

Prerequisites

  • Oracle User must have the SYSDBA privilege granted
  • In Windows: configure a domain user account that is a member of the Administrators group
  • RAC: Configure an Oracle database on every node from where you want to run backups and restores.
  • Required OS User and Group: Operating system user account must have Oracle rights to back up the database
    • ps -ef|grep ora_pmon_DB_NAME OR ps -ef|grep ora_lgwr_DB_NAME
  • Ensure that the Oracle user oracle from the Oracle Inventory group (oinstall) has been added to the Data Protector admin user group.
  • Unix: Add the OSDBA user account to the Data Protector admin or operator user group
  • HP OpenVMS System: Configure a Data Protector admin user with the username and the group name
  • Configuration of an Oracle database consists of providing Data Protector with the following data:
    • Oracle Server home directory
    • Login information to the target database
    • Optionally, login information to the recovery catalog database
    • Optionally, login information to the standby database

Restore

  • Using the Data Protector Oracle integration, you can restore the following:
  • The whole database or parts of it
  • The database to a specific point in time
  • From incremental backup
  • To a host other than the one where the database originally resided
  • A datafile to a location other than its original one
  • A catalog before restoring the database
  • From a chain of incremental backups
  • Restorable items:
You can restore the following database objects using both the Data Protector GUI or RMAN:
o    Control files
o    Datafiles
o    Tablespaces
o    Databases
o    Recovery Catalog Databases


Share this

0 Comment to "Prerequisites and Must know Configure or integrate Online Database backup for Oracle Server Online Database"

Post a Comment