当前位置：网站首页>RMAN abnormal machine recovery error rman-06026 rman-06023

RMAN abnormal machine recovery error rman-06026 rman-06023

2022-07-19 12:06:00 【51CTO】

database ：oracle 11.2.0.4

System ：Centos 7.9

Description of the exception ：rman When the other machine recovers , Report errors RMAN-06026、RMAN-06023, As shown below ：

       
       RMAN> run{ 
       
2> set newname for datafile '+DATA/orcl/datafile/system.256.1107818145' to '/data/orcl/system.256.1107818145'; 
       
3> set newname for datafile '+DATA/orcl/datafile/undotbs2.267.1107818231' to '/data/orcl/undotbs2.267.1107818231'; 
       
4> set newname for datafile '+DATA/orcl/datafile/system.319.1110101255' to '/data/orcl/system.319.1110101255'; 
       
5> set newname for datafile '+DATA/orcl/datafile/sysaux.257.1107818147' to '/data/orcl/sysaux.257.1107818147';  
       
6> set newname for datafile '+DATA/orcl/datafile/undotbs1.258.1107818147' to '/data/orcl/undotbs1.258.1107818147';
       
7> set newname for datafile '+DATA/orcl/datafile/users.259.1107818147' to '/data/orcl/users.259.1107818147';
       
8> restore database; 
       
9> }
       
executing command: SET NEWNAME
       
executing command: SET NEWNAME
       
executing command: SET NEWNAME 
       
executing command: SET NEWNAME
       
executing command: SET NEWNAME
       
executing command: SET NEWNAME
       
Starting restore at 17-JUL-22
       
using channel ORA_DISK_1
       
RMAN-00571: ===========================================================
       
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
       
RMAN-00571: ===========================================================
       
RMAN-03002: failure of restore command at 07/17/2022 00:44: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
      
1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
11.
12.
13.
14.
15.
16.
17.
18.
19.
20.
21.
22.
23.
24.

Show no backup files found , Check datafile 2 and datafile 3 Backup files for .

       
       RMAN> list backup of datafile 3;
       
List of Backup Sets
       
===================
       
BS Key  Type LV Size       Device Type Elapsed Time Completion Time
       
------- ---- -- ---------- ----------- ------------ ---------------
       
13      Full   407.97M    DISK        00:00:00     15-JUL-22      
       
        BP Key: 13   Status: AVAILABLE  Compressed: NO  Tag: TAG20220715T094249
       
        Piece Name:/home/oracle/backupset/data_0212lk4p_1_1.bak
       
  List of Datafiles in backup set 13
       
  File LV Type Ckp SCN    Ckp Time Name
       
  ---- -- ---- ---------- --------- ----
       
  3      Full 1209511    15-JUL-22 +DATA/orcl/datafile/undotbs1.258.1107818147
       
RMAN> list backup of datafile 2;
       
List of Backup Sets
       
===================
       
BS Key  Type LV Size       Device Type Elapsed Time Completion Time
       
------- ---- -- ---------- ----------- ------------ ---------------
       
13      Full   407.97M    DISK        00:00:00     15-JUL-22      
       
        BP Key: 13   Status: AVAILABLE  Compressed: NO  Tag: TAG20220715T094249
       
        Piece Name:/home/oracle/backupset/data_0212lk4p_1_1.bak
       
  List of Datafiles in backup set 13
       
  File LV Type Ckp SCN    Ckp Time Name
       
  ---- -- ---- ---------- --------- ----
       
  2      Full 1209511    15-JUL-22 +DATA/orcl/datafile/sysaux.257.1107818147
      
1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
11.
12.
13.
14.
15.
16.
17.
18.
19.
20.
21.
22.
23.
24.
25.
26.
27.
28.
29.
30.
31.

Conclusion ： Show datafile 2 and datafile 3 All backups of are valid .

View the target library incarnatioin Record ：

       
       RMAN> list incarnation;
       
List of Database Incarnations
       
DB Key  Inc Key DB Name  DB ID            STATUS  Reset SCN  Reset Time
       
------- ------- -------- ---------------- --- ---------- ----------
       
     1      ORCL     1635598952       PARENT  1          24-AUG-13
       
     2      ORCL     1635598952       PARENT  925702     19-JUN-22
       
     3      ORCL     1635598952       CURRENT 1209510    16-JUL-22
      








