904 Bedford St, New York NY 10014

(+1) 5184-453-1514

Month: June 2023

  • Understanding RMAN- RMAN Backups and Reporting

    The RMAN ecosystem consists of many different components. Figure 13-1 shows the interactions of the main RMAN pieces. Refer to this diagram when reading this section. Figure13-1.RMAN architectural components The following list describes the RMAN architectural components and definitions: • DBA: This is the human interaction to ensure successful backups and restores. • Target database:…

    Read More: Understanding RMAN- RMAN Backups and Reporting

Search

Popular Posts

  • Recovery Catalog Versions – RMAN Backups and Reporting
    Recovery Catalog Versions – RMAN Backups and Reporting

    I recommend that you create a recovery catalog for each version of the target databases that you are backing up. Doing so will save you some headaches with compatibility issues and upgrades. I have found it easier to use a recovery catalog when the database version of the rman client is the same version used…

  • Registering a Target Database – RMAN Backups and Reporting
    Registering a Target Database – RMAN Backups and Reporting

    Now, you can register a target database with the recovery catalog. Log in to the target database server. Ensure that you can establish connectivity to the recovery catalog database. For instance, one approach is to populate the TNS_ADMIN/tnsnames.ora file with an entry that points to the remote database. On the target database server, register the…

  • Creating a Recovery Catalog – RMAN Backups and Reporting
    Creating a Recovery Catalog – RMAN Backups and Reporting

    When I use a recovery catalog, I prefer to have a dedicated database that is used only for the recovery catalog. This ensures that the recovery catalog is not affected by any maintenance or downtime required by another application (and vice versa). Listed next are the steps for creating a recovery catalog: 1. Create a…

Tags