Oracle Data Guard Startup & Shutdown Steps

-

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:
  1. Shutdown Normal
  2. Shutdown Transactional
  3. Shutdown Immediate
  4. 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 DISCONNECT FROM SESSION;

Comments

Post a Comment

Popular posts from this blog

Difference join between (+) and (-) notation

-
  I have very old application. Then I saw some store procedure using (+) or (-) notation on the query. What i want to ask are : 1. what is the difference between (+) and (-) notation ? 2. what is the difference between (the position of the notation I put on left or right) ? SELECT * FROM A, B WHERE A.column = B.column(+) and SELECT * FROM A, B WHERE A.column(+) = B.column 3. I read from forum that notation is only present for backwards compatibility because Oracle debuted it before the ANSI standard for joins. So is there any problem if I'm not change the notation to 'join' statement (ANSI standard) on my old existing query ? 4. Is it recommended or not using notation (+) (-) ? 5. How about the performance. It's good using (+) (-) notation or join notation ? and Chris said... The plus sign is Oracle syntax for an outer join. There isn't a minus operator for joins. An outer join means return all rows from one table. Also return the rows from the outer joined where th...
Read more

Setup Oracle Database in Laravel

-
  Laravel is a powerful PHP web application framework that is widely used for building web applications. One of the strengths of Laravel is its ability to work with various databases. In this tutorial, we will walk through the steps involved in setting up an Oracle database in a Laravel framework. Prerequisites Before we begin, ensure that the following requirements are met: A Laravel project is set up on your machine The Oracle database software is installed and running The Oracle Instant Client is installed on your machine Basic knowledge of Laravel and Oracle database Step 1: Install the Oracle Driver The first step is to install the Oracle driver for PHP. The driver can be installed using the following command: composer require yajra/laravel-oci8 This command will install the Oracle driver and its dependencies in your Laravel project. Step 2: Configure the Oracle Driver Next, we need to configure the Oracle driver. To do this, open the “config/database.php” file in your Laravel...
Read more