文档详情

应对RMAN-06026错误,使用DBMS_BACKUP_RESTORE进行恢复.doc

发布:2017-08-06约7.99千字共12页下载文档
文本预览下载声明
昨天做一个实验,结果把数据库搞坏了,当试图进行恢复时居然报了RMAN-06026错误。 回想一下,原来在尝试恢复中使用了_allow_resetlogs_corruption参数,resetlogs之后,Oracle使用当前的控制文件不允许从这个历史备份集中进行恢复。   由于我没有使用catalog,所以尝试使用dbms_backup_restore进行恢复。   1.错误信息   我们看到虽然list backup可以显示备份集,但是无法进行恢复,错误为RMAN-06026,RMAN-06026。   [oracle@jumper oradata]$ rman target /   Recovery Manager: Release 9.2.0.4.0 - Production   Copyright (c) 1995, 2002, Oracle Corporation.   All rights reserved.   connected to target database: CONNER (DBID=3152029224)   RMAN restore database;   Starting restore at 11-JUN-05   using target database controlfile instead of recovery catalog   allocated channel: ORA_DISK_1   channel ORA_DISK_1: sid=11 devtype=DISK   RMAN-00571: ===========================================================   RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============   RMAN-00571: ===========================================================   RMAN-03002: failure of restore command at 06/11/2005 01:19:01   RMAN-06026: some targets not found - aborting restore   RMAN-06023: no backup or copy of datafile 3 found to restore   RMAN-06023: no backup or copy of datafile 2 found to restore   RMAN-06023: no backup or copy of datafile 1 found to restore   RMAN list backup;   List of Backup Sets   ===================   BS Key   Type LV Size   Device Type Elapsed Time Completion Time   ------- ---- -- ---------- ----------- ------------ ---------------   13   Full   1G   DISK   00:03:20   09-JUN-05   BP Key: 13   Status: AVAILABLE   Tag: TA173346   Piece Name: /opt/oracle/product/9.2.0/dbs/0ggmiabq_1_1   SPFILE Included: Modification time: 08-JUN-05   List of Datafiles in backup set 13   File LV Type Ckp SCN   Ckp Time   Name   ---- -- ---- ---------- --------- ----   1   Full 240560269   09-JUN-05 /opt/oracle/oradata/conner/system01.dbf   2   Full 240560269   09-JUN-05 /opt/oracle/oradata/conner/undotbs01.dbf   3   Full 240560269   09-JUN-05 /opt/oracle/oradata/conner/users01.d
显示全部
相似文档