How to perform the Snapshot Standby database in Oracle Database 11gR2(11.2.0.4) The below scenario is to test the snapshot standby database in Oracle database 11gR2(11.2.0.4), Its an feature which allow a read-write operation on standby DB. We are performing the convert of physical standby db to the snapshot standby, after its conversion is completed… Read Read More

How to Multiplex Control file on RAC DB or ASM in Oracle 11gR2 (11.2.0.4.0) In RAC Env, If you have newly configure & created the database as 2 node RAC by default there will be single controlfile will be created, But as per the Oracle recommend there should be atleast 2 controlfile to be created. Read More

How to Recover Loss of data without a Backup in Oracle database 11gR2 (11.2.0.4) This scenario is considering as we don’t have any of database backup like RMAN, Restore point, Flashback, Recyclebin, Therefore we can recover only the DML Operation data loss In our case the user is accidentally deleted the records from table & Read More

How to drop database manually without using DBCA in Oracle database 11gR2 Database status: sys@TESTDB> select instance_name,status,version from V$instance; INSTANCE_NAME    STATUS       VERSION —————- ———— —————– testdb           OPEN         11.2.0.4.0 It’s recommended… Read more..

How to create a database manually in Oracle 11gR2 An Oracle database can be created either using manually or DBCA or at the time of installation of the Oracle software, the below given step by step process is to manually creation of database, Analyse the requirement of the database from the client size regarding the Read More

How to kill all the Oracle Session for specific user in Oracle Database 11gR2 Database Status: sys@TESTDB> select instance_name,status, version from V$instance; INSTANCE_NAME    STATUS       VERSION —————- ———— —————– testdb           OPEN         11.2.0.4.0 Check the… Read more..