Oracle 12c-Performing Reinstating a Failed Primary Database Using DGMGRL Utility
Description:-
- If your former primary database was configured with Flashback Database, you can easily reinstate the failed primary database as a standby database of the new primary database.
- The failed primary database will be reinstated as a standby type that matches the old standby database.
- For example, if you failed over to a physical standby database, the old primary will be reinstated as a physical standby database.
Let’s start the Demo:-
Step1:-Restart the Old Primary Database.
[oracle@primary ~]$ sqlplus ‘/as sysdba’
SQL*Plus: Release 12.1.0.2.0 Production on Wed Jun 13 02:16:25 2018
Copyright (c) 1982, 2014, Oracle. All rights reserved.
Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 – 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
SQL> shut immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup mount
ORACLE instance started.
Total System Global Area 1660944384 bytes
Fixed Size 2925072 bytes
Variable Size 1056968176 bytes
Database Buffers 587202560 bytes
Redo Buffers 13848576 bytes
Database mounted.
Step2:-Reinstate the old primary database.
[oracle@standby ~]$ dgmgrl
DGMGRL for Linux: Version 12.1.0.2.0 – 64bit Production
Copyright (c) 2000, 2013, Oracle. All rights reserved.
Welcome to DGMGRL, type “help” for information.
DGMGRL> connect sys/oracle@stand
Connected as SYSDBA.
DGMGRL> REINSTATE DATABASE ‘prime’;
Reinstating database “prime”, please wait…
Reinstatement of database “prime” succeeded
Step3:-Show the Configuration and Databases.
DGMGRL> SHOW CONFIGURATION;
Configuration – hari
Protection Mode: MaxPerformance
Members:
stand – Primary database
prime – Physical standby database
Fast-Start Failover: DISABLED
Configuration Status:
SUCCESS (status updated 19 seconds ago)
Step4:-Verify the standby status
DGMGRL> show database ‘prime’;
Database – prime
Role: PHYSICAL STANDBY
Intended State: APPLY-ON
Transport Lag: 0 seconds (computed 1 second ago)
Apply Lag: 0 seconds (computed 1 second ago)
Average Apply Rate: 10.00 KByte/s
Real Time Query: OFF
Instance(s):
prime
Database Status:
SUCCESS
DGMGRL> show database ‘stand’;
Database – stand
Role: PRIMARY
Intended State: TRANSPORT-ON
Instance(s):
stand
Database Status:
SUCCESS
Successfully completed the Reinstating a Failed Primary Database using DGMGRL Utlility
Reference:-
http://oradb-srv.wlv.ac.uk/E16655_01/server.121/e17641/cli.htm#i1007698
Catch Me On:- Hariprasath Rajaram
LinkedIn:https://www.linkedin.com/in/hari-prasath-aa65bb19/
Facebook:https://www.facebook.com/HariPrasathdba
FB Group:https://www.facebook.com/groups/894402327369506/
FB Page: https://www.facebook.com/dbahariprasath/?
Twitter: https://twitter.com/hariprasathdba
