It's All About ORACLE

Oracle - The number one Database Management System. Hope this Blog will teach a lot about oracle.

DUL(Data UnLoading) & Desperation

Imagine, if you will, a situation where your Oracle database has become corrupted and your backup could either not be restored or was too out-of-date to be worth restoration. Unfortunately, this situation isn’t as hypothetical or as rare as one would think.
While poor backup strategies set the stage for this situation, hardware failures are an all-too-common occurrence which can wreak havoc on your database. So, what is a DBA to do when confronted with such a vexing situation? If the corruption is substantial or the data must be recovered, the only solution is Data Unloading (DUL).

What is Data Unloading?
DUL is the process of extracting (unloading) data from Oracle data files directly; completely bypassing the Oracle Kernel. Unloading does not even require Oracle to be installed.

How is DUL different from exporting data?
While DUL does export data, it does not require a running server; as does EXP, EXPDP, etc. DUL is strictly an offline operation.

What about database security?
As DUL reads data files directly, user and role-level permissions are completely ineffective. Currently, the only way to protect data from an unloader is to use encryption. However, Oracle’s DUL (and soon DUDE) can read a file which uses Transparent Data Encryption (TDE).

Who can perform DUL?
Technically, anyone who knows the data type and file storage formats used by Oracle can extract the data. Though, DUL is generally performed by specialized utilities; a software category of which only a handful of tools exist.

Basically, these utilities first attempt to open the SYSTEM tablespace data files and retrieve the USER$, OBJ$, TAB$ and COL$ data for use in extracting the data. If this file is also corrupt, you may have to specify object information manually. Though, several of the utilities are able to scan the data files and heuristically determine objects to extract.

SQL and It's Most Basic Command

SQL( Structure Query Language): 
SQL is short for Structured Query Language and is a widely used database language, providing means of data manipulation (store, retrieve, update, delete) and database creation.Almost all modern Relational Database Management Systems like MS SQL Server, Microsoft Access, MSDE, Oracle, DB2, Sybase, MySQL, Postgres and Informix use SQL as standard database language.

Basic SQL Command:
DQL(Data Query Language)
SELECT: Command to retrieve data from tables and views.

DDL: (Data Definition Language):
This includes all commands need to create, modify and drop the structure of database objects.
CREATE: command user to create any database  object.
ALTER: command to modify the structure of any database object.
DROP: To remove the object from database dictionary.

DML(Data Manipulation Language):
This includes command to insert, update and delete data from tables.
INSERT: To insert a record into table.
UPDATE: To update a particular record.
DELETE: To delete a Record from the table.

DCL(Data Control Language):
Contol the access to data in database.
GRANT to allow specified users to perform specified tasks.
REVOKE to cancel previously granted or denied permissions.

DTL(Data Transaction Language):
Control transactions in database accessCOMMIT: commit (make persistent) all changes for the current transaction
ROLLBACK:-- roll back (rescind) all changes for the current transaction.

You Might Also Like

Related Posts with Thumbnails