[Oracledatagard]从库恢复之ORA-16032:parameterORA-07286:问题 - 数据库编程

机房断电，所以oracle的datagard的从库需要重新启动：

1 登录sqlplus启动，出现报错信息：

SQL> STARTUP MOUNT;

ORA-16032: parameter LOG_ARCHIVE_DEST_3 destination string cannot be translated

2 去查看找下 LOG_ARCHIVE_DEST_3 的具体路径

[root@localhost ~]# su - oracle
-rw-r-----. 1 oracle dba 5632 8月 30 2013 spfilepowerdes.ora

3 # 找到了路径

[oracle@localhost dbs]$ strings spfile*.ora|grep dest_3

4 check路径，排查问题

5 解决问题

/data已经存在了，只是无法使用，google，看到2种解决方案

6 再次登录sqlplus start从库

SQL>  STARTUP MOUNT;
ORACLE instance started.

Total System Global Area 5344731136 bytes
Fixed Size		    2213136 bytes
Variable Size		 3489663728 bytes
Database Buffers	 1811939328 bytes
Redo Buffers		   40914944 bytes
Database mounted.

SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE DISCONNECT FROM SESSION;

Database altered.

SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE USING CURRENT LOGFILE;
ALTER DATABASE RECOVER MANAGED STANDBY DATABASE USING CURRENT LOGFILE
*
ERROR at line 1:
ORA-01153: an incompatible media recovery is active

SQL> alter database open;
alter database open
*
ERROR at line 1:
ORA-10456: cannot open standby database; media recovery session may be in
progressSQL> recover managed standby database cancel; Media recovery complete.
7 试图再自动 recover下，不过还是fail，只要再次中止
SQL> recover automatic standby database ;
ORA-00279: change 10386441904 generated at 04/18/2014 17:56:46 needed for
thread 1
ORA-00289: suggestion :
/data/oracle/oradgdata/standby_archive/1_7368_821708334.dbf
ORA-00280: change 10386441904 for thread 1 is in sequence #7368
ORA-00278: log file
'/data/oracle/oradgdata/standby_archive/1_7368_821708334.dbf' no longer needed
for this recovery
ORA-00308: cannot open archived log
'/data/oracle/oradgdata/standby_archive/1_7368_821708334.dbf'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3

Specify log: {=suggested | filename | AUTO | CANCEL}

ORA-00308: cannot open archived log
'/data/oracle/oradgdata/standby_archive/1_7368_821708334.dbf'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3

SQL> RECOVER MANAGED STANDBY DATABASE DISCONNECT FROM SESSION;
Media recovery complete.?

8，查看下当前datagard的状态

SQL> SELECT MESSAGE FROM V$DATAGUARD_STATUS;


MESSAGE
--------------------------------------------------------------------------------
ARC0: Archival started
ARC1: Archival started
ARC2: Archival started
ARC3: Archival started
ARC4: Archival started
ARC5: Archival started
ARC6: Archival started
ARC7: Archival started
ARC8: Archival started
ARC9: Archival started
ARCa: Archival started


MESSAGE
--------------------------------------------------------------------------------
ARCb: Archival started
ARCc: Archival started
ARCd: Archival started
ARCe: Archival started
ARCf: Archival started
ARCg: Archival started
ARCh: Archival started
ARCi: Archival started
ARC1: Becoming the 'no FAL' ARCH
ARC2: Becoming the heartbeat ARCH
ARCj: Archival started


MESSAGE
--------------------------------------------------------------------------------
Media Recovery Start: Managed Standby Recovery
Managed Standby Recovery not using Real Time Apply
Media Recovery Waiting for thread 1 sequ

[Oracledatagard]从库恢复之ORA-16032:parameterORA-07286:问题(一)