备库在切换到主库时报错ORA-00344

SQL> SELECT SWITCHOVER_STATUS FROM V$DATABASE; 

SWITCHOVER_STATUS
--------------------
TO PRIMARY

SQL> ALTER DATABASE COMMIT TO SWITCHOVER TO PRIMARY;
ALTER DATABASE COMMIT TO SWITCHOVER TO PRIMARY
*
ERROR at line 1:
ORA-00344: unable to re-create online log
'/u01/app/oracle/oradata/node1/redo01.log'
ORA-27040: file create error, unable to create file
Linux Error: 2: No such file or directory

SQL> show parameter log_file_name_convert

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
log_file_name_convert                string      /u01/app/oracle/oradata/node2/
                                                 , /u01/app/oracle/oradata/node
                                                 1/

SQL> alter system set log_file_name_convert='/u01/app/oracle/oradata/node1/','/u01/app/oracle/oradata/node2/' scope=spfile;

System altered.

SQL> shutdown immediate
ORA-01109: database not open


Database dismounted.
ORACLE instance shut down.
SQL> startup mount;
ORACLE instance started.

Total System Global Area  285212672 bytes
Fixed Size                  1218992 bytes
Variable Size             121636432 bytes
Database Buffers          159383552 bytes
Redo Buffers                2973696 bytes
Database mounted.
SQL> SELECT SWITCHOVER_STATUS FROM V$DATABASE;

SWITCHOVER_STATUS
--------------------
TO PRIMARY

SQL> ALTER DATABASE COMMIT TO SWITCHOVER TO PRIMARY;

Database altered.

总结：dataguard出现问题最多的一般是在前期配置上，而此例就是因为文件转换参数设置不当导致在将物理备库切到主库角色时报错，以至于为了修改这个不正确的参数使得数据库进行了重启。所以以后在前期配置上需要花些时间更加仔细的配置，这样在日后的运维中也会少很多不必要的运维工作甚至可以避免不必要的数据库重启服务。