I have setup physical standby for 2 node RAC database which is on Primary side.
Archives are all getting transpoted to standby but not getting applied from last one week , and also only 1 standby redolog is in use out of 6 redologs .Not sure where is the issue but below are my questions.
1) do the standby redo logs on primary (both nodes) and standby should be same in number and also in size? as they are not.
2) on standby do redologs and standby redo logs should be same in size ? as they are not
3) when I tried to start recovery , I got
ORA-00283: recovery session canceled due to errors
ORA-01264: Unable to create logfile file name.
4) how to start MRP. please note there is no archive gap, only one standby redo log is in active status bt not sure how to confirm if things are working right.
do i need to fix standby__archive_dest as its pointing to default location ?/dbs/arch but my archives are getting generated to some other location