DataDuard主库备份库同时断电后同步失败

加入收藏设为首页

Oracle管理: DataDuard主库备份库同时断电后同步失败
时间：2014/11/21 20:21:34 作者：solgle 来源：www.solgle.com 查看：1116 评论：0
内容摘要：---因意外断电，备份库同步失败，重启服务照样如此C:\Users\user>sqlplus sys/********@sd_solgle as sysdbaSQL*Plus: Release 11.2.0.1.0 Production on Thu Nov 27 09:31:3...
---因意外断电，备份库同步失败，重启服务照样如此

C:\Users\user>sqlplus sys/********@sd_solgle as sysdba

SQL*Plus: Release 11.2.0.1.0 Production on Thu Nov 27 09:31:31 2014

Copyright (c) 1982, 2010, Oracle. All rights reserved.

本文出自：http://www.solgle.com/news/?116.html

Connected to:

Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> alter database stop logical standby apply;

Database altered.

SQL> alter database start logical standby apply immediate;

Database altered.

----常看归档空间，占用量非常少

select * from v$flash_recovery_area_usage;

SQL> select sum(percent_space_reclaimable) from v$flash_recovery_area_usage;

SUM(PERCENT_SPACE_RECLAIMABLE)

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

4.65

SQL>

----分别查看主库，及备份库alert日志

---主库提示日志信息业正常，备份库确报错了

----备份库alert log

<msg time='2014-11-27T08:00:59.731+08:00' org_id='oracle' comp_id='rdbms'

client_id='' type='UNKNOWN' level='16'

host_id='sd1' host_addr='127.0.0.1' module=''

pid='2041'>

<txt>ARCH: Archival stopped, error occurred. Will continue retrying

</txt>

</msg>

<msg time='2014-11-27T08:00:59.733+08:00' org_id='oracle' comp_id='rdbms'

client_id='' type='UNKNOWN' level='16'

host_id='sd1' host_addr='127.0.0.1' module=''

pid='2041'>

<txt>ORACLE Instance solgle - Archival Error

</txt>

</msg>

<msg time='2014-11-27T08:00:59.734+08:00' org_id='oracle' comp_id='rdbms'

client_id='' type='UNKNOWN' level='16'

host_id='sd1' host_addr='127.0.0.1' module=''

pid='2041'>

<txt>ORA-16014: log 2 sequence# 1619 not archived, no available destinations

ORA-00312: online log 2 thread 1: '/u01/bak_data/SD_solgle/onlinelog/o1_mf_2_b1z7v6o4_.log'

</txt>

</msg>

<msg time='2014-11-27T08:01:00.399+08:00' org_id='oracle' comp_id='rdbms'

client_id='' type='UNKNOWN' level='16'

host_id='sd1' host_addr='127.0.0.1' module='MMON_SLAVE'

pid='10768'>

<txt>Deleted Oracle managed file /u01/data/bak_data/SD_solgle/foreign_archivelog/os_solgle/2014_11_15/o1_mf_1_1710_b6gqsmm9_.arc

</txt>

</msg>

归档失败，且"Deleted Oracle managed file",删除归档以给出空间，迅速查看磁盘使用情况

[oracle@sd1 u01]$ df -h

Filesystem Size Used Avail Use% Mounted on

/dev/mapper/VolGroup-lv_root 36G 21G 14G 60% /

tmpfs 2.0G 624M 1.4G 31% /dev/shm

/dev/sda1 477M 55M 397M 13% /boot

/dev/sdb1 50G 47G 321M 100% /u01/data

---验证归档路径

SQL> show parameter db_recovery

NAME TYPE VALUE

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

db_recovery_file_dest string /u01/data/bak_data

db_recovery_file_dest_size big integer 18G

SQL>

-----先释放磁盘空间

C:\Users\user>rman target=sys/********@sd_solgle nocatalog

恢复管理器: Release 11.2.0.1.0 - Production on 星期四 11月 27 10:34:53 2014

Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.

连接到目标数据库: solgleL (DBID=4211756622)

使用目标数据库控制文件替代恢复目录

RMAN> delete noprompt archivelog all;

---重启同步服务

C:\Users\user>sqlplus sys/********@sd_solgle as sysdba

SQL*Plus: Release 11.2.0.1.0 Production on Thu Nov 27 10:34:01 2014

Copyright (c) 1982, 2010, Oracle. All rights reserved.

Connected to:

Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> alter database stop logical standby apply;

Database altered.

SQL> alter database start logical standby apply immediate;

Database altered.

SQL>

-----测试，同步还是不行，重启主库日志传输

SQL> exec dbms_logstdby.build;

PL/SQL procedure successfully completed.

SQL>

----重启备份库日志同步,还是不行

----看来只有重建备份库了

--->>>http://www.solgle.com/news/?115.html

标签：DataDuard主库备份库同时断电后同步失败


solgle.com 版权所有，欢迎分享！！！

上一篇：asmcmd登陆问题小计
下一篇：DataGuard备份库服务器断网恢复小计

相关文章

相关评论

本类更新

本类推荐

本类排行

: 国家数据 | 中证指数 | Oracle官方文档 | 沪深行情 | 流量统计 | 深交所 | 上交所 | 中国证券登记 | 同业拆放利率 | 巨潮资讯 | 指数估值 | 看财报 |

联系我们 - 关于我们 - 网站同盟