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

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

You May Also Like

TNS-01106: Listener using listener name has already been started
Query clause in oracle datapump expdp
Useful DGMGRL commands in oracle dataguard
oraversion utility in oracle 18c - New feature
How to move AUD$ table to another tablespace using DBMS_AUDIT_MGMT
How to get the execution plan for a SQL between two AWR snapshots
Steps for upgrading oracle database to 19c using DBUA
TRUST_EXISTING_TABLE_PARTITIONS in oracle 12.2 datapump
ORA-02304: invalid object identifier literal while import with CREATE TYPE OID
How to change flash recovery area location

From This Website

How to recreate MGMT database in ORACLE 12C GRID
how to Print execution time of tasks in ansible
How to keep or delete columns/Variable of a data frame in R
Rollback database patch in oracle 12c
TNS-12542: TNS:address already in use
Enable DDL replication in goldengate
Clone a database using dbca command in oracle 19c -New feature
Defgen utility in Oracle goldengate
How to change the case (Lower to Upper and Vice Versa) in R
ERROR: No checkpoint table specified for ADD REPLICAT