昨天做一个实验，结果把数据库搞坏了，当试图进行恢复时居然报了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: TAG20050609T173346
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.dbf
RMAN exit
Recovery Manager complete.
2.使用dbms_backup_restore进行恢复
dbms_backup_restore是一个非常强大的package，可以在数据库nomount下使用，用于从备份集中读取各类文件。
本例使用如下脚本:
DECLARE
devtype varchar2(256);
done boolean;
BEGIN
devtype:=sys.dbms_backup_restore.deviceAllocate (type='',ident='t1');
sys.dbms_backup_restore.restoreSetDatafile;
sys.dbms_backup_restore.restoreDatafileTo(dfnumber=01,toname='/opt/oracle/oradata/conner/system01.dbf');
sys.dbms_backup_restore.restoreDatafileTo(dfnumber=02,toname='/opt/oracle/oradata/conner/undotbs01.dbf');
sys.dbms_backup_restore.restoreDatafileTo(dfnumber=03,toname='/opt/oracle/oradata/conner/users01.dbf');
sys.dbms_backup_restore.restoreBackupPiece(done=done,handle='/opt/oracle/product/9.2.0/dbs/0ggmiabq_1_1', params=null);
sys.dbms_backup_restore.deviceDeallocate;
END;
/
3.执行恢复
[oracle@jumper conner]$ sqlplus "/ as sysdba"
SQL*Plus: Release 9.2.0.4.0 - Production on Sat Jun 11 01:24:34 2005
Copyright (c) 1982, 2002, Oracle Corporation.
All rights reserved.
Connected to an idle instance.
SQL startup nomount;
ORACLE instance started.
Total System Global Area
101782828 bytes
Fixed Size
451884 bytes
Variable Size
37748736 bytes
Database Buffers
62914560 bytes
Redo Buffers
667648 bytes
SQL DECLARE
2
devtype varchar2(256);
3
done boolean;
4
BEGIN
5
devtype:=sys.dbms_backup_restore.deviceAllocate (type='',ident='t1');
6
sys.dbms_backup_restore.restoreSetDatafile;
7
sys.dbms_backup_restore.restoreDatafileTo(dfnumber=01,toname='/opt/oracle/oradata/conner/system01.dbf');
8
sys.dbms_backup_restore.restoreDatafileTo(dfnumber=02,toname='/opt/oracle/oradata/conner/undotbs01.dbf');
9
sys.dbms_backup_restore.restoreDatafileTo(dfnumber=03,toname='/opt/oracle/oradata/conner/users01.dbf');
10
sys.dbms_backup_restore.restoreBackupPiece(done=done,handle='/opt/oracle/product/9.2.0/dbs/0ggmiabq_1_1',
params=null);
11
sys.dbms_backup_restore.deviceDeallocate;
12
END;
13
/
PL/SQL procedure successfully completed.
SQL
至此，从备份集中读取文件完毕。
4.恢复控制文件
由于大意，也没有备份控制文件，所以只好重建控制文件。
SQL alter database mount;
Database altered.
SQL alter database backup controlfile to trace;
Database altered.
找到trace文件，编辑、执行重建控制文件需要部分:
[oracle@jumper oracle]$ sqlplus "/ as sysdba"
SQL*Plus: Release 9.2.0.4.0 - Production on Sat Jun 11 01:30:50 2005
Copyright (c) 1982, 2002, Oracle Corporation.
All rights reserved.
Connected to:
Oracle9i Enterprise Edition Release 9.2.0.4.0 - Production
With the Partitioning option
JServer Release 9.2.0.4.0 - Production
SQL shutdown immediate;
ORA-01109: database not open
Database dismounted.
ORACLE instance shut down.
SQL startup nomount;
ORACLE instance started.
Total System Global Area
101782828 bytes
Fixed Size
451884 bytes
Variable Size
37748736 bytes
Database Buffers
62914560 bytes
Redo Buffers
667648 bytes
SQL set echo on
SQL @ctl
SQL
SQL CREATE CONTROLFILE REUSE DATABASE "CONNER" RESETLOGS
ARCHIVELOG
2
--
SET STANDBY TO MAXIMIZE PERFORMANCE
3
MAXLOGFILES 5
4
MAXLOGMEMBERS 3
5
MAXDATAFILES 100
6
MAXINSTANCES 1
7
MAXLOGHISTORY 1361
8
LOGFILE
9
GROUP 1 '/opt/oracle/oradata/conner/redo01.log'
SIZE 10M,
10
GROUP 2 '/opt/oracle/oradata/conner/redo02.log'
SIZE 10M,
11
GROUP 3 '/opt/oracle/oradata/conner/redo03.log'
SIZE 10M
12
-- STANDBY LOGFILE
13
DATAFILE
14
'/opt/oracle/oradata/conner/system01.dbf',
15
'/opt/oracle/oradata/conner/undotbs01.dbf',
16
'/opt/oracle/oradata/conner/users01.dbf'
17
CHARACTER SET ZHS16GBK
18
;
Control file created.
5.执行恢复
SQL recover database;
ORA-00283: recovery session canceled due to errors
ORA-01610: recovery using the BACKUP CONTROLFILE option must be done
SQL recover database using backup controlfile until cancel;
ORA-00279: change 240560269 generated at 06/09/2005 17:33:48 needed for thread 1
ORA-00289: suggestion : /opt/oracle/oradata/conner/archive/1_7.dbf
ORA-00280: change 240560269 for thread 1 is in sequence #7
Specify log: {=suggested | filename | AUTO | CANCEL}
auto
ORA-00279: change 240600632 generated at 06/10/2005 10:42:26 needed for thread 1
ORA-00289: suggestion : /opt/oracle/oradata/conner/archive/1_8.dbf
ORA-00280: change 240600632 for thread 1 is in sequence #8
ORA-00278: log file '/opt/oracle/oradata/conner/archive/1_7.dbf' no longer needed for this recovery
Specify log: {=suggested | filename | AUTO | CANCEL}
auto
ORA-00279: change 240620884 generated at 06/10/2005 10:45:42 needed for thread 1
ORA-00289: suggestion : /opt/oracle/oradata/conner/archive/1_9.dbf
ORA-00280: change 240620884 for thread 1 is in sequence #9
ORA-00278: log file '/opt/oracle/oradata/conner/archive/1_8.dbf' no longer needed for this recovery
ORA-00283: recovery session canceled due to errors
ORA-00600: internal error code, arguments: [3020], [4242465], [1], [9], [314], [272], [], []
ORA-10567: Redo is inconsistent with data block (file# 1, block# 48161)
ORA-10564: tablespace SYSTEM
ORA-01110: data file 1: '/opt/oracle/oradata/conner/system01.dbf'
ORA-10560: block type 'DATA SEGMENT HEADER - UNLIMITED'
ORA-01112: media recovery not started
SQL recover database using backup controlfile until cancel;
ORA-00279: change 240620949 generated at 06/10/2005 10:45:44 needed for thread 1
ORA-00289: suggestion : /opt/oracle/oradata/conner/archive/1_9.dbf
ORA-00280: change 240620949 for thread 1 is in sequence #9
Specify log: {=suggested | filename | AUTO | CANCEL}
cancel
Media recovery cancelled.
SQL alter database open resetlogs;
Database altered.
SQL select name from v$datafile;
NAME
------------------------------------------------------------
/opt/oracle/oradata/conner/system01.dbf
/opt/oracle/oradata/conner/undotbs01.dbf
/opt/oracle/oradata/conner/users01.dbf
SQL
至此恢复完毕。
