Slave uard slave database cannot OPEN report ORA-10458: ORA-01152: ORA-01110

Perform replica uard. After the standby database RMAN is synchronized, alterdatabaseopenreadonly cannot start. There is no error in the rman process. When the standby database is started, there is a heap of E in alter. log.

Perform replica uard. After the standby database RMAN is synchronized, the alter database open read only command cannot start. There is no error in the rman process. When the standby database is started, there is a heap of E in alter. log.

SQL> alter database open read only;
Alter database open read only
*
ERROR at line 1:
ORA-10458: standby database requires recovery
ORA-01152: file 1 was not restored from a sufficiently old backup
ORA-01110: data file 1: '/Oracle/oradata/BSTYLE/system.309.766573511'

Alter. log error

Error 12154 removed ed logging on to the standby

Background:
Perform replica uard. After the standby database RMAN is synchronized, the alter database open read only command cannot start. There is no error in the rman process. When the standby database is started, check alter. there are a bunch of log errors 12154 written ed logging on to the standby, and then look at the master database alter. log, there are also a bunch of errors 12154 logged ed logging on to the standby

What does this mean? It means that the archivelog archive path to the slave database failed, and the archive failed! However, it is normal for the master database sqlplus to connect to the slave database or the slave database to connect to the master database! Why not archive?

SQL> select error from v $ archive_dest;

ERROR
-----------------------------------------------------------------

ORA-12154: TNS: cocould not resolve the connect identifier specified

I cocould tnsping the STANDBY from production

Archive_dest_2 in Dataguard is used to point to the standby database. Archive logs are uploaded to the standby database and configuration parameters are checked.

Note that service = in dest_2 should be the same as the slave database defined in tnsnames, for example.

Here, the archive is passed out because of different settings. After the change is the same, everything is OK !!!

References:

Important configuration parameters of Oracle Data Guard

Configure Oracle 11g Data Guard based on the same host

Explore Oracle 11g elastic uard

Oracle Data Guard (RAC + DG) archive deletion policies and scripts

Role conversion for Oracle Data Guard

FAL gap in Oracle Data Guard logs

Oracle 11g Data Guard Error 16143 Heartbeat failed to connect to standby