rman备份archivelog出现ORA-19625

最新推荐文章于 2021-04-15 09:47:56 发布
最新推荐文章于 2021-04-15 09:47:56 发布
阅读量131 收藏
点赞数
文章标签： 操作系统 数据库
rman备份archivelog时出现以下错误：
RMAN> backup archivelog all delete input;
Starting backup at 14-APR-14
current log archived
using channel ORA_DISK_1
using channel ORA_DISK_2
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of backup command at 04/14/2014 18:40:23
RMAN-06059: expected archived log not found, loss of archived log compromises recoverability
ORA-19625: error identifying file /home/oracle/PROD/1_2_844469007.dbf
ORA-27037: unable to obtain file status
Linux Error: 2: No such file or directory
Additional information: 3
网上查了出错原因是由于 操作系统下删除了这个归档日志，这个日志还没备份过，rman去备份的时候，找不到这个归档就出错了。可使用change archivelog all crosscheck命令来解决此问题，如下：
RMAN> change archivelog all crosscheck;
released channel: ORA_DISK_1
released channel: ORA_DISK_2
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=43 device type=DISK
allocated channel: ORA_DISK_2
channel ORA_DISK_2: SID=45 device type=DISK
validation succeeded for archived log
archived log file name=/home/oracle/PROD/1_16_827176743.dbf RECID=1 STAMP=844399662
validation succeeded for archived log
archived log file name=/home/oracle/PROD/1_17_827176743.dbf RECID=2 STAMP=844460245
validation succeeded for archived log
archived log file name=/home/oracle/PROD/1_18_827176743.dbf RECID=3 STAMP=844461320
validation succeeded for archived log
archived log file name=/home/oracle/PROD/1_19_827176743.dbf RECID=4 STAMP=844461426
validation succeeded for archived log
archived log file name=/home/oracle/PROD/1_20_827176743.dbf RECID=5 STAMP=844461580
validation succeeded for archived log
archived log file name=/home/oracle/PROD/1_21_827176743.dbf RECID=6 STAMP=844461592
validation succeeded for archived log
archived log file name=/home/oracle/PROD/1_22_827176743.dbf RECID=7 STAMP=844461696
validation succeeded for archived log
archived log file name=/home/oracle/PROD/1_23_827176743.dbf RECID=8 STAMP=844462037
validation succeeded for archived log
archived log file name=/home/oracle/PROD/1_24_827176743.dbf RECID=9 STAMP=844462165
validation succeeded for archived log
archived log file name=/home/oracle/PROD/1_25_827176743.dbf RECID=10 STAMP=844462279
validation succeeded for archived log
archived log file name=/home/oracle/PROD/1_26_827176743.dbf RECID=11 STAMP=844462409
validation succeeded for archived log
archived log file name=/home/oracle/PROD/1_27_827176743.dbf RECID=12 STAMP=844465108
validation succeeded for archived log
archived log file name=/home/oracle/PROD/1_28_827176743.dbf RECID=13 STAMP=844469010
validation succeeded for archived log
archived log file name=/home/oracle/PROD/1_1_844532679.dbf RECID=16 STAMP=844533450
validation succeeded for archived log
archived log file name=/home/oracle/PROD/1_2_844532679.dbf RECID=19 STAMP=844537684
validation succeeded for archived log
archived log file name=/home/oracle/PROD/1_2_844532679.dbf RECID=17 STAMP=844533553
validation succeeded for archived log
archived log file name=/home/oracle/PROD/1_3_844532679.dbf RECID=20 STAMP=844537685
validation succeeded for archived log
archived log file name=/home/oracle/PROD/1_4_844532679.dbf RECID=18 STAMP=844537684
validation succeeded for archived log
archived log file name=/home/oracle/PROD/1_1_844537684.dbf RECID=23 STAMP=844605032
validation succeeded for archived log
archived log file name=/home/oracle/PROD/1_1_844537684.dbf RECID=21 STAMP=844575254
validation succeeded for archived log
archived log file name=/home/oracle/PROD/1_2_844537684.dbf RECID=24 STAMP=844605033
validation succeeded for archived log
archived log file name=/home/oracle/PROD/1_2_844537684.dbf RECID=22 STAMP=844581004
validation succeeded for archived log
archived log file name=/home/oracle/PROD/1_3_844537684.dbf RECID=25 STAMP=844605034
validation succeeded for archived log
archived log file name=/home/oracle/PROD/1_1_844469007.dbf RECID=14 STAMP=844530587
validation succeeded for archived log
archived log file name=/home/oracle/PROD/1_1_844605031.dbf RECID=26 STAMP=844670045
validation succeeded for archived log
archived log file name=/home/oracle/PROD/1_2_844605031.dbf RECID=27 STAMP=844797748
validation succeeded for archived log
archived log file name=/home/oracle/PROD/1_3_844605031.dbf RECID=28 STAMP=844841532
validation succeeded for archived log
archived log file name=/home/oracle/PROD/1_4_844605031.dbf RECID=29 STAMP=844847317
validation succeeded for archived log
archived log file name=/home/oracle/PROD/1_5_844605031.dbf RECID=30 STAMP=844855807
validation succeeded for archived log
archived log file name=/home/oracle/PROD/1_6_844605031.dbf RECID=31 STAMP=844855838
validation succeeded for archived log
archived log file name=/home/oracle/PROD/1_7_844605031.dbf RECID=32 STAMP=844886422
validation succeeded for archived log
archived log file name=/home/oracle/PROD/1_8_844605031.dbf RECID=33 STAMP=844886590
validation succeeded for archived log
archived log file name=/home/oracle/PROD/1_9_844605031.dbf RECID=34 STAMP=844886622
Crosschecked 33 objects
validation failed for archived log
archived log file name=/home/oracle/PROD/1_2_844469007.dbf RECID=15 STAMP=844530793
Crosschecked 1 objects
--再次执行archivelog的rman备份就成功了，如下：
RMAN> backup archivelog all delete input;
Starting backup at 14-APR-14
current log archived
using channel ORA_DISK_1
using channel ORA_DISK_2
channel ORA_DISK_1: starting compressed archived log backup set
channel ORA_DISK_1: specifying archived log(s) in backup set
input archived log thread=1 sequence=16 RECID=1 STAMP=844399662
input archived log thread=1 sequence=17 RECID=2 STAMP=844460245
input archived log thread=1 sequence=18 RECID=3 STAMP=844461320
channel ORA_DISK_1: starting piece 1 at 14-APR-14
channel ORA_DISK_2: starting compressed archived log backup set
channel ORA_DISK_2: specifying archived log(s) in backup set
input archived log thread=1 sequence=1 RECID=16 STAMP=844533450
channel ORA_DISK_2: starting piece 1 at 14-APR-14
channel ORA_DISK_2: finished piece 1 at 14-APR-14
piece handle=/home/oracle/backup/PROD_20140414_1bp5ntq0_1_1.bak tag=TAG20140414T190432 comment=NONE
channel ORA_DISK_2: backup set complete, elapsed time: 00:00:02
channel ORA_DISK_2: deleting archived log(s)
archived log file name=/home/oracle/PROD/1_1_844532679.dbf RECID=16 STAMP=844533450
channel ORA_DISK_2: starting compressed archived log backup set
channel ORA_DISK_2: specifying archived log(s) in backup set
input archived log thread=1 sequence=19 RECID=4 STAMP=844461426
input archived log thread=1 sequence=20 RECID=5 STAMP=844461580
input archived log thread=1 sequence=21 RECID=6 STAMP=844461592
input archived log thread=1 sequence=22 RECID=7 STAMP=844461696
input archived log thread=1 sequence=23 RECID=8 STAMP=844462037
input archived log thread=1 sequence=24 RECID=9 STAMP=844462165
input archived log thread=1 sequence=25 RECID=10 STAMP=844462279
channel ORA_DISK_2: starting piece 1 at 14-APR-14
channel ORA_DISK_1: finished piece 1 at 14-APR-14
piece handle=/home/oracle/backup/PROD_20140414_1ap5ntq0_1_1.bak tag=TAG20140414T190432 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:03
channel ORA_DISK_1: deleting archived log(s)
archived log file name=/home/oracle/PROD/1_16_827176743.dbf RECID=1 STAMP=844399662
archived log file name=/home/oracle/PROD/1_17_827176743.dbf RECID=2 STAMP=844460245
archived log file name=/home/oracle/PROD/1_18_827176743.dbf RECID=3 STAMP=844461320
channel ORA_DISK_1: starting compressed archived log backup set
channel ORA_DISK_1: specifying archived log(s) in backup set
input archived log thread=1 sequence=2 RECID=19 STAMP=844537684
input archived log thread=1 sequence=3 RECID=20 STAMP=844537685
channel ORA_DISK_1: starting piece 1 at 14-APR-14
channel ORA_DISK_2: finished piece 1 at 14-APR-14
piece handle=/home/oracle/backup/PROD_20140414_1cp5ntq3_1_1.bak tag=TAG20140414T190432 comment=NONE
channel ORA_DISK_2: backup set complete, elapsed time: 00:00:00
channel ORA_DISK_2: deleting archived log(s)
archived log file name=/home/oracle/PROD/1_19_827176743.dbf RECID=4 STAMP=844461426
archived log file name=/home/oracle/PROD/1_20_827176743.dbf RECID=5 STAMP=844461580
archived log file name=/home/oracle/PROD/1_21_827176743.dbf RECID=6 STAMP=844461592
archived log file name=/home/oracle/PROD/1_22_827176743.dbf RECID=7 STAMP=844461696
archived log file name=/home/oracle/PROD/1_23_827176743.dbf RECID=8 STAMP=844462037
archived log file name=/home/oracle/PROD/1_24_827176743.dbf RECID=9 STAMP=844462165
archived log file name=/home/oracle/PROD/1_25_827176743.dbf RECID=10 STAMP=844462279
channel ORA_DISK_2: starting compressed archived log backup set
channel ORA_DISK_2: specifying archived log(s) in backup set
input archived log thread=1 sequence=26 RECID=11 STAMP=844462409
input archived log thread=1 sequence=27 RECID=12 STAMP=844465108
channel ORA_DISK_2: starting piece 1 at 14-APR-14
channel ORA_DISK_1: finished piece 1 at 14-APR-14
piece handle=/home/oracle/backup/PROD_20140414_1dp5ntq3_1_1.bak tag=TAG20140414T190432 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:00
channel ORA_DISK_1: deleting archived log(s)
archived log file name=/home/oracle/PROD/1_2_844532679.dbf RECID=19 STAMP=844537684
archived log file name=/home/oracle/PROD/1_3_844532679.dbf RECID=20 STAMP=844537685
channel ORA_DISK_1: starting compressed archived log backup set
channel ORA_DISK_1: specifying archived log(s) in backup set
input archived log thread=1 sequence=4 RECID=18 STAMP=844537684
channel ORA_DISK_1: starting piece 1 at 14-APR-14
channel ORA_DISK_2: finished piece 1 at 14-APR-14
piece handle=/home/oracle/backup/PROD_20140414_1ep5ntq3_1_1.bak tag=TAG20140414T190432 comment=NONE
channel ORA_DISK_2: backup set complete, elapsed time: 00:00:01
channel ORA_DISK_2: deleting archived log(s)
archived log file name=/home/oracle/PROD/1_26_827176743.dbf RECID=11 STAMP=844462409
archived log file name=/home/oracle/PROD/1_27_827176743.dbf RECID=12 STAMP=844465108
channel ORA_DISK_2: starting compressed archived log backup set
channel ORA_DISK_2: specifying archived log(s) in backup set
input archived log thread=1 sequence=1 RECID=23 STAMP=844605032
channel ORA_DISK_2: starting piece 1 at 14-APR-14
channel ORA_DISK_1: finished piece 1 at 14-APR-14
piece handle=/home/oracle/backup/PROD_20140414_1fp5ntq4_1_1.bak tag=TAG20140414T190432 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:00
channel ORA_DISK_1: deleting archived log(s)
archived log file name=/home/oracle/PROD/1_4_844532679.dbf RECID=18 STAMP=844537684
channel ORA_DISK_1: starting compressed archived log backup set
channel ORA_DISK_1: specifying archived log(s) in backup set
input archived log thread=1 sequence=28 RECID=13 STAMP=844469010
channel ORA_DISK_1: starting piece 1 at 14-APR-14
channel ORA_DISK_1: finished piece 1 at 14-APR-14
piece handle=/home/oracle/backup/PROD_20140414_1hp5ntq4_1_1.bak tag=TAG20140414T190432 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:04
channel ORA_DISK_1: deleting archived log(s)
archived log file name=/home/oracle/PROD/1_28_827176743.dbf RECID=13 STAMP=844469010
channel ORA_DISK_1: starting compressed archived log backup set
channel ORA_DISK_1: specifying archived log(s) in backup set
input archived log thread=1 sequence=1 RECID=14 STAMP=844530587
channel ORA_DISK_1: starting piece 1 at 14-APR-14
channel ORA_DISK_2: finished piece 1 at 14-APR-14
piece handle=/home/oracle/backup/PROD_20140414_1gp5ntq4_1_1.bak tag=TAG20140414T190432 comment=NONE
channel ORA_DISK_2: backup set complete, elapsed time: 00:00:04
channel ORA_DISK_2: deleting archived log(s)
archived log file name=/home/oracle/PROD/1_1_844537684.dbf RECID=23 STAMP=844605032
channel ORA_DISK_2: starting compressed archived log backup set
channel ORA_DISK_2: specifying archived log(s) in backup set
input archived log thread=1 sequence=2 RECID=24 STAMP=844605033
input archived log thread=1 sequence=3 RECID=25 STAMP=844605034
channel ORA_DISK_2: starting piece 1 at 14-APR-14
channel ORA_DISK_1: finished piece 1 at 14-APR-14
piece handle=/home/oracle/backup/PROD_20140414_1ip5ntq8_1_1.bak tag=TAG20140414T190432 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:08
channel ORA_DISK_1: deleting archived log(s)
archived log file name=/home/oracle/PROD/1_1_844469007.dbf RECID=14 STAMP=844530587
channel ORA_DISK_1: starting compressed archived log backup set
channel ORA_DISK_1: specifying archived log(s) in backup set
input archived log thread=1 sequence=1 RECID=26 STAMP=844670045
input archived log thread=1 sequence=2 RECID=27 STAMP=844797748
input archived log thread=1 sequence=3 RECID=28 STAMP=844841532
channel ORA_DISK_1: starting piece 1 at 14-APR-14
channel ORA_DISK_2: finished piece 1 at 14-APR-14
piece handle=/home/oracle/backup/PROD_20140414_1jp5ntq8_1_1.bak tag=TAG20140414T190432 comment=NONE
channel ORA_DISK_2: backup set complete, elapsed time: 00:00:07
channel ORA_DISK_2: deleting archived log(s)
archived log file name=/home/oracle/PROD/1_2_844537684.dbf RECID=24 STAMP=844605033
archived log file name=/home/oracle/PROD/1_3_844537684.dbf RECID=25 STAMP=844605034
channel ORA_DISK_2: starting compressed archived log backup set
channel ORA_DISK_2: specifying archived log(s) in backup set
input archived log thread=1 sequence=4 RECID=29 STAMP=844847317
input archived log thread=1 sequence=5 RECID=30 STAMP=844855807
input archived log thread=1 sequence=6 RECID=31 STAMP=844855838
input archived log thread=1 sequence=7 RECID=32 STAMP=844886422
input archived log thread=1 sequence=8 RECID=33 STAMP=844886590
input archived log thread=1 sequence=9 RECID=34 STAMP=844886622
input archived log thread=1 sequence=10 RECID=35 STAMP=844887872
channel ORA_DISK_2: starting piece 1 at 14-APR-14
channel ORA_DISK_1: finished piece 1 at 14-APR-14
piece handle=/home/oracle/backup/PROD_20140414_1kp5ntqg_1_1.bak tag=TAG20140414T190432 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:16
channel ORA_DISK_1: deleting archived log(s)
archived log file name=/home/oracle/PROD/1_1_844605031.dbf RECID=26 STAMP=844670045
archived log file name=/home/oracle/PROD/1_2_844605031.dbf RECID=27 STAMP=844797748
archived log file name=/home/oracle/PROD/1_3_844605031.dbf RECID=28 STAMP=844841532
channel ORA_DISK_2: finished piece 1 at 14-APR-14
piece handle=/home/oracle/backup/PROD_20140414_1lp5ntqh_1_1.bak tag=TAG20140414T190432 comment=NONE
channel ORA_DISK_2: backup set complete, elapsed time: 00:00:15
channel ORA_DISK_2: deleting archived log(s)
archived log file name=/home/oracle/PROD/1_4_844605031.dbf RECID=29 STAMP=844847317
archived log file name=/home/oracle/PROD/1_5_844605031.dbf RECID=30 STAMP=844855807
archived log file name=/home/oracle/PROD/1_6_844605031.dbf RECID=31 STAMP=844855838
archived log file name=/home/oracle/PROD/1_7_844605031.dbf RECID=32 STAMP=844886422
archived log file name=/home/oracle/PROD/1_8_844605031.dbf RECID=33 STAMP=844886590
archived log file name=/home/oracle/PROD/1_9_844605031.dbf RECID=34 STAMP=844886622
archived log file name=/home/oracle/PROD/1_10_844605031.dbf RECID=35 STAMP=844887872
Finished backup at 14-APR-14
Starting Control File Autobackup at 14-APR-14
piece handle=/home/oracle/backup/control/c-239015079-20140414-0d comment=NONE
Finished Control File Autobackup at 14-APR-14
注意：
crosscheck archivelog all： 当手工删除了数据库的归档文件后，需要用这个命令进行同步。 （物理上删除了归档日志，但是控制文件并不知道；因此需要交叉检验以同步信息） 
CROSSCHECK BACKUP： 当手工删除了RMAN的备份级时，需要使用的是这个命令：
他们的区别是同步的内容不同，一个是同步归档文件的状态，一个是同步RMAN备份信息。

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/21251711/viewspace-1167980/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/21251711/viewspace-1167980/

