- 备份与恢复
解决Rac实例Stuck Archiver
时间：2014/10/22 21:40:24 作者：solgle 来源：www.solgle.com 查看：5733 评论：1内容摘要：解决实例stuck Archiver---查看Rac数据库状态[grid@www.solgle.com-1 bin]$ ./crsctl stat res解决实例stuck Archiver---查看Rac数据库状态[grid@www.solgle.com-1 bin]$ ./crsctl stat res -t--------------------------------------------------------------------------------NAME TARGET STATE SERVER STATE_DETAILS--------------------------------------------------------------------------------Local Resources--------------------------------------------------------------------------------ora.DATA1.dgONLINE ONLINE www.solgle.com-1ONLINE ONLINE www.solgle.com-2ora.DATA2.dgONLINE ONLINE www.solgle.com-1ONLINE ONLINE www.solgle.com-2ora.LISTENER.lsnrONLINE ONLINE www.solgle.com-1ONLINE ONLINE www.solgle.com-2ora.asmONLINE ONLINE www.solgle.com-1 StartedONLINE ONLINE www.solgle.com-2 Startedora.gsdOFFLINE OFFLINE www.solgle.com-1OFFLINE OFFLINE www.solgle.com-2ora.net1.networkONLINE ONLINE www.solgle.com-1ONLINE ONLINE www.solgle.com-2ora.onsONLINE ONLINE www.solgle.com-1ONLINE ONLINE www.solgle.com-2--------------------------------------------------------------------------------Cluster Resources--------------------------------------------------------------------------------ora.LISTENER_SCAN1.lsnr1 ONLINE ONLINE www.solgle.com-1ora.cvu1 ONLINE ONLINE www.solgle.com-1ora.solgle.db1 ONLINE INTERMEDIATE www.solgle.com-1 Stuck Archiver2 ONLINE ONLINE www.solgle.com-2 Openora.oc4j1 ONLINE ONLINE www.solgle.com-1ora.www.solgle.com-1.vip1 ONLINE ONLINE www.solgle.com-1ora.rac2.vip1 ONLINE ONLINE www.solgle.com-2ora.scan1.vip1 ONLINE ONLINE www.solgle.com-1[grid@www.solgle.com-1 bin]$--www.solgle.com-1归档出错，下面进行处理---查看空间使用情况C:\Users\user>sqlplus sys/********@solgle_db as sysdba;SQL*Plus: Release 11.2.0.1.0 Production on Thu Oct 23 09:04:30 2014Copyright (c) 1982, 2010, Oracle. All rights reserved.Connected to:Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit ProductionWith the Partitioning, Real Application Clusters, Automatic Storage ManagemenOLAP,Data Mining and Real Application Testing optionsSQL> set linesize 100SQL> show parameter db_recoveryNAME TYPE VALUE------------------------------------ -------------------------------- ------------------------------db_recovery_file_dest string +data2db_recovery_file_dest_size big integer 40GSQL>SQL> select sum(percent_space_used) from v$flash_recovery_area_usage;SUM(PERCENT_SPACE_USED)-----------------------99.98SQL>
---一般遇到这种情况，要么扩大空间，要么删除文件----查看asm磁盘组磁盘空间使用情况[grid@www.solgle.com-1 bin]$ ./asmcmdASMCMD> lsdgState Type Rebal Sector Block AU Total_MB Free_MB Req_mir_free_MB Usable_file_MB Offline_disks Voting_files NameMOUNTED EXTERN N 512 4096 2097152 137708 54984 0 54984 0 Y DATA1/MOUNTED EXTERN N 512 4096 1048576 41239 20 0 20 0 N DATA2/ASMCMD> exit[grid@www.solgle.com-1 bin]$---如果是windows server，可以cmd->asmca来查看空间使用情况---free_MB 是磁盘剩余空间，20M已经很少了，当然可以添加磁盘，但这里选择删除文件来释放空间C:\Users\user>rman target=sys/********@solgle_db nocatalog恢复管理器: Release 11.2.0.1.0 - Production on 星期四 10月 23 09:03:24 2014Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.连接到目标数据库: solgle (DBID=1369758280)使用目标数据库控制文件替代恢复目录RMAN> delete noprompt obsolete;RMAN 保留策略将应用于该命令将 RMAN 保留策略设置为冗余 1分配的通道: ORA_DISK_1通道 ORA_DISK_1: SID=71 实例=solgle2 设备类型=DISK删除以下已废弃的备份和副本:类型 关键字 完成时间 文件名/句柄-------------------- ------ ------------------ --------------------存档日志 5284 09-10月-14 +DATA2/solgle/archivelog/2014_10_09/thread_2_seq_1774.1392.860515205存档日志 5285 09-10月-14 +DATA2/solgle/archivelog/2014_10_09/thread_1_seq_3558.691.860529621存档日志 5286 09-10月-14 +DATA2/solgle/archivelog/2014_10_09/thread_1_seq_3559.514.860540419存档日志 5287 10-10月-14 +DATA2/solgle/archivelog/2014_10_10/thread_2_seq_1775.480.860562593备份集 26 10-10月-14备份片段 26 10-10月-14 +DATA2/solgle/autobackup/2014_10_10/s_860581333.474.860581341备份集 27 20-10月-14备份片段 27 20-10月-14 +DATA2/solgle/autobackup/2014_10_20/s_861448746.541.861448755备份集 28 20-10月-14备份片段 28 20-10月-14 +DATA2/solgle/autobackup/2014_10_20/s_861452127.1304.861452135备份集 29 20-10月-14备份片段 29 20-10月-14 +DATA2/solgle/autobackup/2014_10_20/s_861460159.1194.861460167备份集 30 20-10月-14备份片段 30 20-10月-14 +DATA2/solgle/autobackup/2014_10_20/s_861464063.1154.861464069备份集 31 20-10月-14备份片段 31 20-10月-14 +DATA2/solgle/autobackup/2014_10_20/s_861467066.1239.861467073备份集 32 20-10月-14备份片段 32 20-10月-14 +DATA2/solgle/autobackup/2014_10_20/s_861467668.515.861467677备份集 33 20-10月-14备份片段 33 20-10月-14 +DATA2/solgle/autobackup/2014_10_20/s_861468370.531.861468377已删除的归档日志归档日志文件名=+DATA2/solgle/archivelog/2014_10_09/thread_2_seq_1774.1392.860515205 RECID=5284 STAMP=860515210已删除的归档日志归档日志文件名=+DATA2/solgle/archivelog/2014_10_09/thread_1_seq_3558.691.860529621 RECID=5285 STAMP=860529628已删除的归档日志归档日志文件名=+DATA2/solgle/archivelog/2014_10_09/thread_1_seq_3559.514.860540419 RECID=5286 STAMP=860540426已删除的归档日志归档日志文件名=+DATA2/solgle/archivelog/2014_10_10/thread_2_seq_1775.480.860562593 RECID=5287 STAMP=860562599已删除备份片段备份片段句柄=+DATA2/solgle/autobackup/2014_10_10/s_860581333.474.860581341 RECID=26 STAMP=860581340已删除备份片段备份片段句柄=+DATA2/solgle/autobackup/2014_10_20/s_861448746.541.861448755 RECID=27 STAMP=861448753已删除备份片段备份片段句柄=+DATA2/solgle/autobackup/2014_10_20/s_861452127.1304.861452135 RECID=28 STAMP=861452135已删除备份片段备份片段句柄=+DATA2/solgle/autobackup/2014_10_20/s_861460159.1194.861460167 RECID=29 STAMP=861460166已删除备份片段备份片段句柄=+DATA2/solgle/autobackup/2014_10_20/s_861464063.1154.861464069 RECID=30 STAMP=861464069已删除备份片段备份片段句柄=+DATA2/solgle/autobackup/2014_10_20/s_861467066.1239.861467073 RECID=31 STAMP=861467072已删除备份片段备份片段句柄=+DATA2/solgle/autobackup/2014_10_20/s_861467668.515.861467677 RECID=32 STAMP=861467676已删除备份片段备份片段句柄=+DATA2/solgle/autobackup/2014_10_20/s_861468370.531.861468377 RECID=33 STAMP=86146837612 对象已删除RMAN>---再次查看空间使用率SQL> select sum(PERCENT_SPACE_USED) from v$flash_recovery_area_usage;SUM(PERCENT_SPACE_USED)-----------------------99.91SQL>----99.91% ，说明删除冗余后，剩余空间还是没有释放很多---下面继续删除归档文件RMAN> delete noprompt archivelog all;释放的通道: ORA_DISK_1分配的通道: ORA_DISK_1通道 ORA_DISK_1: SID=71 实例=solgle2 设备类型=DISKdb_unique_name 为 solgle 的数据库的归档日志副本列表=====================================================================5821 2 2080 A 22-10月-14名称: +DATA2/solgle/archivelog/2014_10_22/thread_2_seq_2080.265.8616548995826 2 2081 A 22-10月-14名称: +DATA2/solgle/archivelog/2014_10_22/thread_2_seq_2081.872.8616574155829 2 2082 A 22-10月-14名称: +DATA2/solgle/archivelog/2014_10_22/thread_2_seq_2082.880.861665665已删除的归档日志归档日志文件名=+DATA2/solgle/archivelog/2014_10_10/thread_1_seq_3560.860.860583609 RECID=5288 STAMP=860583616已删除的归档日志归档日志文件名=+DATA2/solgle/archivelog/2014_10_10/thread_1_seq_3561.724.860626827 RECID=5291 STAMP=860626833已删除的归档日志归档日志文件名=+DATA2/solgle/archivelog/2014_10_11/thread_1_seq_3562.1080.860652157 RECID=5292 STAMP=860652164已删除的归档日志归档日志文件名=+DATA2/solgle/archivelog/2014_10_11/thread_1_seq_3563.986.860674511 RECID=5294 STAMP=860674519已删除的归档日志归档日志文件名=+DATA2/solgle/archivelog/2014_10_11/thread_1_seq_3564.907.860674551 RECID=5295 STAMP=860674560... ...---rman 删除仍在继续，下面查询空间使用率SQL> select sum(percent_space_used) from v$flash_recovery_area_usage;SUM(PERCENT_SPACE_USED)-----------------------60.7SQL>----空间还会逐渐释放出来，下面可以开始启动实例www.solgle.com-1了[grid@www.solgle.com-1 bin]$ ./srvctl start instance -d solgle -n www.solgle.com-1PRCC-1015 : solgle was already running on www.solgle.com-1PRCR-1004 : Resource ora.solgle.db is already running----查看状态，还用不着执行启动www.solgle.com-1命令，已经自动启起来了[grid@www.solgle.com-1 bin]$ ./crsctl stat res -t--------------------------------------------------------------------------------NAME TARGET STATE SERVER STATE_DETAILS--------------------------------------------------------------------------------Local Resources--------------------------------------------------------------------------------ora.DATA1.dgONLINE ONLINE www.solgle.com-1ONLINE ONLINE www.solgle.com-2ora.DATA2.dgONLINE ONLINE www.solgle.com-1ONLINE ONLINE www.solgle.com-2ora.LISTENER.lsnrONLINE ONLINE www.solgle.com-1ONLINE ONLINE www.solgle.com-2ora.asmONLINE ONLINE www.solgle.com-1 StartedONLINE ONLINE www.solgle.com-2 Startedora.gsdOFFLINE OFFLINE www.solgle.com-1OFFLINE OFFLINE www.solgle.com-2ora.net1.networkONLINE ONLINE www.solgle.com-1ONLINE ONLINE www.solgle.com-2ora.onsONLINE ONLINE www.solgle.com-1ONLINE ONLINE www.solgle.com-2--------------------------------------------------------------------------------Cluster Resources--------------------------------------------------------------------------------ora.LISTENER_SCAN1.lsnr1 ONLINE ONLINE www.solgle.com-1ora.cvu1 ONLINE ONLINE www.solgle.com-1ora.solgle.db1 ONLINE ONLINE www.solgle.com-1 Open2 ONLINE ONLINE www.solgle.com-2 Openora.oc4j1 ONLINE ONLINE www.solgle.com-1ora.www.solgle.com-1.vip1 ONLINE ONLINE www.solgle.com-1ora.rac2.vip1 ONLINE ONLINE www.solgle.com-2ora.scan1.vip1 ONLINE ONLINE www.solgle.com-1[grid@www.solgle.com-1 bin]$----因为删除了所有归档，所以现在备份下RMAN> backup as compressed backupset database;启动 backup 于 23-10月-14使用通道 ORA_DISK_1使用通道 ORA_DISK_1通道 ORA_DISK_1: 正在启动压缩的全部数据文件备份集通道 ORA_DISK_1: 正在指定备份集内的数据文件输入数据文件: 文件号=00003 名称=+DATA1/solgle/datafile/undotbs1.258.855682813输入数据文件: 文件号=00022 名称=+DATA1/solgle/datafile/tbs_data_part_17.284.856869153... ...----再次删除冗余RMAN> delete noprompt obsolete;RMAN 保留策略将应用于该命令将 RMAN 保留策略设置为冗余 1使用通道 ORA_DISK_1删除以下已废弃的备份和副本:类型 关键字 完成时间 文件名/句柄-------------------- ------ ------------------ --------------------备份集 25 10-10月-14备份片段 25 10-10月-14 +DATA2/solgle/backupset/2014_10_10/nnndf0_tag20141010t092937_0.1269.860578185备份集 34 20-10月-14备份片段 34 20-10月-14 +DATA2/solgle/autobackup/2014_10_20/s_861469169.527.861469177已删除备份片段备份片段句柄=+DATA2/solgle/backupset/2014_10_10/nnndf0_tag20141010t092937_0.1269.860578185 RECID=25 STAMP=860578183已删除备份片段备份片段句柄=+DATA2/solgle/autobackup/2014_10_20/s_861469169.527.861469177 RECID=34 STAMP=8614691762 对象已删除RMAN> exit恢复管理器完成。C:\Users\user>--实例恢复成功solgle.com 版权所有，欢迎分享！！！
- 相关文章
- 相关评论
- 本类更新
-
4-29打开数据库报ora-00742,ora-00312,解决方式小计
-
11-27逻辑DataGuard重新部署逻辑备用数据库
-
11-14处理Oracle集群Asm磁盘阵列断网问题
-
11-6RMAN-06207:警告:由于状态不匹配,所以不能删除1对象(对于DISK通道)
-
10-22解决Rac实例Stuck Archiver
-
9-22DataGuard物理备用切换到逻辑备用
-
9-19ORA-01126:探索DataGuard的保护模式切换规则
-
9-18ORA-19606:无法复制到(或还原为)快照控制文件
-
9-7部署Oracle 11g DataGuard 用Rman创建 standby database
-
7-13ORA-00845: MEMORY_TARGET not supported on this system
-
- 本类推荐
- 本类排行
-
4-29打开数据库报ora-00742,ora-00312,解决方式小计
-
10-22解决Rac实例Stuck Archiver
-
11-6RMAN-06207:警告:由于状态不匹配,所以不能删除1对象(对于DISK通道)
-
11-14处理Oracle集群Asm磁盘阵列断网问题
-
10-24RMAN备份与恢复
-
7-13ORA-03113: 通信通道的文件结尾
-
9-7部署Oracle 11g DataGuard 用Rman创建 standby database
-
9-18ORA-19606:无法复制到(或还原为)快照控制文件
-
7-20ORA-00000 normal, successful completion
-
7-9ORA-38760:This database instance failed to turn on flashback database
-
Copyright © 2013-2028 solgle.com,All rights reserved.[solgle.com] 公安机关备案号:51010802000219
Email:solgle@solgle.com; weixin:cd1008610000 ICP:蜀ICP备14011070号-1
Email:solgle@solgle.com; weixin:cd1008610000 ICP:蜀ICP备14011070号-1
