Tags » Database

Find & repair Corrupt block in Oracle database

Find & repair Corrupt block in Oracle
~ Applies to any Oracle version
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
— Find if any block (Table) is corrupted.

SQL> select * from V$DATABASE_BLOCK_CORRUPTION — will show if any corruped block… 371 more words

Database

Block corruption & Correction: a case study

Logical Block corruption & Correction: a case study

In one of a production database, I have received following errors in UI ( front-end) and back-end as well though mail. 2,770 more words

Database

Fix block corruption via RMAN - Pains & Gains of NOLOGGING mode in Oracle database

Fix block corruptions via RMAN using Oracle 11gR2
Pains & Gains of NOLOGGING mode in Oracle database

a) About NOLOGGING
b) FORCE LOGGING Options
c) Gains of NO LOGGING… 2,319 more words

Database

Basic audit on user level activities in Oracle

Configuring and Administering Auditing : Using Oracle 11g
============================================
Auditing is always about accountability, and is frequently done to protect and preserve privacy for the information stored in databases. 898 more words

Database

Guaranteed Restore Point creates Flashback Log even Flashback logging is Disabled

Recently, we experienced couple of issues regarding Flash Recovery area space.

One is exhausted disk space on production database servers… 1,123 more words

Database

In Oracle schema there are tables which has huge difference in actual size (size from User_segments) and expected size from user_tables (Num_rows*avg_row_length (in bytes)). This all is due to fragmentation in the table or stats for table are not updated into user_tables. 2,281 more words

Database

Creating a Tenant Database in SAP HANA Multitenant Database Containers

The data is the most important piece in almost all system, for that reason the platform selection and the data structure design are the first step to consider.  330 more words

SAP