备份与恢复

ORA-00257:arhive error connect internal only,until freed.

时间:2014-7-9 21:59:18  作者:solgle  来源:www.solgle.com  查看:408  评论:0
内容摘要:用toad连接数据库报以下错误ORA-00257 :arhive error connect internal only,until freed.登陆主库SQL*Plus: Release 11.2.0.1.0 Production on Sun Sep 28 09:16...
用toad连接数据库报以下错误
ORA-00257 :arhive error connect internal only,until freed.
----登陆主库
SQL*Plus: Release 11.2.0.1.0 Production on Sun Sep 28 09:16:05 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> select sum(percent_space_used) from v$flash_recovery_area_usage;
 
SUM(PERCENT_SPACE_USED)
-----------------------
                  69.87
SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64
bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
 
C:\Users\user>
 
---登陆主库所在linux服务器
[oracle@sd1 ~]$ df -h
Filesystem                    Size  Used Avail Use% Mounted on
/dev/mapper/VolGroup-lv_root   36G   21G   14G  62% /
tmpfs                         1.5G  721M  765M  49% /dev/shm
/dev/sda1                     477M   55M  397M  13% /boot
/dev/sdb1                      50G   46G  1.1G  98% /u01/data
/dev/sr0                      3.7G  3.7G     0 100% /media/OL6.5 x86_64 Disc 1 
 
20131125
[oracle@sd1 ~]$ 
 
---从/dev/sdb1 use% 为98%,说明空间紧张
 
---rman 管理主库归档日志,释放空间
 
恢复管理器: Release 11.2.0.1.0 - Production on 星期日 9月 28 09:34:00 2014
 
Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.
 
连接到目标数据库: solgle (DBID=1370340464)
使用目标数据库控制文件替代恢复目录
 
RMAN> delete obsolete;
 
RMAN 保留策略将应用于该命令
将 RMAN 保留策略设置为冗余 1
分配的通道: ORA_DISK_1
通道 ORA_DISK_1: SID=68 设备类型=DISK
删除以下已废弃的备份和副本:
类型                 关键字 完成时间           文件名/句柄
-------------------- ------ ------------------ --------------------
备份集               27     19-9月 -14
备份片段       27     19-9月 -14         /u01/data/bak_data/OS_solgle/autobackup
/2014_09_19/o1_mf_s_858697390_b1qo9hld_.bkp
 
是否确定要删除以上对象 (输入 YES 或 NO)? yes
已删除备份片段
备份片段句柄=/u01/data/bak_data/OS_solgle/autobackup/2014_09_19/o1_mf_s_85869739
0_b1qo9hld_.bkp RECID=27 STAMP=858697391
1 对象已删除
 
RMAN> delete archivelog all;
 
 
---再看主库
SQL> select sum(percent_space_used) from v$flash_recovery_area_usage;
SUM(PERCENT_SPACE_USED)
-----------------------
                  35.58
SQL>
 
 
----该错误已经解决
---建议:data path and archive path 分开
 
 
 
ORA-16198: Timeout incurred on internal channel during remote archival
该错误为逻辑备份库的 归档空间满了,或者是路径不能访问


 
标签:ORA-00257 ORA-16198 arhive error connect internal only until freed. 

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

相关评论
   Copyright © 2013-2020 solgle.com,All rights reserved.[solgle.com] 公安机关备案号:51010802000219
Email:solgle@solgle.com; weixin:cd1008610000 ICP:蜀ICP备14011070号-1