Common user and Local user in ORACLE 12c. Oracle has Introduced Multitenant architecture in the version 12c and also new terminologies for users in container database called LOCAL USER and COMMON USER. Common users Users who exist in all containers current and future and… Read More
How to perform DATAPUMP operations on standby database by converting SNAPSHOT standby. Data Guard is the name for Oracle’s standby database solution, used for disaster recovery and high availability. This article contains an updated version of 12cR1 Converting physical standby into snapshot standby and… Read More
I Standardized and customized the SecureCRT to group and link the frequently used commands. It will make the Oracle DBA job easy and fast. Let me know if anyone is interested in the demo. Please download the latest button bar file from below link… Read More
What are the Oracle 12c Pluggable databases? How does a pluggable database work? These are the databases that are stored within the CDB. A PDB is a portable collection of schemas, schema objects, and non schema objects that appears to an Oracle Net client… Read More
How to Create New database using RMAN backup pieces. To create a new database with RMAN backup we call it as RMAN CLONING. Scenario : Here I am giving steps for create a new database using rman backup pieces in different servers and directory… Read More
Scenario: One of the archivelog files is missing and there is no backup of that archivelog. Primary database and Standby database are not in SYNC. There is an archival gap. Resyncing the standby data using RMAN incremental backup taken from the primary database. PRIMARY DATABASE … Read More
How to build ACTIVE STANDBY DATABASE using RMAN DUPLICATE command in ORACLE DATABASE 12c. Data Guard is the name for Oracle’s standby database solution, used for disaster recovery and high availability. This article contains an updated version of the 12cR1 active standby setup… Read More
Oracle 12c – Multitenant Architecture & Creating database manually Containers in Multitenancy Oracle Database 12c introduced a new feature called “multitenant.” The multitenant feature provides the ability for a single instance to manage multiple databases. The multitenant architecture enables an Oracle database to function… Read More
When to Use MongoDB Is MongoDB right for your application? That depends on the kind of data you have, and what you want to do with that data. NoSQL databases have risen to the occasion when it comes to unstructured data and the kind… Read More
1. Backup the current Stats For Database stats: SQL> Exec dbms_stats.export_database_stats(statown => ‘SYSTEM’, stattab => ‘prod_stats_database_03282018’); For System stats: SQL> Exec dbms_stats.export_SYSTEM_stats(statown => ‘SYSTEM’, stattab => ‘prod_stat_system_03282018’); For Dictionary stats: SQL> Exec dbms_stats.export_Dictionary_stats(statown => ‘SYSTEM’, stattab => ‘prod_stats_dictionary_03282018’); For Fixed Tables stats: SQL> Exec dbms_stats.export_FIXED_OBJECTS_stats(statown… Read More
