Skip to main content

STEPS TO TURN ON PHISICAL STANBY TO ACTIVE STANDBY DATABASE



Please follow below steps.

NOTE: Here primary & standby already configuared. The below are the steps we are performing on standby database, to make it active standby database.

-------------------------------------------------------------
1. Connect to the standby database.
-------------------------------------------------------------
2. Stop redo apply using the below script

SQL>recover managed standby database cancel;
---------------------------------------------------------------------------------------------------
3. Issue the following query to find out if the standby database is performing Redo Apply or real-time apply. If the MRP0 or MRP process exists, then the standby database is applying redo

SQL> SELECT PROCESS, STATUS FROM V$MANAGED_STANDBY;

---------------------------------------------------------------------------------------------------

4. Check database tole, open mode using the below script. 

SQL>select name, database_role,open_mode from v$database;

NAME      DATABASE_ROLE        OPEN_MODE
---------     ------------------------------   ------------------
TESTP     PHYSICAL STANDBY      MOUNTED  

---------------------------------------------------------------------------------------------------

5. Now open the database in OPEN READ ONLY mode. Use below SQL

SQL> Alter database open read only;

---------------------------------------------------------------------------------------------------

6. Check database tole, open mode using the below script. 

SQL>select name, database_role,open_mode from v$database;

NAME      DATABASE_ROLE       OPEN_MODE
---------     ------------------------------   ------------------
TESTP    PHYSICAL STANDBY     READ ONLY

---------------------------------------------------------------------------------------------------

7. start redo apply using below SQL on standby database.

SQL>alter database recover managed standby database using current logfile disconnect;

---------------------------------------------------------------------------------------------------

8. Check database tole, open mode using the below script. 

SQL>select name, database_role,open_mode from v$database;

NAME      DATABASE_ROLE       OPEN_MODE
----------    -----------------------------    -----------------------------------
TESTP    PHYSICAL STANDBY     READ ONLY WITH APPLY

---------------------------------------------------------------------------------------------------


NOTE:

--------------------------------------------
Start Redo Apply or Real-Time Apply:
--------------------------------------------

- To start Redo Apply, issue the following statement: - 

SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE DISCONNECT FROM SESSION;


- To start real-time apply, issue the following statement: - 

SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE USING CURRENT LOGFILE DISCONNECT;


Labels

Labels:

Comments

Post a Comment

Popular posts from this blog

ORA-28007: THE PASSWORD CANNOT NE REUSED

             - Here will see how to deal with  => ORA-28007: the password cannot be reused -  I got a request from client user, stating his account has been locked. When I check the status of the account I found the below. connect to SYS user & execute the below query of that database. SQL> select password,username,account_status,profile from dba_users where username='TEST'; PASSWORD               USERNAME   ACCOUNT_STATUS                 PROFILE ------------------             ----------------  -------------------------------           -------------------- AB2Aa8AC9971521e3     TEST       EXPIRED(GRACE)&LOCKED    NONAPP_USERS So, then I have unlocked the account and checked the same again & I found the below results. ...
Post a Comment
Read more

Process m000 died, see its trace file

Alert Log: [oracle@ bdump]$ view alert_HDRTG12.log Thu May 28 22:05:42 PDT 2015 Process P021 died, see its trace file Thu May 28 22:05:47 PDT 2015 Process m000 died, see its trace file Thu May 28 22:05:47 PDT 2015 ksvcreate: Process(m000) creation failed Thu May 28 22:06:00 PDT 2015 Process P021 died, see its trace file Thu May 28 22:06:10 PDT 2015 Process P021 died, see its trace file Thu May 28 22:06:43 PDT 2015 [oracle@bdump]$ sqlplus / as sysdba SQL*Plus: Release 10.2.0.5.0 - Production on Thu May 28 23:38:59 2015 Copyright (c) 1982, 2010, Oracle.  All Rights Reserved. Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options SQL> select name from v$database; NAME --------------------------- HDRTG12 SQL> select * from v$resource_limit where RESOURCE_NAME in ('sessions','processes','transactions'); RESOURCE...
Post a Comment
Read more