生产库恢复目录出现的问题如下:
由于通过生产库的RMAN备份恢复一个生产库的副本时,在恢复归档日志时使用了生产库的Catalog库,导致生产库的归档日志备份失败。
备份信息如下:
=========================================
恢复管理器: Release 10.2.0.4.0 - Production on 星期四 10月 22 00:17:19 2009
Copyright (c) 1982, 2007, Oracle. All rights reserved.
连接到目标数据库: YWZKR (DBID=734179557)
连接到恢复目录数据库
RMAN> run {
2> allocate channel ch1 type disk maxpiecesize=2G;
3> allocate channel ch2 type disk maxpiecesize=2G;
4> sql 'alter system archive log current';
5> backup archivelog all delete input tag=ywzkr_arch
6> format
6> '/ywzkr_arch/dbbackup/rmanbackup/yw_arch_work/YW_ARCH_%Y_%M_%D/arch_%
6> d_%t_%s_%p.bkp';
7> release channel ch1;
8> release channel ch2;
9> }
10>
分配的通道: ch1
通道 ch1: sid=766 devtype=DISK
分配的通道: ch2
通道 ch2: sid=638 devtype=DISK
sql 语句: alter system archive log current
启动 backup 于 2009-10-22 00:17:23
当前日志已存档
释放的通道: ch1
释放的通道: ch2
MAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: backup 命令 (在 10/22/2009 00:17:26 上) 失败
RMAN-06059: 没有找到预期的归档日志, 归档日志的丢失将影响可恢复性
ORA-19625: 识别文件/image/oraywzkr/archive/arch_2bc2b0e5_1_684411423_2666.log时出错
ORA-27037: 无法获得文件状态
HPUX-ia64 Error: 2: No such file or directory Additional information: 3
恢复管理器完成。
==========================================================
其中/image/oraywzkr/archive/ 目录不是生产库的路径,是我们创建的恢复库的路径信息。
解决办法:
1.crosscheck the archivelog.
RMAN>crosscheck archivelog all;
2.List archived log.
RMAN>list archivelog all;
3. Delete expired archivelog.
RMAN>delete expired archivelog all;
4. List backup of archivelog .
RMAN>list backup of archivelog all;
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/11411056/viewspace-734426/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/11411056/viewspace-734426/