备库添加日志文件

  为了保持主备库的在线日志文件组保持一致,在主库添加后需要在备库也相应的添加,步骤如下:

1.退出日志应用模式
SQL> alter database add logfile group 8 ('/u01/app/oracle/oradata/oracl/redo04.log') SIZE 512m;
alter database add logfile group 8 ('/u01/app/oracle/oradata/oracl/redo04.log') SIZE 512m
*
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.

2.设置standby_file_management为manual
SQL> alter database add logfile group 8 ('/u01/app/oracle/oradata/oracl/redo04.log') SIZE 512m;
alter database add logfile group 8 ('/u01/app/oracle/oradata/oracl/redo04.log') SIZE 512m
*
ERROR at line 1:
ORA-01275: Operation ADD LOGFILE is not allowed if standby file management is
automatic.

SQL> alter system set standby_file_management=manual;

System altered.

3.添加日志组
SQL> alter database add logfile group 8 ('/u01/app/oracle/oradata/oracl/redo04.log') SIZE 512m;

Database altered.

4.将standby_file_management修改为auto
SQL> alter system set standby_file_management=auto;

System altered.

5.启用日志应用
SQL> alter database recover managed standby database using current logfile disconnect from session;

Database altered.

-- The End --