Posts

Oracle Data Guard Startup & Shutdown Steps

-
Image
Data Guard Shutdown Sequence Stop log apply service or MRP and shutdown the standby SQL > ALTER DATABASE RECOVER MANAGED STANDBY DATABASE CANCEL ; SQL > SHUT IMMEDIATE ; Stop log shipping from primary and shutdown primary database SQL > ALTER SYSTEM SET log_archive_dest_state_2 = 'DEFER' ; SQL > ALTER SYSTEM SET log_archive_dest_state_3 = 'DEFER' ; SQL > SHUT Transactional ; Modes of Shutdown of the Oracle Database: Shutdown Normal Shutdown Transactional Shutdown Immediate Shutdown Abort Data Guard Startup Sequence Startup primary database and enable log shipping SQL > STARTUP ; SQL > ALTER SYSTEM SET log_archive_dest_state_2 = 'ENABLE' ; SQL > ALTER SYSTEM SET log_archive_dest_state_3 = 'ENABLE' ; Startup standby and enable log apply service or MRP SQL > startup nomount ; SQL > alter database mount standby database ; SQL > ALTER DATABASE RECOVER MANAGED STANDBY DATABASE DISCONNE...
Post a Comment
Read more

How to open and edit a large 250GB SQL file in Windows?

-
Image
  How to open and edit a large 250GB SQL file in Windows? Database administrators and programmers are often in a situation where they need to open or edit a large SQL file. These files are often created using the mysqldump utility, when generating cold backups of the database. The common simple text editors such as Notepad and Notepad++ will not be able to properly open large SQL files, especially when you reach sizes like 100-200GB of data. The reason they do not actually work with such large files is because they try to load the data to the computer's memory (RAM), and therefore they are somewhat limited to the amount of RAM you have in the computer (which is probably a lot less than 200GB). I can recommend that you'll try out  EmEditor , which according to their website can easily handle files up to 248 GB. Personally, I tried using it with a 70-80GB dump and it worked perfectly on my Windows dell laptop (8GB RAM, dual core CPU - nothing special). The reason EmEdi...
Post a Comment
Read more

Steps to create a Database Link from Oracle to MySQL

-
Image
  teps to create a Database Link from Oracle to MySQL Nowadays many companies are using a mix of  RDBMS  system for example, some instances are running on  Oracle  and other instances are running on  MySQL , and if we want to  access data  we need to do it using a  heterogeneous   connection .  Heterogeneous connections  allow us to  query data  from  non-Oracle databases  using  SQL . In this blog post we will see   How to create a database link from Oracle to MySQL via ODBC .   Below are the high-level steps we will follow to set up dblink . 1. Setup MySql User in MySQL Cluster 2. Install MySQL ODBC Drivers in Oracle Server 3. Edit odbc.ini file & Test DSN’s connectivity in Oracle Server 4. Create initMYSQL.ora file in Oracle Server 5. Configure tnsname.ora & listener.ora file in Oracle Server 6. Create DB Link & Test Connectivity in Oracle Server   Below are setup details a...
Post a Comment
Read more