The ADR Command Interpreter (ADRCI) Or ADR:- setting in Oracle Database 12cR1

The ADR is a file based repository for database diagnostics data such as traces, incident, dumps, and packages, the alert log ,health monitor reports ,core dumps and more. It has unified directory structure across multiple instances and many products. Stored outside of the database. There for it is available for problem diagnosis when the database … Continue reading The ADR Command Interpreter (ADRCI) Or ADR:- setting in Oracle Database 12cR1

Configure Transparent Data Encryption (TDE) in Oracle 12c database

1… Create a directory for the key store 2.. Specify key store location in sqlnet.ora 3.. Login with SYSKM or SYSDBA privilege 3.1  Once logged in create keystore file 3.2 Now once key store is created, open the software key file 3.3  Create the master encryption key which is stored encrypted in the keystore file … Continue reading Configure Transparent Data Encryption (TDE) in Oracle 12c database

Recovery of Non-system Datafile without backup using rman in 11gR2

Assumption :- For tablespace RECOVERY one datafile is backedup using rman and other datafile is not backedup. 1.. Create tablespace called RECOVERY with one datafile recovery01.dbf 2.. Take full backup of Database using rman Now again add a new datafile as recovery02.dbf to RECOVERY Tablespace that you have created. 3.. For testing purpose create a … Continue reading Recovery of Non-system Datafile without backup using rman in 11gR2

Ways to find Out DBID of Oracle Database in 11gR2

DBID stands for database identifier which is a unique identifier for each oracle database running in your server. DBID information is found in control files as well as datafile header. If the database is up and running then DBID can be found from v$database or while connecting to rman target / 1.. If Oracle Database … Continue reading Ways to find Out DBID of Oracle Database in 11gR2

Restore and Recovery of Redo log files complete loss in 11gR2

1.. Check name , open mode and log mode of database 2..  Check online redo log file group, redo log file name and size 3..  To simulate go to redo log location and delete redo log file 4..  Check Archive log is enabled or not 5.. Alter switch syntax will hang Error in Alert log … Continue reading Restore and Recovery of Redo log files complete loss in 11gR2

Cloning PDB within same Oracle Container Based Database 12cR1….

1.. Create a new directory like clone to clone PDBs from existing PDBs mkdir -p /u001/oracle/oradata/CDB2/clone 2.. Now connect with sysdba user and verify Container Database you want to connect and status of PDBs that you want to clone . PDB that you want to clone should be closed and in read only mode. 3..  … Continue reading Cloning PDB within same Oracle Container Based Database 12cR1….

Unplug and plug non-container database into Container base database (CDB) in 12cR1

Assumption :- Same version 12cR1 (12.1.0.2.0) of Oracle Database is installed one as NONCDB and other one as CDB(PDB) top of same operating system version and flavor. 1.. Source the environment for non container base NONCDB  database and login as sys as sysdba 2.. Shutdown the database and start in mount mode 3.. Now open … Continue reading Unplug and plug non-container database into Container base database (CDB) in 12cR1

Easy to drop Oracle database using rman 11gR2

Purpose :-  Use the DROP DATABASE command to delete the target database and if RMAN is connected to a recovery catalog, unregister it. RMAN removes all data files, online redo logs, and control files belonging to the target database. By default, RMAN prompts for confirmation. Prerequisites :-  Execute this command only at the RMAN prompt. … Continue reading Easy to drop Oracle database using rman 11gR2

Sql queries to find out Database growth

1.. Sql query to find database growth month wise and year select to_char(creation_time,'RRRR') , to_char (creation_time, 'Month') , round (sum(bytes)/1024/1024/1024) as GB from v$datafile group by to_char(creation_time,'RRRR') ,to_char (creation_time, 'Month')--,creation_time order by 1,2 2.. sql query to check the database growth (select min(creation_time) from v$datafile) "Creation Time ", (select name from v$database) "Database Name", ROUND((SUM(USED.BYTES) … Continue reading Sql queries to find out Database growth