How to create log and standby log files manually in standby database after primary backup restoration

STANDBY LOGS

Get relevant details from primary side

SQL> select GROUP#,BLOCKSIZE,THREAD# from v$standby_log;
    GROUP#  BLOCKSIZE    THREAD#
---------- ---------- ----------
         9        512          1
        10        512          1
        11        512          1
        12        512          1
        13        512          1
        14        512          2
        15        512          2
        16        512          2
        17        512          2
        18        512          2
10 rows selected.

Remove or drop already registered files

ALTER DATABASE CLEAR LOGFILE GROUP 11;
ALTER DATABASE DROP STANDBY LOGFILE GROUP 11;

Change to STANDBY_FILE_MANAGEMENT=MANUAL
ALTER SYSTEM SET STANDBY_FILE_MANAGEMENT=MANUAL;

Add standby log files

ALTER DATABASE ADD STANDBY LOGFILE THREAD 1 GROUP 11 ('/home/app/oracle/oradata/group_13.671.929171715','/data/app/oracle/oradata/CCORA12C/group_13.361.929171713') SIZE 512M;

Change to STANDBY_FILE_MANAGEMENT=AUTO
ALTER SYSTEM SET STANDBY_FILE_MANAGEMENT=AUTO;


LOGS

Get relevant details from primary side
SQL> select GROUP#,THREAD#,MEMBERS from v$log;

    GROUP#    THREAD#    MEMBERS
---------- ---------- ----------
         1          1          2
         6          1          2
         5          1          2
         2          1          2
         7          2          2
         8          2          2
         3          2          2
         4          2          2



Remove or drop already registered files
ALTER DATABASE DROP LOGFILE GROUP 1;

Add log files
ALTER DATABASE ADD LOGFILE THREAD 1 GROUP 1 ('/home/app/oracle/oradata/group_1.260.926202925','/home/app/oracle/oradata//group_1.347.926202923') SIZE 512M;

Comments

Popular posts from this blog

[FATAL] [DBT-10503] Template file is not specified

Resolving ORA-10635 and ORA-39171 Errors During BLOB Tablespace Maintenance

How to resolve RMAN-06035: wrong version of recover.bsq, expecting 11.2.0.4, found 11.2.0.2