I had to relocate all files on my 11.2 physical standby database to a new mount point (nothing changed on the primary). I cancelled managed recovery on the standby and shutdown the standby, then copied the datafiles, controlfile, ORLs, and SRLs to their new location. After that, I mounted the standby, set standby_file_management=MANUAL and did a "alter database rename file" for all files; however, I saw this error repeatedly for all files:
Example:
ORA-1511 signalled during: alter database rename file '/g06/oradata/mydb/redo06.log' to '/g03/oradata/mydb/redo06.
log'...
I did this:
select name from v$datafile;
select name from v$tempfile;
select member from v$logfile;
All the datafiles and tempfiles were showing in the new correct location as well as all the ORLs and SRLs except one SRL file, which was still showing in its old location. I then did:
select * from v$standby_log and that one particular SRL showed ACTIVE. I started managed recovery and switched logfiles on the primary. I then shutdown the standby again and started it up and this time I was able to rename that one SRL that I couldn't rename before (probably due to the log switch).
Why am I seeing the ORA-1511 errors even though the rename worked? Why did the one SRL rename not work? What is the correct way to do this?
Also, I switched log files a bunch of times on the primary and I noticed the only two out of six SRLs were ever being used. Aren't they supposed to rotate in circular fashion instead of switching back and forth between only two of the six SRLs?