oracle dg修改联机日志logfile路径以及大小

SQL> alter database clear logfile group 4;
alter database clear logfile group 4
*
ERROR at line 1:
ORA-01156: recovery or flashback in progress may need access to files




SQL> alter database recover managed standby database cancel;


Database altered.


SQL> alter database clear logfile group 4;


Database altered.


SQL> alter database drop logfile group 4; 
alter database drop logfile group 4
*
ERROR at line 1:
ORA-01275: Operation DROP LOGFILE is not allowed if standby file management is
automatic.




SQL> alter system set standby_file_management=manual; 


System altered.


SQL>  alter database drop logfile group 4;


Database altered.

--创建新的logfile，指定路径以及大小

SQL> alter database add logfile group4 

(

/log/qxdb/redo01,

/log/qxdb/redo02

) size 800M;

alter system set LOG_FILE_NAME_CONVERT='/u01/','/u01/' scope=spfile; 
alter database clear logfile group 1;  
alter database clear logfile group 2;  
alter database clear logfile group 3;
alter database clear logfile group 4;
  
alter system reset LOG_FILE_NAME_CONVERT;  
shutdown immediate;  
startup;  
alter system set standby_file_management=auto; 
alter database recover managed standby database using current logfile disconnect from session;