Source library view incarnatioin Record ：

       
       RMAN> list incarnation;
       
using target database control file instead of recovery catalog
       
List of Database Incarnations
       
DB Key  Inc Key DB Name  DB ID            STATUS  Reset SCN 
       
Reset Time
       
------- ------- -------- ---------------- --- ---------- ----------
       
1       1      ORCL     1635598952       PARENT  1          24-AUG-13
       
2       2      ORCL     1635598952       CURRENT 925702     19-JUN-22
      
1.
2.
3.
4.
5.
6.
7.
8.
9.

explain ： The source library shows only two reset scn Record , The target library control file is restored from the source library , But it shows that there are three records .

Solution ：

Reset the target library to incarnation 2.

       
       RMAN>reset database to incarnation 2;
       
database reset to incarnation 2
       
RMAN>run{ 
       
2> set newname for  datafile '+DATA/orcl/datafile/system.256.1107818145' to '/data/orcl/system.256.1107818145'; 
       
3> set newname for  datafile '+DATA/orcl/datafile/undotbs2.267.1107818231' to '/data/orcl/undotbs2.267.1107818231'; 
       
4> set newname for  datafile '+DATA/orcl/datafile/system.319.1110101255' to '/data/orcl/system.319.1110101255'; 
       
5> set newname for  datafile '+DATA/orcl/datafile/sysaux.257.1107818147' to '/data/orcl/sysaux.257.1107818147';  
       
6> set newname for  datafile '+DATA/orcl/datafile/undotbs1.258.1107818147' to '/data/orcl/undotbs1.258.1107818147';
       
7> set newname for  datafile '+DATA/orcl/datafile/users.259.1107818147' to '/data/orcl/users.259.1107818147';
       
8> restore database; 
       
9> }
       
executing command: SET NEWNAME
       
executing command: SET NEWNAME
       
executing command: SET NEWNAME
       
executing command: SET NEWNAME
       
executing command: SET NEWNAME
       
executing command: SET NEWNAME
       
Starting restore at 17-JUL-22 using channel ORA_DISK_1
       
channel ORA_DISK_1: starting datafile backup set restore
       
channel ORA_DISK_1: specifying datafile(s) to restore from backup set
       
channel ORA_DISK_1: restoring datafile 00001 to /data/orcl/system.256.1107818145
       
channel ORA_DISK_1: restoring datafile 00004 to /data/orcl/users.259.1107818147
       
channel ORA_DISK_1: restoring datafile 00006 to /data/orcl/system.319.1110101255
       
channel ORA_DISK_1: reading from backup piece /home/oracle/backupset/data_0112lk4p_1_1.bak
       
channel ORA_DISK_1: piece handle=/home/oracle/backupset/data_0112lk4p_1_1.bak tag=TAG20220715T094249
       
channel ORA_DISK_1: restored backup piece 1
       
channel ORA_DISK_1: restore complete, elapsed time: 00:00:25
       
channel ORA_DISK_1: starting datafile backup set restore
       
channel ORA_DISK_1: specifying datafile(s) to restore from backup set
       
channel ORA_DISK_1: restoring datafile 00002 to /data/orcl/sysaux.257.1107818147
       
channel ORA_DISK_1: restoring datafile 00003 to /data/orcl/undotbs1.258.1107818147
       
channel ORA_DISK_1: restoring datafile 00005 to /data/orcl/undotbs2.267.1107818231
       
channel ORA_DISK_1: reading from backup piece /home/oracle/backupset/data_0212lk4p_1_1.bak
       
channel ORA_DISK_1: piece handle=/home/oracle/backupset/data_0212lk4p_1_1.bak tag=TAG20220715T094249
       
channel ORA_DISK_1: restored backup piece 1
       
channel ORA_DISK_1: restore complete, elapsed time: 00:00:25
       
Finished restore at 17-JUL-22
      
1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
11.
12.
13.
14.
15.
16.
17.
18.
19.
20.
21.
22.
23.
24.
25.
26.
27.
28.
29.
30.
31.
32.
33.
34.
35.
36.
37.