While taking backup by connecting to catalog database, Got RMAN-20001 : target database not found  error. Below is the exact error;   released channel: t1 released channel: t2 released channel: t3 RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-03002: failure of crosscheck command at 11/24/2015 15:40:53 RMAN-06004: ORACLE error from […]

While doing import, got below error. CREATE TYPE “TEST_CVGCM02”.”TEST_TEST2″ OID ‘BE4C0AFD318A07CBE0443C4A923B4794’ AS OBJECT ( NAME varchar2(40), AGE number(4), ID number(5) ) ORA-39083: Object type TYPE failed to create with error: ORA-02304: invalid object identifier literal Failing sql is: Login to database, Check whether that OID “BE4C0AFD318A07CBE0443C4A923B4794″ exists or not. SQL> select owner,TYPE_NAME,TYPE_OID from dba_types where […]

Block change tracking file keeps track of all changes to blocks of datafile since the last incremental backup. So while taking incremental backup, RMAN will read this tracking file, instead of going through all the blocks to find the changed blocks. It hugely reduced the incremental backup time.   How to enable block change tracking: […]

This flashback query  allows us  to query a table at a point in the past. We can retrieve which we might have deleted by  mistake in the past.   Make sure flashback is enabled: SQL> select flashback_on from v$database; FLASHBACK_ON —————— YES If flashback is not enabled Refer: How to enable flashback in oracle Delete […]

By using flashback technology we can restore the database to a particular point in past. It’s like time machine. Here we will see , how to enable and disable flashback in oracle.   ENABLE FLASHBACK:   Make sure the database is in archive log mode : Refer : How to enable and disable archive log  […]

With multitenant feature introduced in oracle 12c, New commands are there for taking rman backup of pluggable database and root container database. Backup of complete container( ROOT + ALL PDBS ) SQL> show pdbs CON_ID CON_NAME OPEN MODE RESTRICTED ———- —————————— ———- ———- 2 PDB$SEED READ ONLY NO 3 ORCL READ WRITE NO 5 PROD_MN […]

If you wish to save your statistics of schema or table, which you can use later during any query issue Or if you wish copy the statistics from production database to development , then this method will be helpful. Here i will take export of statistics of a table RAJ.TEST from PROD and import into […]

Suppose you wish to take a expdp backup of a big table, but you don’t sufficient space in a single mount point to keep the dump. In this case we take expdp dump to multiple directory. DEMO: Create 2 directories: SQL> create directory DIR1 as ‘/home/oracle/DIR1’; Directory created. SQL> create directory DIR2 as ‘/home/oracle/DIR2’; Directory […]