DOYENSYS Knowledge Portal




We Welcome you to visit our DOYENSYS KNOWLEDGE PORTAL : Doyensys Knowledge Portal




Monday, October 3, 2016

Error: Primary database is in MAXIMUM PERFORMANCE mode

Error:

RFS[4]: No standby redo logfiles of size 102400 blocks exist

Fix:

In standby database, standby redo logs on the standby database and the online redo logs on the primary database are in different size, you will get this error. The easy way to check the size is go to the data directory and compare the file size,

In Standby database,

select * from v$logfile where type = 'STANDBY';


Drop and recreate the standby redo log files, 

alter database drop logfile '/data/oradata/tstdba/sby_redo01.log';
alter database drop logfile '/data/oradata/tstdba/sby_redo02.log';
alter database drop logfile '/data/oradata/tstdba/sby_redo03.log';

alter database add standby logfile '/data/oradata/tstdba/stdby_redo01.log' size 50m;
alter database add standby logfile '/data/oradata/tstdba/stdby_redo02.log' size 50m;
alter database add standby logfile '/data/oradata/tstdba/stdby_redo03.log' size 50m;



No comments: