Oracle Tutorial for Beginners
Hello friends My name is SHRIPAL SINGH and i'm working as a ORACLE DBA from july 2012 to till now. Behind of making this blog my purpose is making that easy to understand of ORACLE DATABASE, so that every body can understand it easily, i also making a YouTube channel www.youtube.com/user/ocptechno , connect to my YouTube channel and enjoy free videos.
Friday, December 31, 2021
Data Pump Export Import Over the Network using network_link
Thursday, December 16, 2021
Wednesday, January 6, 2021
What is Character Functions
Hello, friends in this article we are going to discuss how to use Character Functions in SQL. The character functions accept only Character type values and return in character and number both.
Type of Character Functions
There are eight types of Character Functions in SQL.
- CONCAT
- SUBSTR
- LENGTH
- INSTR
- LPAD
- RPAD
- REPLACE
- TRIM
So, let's understand the working of each function one by one.
1. CONCAT
The CONCAT function joint two or more strings and display as a single string. We can use a minimum of two strings with the CONCAT function. For example, we have two strings like “OCP” and “TECHNOLOGY” and we want to display both strings together.
SQL> SELECT CONCAT('OCP','TECHNOLOGY') FROM DUAL;
The output from the above query is “OCPTECHNOLOGY“.
2. SUBSTR
The SUBSTR function Retrieve a part of the string as specified the length in function, as you can see in the below output. As we have a string like “OCPTECHNOLOGY” and we just want to display only the first three characters of the string.
SQL> SELECT SUBSTR('OCPTECHNOLOGY',1,3) FROM DUAL;
So, from the above query, we get the “OCP” as output.
3. LENGTH
The LENGTH function calculates the length of a string as a numeric value. Suppose we have a string like “OCPTECHNOLOGY” and we just want to count the letters of the sting, so you can use the length function.
SQL> SELECT LENGTH('OCPTECHNOLOGY') FROM DUAL;
The output is 13.
4. INSTR
The INSTR function shows the position of a given character in number. For example, you want to find out the position of “T” later from the “OCPTECHNOLOGY” string.
Thursday, December 31, 2020
Wednesday, January 15, 2020
Data Guard Physical Standby and Logical Standby Database Architecture in...
-Types of Standby Databases
-Background Services
-Data Guard Architecture
-Protection mode of Data Guard
Types of Standby Database
-Physical Standby
-Logical Standby
Discuss Later
Snapshot Standby
Active-Standby
Background Process work behind the Data Guard Configuration
*LNS - Log Network Service ( Running on the Primary Database)
*RFS - Remote File Service (Running on the Standby Database)
*MRP - Media Recovery Process (Running on the Standby Database)
*LSP - Logical Standby Process (Running on Logical Standby Database)
Standby
*Standby is a block to block a copy of the production database.
*The Standby Database also called is Physical Standby.
*The MRP process Manage the recovery which applies the received redo on physical standby.
Logical Standby
*Convert received redo in SQL statement and execute on standby.
*Logical standby database read/write operations (not on the replicated tables)
*Structure not same .
*Involve a few extra processes.
*Not all data types are supported.
Redo Transport Services
*SYNC - Synchronous Redo Transport
*ASYNC - Asynchronous Redo Transport
Note:- Both have the same responsibility to transport redo from production to standby.
SYNC - Synchronous Redo Transport
*Zero Data Loss
*Performance impact
ASYNC - Asynchronous Redo Transport
*Data Loss
*Zero performance impact
Protection mode for Data Guard
Maximum Performance
*It uses ASYNC redo transport
*Priority given to performance
*Minimum data loss
Maximum Availability
*It uses SYNC redo transport (Required)
*First Priority given availability and second priority is data protection
*If standby not available, the primary will wait and then proceed
Maximum Protection
*It uses SYNC redo transport (Required)
*Zero data loss
*If standby not available, the primary will be hangs and database will be abort
*Suggested more than one standby configured
#DataGuard #Architecture #DGtutorial
Sunday, January 5, 2020
Oracle Data Guard Tutorial Full Series in Hindi
Oracle Data Guard full course series in Hindi.
Hello Friends, in this series we are going to cover full data Guard tutorial
in the first part, we cover the following topics.
Our Topics
1. Introduction to Oracle Data Guard
2. How to configure oracle data guard from scratches.
3. How to configure the DG Broker.
4. How to manage Physical and Logical standby.
5. How to switchover the role.
6. How to convert the physical standby database into Active standby
7. How to convert the physical standby database into snapshot standby
Please write your views in the comment box.
Click here for my website
How to create Database in RPM base Installation Oracle 19c - Full Guide
For more detail please visit on my website Click Here
Friday, December 20, 2019
Wednesday, August 7, 2019
How to create and use DB Link between two servers step by step
DB Link complete tutorial step by step.
oracle find objects using database link.
oracle heterogeneous services 12c.
database link from oracle to sql server linux.
heterogeneous db link in oracle.
how to create dblink between two different databases in oracle.
create database link using tns.
grant create database link.
how to check db links in oracle.
How to Create a Dblink, dblink in 12c and 11g, creation of database link, heterogeneous dblink,
#DBLink #dblinkin12c #oracledblink
Thursday, July 18, 2019
How to use RMAN in NOARCHIVELOG mode
alter database archivelog.
rman backup script.
rman script to backup database in noarchivelog mode.
rman 06149.
a database is running in noarchivelog mode then which type of backups you can take.
rman online backup archivelog mode.
oracle hot backup without archivelog.
rman restore database in noarchivelog mode.
How to Resolve RMAN-06149: cannot BACKUP DATABASE in NOARCHIVELOG mode.
Oracle Interview application https://play.google.com/store/apps/de...
My Facebook page https://www.facebook.com/ocptechnology
My Second Channel https://www.youtube.com/4usupport
My Instagram https://www.instagram.com/ocptechnology/
My Website http://ocptechnology.com/
My twitter https://twitter.com/ocptechnology
rman backup script
rman backup commands
enable archivelog mode
oracle rman 12c
backup control file
enable archivelog mode oracle 12c
rman tutorial
oracle archive log mode check
change archive log destination
rman backup archivelog to different location
enable archivelog mode oracle 11g
rman download
how to take incremental backup in oracle
rman backup logs
recover database noredo on standby
noarchivelog mode to archivelog mode 12c
backup tablespace in rman
alter database recover datafile
rman incremental backup script for linux
enable archivelog mode oracle 12c rac
recover oracle database without archivelog
noarchivelog mode to archivelog mode
rman restore database in noarchivelog mode
disable archivelog mode oracle 12c
rman prerequisites
rman backup wiki
oracle rman online backup script
partial backup in oracle
taking tablespace backup using rman
loss of datafile in oracle
how to view rman backups
noredo option
oracle recover database options