Oracle管理

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

时间:2014/11/21 20:21:34  作者:solgle  来源:www.solgle.com  查看:1123  评论: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.
 
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: &apos;/u01/bak_data/SD_solgle/onlinelog/o1_mf_2_b1z7v6o4_.log&apos;
 </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>
 
----重启备份库日志同步,还是不行
 
----看来只有重建备份库了
 
标签:DataDuard主库备份库同时断电后同步失败 

solgle.com 版权所有,欢迎分享!!!

相关文章
    相关评论
     img1 img2 img3 img4 img5 img6 img7 img8 img9 img10
    评论者:      验证码:  点击获取验证码
       Copyright © 2013-2028 solgle.com,All rights reserved.[solgle.com] 公安机关备案号:51010802000219
    Email:solgle@solgle.com; weixin:cd1008610000 ICP:蜀ICP备14011070号-1