In this post, we will learn about how to use RMAN Catalog Command, how to use catalog start with command, and how to catalog backup pieces on tapes RMAN Catalog command You re-create the control file and you dont use the recovery catalog and use the control file only to store the RMAN data, thereby […]
How to use RMAN Catalog Command Read More »
Here are the Top Oracle DRM Interview questions Question 1 What is Version? Answer Data Relationship Management organizes sets of related data into versions. It is a collection of all hierarchies. Can be live, or a snapshot of metadata at a certain time. Data within each version is categorized into hierarchies, nodes, and properties. All
Oracle drm interview questions Read More »
In this post, we will learn about RMAN crosscheck command like rman crosscheck archivelog all, RMAN crosscheck backup etc What is RMAN Crosscheck command RMAN Crosscheck backup Here is the command to do a Crosscheck backup rman target /crosscheck backup: The above will do a crosscheck for the backup on the disk and tapes if
How to use RMAN Crosscheck command Read More »
What is Oracle Data Relationship Management? DRM stands for Data Relationship Management. It is a component of the Enterprise performance management Application suite(EPM) It Synchronizes hierarchies, cross-references, and enterprise dimensions across all applications It is a centralized “system of record” to capture and manage changes to critical reference data across enterprise applications It is a
Oracle Data Relationship Management: Definition, Password , Login Read More »
Controlfile is an important part of the Oracle database and backing up the control file is a necessary operation. Here is How to backup controlfile in RMAN How to enable auto backup of controlfile We can enable auto backup of the controlfile using RMAN settings. This will an auto backup of the control file after
How to backup controlfile in RMAN in Oracle Database Read More »
Auto Increment Column is a quite common requirement in the coding. Here are some of the ways to get that in MySQL . we will also check about MySQL Auto Increment reset Auto Increment Column MySQL database The AUTO_INCREMENT attribute can be used to generate a unique identity for new rows Example use techdb; CREATE
MySQL Auto Increment and reset Read More »
