How to Check Oracle 11g 12c Database Wallet is Open or Not? v$encryption_wallet

If Oracle wallet is enabled in your oracle database and if you forget to enable the wallet after opening the database you will get following error.

ORA-28365: wallet is not open

In case if you try to access RMAN backup you will get following error message

ORA-19913: unable to decrypt backup

ORA-28365: wallet is not open

There is one data dictionary view v$encryption_wallet for the same to check. 

Oracle: SQL Query to Find out Index Name, Column Name for Table

It is common requirement for a developer or DBA to find out the index name, column name for the table. Sometimes the index would be composite index. So in that case we have to find out that also like how many columns associated with the index and their order. There are 2 data dictionary views for the same. DBA_INDEXES and DBA_IND_COLUMNS. DBA_INDEXES gives just index names associated with the table and DBA_IND_COLUMNS gives the associated columns and their order.

How to Backup and Recovery Using Backup as Oracle RMAN Image Copy

RMAN image copy backup will take more space than the normal RMAN backup as it takes the entire datafile file as backups. But some situations we can use this method to backup and restore the database. Here is the method and RMAN command syntax for the same.

1.   Backup the database