Oracle Tutorial for Beginners

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

In this video, we are going to demonstrate to you how to create a database in RPM-based installation database 19c, Full guide on the Production environment.

For more detail please visit on my website Click Here

Friday, December 20, 2019

How to install oracle 19c on windows and create database using dbca

Wednesday, August 7, 2019

How to create and use DB Link between two servers step by step

In this video, I'm going to show you how to create DB Link between two oracle databases, and how to use DB link remotely,
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

Hello Friends in this video i'm going to show you how to use take rman backup if your database is running 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

Tuesday, July 16, 2019

Real Application Clusters - RAC | Oracle India

Real Application Clusters - RAC | Oracle India

#RAC #12C #ORACLE

Introduction to Oracle Real Application Clusters

Introduction to Oracle RAC

RAC EXPERT Book Link:- https://amzn.to/2Sjmpcm

Oracle Database 12C Book Link:- https://amzn.to/32xeBIQ

Oracle Database 11g The Complete Reference Book Link:-

https://amzn.to/2XJQHeh

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

SQL Tutorial

Online oracle training

Rman duplicate database from tag

Introduction to Oracle Real Application Clusters

Introduction to Oracle RAC

Oracle DBA Tutorial

Oracle Database 11g Release 2 RAC On Linux Using VirtualBox

Monday, July 15, 2019

how to restore rman backup on different server

how to restore rman backup to another server

how to restore rman backup on same server

how to restore rman backup to new server

how to restore the rman backup to different server

restore rman backup different server asm

Sunday, January 6, 2019

How to to manual Failover on physical standby

Failover on Physical Standby

How to do manually Failover on Physical Standby Database step by step.

Do Failover on Physical standby database without DG-Broker. Here is my other post for how to migrate Non-ASM Oracle Database to ASM filesystem. Click here For YouTube video

Standby related Error ORA-10456: cannot open standby database.

Once you have done failover, the standby database become Primary, Now you can not switchback to standby database again. so you can perform Failover only one time.

Step-1. Suppose you have lost the primary database for any reason.

On Standby: First of all cancel the standby database recovery using following command.

SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE CANCEL;

Note: The standby redo log information is still required, Therefore issue this command.

Step-2.

SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE FINISH;

If you are not using standby redo logs then run the following Steps.

SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE FINISH SKIP STANDBY LOGFILE;

Step-3. Now converting standby database role in primary role using following commands.

SQL> ALTER DATABASE COMMIT TO SWITCHOVER TO PRIMARY;

Alert: This will only succeed if the correct RECOVER FINISH-statement was issued before. If you forgot the ‘SKIP STANDBY LOGFILE’ although you have no Standby RedoLogs, the COMMIT to Switchover will fail with the error that more Media Recovery is required here.

If the COMMIT TO SWITCHOVER fails for any reason you have to use the ACTIVATEcommand which forces the Failover.

Step-4.

SQL> ALTER DATABASE ACTIVE STANDBY DATABASE;
SQL> SHU IMMEDIATE
SQL> STARTUP

Hope you Enjoyed this artical, please tell us about your experience just write in comment box.

Thanks Always keep smile