There are many cases where we need to capture the ddl statements in our production environment where application team have direct access for create or drop any object in the application schema in the production database . What is DDL ?? DDL (Data Definition Language) is a language used by a database management system that allows users to define the database and specify data types, structures […]
All posts by Arun Gupta
MUST_RENAME_THIS_DATAFILE on RAC Standby
Few days ago i got the activity to create the 2 NODE RAC DR on EXADATA for 2 NODE RAC Production. Here I am listing few issues that made this activity perfect case for Data Guard beginners Environment:Production Database Name: Financedb_unique_name : finance Standby Database Name : Finstandbydb_unique_name : finstandby Production OS Node: agoracledba1 agoracledba2Standby […]
Oracle Gateway Installation for MSSQL Server on RHEL 7
Upgrading to Oracle Database 12cR2 Using Transient Logical Standby Method
Rolling upgrade with Transient Logical Standby is known as a MAA (Maximum Availability Architecture) technique, to minimize downtime during upgrade of Oracle database. This note will document the steps for performing the Advanced Data Guard method of Transient Logical Rolling Upgrade. The following picture provides the general flow for an example migration of on-premise database […]
Database Cloning without RMAN on windows
CREATE INITSRDB.ORA PFILE IN D:\DATABASE\APP FOLDER *.db_name=’srdb2′ *.control_files=’D:\DATABASE\APP\SHRIRAM\REDOLOGS\srdb2\CONTROLFILE\O1_srdb2.CTL’ 2. CREATE DESTINATION FOLDER DATAFILES FOLDER ONLINE REDOLOGS FOLDER CONTROLFILE FOLDER 3. CREATE SERVICE USING ORADIM ORADIM -NEW -SID SRDB2 NOTE: CHECK WHETHER THE SERVICE IS RUNNING OR NOT. 4. COPY ALL THE DATAFILES, REDOLOGS TO DESTINATION FOLDER AS IT IS THE CASE OF DATABASE CLONING WITHOUT […]
Connecting PDB in Oracle 12c
To connect as sys or other elevated local users, use the same methods as below, but use ‘as sysdba‘ where necessary Method 1: alter session set container = pdbName; Method 2:For other methods, you need to know the service-name for the PDB: Get the service name for the PDB: SELECT name || ‘ ‘|| pdb […]