问题
DG备库无法转为读写
尝试解决方案
shutdown immediate;
startup mount;
alter database open read write;
- ORA-16003
alter database clear logfile group 11; --重建group11的文件
alter database clear unarchived logfile group 11;
- ORA-00313
最终解决方案
alter database clear unarchived logfile group 20;
alter database activate standby database;
select open_mode from v$database;
read write