crbzijz188696507
关注
  • 0
    点赞
  • 踩
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
备份归档日志报错 ORA-19625 的解决办法
milia_mxj
08-22 2639
今天在备份归档日志的时候，出错了，发现是由于备份的目录改变了RMAN> backup archivelog all delete input; --备份默认目录下所有归档日志，并且删除这个目录下所有归档日志Starting backup at 21-AUG-08current log archivedusing channel ORA_DISK_1RMAN-00571: =========
[重庆思庄每日技术分享]-使用RMAN活动复制数据库时出现报错Ora-19625
XIANHUAFANG的博客
01-25 1238
在通过RMAN活动复制数据库时，出现这样的报错： RMAN-03002: failure of Duplicate Db command at 05/23/2021 14:54:54 RMAN-03015: error occurred in stored script Memory Script ORA-19625: error identifying file //system01.dbf ORA-27037: unable to obtain file status SVR4 Error:
Recover Database Fails with RMAN-06558 [ID 1185074.1]
05-22 501
Recover Database Fails with RMAN-06558 [ID 1185074.1]In this Document Symptoms Changes Cause Sol...
Oracle在Rman备份模式下误删归档日志文件解决方法
annicybc的专栏
08-04 4103
问题来源：在使用rman备份策略的数据库中，由于不小心删除了数据库的归档日志文件，导致rman备份的时候报错不能正常进行归档日志的备份工作，但是删除的归档日志已经不在需要使用。但是没有办法跳过没有用的已经删除的归档日志。报错内容：RMAN-00571: ===========================================================RMAN-00569:
ORA-00257Oracle释放archivelog空间.doc
11-25
这个步骤需要登录RMAN（Recovery Manager），然后执行crosscheck archivelog all;命令，以将已删除的日志文件标识成 expired。然后，执行delete expired archivelog all;命令，以释放逻辑空间。 在释放archivelog...
ORA-00257错误.doc
03-04
处理 ORA-00257 错误的思路是：删除物理文件和登录 RMAN 释放 archivelog 空间。下面是详细的处理过程： 1. 删除物理文件 首先，我们需要登录到 Oracle 服务器，使用 su 命令切换到 Oracle 用户，然后使用 sqlplus...
oracle 回闪日志 满了 ORA-03113 通信信道结束 进入 rman 删除日志
06-20
ORA-03113是一个常见的Oracle错误代码，通常出现在尝试通过网络连接到数据库服务器时出现通信问题。这个错误可能是由于网络配置不正确、网络故障或数据库服务未启动等原因导致的。 **2. 解决ORA-03113错误的方法** ...
ORA-00257归档日志清理问题
12-14
7. **监控与预警**：设置数据库监控，当归档日志空间接近上限时，及时收到警告，从而提前进行清理或扩展存储空间，避免出现“ORA-00257”这样的紧急情况。 8. **数据库配置优化**：考虑调整参数`LOG_ARCHIVE_DEST_n...
Oracle归档日志写满(ora-00257)了怎么办
12-16
### Oracle归档日志写满(ora-00257)解决办法 #### 问题背景 在Oracle数据库管理过程中，经常会遇到ORA-00257错误：“archiver error. Connect internal only, until freed”。这通常是因为归档日志空间不足导致的，...
oracle技术之一次RMAN备份报错的诊断过程（一）
weixin_34018169的博客
05-23 320
今天检查数据库中的备份输出脚本时，发现RMAN备份出现了错误。这一篇主要描述问题的现象。错误信息如下：bash-3.00$ more /data/backup/backup_tradedb_090523.outScript. /data/backup/backup_tradedb.sh==== started on Sat May 23 23:00:00 CST 2009 =...
归档日志文件异常
cuiding4761的博客
12-03 183
在生产环境下，oracle数据库如果处于archivelog mode（归档模式），就会不断地产生归档日志，因此有可能会产生ORA-00257错误。原因是档日志文件太多造成磁盘或者设备空间不足。 ORA-00257 a...
Oerr--解决在备份时出现的ORA-230
cuifan5176的博客
07-19 426
今天在备份时再次遇到ORA-230，在不久前遇到过，当时还想着帖上解决过程的呢。今天遇到时，都有点不记得了。帖上过程方便以后需要时参考(相关信息来自metalink)备份时的出错信息的片段如下：validation succee...
如何删除归档日志文件[转]
abc123098098的博客
09-21 156
我们都都知道在controlfile中记录着每一个archivelog的相关信息，当然们在OS下把这些物理文件delete掉后，在我们的 controlfile中仍然记录着这些archivelog的信息，在oracle的OEM管理器中有可视化的日志展现出，当我们手工清除archive目录下的文件后，这些记录并没有被我们从controlfile中清除掉，也就是oracle并不知道这些文件已...
Oracle DataGuard备机出现ORA-00600 [2619]错误的处理思路
还不算晕的专栏
04-15 1371
晚上接到用户电话，DG备机报错无法正常同步。ORA-00600: internal error code, arguments: [2619], [84747]，了解到之前出现磁盘空间满，已经人为删除处理过；这是一个典型的DG空间满后的问题，官方文档ORA-600[2619] During Physical Standby Recovery (Doc ID 1138913.1)对此有说明；总结理解一下，问题原因为磁盘空间满，导致归档日志未完全写入而出现损失，DG备机的MRP进程无法使用此归档日志。了解了原理
oracle查询失效归档,Rman Crosscheck删除失效归档
weixin_30744613的博客
04-05 643
Rman Crosscheck删除失效归档$ rman target /Recovery Manager: Release 9.2.0.4.0 - 64bit ProductionCopyright (c) 1995, 2002, Oracle Corporation. All rights reserved.connected to target database: AVATAR2 (DBID...
archivelogs文件清理及使用失效归档的删除
tao19910610的博客
09-25 4112
Oracle在开启了归档模式后，会在指定的archive目录下产生很多的archivelog文件，而且默认是不会定期清除的，时间长久了，该文件夹会占用很大的空间。 问题：如何定期正确删除archivelog文件呢？ 很多人直接在archive目录下删除文件，这样其实不能达到在Oracle CLF文件中删除文件记录的效果。 正确方法： 1.用RMAN连接目标DB：在命令行界面输入以下命令 R
Rman Crosscheck删除失效归档
cl2516的博客
07-06 188
当手工删除了归档日志以后，Rman备份会检测到日志缺失，从而无法进一步继续执行。所以此时需要手工执行crosscheck过程，之后Rman备份可以恢复正常。1.Crosscheck日志$ rman target / Recov...
rman使用crosscheck archivelog all命令时验证归档日志失败
热门推荐
yuzhenhuan01的专栏
01-29 1万+
问题描述： Microsoft Windows XP [版本 5.1.2600] (C) 版权所有 1985-2001 Microsoft Corp. C:/Documents and Settings/zhenhuan_yu>rman target / 恢复管理器: Release 10.2.0.1.0 - Production on 星期五 1月 29 11:03:09 2010 ...
ORACLE中使用RAMA删除部分日志
Internetroot的专栏
01-20 523
1.登陆RAMA并查看相关日志文件 rman connect target sys/oracle list archivelog all [oracle@oracledb ~]$ rman Recovery Manager: Release 11.2.0.4.0 - Production on Fri Jan 20 07:05:17 2017 Copyright (c) 198
解决ORA-00257
最新发布
08-27
ORA-00257错误是由于Oracle数据库的归档日志满了导致的。要解决这个问题，可以采取以下几个步骤： 1. 首先，确认归档日志的使用情况。你可以通过查询v$flash_recovery_area_usage视图来获取有关归档日志使用情况的信息。如果归档日志的使用量超过了可用空间的80%，则需要清理归档日志。 2. 清理归档日志。你可以使用RMAN工具或者手动删除过期的归档日志来释放空间。如果使用RMAN，可以运行以下命令：DELETE ARCHIVELOG UNTIL TIME 'sysdate-7' BACKED UP 1 TIMES TO DISK; 这个命令将删除一周前的已备份的归档日志。如果你使用手动删除归档日志，请确保你备份了这些归档日志，并且在删除之前先将它们标记为已备份。 3. 增加归档日志的存储空间。如果你发现归档日志频繁满了，可以考虑增加归档日志的存储空间。你可以通过修改参数LOG_ARCHIVE_DEST_n来指定归档日志的存储位置，或者增加归档日志的存储空间。 总结起来，解决ORA-00257错误的步骤包括确认归档日志的使用情况，清理过期的归档日志以释放空间，并且可以考虑增加归档日志的存储空间。<span class="em">1</span><span class="em">2</span><span class="em">3</span> #### 引用[.reference_title] - *1* [Oracle归档日志写满(ora-00257)了怎么办](https://download.csdn.net/download/weixin_38710781/12830263)[target="_blank" data-report-click={"spm":"1018.2226.3001.9630","extra":{"utm_source":"vip_chatgpt_common_search_pc_result","utm_medium":"distribute.pc_search_result.none-task-cask-2~all~insert_cask~default-1-null.142^v93^chatsearchT3_2"}}] [.reference_item style="max-width: 33.333333333333336%"] - *2* [ORA-00257: 归档程序错误 Oracle归档报错处理方式](https://blog.csdn.net/zl61347338/article/details/123202527)[target="_blank" data-report-click={"spm":"1018.2226.3001.9630","extra":{"utm_source":"vip_chatgpt_common_search_pc_result","utm_medium":"distribute.pc_search_result.none-task-cask-2~all~insert_cask~default-1-null.142^v93^chatsearchT3_2"}}] [.reference_item style="max-width: 33.333333333333336%"] - *3* [ORA-00257: Archiver error. Connect AS SYSDBA only until resolved错误解决](https://blog.csdn.net/Paulangsky/article/details/127518046)[target="_blank" data-report-click={"spm":"1018.2226.3001.9630","extra":{"utm_source":"vip_chatgpt_common_search_pc_result","utm_medium":"distribute.pc_search_result.none-task-cask-2~all~insert_cask~default-1-null.142^v93^chatsearchT3_2"}}] [.reference_item style="max-width: 33.333333333333336%"] [ .reference_list ]
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值