ORA-01152 备库能mount但不能open

查看error

SQL> r

  1* SELECTdest_id,status,error from v$archive_dest where status='ERROR'

   DEST_ID STATUS    ERROR

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

     2 ERROR     ORA-12541: TNS:no listener

这个查询一般是在主库查，这么看是备库没有监听

v$archive_dest你报错的是dest_id=2

dest_id=2就是到对方的备库报错了

为什么？因为12514 那就看对方备库的监听

查看日志是否应用

之后又看到disable，主库没有放行

SQL> SELECT dest_id,status,error from v$archive_dest where status='DISABLED';
   DEST_ID STATUS
---------- ---------
ERROR
-----------------------------------------------------------------
         2 DISABLED
ORA-16057: server not in Data Guard configuration

应该是 log_archive_dest_2_state=disable,着DEFERLIAO

主库通道2的状态应该不对

看log_archive_config

主库没有

备库有

在执行duplicate target database for standby from activedatabase 语句成功后，备库无法open

SQL> alter database open;

alter database open

*

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: '/hisorcldg/oradata/hisorcldg/system01.dbf'

SQL> alter system setlog_archive_config='dg_config=(hisorcl,hisorcldg)';

System altered.

此后问题解决.