重建online redo
SQL> alter database rename file '/u01/app/oracle/flash_recovery_area/DG_ST/onlinelog/o1_mf_1_8qwomcmy_.log' to '/u01/app/oracle/oradata/dg/redo01.log';
alter database rename file '/u01/app/oracle/flash_recovery_area/DG_ST/onlinelog/o1_mf_1_8qwomcmy_.log' to '/u01/app/oracle/oradata/dg/redo01.log'
*
ERROR at line 1:
ORA-01511: error in renaming log/data files
ORA-01275: Operation RENAME is not allowed if standby file management is
automatic.
关闭数据库,在开启状态下。将auto修改成manual
SQL>alter system set standby_file_management=manual;
初始化参数STANDBY_FILE_MANAGEMENT用于激活或禁止自动备用文件管理特征,默认值为MANUAL。
当设置该参数为MANUAL时,需要手工管理备用数据库的文件;当设置该参数为AUTO时,如果在主数据库上增加或删除文件,则会自动在备用数据库上增加或删除文件。
该初始化参数是动态参数,可以使用ALTER SYSTEM命令进行修改。
alter database rename file '/u01/app/oracle/flash_recovery_area/DG_ST/onlinelog/o1_mf_1_8qwomcmy_.log' to '/u01/app/oracle/oradata/dg/redo01.log';
重建standby redo log
SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE CANCEL;
SQL>alter database clear logfile group 1;
SQL> alter database drop standby logfile group 1;
SQL> alter database add standby logfile group 1 ('/u03/redo/stby01.log') size 50m;