Database Blog

Step by Step Converting a file system From Non-ASM to ASM in Oracle Database

Converting a file system From Non-ASM to ASM in Oracle Database We are going to Converting a file system From Non-ASM to ASM in Oracle Database . Check the database…

Read More

CHANGING A DATABASE NAME USING NEWID

CHANGING A DATABASE NAME USING NEWID DBNEWID is a database utility that can change the internal database identifier (DBID) and the database name (DBNAME) for an operational database. The DBNEWID…

Read More

MATERIALIZED VIEW

DIFFERENCE BETWEEN View and Materialized View is that Views are not stored physically on the disk.View can be defined as a virtual table created as a result of the query but Materialized View is a…

Read More

Reinstating a Failed Primary Database using Dataguard Broker

Reinstating a Failed Primary Database using Dataguard Broker Details : DETAILS SOURCE TARGET IP_ADDRESS 192.168.1.44 192.168.1.37 SERVER_NAME PRIMARY STANDBY DB_VERSION 12.2.0.1 12.2.0.1 DB_NAME DELL STANDBY The Primary Database DELL is…

Read More

Oracle Cloud Infrastructure Announces Second Data Center Region in Japan

Oracle has announced that it’s possible to create a new cloud zone in Osaka, Japan. The domain’s name is ap-Osaka-1. The zone key is KIX, and this area contains availability…

Read More

Schema Refresh

SCHEMA REFRESH In this Post , Let us discuss the steps involved during schema refresh using datapump. Prerequisite to check on Before Export on SOURCE SIDE 1. Check the Schema…

Read More

RESTORE USING RMAN TO CREATE ORACLE 12C DATABASE ON SCRATCH SERVER

RESTORE USING RMAN TO CREATE ORACLE 12C DATABASE ON SCRATCH SERVER Overview Following is the scenario, All the hard drives of the production server have been damaged and we have…

Read More

REFRESH STANDBY USING INCREMENTAL(SCN BASED) BACKUP

REFRESH STANDBY USING INCREMENTAL(SCN BASED) BACKUP This method is used to resolve problems if a physical standby database has lost or corrupted archived redo data or has an unresolvable archive…

Read More

Sql plan base line export and import it in new database

Check the count of sql baselines to be exported:- select count(*) from dba_sql_plan_baselines; 725 Create a user with which the base should be exported:- create user sqbl identified by “#####”;…

Read More

Oracle 12c- Dataguard Failover Using DGMGRL Utility

Dataguard Failover Using DGMGRL Failover is an irreversible transition of a standby database to the primary role. This is only done in the event of a catastrophic failure of the…

Read More