After a difficult start in cloud computing, Oracle, a long-term commercial software company, has launched a second-generation cloud system that manages the data centers in which customers lease capacity. According…
Read MoreConverting a file system From ASM to Non-ASM in Oracle Database We are going to Converting a file system From ASM to Non-ASM in Oracle Database Check the database version…
Read MoreConverting 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 MoreCHANGING 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 MoreDIFFERENCE 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 MoreReinstating 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 MoreOracle 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 MoreSCHEMA 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 MoreRESTORE 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 MoreREFRESH 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