Home 2022
Yearly Archives: 2022
Protected: Profiles
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...
User Management
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...
Protected: How to Decide if column should be indexed?
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...
Protected: Database Link (DB Link)
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
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
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
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
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...
Protected: Oracle Data Pump – Expdp, Impdp
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
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
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
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...
Common User Vs Local User In 12c
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)
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
Oracle Database 12c introduced a new feature called “Multitenant.”
The multitenant feature provides the ability for a single instance to manage multiple databases. The...
Azure : Create Gateway Subnet
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...
Protected: AZURE MONITORING – VIA LOG ANALYTICS
CONFIGURE LOG ANALYTICS
PORTAL > CREATE > SEARCH LOG ANALYTICS> SELECT LOG ALALYTICS WORKSACE >CREATE> LOG ANALYTICS NAME- AZURE MONITORING
EXISTING RESOURCE GROUP > PERGB LICENCE...
Protected: Step by Step Data Guard Configuration in 19c
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...
Undo Tablespace & ORA-01555 snapshot too old error..!!
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
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...
Migrate Non-ASM to ASM instance in 12c
Check the status of ASM instance .
SQL> SELECT INSTANCE_NAME,VERSION,STATUS FROM V$INSTANCE;
INSTANCE_NAME VERSION STATUS
------------- -------- ----------------
+ASM ...
Protected: 2 node RAC with Dataguard Configuration (DGMGRL)
This guide will take you through the steps configure Oracle Grid Infrastructure 12c and Database 12c including RAC to RAC Data Guard and Data...
Protected: Fixing Corrupted Grid Home
--Detach home /u01/grid/oracle/product/11.2.0.4/grid
export ORACLE_HOME=/u01/grid/oracle/product/11.2.0.4/grid
cd /u01/grid/oracle/product/11.2.0.4/grid/oui/bin
./detachHome.sh
--Validate the home are detached
cat /u01/oracle/product/oraInventory/ContentsXML/inventory.xml
--Take a backup of below files
cd /u01/grid/oracle/product/11.2.0.4/grid/crs/install
cp s_crsconfig_enabl11_env.txt /home/oracle/s_crsconfig_enabl11_env_bkp.txt
cp crsconfig_params /home/oracle/crsconfig_params_bkp.txt
--Remove the files...
Protected: srvctl related configurations
--add database to GRID and create the service, for example:
srvctl add database -d cm1919 -i cm19191 -o $ORACLE_HOME -p "+M1919_DG1/m1919/spfilecm1919.ora" -a "M1919_DG1,M1919_DG_FLASH" -m world...
Protected: Monitor Standby Database with Lag Time Report
vi /home/oracle/scripts/lag_time_report_and_diskgroup_space.ksh
#!/bin/ksh
export ORACLE_SID=<Target_ORACLE_SID>
export ORACLE_HOME=/u01/oracle/product/11.2.0.4/db
/u01/oracle/product/11.2.0.4/db/bin/sqlplus -s / as sysdba << NACHO > /tmp/standbylag.log
set feedback off
select 'Standby thread '|| thread# || ' is '|| round((sysdate -...