Mir Sayeed Hassan – Oracle Blog

Oracle DBA – Tips & Techniques | Learn with real-time examples

  • Translate

  • It’s Me






  • My Certificates

  • Links

    My Acclaim Certification : Credly Profile
    My Oracle ACE Pro Profile

  • Achievements

    Awarded Top 100 Oracle Blogs from Worldwide - #RANK 39
  • VISITORS COUNT

  • Verified International Academic Qualification from World Education Service (WES)

    Verified International Academic Qualification from World Education Service (WES)

  • Jobs

Archive for February, 2018

Recyclebin at User & Database level in Oracle database 11gR2

Posted by Mir Sayeed Hassan on 28th February 2018

Recycle bin concept in Oracle database 11gR2 Recycle bin is similar to windows recyclebin in Oracle database & here the entire drop object is stored in FLASHBACK Area As per my recycle bin its a virtual where all the dropped objects reside in it, It occupy the exact space as when they are created in Read More

Posted in DBA Administration | Comments Off on Recyclebin at User & Database level in Oracle database 11gR2

ORA-39213/ORA-39006: Metadata processing is not available, internal error

Posted by Mir Sayeed Hassan on 26th February 2018

ORA-39213/ORA-39006: Metadata processing is not available, internal error [oracle@testdb ~]$ expdp system directory=db_dump dumpfile=full_db26feb18.dmp logfile= full_db26feb18.log full=yes Export: Release 11.2.0.4.0 – Production on Mon Feb 26 16:03:01 2018 Copyright (c) 1982, 2011, Oracle and/or its affiliates All rights reserved.

Posted in ORA-Error | Comments Off on ORA-39213/ORA-39006: Metadata processing is not available, internal error

RMAN database restore from lower version (11.2.0.1) to 11.2.0.4 by using upgrade in Oracle database 11gR2

Posted by Mir Sayeed Hassan on 25th February 2018

RMAN database restore from lower version (11.2.0.1) to 11.2.0.4 by using upgrade in Oracle database 11gR2 Copy the datafiles, archivelog files and controlfile from real database to restore backup location by using the NC or Winscp or any suitable method First verify the real database version: [oracle@realdb backup]$ !sq sqlplus… Read more..

Posted in RMAN | Comments Off on RMAN database restore from lower version (11.2.0.1) to 11.2.0.4 by using upgrade in Oracle database 11gR2

Block Change Tracking for Incremental Backups in Oracle database 11gR2

Posted by Mir Sayeed Hassan on 25th February 2018

Block Change Tracking for Incremental Backups in Oracle database 11gR2 The Block change tracking is mainly used in Incremental backup of the database as it has to scan each block of the datafile to find weather it has any changes or not & it also consume more time, to reduce this we can enable the Read More

Posted in RMAN | Comments Off on Block Change Tracking for Incremental Backups in Oracle database 11gR2

Truncate all the tables data from the Oracle schema in Oracle database 11gR2

Posted by Mir Sayeed Hassan on 24th February 2018

Truncate all the tables data from the Oracle schema in Oracle database 11gR2 sys@TESTDB>;create user mir identified by mirhassan123; User created. sys@TESTDB>;grant connect,resource to mir; Grant succeeded. sys@TESTDB>;conn mir Enter password: Connected. mir@TESTDB>;sho user USER… Read more..

Posted in DBA Administration | Comments Off on Truncate all the tables data from the Oracle schema in Oracle database 11gR2

Crontab job for RMAN Backup as Level 0 and level 1

Posted by Mir Sayeed Hassan on 18th February 2018

Crontab job for RMAN Backup as Level 0 and level 1 Create all the directories and give the permission in /backup folder [oracle@Testdb ~]$ cd /backup/rman/ Example: $mkdir friday_level_0 And others [oracle@Testdb rman]$ ls friday_level_0  monday_level_1 … Read more..

Posted in RMAN | Comments Off on Crontab job for RMAN Backup as Level 0 and level 1