How to Exclude Specific Tablespace from the RMAN Backup in Oracle 11gR2 Check the database details SQL> select instance_name,version,open_mode from v$instance, v$database; INSTANCE_NAME VERSION OPEN_MODE —————- —————– ———– testdb1 11.2.0.4.0 READ WRITE Check the RMAN Configuration [oracle@testdb… Read more..

Move the datafile in standby database from one disk to another in Oracle 11gR2(11.2.0.4) Check the database status SQL> select version,instance_name,open_mode from V$database,v$instance; VERSION           INSTANCE_NAME    OPEN_MODE ——- —————- ——————– 11.2.0.4.0        teststd         MOUNTED Fallow… Read more..

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..