ORA-01511 error in renaming log/data files ORA-00261 log 4 of thread 1 is being

資料庫版本12.2，使用standby備庫備份恢復出一套可讀寫的資料庫，在rename standby redolog時遇到ORA-01511 error in renaming log/data files ORA-00261 log 4 of thread 1 is being archived or modified，該錯誤是因為備庫還處於reco ver模式，standby redo logfile還在使用中時做的全庫備份。

solution:

1. restore controlfile時指定primary

2. alter database clear unarchived logfile group 4;

3. alter database drop standby logfile group 4;

4. alter database open resetlogs;