rman incranation

admin

1. 
   
2. RMAN> restore database;
   
3. 
   
4. Starting restore at 25-OCT-21
   
5. allocated channel: ORA_DISK_1
   
6. channel ORA_DISK_1: SID=252 device type=DISK
   
7. 
   
8. RMAN-00571: ===========================================================
   
9. RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
   
10. RMAN-00571: ===========================================================
    
11. RMAN-03002: failure of restore command at 10/25/2021 15:49:58
    
12. RMAN-06026: some targets not found - aborting restore
    
13. RMAN-06023: no backup or copy of datafile 7 found to restore
    
14. RMAN-06023: no backup or copy of datafile 4 found to restore
    
15. RMAN-06023: no backup or copy of datafile 3 found to restore
    
16. RMAN-06023: no backup or copy of datafile 1 found to restore
    
17. 
    
18. RMAN> exit

复制代码

1. RMAN> list incarnation;
   
2. 
   
3. using target database control file instead of recovery catalog
   
4. 
   
5. List of Database Incarnations
   
6. DB Key  Inc Key DB Name  DB ID            STATUS  Reset SCN  Reset Time
   
7. ------- ------- -------- ---------------- --- ---------- ----------
   
8. 1       1       ORCL     1609771683       PARENT  1          26-JAN-17
   
9. 2       2       ORCL     1609771683       PARENT  1408558    31-AUG-21
   
10. 3       3       ORCL     1609771683       CURRENT 6766564    19-OCT-21
    

复制代码

1. RMAN> reset database to incarnation 2;
   
2. 
   
3. database reset to incarnation 2
   
4. 
   
5. RMAN> restore database;
   
6. 
   
7. Starting restore at 25-OCT-21
   
8. allocated channel: ORA_DISK_1
   
9. channel ORA_DISK_1: SID=253 device type=DISK
   
10. 
    
11. channel ORA_DISK_1: starting datafile backup set restore
    
12. channel ORA_DISK_1: specifying datafile(s) to restore from backup set
    
13. channel ORA_DISK_1: restoring datafile 00001 to /app/oracle/db/oradata/orcl/system01.dbf
    
14. channel ORA_DISK_1: restoring datafile 00002 to /app/oracle/db/oradata/orcl/zhyu101.dbf
    
15. channel ORA_DISK_1: restoring datafile 00003 to /app/oracle/db/oradata/orcl/sysaux01.dbf
    
16. channel ORA_DISK_1: restoring datafile 00004 to /app/oracle/db/oradata/orcl/undotbs01.dbf
    
17. channel ORA_DISK_1: restoring datafile 00005 to /app/oracle/db/oradata/orcl/zhyu01.dbf
    
18. channel ORA_DISK_1: restoring datafile 00007 to /app/oracle/db/oradata/orcl/users01.dbf
    
19. channel ORA_DISK_1: reading from backup piece /tmp/full_3l0cgv8p_1_1.bak
    
20. channel ORA_DISK_1: piece handle=/tmp/full_3l0cgv8p_1_1.bak tag=TAG20211025T152409
    
21. channel ORA_DISK_1: restored backup piece 1
    
22. channel ORA_DISK_1: restore complete, elapsed time: 00:00:25
    
23. Finished restore at 25-OCT-21
    
24. 
    

复制代码