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

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

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

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

how to restore rman backup on different server

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

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