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 …
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 »
In this post, we will learn Why index become unusable in Oracle, query to check unusable indexes in oracle, How to rebuild the unusable index in oracle,how to rebuild the unusable index partition in oracle Why index become unusable in Oracle Sometimes when you are rebuilding the table and you forget to rebuild the index …
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 »
We can check RMAN backup status in sql using the below sql col STATUS format a9 col hrs format 999.99 select SESSION_KEY,SESSION_RECID,SESSION_STAMP, INPUT_TYPE, STATUS, to_char(START_TIME,’mm/dd/yy hh24:mi’) start_time, to_char(END_TIME,’mm/dd/yy hh24:mi’) end_time, elapsed_seconds/3600 hrs from V$RMAN_BACKUP_JOB_DETAILS order by session_key; This is very helpful when you are operating in a DBCS(Database Cloud Service) environment with automated backup. The …
How to check RMAN backup status in sql Read More »
