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