Sunday 28 February 2021

RFS[2]: No standby redo logfiles available for T-1

 Error Reason: Redo Log size different in Primary and Standby Database.

Solution:

---------Standby Database--------
SQL> alter database recover managed standby database cancel;

Database altered.

SQL> alter system set standby_file_management=manual;

System altered.

SQL> alter database drop STANDBY logfile group 61;

Database altered.

SQL> alter database drop STANDBY logfile group 62;

Database altered.

SQL> alter database drop STANDBY logfile group 63;

Database altered.

SQL> alter database drop STANDBY logfile group 64;

Database altered.

SQL> alter database drop STANDBY logfile group 65;

Database altered.

SQL> alter database drop STANDBY logfile group 66;

Database altered.

SQL>
SQL> select group# from v$standby_log;

no rows selected

SQL> ALTER DATABASE ADD STANDBY LOGFILE THREAD 1 GROUP 61 ('+REDO1','+REDO2','+REDO3') size 1024M;

Database altered.

SQL> ALTER DATABASE ADD STANDBY LOGFILE THREAD 1 GROUP 62 ('+REDO1','+REDO2','+REDO3') size 1024M;

Database altered.

SQL> ALTER DATABASE ADD STANDBY LOGFILE THREAD 1 GROUP 63 ('+REDO1','+REDO2','+REDO3') size 1024M;

Database altered.

SQL> ALTER DATABASE ADD STANDBY LOGFILE THREAD 1 GROUP 64 ('+REDO1','+REDO2','+REDO3') size 1024M;

Database altered.

SQL> ALTER DATABASE ADD STANDBY LOGFILE THREAD 1 GROUP 65 ('+REDO1','+REDO2','+REDO3') size 1024M;

Database altered.

SQL> ALTER DATABASE ADD STANDBY LOGFILE THREAD 1 GROUP 66 ('+REDO1','+REDO2','+REDO3') size 1024M;

Database altered.

SQL> alter system set standby_file_management=auto;

System altered.

SQL> recover managed standby database using current logfile disconnect;
Media recovery complete.
SQL>
SQL>
SQL>

No comments:

Post a Comment