Oracle Flashback Database, allows to quickly recover the entire database from logical data corruptions or user errors. It is very similar to PITR (Point In Time Recovery) which puts back the database to a state at a particular time in recent past. 1. Place your database in mount stage. sql>shutdown immediate sql>startup mount 2. Set DB_FLASHBACK_RETENTION_TARGET […]
Category: ORACLE DATABASE
ORA-15032: Not All Alterations Performed
While setting attribute on a ASM diskgroup, we got below error. oracle@crmcpredb1:~$ echo $ORACLE_SID +ASM1 oracle@crmcpredb1:~$ sqlplus / as sysdba SQL*Plus: Release 12.1.0.2.0 Production on Fri Sep 16 11:19:25 2016 Copyright (c) 1982, 2014, Oracle. All rights reserved. Connected to: Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 – 64bit Production With the Real Application Clusters […]
Recreate Oracle Central Inventory
Inventory is the index for the oracle installation. All the details about the ORACLE_HOME including different utility versions, patch details etc. If you do a fresh Oracle installation the inventory will be updated. But if you copy the ORACLE binaries from some other location and if you are not updating the inventory, we cannot read […]
Amount of redo generated during user-managed backup
I must thank my fellow DBA Franky Weber Faust for his publication in his blog. Introduction: – In this article, we have a quick journey on redo log during user-managed backup. RMAN is the most recommended tool for performing backup and recovery of an Oracle database, but we know that this is not always the case and many […]
Move tables (online / offline) in Oracle (9i-12cR2)
I must thank my fellow DBA Franky Weber Faust for his publication in his blog. The goal here is to share the procedures for performing the move of tables in Oracle Database from version 9i to version 12cR2. Here in this article I am using 12cR2 (12.2.0.1) to also be able to demonstrate the features […]
Oracle and it’s different Versions
Oracle Database Technology – the Oracle server versioning Oracle Version 2 – first commercial RDBMS Oracle Version 3 – rewritten in the C programming language Oracle Version 4 – improved query performance Oracle Version 5 – added a networking stack for client-server computing Oracle Version 6 – OLTP improvements, Oracle parallel server Oracle Version 7 – first “Modern” Oracle New security model […]
Index (B-tree)
B-tree Index B-tree stands for Balanced Tree in RDBMS. It is commonly used in database and filesystem.The B-tree enables the database to find a leaf node quickly. It is a good example of a data structure for external memory. Telephone directory, library are the best example of B-tree index. Why do we use B-tree? keeps keys in […]
IOT
IOT Index IOT stands for Index Organised Table in oracle database.The idea behind an IOT is simple. You hold all the data for the table in the ordered structure of an index. Why do we use IOT? An IOT has the structure of an index and stores all the columns of the row, accesses via […]
Index In Oracle
We are living on the planet with the seven billion population.Each and every human being’s have some information. Data is an important factor in the business’s world. Every day in business’s operation we deal with data. It can be structure and un-structure data. All the report of business prepare with the help of data. We take a […]