Below are the steps for recreating physical standby controlfile.

1. Get the controlfile location [STANDBY]

SQL> show parameter control_files

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
control_files                        string      /archive/NONPLUG/NONCDB/contro
                                                 l01.ctl, /archive/NONPLUG/NONC
                                                 DB/control02.ctl

2. Cancel recovery [STANDBY]

alter database recover managed standby database cancel;

3. Shutdown standby [ STANDBY]

SQL> SHUTDOWN IMMEDIATE
Database closed.
Database dismounted.
ORACLE instance shut down.

4. Create standby controlfile in primary [ PRIMARY]

alter database create standby controlfile as '/export/home/oracle/standby_ctrl.ctl';

5. copy the controlfile to standby server.

scp /export/home/oracle/standby_ctrl.ctl [email protected]:/export/stdby/home/

6.Replace the existing controlfile with the new controlfile [ STANDBY]

rm -rf /archive/NONPLUG/NONCDB/control01.ctl
rm -rf /archive/NONPLUG/NONCDB/control02.ctl

cp /export/stdby/home/standby_ctrl.ctl /archive/NONPLUG/NONCDB/control01.ctl
cp /export/stdby/home/standby_ctrl.ctl /archive/NONPLUG/NONCDB/control02.ctl

7. Mount standby database [ STANDBY]

SQL> startup mount
ORACLE instance started.
Total System Global Area 1.1107E+10 bytes
Fixed Size 7644464 bytes
Variable Size 9294584528 bytes
Database Buffers 1711276032 bytes
Redo Buffers 93011968 bytes
Database mounted.

8. Start MRP recovery process [ STANDBY]

alter database recover managed standby database disconnect from session;
CONTROLFILEdataguardstandby DATAGUARD


Related Topics

Useful DGMGRL commands in oracle dataguard
How to add a tempfile in primary database in dataguard
Flashback primary database in dataguard environment
How to disable enable log shipping in standby using dgmgrl
Standby redologs in oracle dataguard
How to enable active dataguard in physical standby database
How to setup dataguard broker configuration (DG broker) in 12c
How to use expdp to export data from physical standby database
How to recreate physical standby controlfile

You May Also Like

Alert log rotation script in oracle
Find sessions consuming lot of CPU
Multinode Hadoop installation steps
ORA-16855: transport lag has exceeded specified threshold
Perform Flashback in pluggable database(PDB) in oracle 12.2
sec_case_sensitive_logon parameter in oracle
SGA TARGET ADVISORY IN ORACLE
ORA-02304: invalid object identifier literal while import with CREATE TYPE OID
ORA-20101: TABLESPACE is not a ASSM (Automatic Segment Space Management) tablespace
Upgrade database using OEM 12C cloud control

From This Website

How to enable active dataguard in physical standby database
TNS-12542: TNS:address already in use
Oswatcher tool for collecting server diagnostic information
DEFERRED_SEGMENT_CREATION parameter in oracle
How to use expdp to export data from physical standby database
Shell script for monitoring Alert log
Obey command in goldengate
How to monitor parallel queries in oracle db
Ansible script to run script on remote server and fetch the output
DBMS_PARALLEL_EXECUTE in oracle PL/SQL