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 

How to Prepare your Oracle DBA Interview

Prepare your oracle DBA Interview Easily.

How to Prepare your Oracle DBA Interview

Prepare your oracle DBA Interview Easily.

What is MySQL and Why It Is the World’s Most Popular Open Source Database

MySQL? What?

MySQL? What?

My is the daughter’s name of the MySQL’s co-founder, Monty Widenius.

The name of MySQL is the combination of My and SQL, MySQL.

The MySQL is a DBMS (database management system) that allows you to manage RDBMS (relational databases). MySQL is open source Database software backed by Oracle. It means you can use MySQL without paying a money. In addition, if you want, you can change its source code to fullfile your needs.

If you have need any support so you can buy a commercial license version software from Oracle to get a premium support services.

MySQL is very easy to master in comparison with other DB software like Oracle DB, or Microsoft SQL Server.

MySQL support to various platforms like Linux, UNIX, Windows, etc. You can install it in a server or even in a desktop. In addition, MySQL is reliable, scalable, and fast database software.

The legally way to pronounce MySQL is My Ess Que Ell, not My Sequel. However, you can pronounce it whatever you like, who care?

If you develop any type of websites or web applications, MySQL database is a good choice. MySQL is an important component of LAMP stack, which includes Apache, Linux, MySQL, and PHP.

Using DG-Broker how to switchover Primary and standby roles step by step

How to switchover database role in DataGuard using DGMGRL ( DATA GUARD BROKER) STEP BY STEP.

How to configure Oracle 12c DataGuard Part-2 YouTube !

How to configure Oracle 12c DataGuard Part-2 YouTube !

Oracle Tutorial - How to make a Login script for Oracle Database

Hello Friends in this video i'm going to demonstrate you how to make a auto login script for oracle database step by step.



For more detail please visit on following link.



www.ocptechnology.com

How to import the dumpfile if the Database version are not same

Hello Friends in this video i'm going to show you how to import the dumpfile if the Database version are not same step by step.



oracle training for beginners

www.ocptechnology.com