Home Blog Page 2

Script Repositories (All in One…)

0
DBA-ScriptsDownload

RAID (Redundant Array of Inexpensive disks)

0
RAID stands for Redundant Array of Inexpensive Disks which was later interpreted to Redundant Array of Independent Disks. This technology is now used in...
golden gate bridge san francisco california

Before we start tuning GoldenGate…

0
Large objects (LOBs) LOBs can be a problem in data replication by virtue of their size and the ability to extract, transmit, and deliver the...
Crookes' tube for showing the interaction between parallel beams of cathode rays (tubes)

Adding Replicats with @RANGE function in GG

0
The RANGE function The way the @RANGE function works is it computes a hash value of the columns specified in the input. If no columns...
Man in profile, hand drawn

Protected: Profiles

0
A profile is a collection of attributes that apply to a user.The profile is used to enable a single point of reference for multiple...
photo of people engaged on their phones

User Management

0
About User Accounts:The areas in which you can configure security are as follows: • User accounts For users to access your database, you must create user...
a text on a pink surface

Protected: How to Decide if column should be indexed?

0
Many people ask these Questions, Q. How to identify which column is candidate for Index creation? Q. How to determine index will really help to perform...
metal chain with lock on street

Protected: Database Link (DB Link)

0
A database link (DBlink) is a definition of how to establish a connection from one Oracle database to another. Type of Database Links:Private database link...

Protected: Recovery Catalog

0
What is Recovery Catalog? A recovery catalog is a database schema used by RMAN Which is used to stored Metadata of one ormore databases. Benefits: It creates...

Recovery of dropped tablespace with RMAN

0
SELECT NAME ,OPEN_MODE FROM V$DATABASE;SELECT LOG_MODE FROM V$DATABASE;SELECT NAME FROM V$DATAFILE;SELECT NAME FROM V$TABLESPACE; CREATE TABLESPACE(TB1) RMAN > BACKUP DATABASE PLUS ARCHIVELOG; LIST BACKUP OF CONTROLFILE; LIST BACKUP...

Control File and Redolog File Multiplexing

0
Control file and Redolog file contains crucial database information and loss of these files will lead to loss of important data about database. It...

ARCHIVE AND OLD RMAN BACKUP REMOVAL

0
RMAN> show all; CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 7 DAYS; RMAN> CONFIGURE RETENTION POLICY TO NONE; The REDUNDANCY parameter of the CONFIGURE RETENTION POLICY command...
close up shot of keyboard buttons

Protected: Oracle Data Pump – Expdp, Impdp

0
Oracle Data Pump Export is a built-in utility program for unloading data and metadata into a set of dump files. The dump file set...

12cR1 to 19C upgradation with auto upgrade feature

0
We have a 12cR1 database. Database name is ‘sha’ and version is 12.1.0.2.0 as can beseen from below image. Lets make a table in scott...

Upgrade Oracle Database from 12.1.0.2 to 12.2.0.1 using DBUA

0
Supported Upgrade PathsDirect upgrades are possible from existing databases with the following versions.Destination Source=========== ======12c Release 1 (12.1.0.2) 10.2.0.5+, 11.1.0.7+, 11.2.0.2+ or 12.1.0.112c Release...

ASM / GRID Installation

0
Prerequisite. Add below OS groups Add  asmdba as secondary group to Oracle user Create Grid User # useradd -u 54331 -g oinstall -G dba,asmdba,asmoper,asmadmin,racdba grid Change the password for...
Connector for radio equipment, 1942-1946 (electric cable)

Common User Vs Local User In 12c

0
COMMON USER: 1.A common user is a Database user, which perform an activity in all the containers including root container of the CDB. 2.A common user...

How To Rename A Pluggable Database ( PDB)

0
The following explains how to rename a container (pluggable databases). Step-By-Step 1. Shutdown the pluggable database (PDB). SQL> show pdbs; CON_ID CON_NAME OPEN...

Multi-tenant Architecture

0
Oracle Database 12c introduced a new feature called “Multitenant.” The multitenant feature provides the ability for a single instance to manage multiple databases. The...
man holding ice cream cone under cloud

Azure : Create Gateway Subnet

0
STEP-1- Create Gateway Subnet Resource Group > VNET>SUBNETS> GATEWAY SUBNETS>ADD – 10.0.1.0/24 (Available Free Subnet). STEP-2 Create Gateway Create. SEARCH > VIRTUAL NETWORK GATEWAY> SELECT VIRTUAL NETWORK...
man holding ice cream cone under cloud

Protected: AZURE MONITORING – VIA LOG ANALYTICS

0
CONFIGURE LOG ANALYTICS PORTAL > CREATE > SEARCH LOG ANALYTICS> SELECT LOG ALALYTICS WORKSACE >CREATE> LOG ANALYTICS NAME- AZURE MONITORING EXISTING RESOURCE GROUP > PERGB LICENCE...
Landsat Data Continuity Mission Environmental Testing is Underway

Protected: Step by Step Data Guard Configuration in 19c

0
1) PREREQUISITES: Requirements before starting the DATA GUARD CONFIGURATION. NOTE: 1) In PRIMARY SERVER DG11 we need to install the BINARIES OF ORACLE 19c and...
yellow scrabble tiles

Undo Tablespace & ORA-01555 snapshot too old error..!!

0
As an “Oracle DBA ” normally interviewer ask about ORA-01555 snapshot too old error.   What is Undo? Oracle Database maintain information that is used to roll back, or undo. Such...

Create Duplicate Database Using RMAN

0
Source Database Name is PRODDB Target (duplicate) Database name is MYDB  Source  Host Name     : server1.localdomain Target Host Name       : server2.localdomain Put Database in archivelog mode. SQL> archive log list; Database...
black internal hdd on black surface

Migrate Non-ASM to ASM instance in 12c

0
Check the status of ASM instance . SQL> SELECT INSTANCE_NAME,VERSION,STATUS FROM V$INSTANCE; INSTANCE_NAME VERSION STATUS ------------- -------- ---------------- +ASM ...