oracle ora 01152,standby database ope时，提示ORA-10458: ORA-01152: ORA-01110:

在配置完standby database，完成数据库同步时，将standby database切换到open状态时，提示下面的的错误

SQL> select open_mode from v$database;

OPEN_MODE

--------------------

MOUNTED

SQL> alter database open;

alter database open

*

ERROR at line 1:

ORA-10458: standby database requiresrecovery

ORA-01152: file 1 was not restored from asufficiently old backup

ORA-01110: data file 1:

'/u01/app/oracle/oradata/racdg/datafile/system.256.1034746429'

SQL> select open_mode from v$database;

OPEN_MODE

--------------------

READ ONLY WITH APPLY

退出sqlplus，找到数据库的aler告警日志，查询详细的报错信息，如下：

Thu Mar 12 08:48:32 2020

ARC3 started with pid=26, OS id=36461

ARC1: Archival started

ARC2: Archival started

ARC2: Becoming the 'no FAL' ARCH

ARC1: Becoming the heartbeat ARCH

ARC1: Becoming the active heartbeat ARCH

WARNING:No local destinations have been defined for archival of the Standby Redo Log.

Completed: alter database mount standby database

ARC3: Archival started

ARC0: STARTING ARCH PROCESSES COMPLETE

Errors in file /u01/app/oracle/diag/rdbms/orcl/orcl/trace/orcl_lgwr_35271.trc:

ORA-00313: open failed for members of log group 1 of thread 1

ORA-00312: online log 1 thread 1: '/u01/app/oracle/oradata/racdg/onlinelog/group_1.263.1034746481'

ORA-27037: unable to obtain file status

提示没有在本地为归档设置目录。

查看standby database的pfile，发现log_archive_dest2与fal_server和standby database的db_unique_name都未能设置或设置错误

[oracle@racdg dbs]$ cat initorcl.ora

orcl.__db_cache_size=838860800

orcl.__java_pool_size=16777216

orcl.__large_pool_size=33554432

orcl.__oracle_base='/u01/app/oracle'#ORACLE_BASE set from environment

orcl.__pga_aggregate_target=402653184

orcl.__sga_target=1191182336

orcl.__shared_io_pool_size=0