As we know that SYSTEM – stores the data dictionary. Being an Oracle DBA we all know the importance of SYSTEM tablespace. In these below lines, we can have actual technical knowledge about system’s information. SYSTEM – a tablespace that is always used to store SYSTEM data that includes data about tables, indexes, sequences, and other objects – this metadata […]
Articles Tagged: DBVERIFY
Recover sparse corrupted data blocks one several datafiles
Being an Oracle DBA we all are known about data block. Here this line explains the technical definition of data block A data block is the smallest unit of storage in an Oracle database. Every database has a default block size (specified when the database is created), although blocks in different tablespaces may have different […]
Recover contiguous corrupted data blocks
Being a DBA we all have good knowledge on feature of its database. As we know that Oracle has introduced a new feature in 11g which can be used to get assistance in case of loss or corruption of datafiles, redo log files or controlfiles. This tool is called data recovery advisor and is accessible from […]
Recover a never backed up tablespace after losing its datafile
In this post, we are going to learn steps which are use recover a never backed up tablespace after losing its datafile and even the current controlfile after the autobackup feature completes its job. This crash involves the lost of the “never backed up” tablespace and of the current controlfile. Let’s start with an example. Our […]
Retrieve the DATABASE IDENTIFIER from datafiles or online logs
This article is about the steps which require recovery when we retrieve the DATABASE IDENTIFIER dumping it from datafiles or online and archived redo logs . DBID stands for database identifier, which is a unique identifier for each Oracle database running. It is found in control files as well as datafile header. If the database is open […]
Restore from a loss of a subset of the current control files
Oracle database without control file is just like a human body without a backbone. Control file plays the role of the backbone of the database . Being an oracle dba we must know about controlfile . The control file is a file that the Oracle DBMS maintains to manage the state of the database, and it is […]