A standby database is in mounted state and you are required to perform a failover to the physical standby. Which solution is best suited forthis scenario?

Question

Options

• AALTER DATABASE RECOVER MANAGED STANDBY DATABASE statement with the FINISH
• BALTER DATABASE PREPARE TO SWITCHOVER and ALTER DATABASE COMMIT TO
• CALTER DATABASE RECOVER TO STANDBY DATABASE statement with the FINISH keyword
• DD) ALTER DATABASE PREPARE SWITCHOVER and ALTER DATABASE COMMIT TO

• A
  74% (29)
• B
  13% (5)
• C
  8% (3)
• D
  5% (2)

Explanation

https://docs.oracle.com/database/121/SBYDB/concepts.htm#SBYDB4710 Role Transitions An Oracle database operates in one of two roles: primary or standby. Using Oracle Data Guard, you can change the role of a database using either a switchover or a failover operation. A switchover is a role reversal between the primary database and one of its standby databases. A switchover ensures no data loss. This is typically done for planned maintenance of the primary system. During a switchover, the primary database transitions to a standby role, and the standby database transitions to the primary role. A failover is when the primary database is unavailable. Failover is performed only in the event of a failure of the primary database, and the failover results in a transition of a standby database to the primary role. The database administrator can configure Oracle Data Guard to ensure no data SQL> select name,open_mode,database_role from v$database; NAME OPEN_MODE DATABASE_ROLE --------- -------------------- ---------------- RTS MOUNTED PHYSICAL STANDBY Following sort of SQL command will help to bring up standby as primary: SQL> alter database recover managed standby database finish; Database altered. SQL> alter database activate standby database; Database altered. Managed recovery process has been stopped between primary and standby database and standby becomes primary database. Bounce your standby database and verify database name its open mode and its role: SQL> shutdown immediate; ORA-01109: database not open Database dismounted. ORACLE instance shut down. ORACLE instance started. Total System Global Area 1469792256 bytes Fixed Size 2213456 bytes Variable Size 905972144 bytes Database Buffers 553648128 bytes Redo Buffers 7958528 bytes Database mounted. Database opened. SQL> select name,open_mode,database_role from v$database; NAME OPEN_MODE DATABASE_ROLE --------- -------------------- ---------------- RTS READ WRITE PRIMARY

No community discussion yet for this question.