This content has been marked as final. Show 3 replies
Even if you add standby or online redo log files or even if you resize by drop and recreate redo log files, they won't be created on standby database. They are instance specific.
Let perform all the recovery, cancel MRP.
And then drop, add standby redo log files, I think you must put standby_file_management to MANUAL before adding new standby redo log files. And don't forget to set standby file management to AUTO again after performing changes.
And you trying to perform log switch on standby, it's applicable only on primary because log switch can be performed only on database which uses online redo log files. Even if you open standby databases with recovery no redo will be generated hence no log switches are allowed too.
I don't have an exact document. But you stop apply on the standby and then :
Then you can use this document to recreate :
alter database drop standby logfile group 5;
Remember if the old files on the OS remain you could have a conflict.