DBA SECURITY WORLD UPDATES

  Organizations in highly regulated industries go through many business events that trigger the need for a data migration. The typical “lift and shift” approach to data migration, however, results in a considerable amount of time and resource allocation—without any concrete business value to show for it. Adlib goes beyond just automating the process of moving your data between repositories. We add value to your content before, during, and after migration, for enriched content that’s easier to find and easier to use. Oracle Data Pump  is a newer, faster and more flexible alternative to the "exp" and "imp" utilities used in previous Oracle versions. In addition to basic import and export functionality data pump provides a PL/SQL API and support for external tables. In order to use Data Pump, the database administrator must create a directory object and grant privileges to the user on that directory object. You would login to SQL*Plus as system and enter the following ...

DATA CLOUD What is the Data Cloud? The Data Cloud concept refers to a unified environment where organizations can connect to a single copy of all their data, eliminating silos that often hinder data accessibility. This approach allows businesses to easily unify, analyze, share, and monetize their data across different departments and partners[1].  Understanding the Snowflake Data Cloud The Snowflake Data Cloud is a revolutionary platform that enables organizations to manage, analyze, and share data seamlessly across various environments. With its unique architecture and capabilities, Snowflake addresses the challenges of data silos, scalability, and real-time analytics, making it a preferred choice for businesses looking to leverage their data effectively.  Key Features of Snowflake Data Cloud 1. Unified Platform for Diverse Workloads    - Snowflake supports multiple workloads including Data Warehousing, Data Lakes, Data Engineering, AI/ML, and more. This versatilit...

Many people asks this question why and how nodes are evicted from cluster... Here is the simple answer.. It occurs when the instance members in a RAC fail to ping/connect to each other via this private interconnect, but the servers are all pysically up and running and the database instance on each of these servers is also running. These individual nodes are running fine and can conceptually accept user connections and work independently. So basically due to lack of commincation the instance thinks that the other instance that it is not able to connect is down and it needs to do something about the situation. The problem is if we leave these instance running, the sane block might get read, updated in these individual instances and there would be data integrity issue, as the blocks changed in one instance, will not be locked and could be over-written by another instance. Oracle has efficiently implemented check for the split brain syndrome. In RAC if any node becomes inactive, or if ot...

Guys below are the very good materials  to learn many new features of oracle 12 C....Walk around it and I'm sure you will love it....... click here to access the presentation material. Below are some important links relevant to this subject: Installing Oracle Database Software and Creating a Database : https://apex.oracle.com/pls/apex/f?p=44785:24:110997252215321:::24:P24_CONTENT_ID,P24_ PROD_SECTION_GRP_ID,P24_PREV_PAGE:6281,,24 Tutorials:- Managing Pluggable Databases using SQL Developer https://apex.oracle.com/pls/apex/f?p=44785:24:0::NO:24:P24_CONTENT_ID, P24_PREV_PAGE:7649,1 Redaction Management in Oracle SQL Developer https://apex.oracle.com/pls/apex/f?p=44785:24:0::NO::P24_CONTENT_ID,P24 _PREV_PAGE:7650,2 Monitoring and Tuning the Database https://apex.oracle.com/pls/apex/f?p=44785:24:0::NO::P24_CONTENT_ID,P24 _PREV_PAGE:6283,2 https://apex.oracle.com/pls/apex/f?p=44785:24:0::NO::P24_CONTENT_ID,P24 _PREV_PAGE:6290,2 You can also download the ...

Pluggable Databases create a container database(root db) and plug many database inside it ..... what's the question in your mind now? why oracle making it so complicated, first create container db then create plugable db? Obviously managing them will require lots of effors... The Benefit whcih we get , all these databases then share the exact same oracle server processes (aka background processes) and memory (Unlike in the previous versions where each database got its own set of background processes and shared memory allocation). Means You will have only one pmon and can create many instance on a single server. Isn't it sounds extraordinary?

Online Data-file Move Online Datafile Move is the very helpful technique implemented by oracle corporation in its 12C release.You need not to be worry about taking the tablespace offline to move the datfile... wowla!!!  Lets see how this magic work... SELECT file_id, file_name FROM dba_data_files ORDER BY file_id; FILE_ID FILE_NAME ---------- ---------------------------------------------------------------------- 1 /u01/app/oracle/oradata/cdb1/system01.dbf 3 /u01/app/oracle/oradata/cdb1/sysaux01.dbf 4 /u01/app/oracle/oradata/cdb1/undotbs01.dbf 6 /u01/app/oracle/oradata/cdb1/users01.dbf SQL> ALTER DATABASE MOVE DATAFILE '/u01/app/oracle/oradata/cdb1/system01.dbf' TO '/tmp/system01.dbf'; Database altered. SQL> 　 SQL> SELECT file_id, file_name FROM dba_data_files WHERE file_id = 1; FILE_ID FILE_NAME ---------- ---------------------------------------------------------------------- 1 /tmp/system01.dbf SQL...