Monitoring RMAN Backup with QBR tools

The Quest Backup Reporter is a windows client application. It can connect too many databases at a time and reports directly from oracle data dictionary views and RMAN catalog. It does not make any modification to either database as well as RMAN configuration. It is just a read only reporting tools. Quest Backup Reporter tools […]

Read More

COMPRESSED INCREMENTAL BACKUP

We need compressed full and incremental backup to apply in standby site and for make restoration faster INCREMENTAL LEVEL 0 BACKUP RUN { BACKUP AS COMPRESSED BACKUPSET INCREMENTAL LEVEL 0 DATABASE PLUS ARCHIVELOG; DELETE NOPROMPT ARCHIVELOG ALL BACKED UP 1 TIMES TO DISK; } INCREMENTAL LEVEL 1 BACKUP RUN { BACKUP AS COMPRESSED BACKUPSET INCREMENTAL […]

Read More

RECOVER ORACLE DATAFILES WITH NO DOWNTIME

What will happen if dbf file accidentally deleted when the database is still open and how to recover it? On Unix/Linux, when a file is deleted, but a process still has the file open, the file is still there in the filesystem, and only the inode is removed. But the process can continue to use […]

Read More

Rman Backup In Multitenant Database Oracle 12c

Introduction: –   As a DBA we all familiar with the backup commands. In the latest database of Oracle,  we find some different commands we must keep it in mind how to take backup. In this article, we are going to know about the  Rman Backup In Multitenant Database Oracle 12c.With multitenant feature introduced in oracle 12c, […]

Read More

Catalog Database Configure

Description:    RDB1 as TARGET SERVER                         RDB2 as CATALOG SERVER  create a database using DBCA on catalog server as catalog database i.e. RDB create a service in target server for the catalog server connection. check service alias using TNSPING servicename(EX:TNSPING RDB2) in terminal […]

Read More