Find UNUSABLE indexes in Oracle DB 11g

Find all unusable indexes in db

select owner, index_name from dba_indexes where status='UNUSABLE';

Rebuild index

alter index <INDEX_NAME> rebuild;