|
测试内容；
1 全备份-增备 这种备份方式，在全备份和增量备份之间，产生的归档日志。在使用全备+增备进行恢复的时候，这些归档日志，会不会用到.（已通过以下案例测试）
结论： 不会用到。
另一个问题
1 全备份-累计增量备份-累计增量备份-累计增量备份 这种备份方式，如果只使用一个全备份和最后一个累计增量备份，是否可以恢复出来数据库。
个人猜测，根据docs文档，累计增量备份，是基于0及备份的。所以，应该是可以恢复出来数据库的（没有测试，只是根据文档猜测）
看文档，里面有一段：
When restoring incremental backups, RMAN uses the level 0 backup as the starting point, then updates changed blocks based on level 1 backups where possible to avoid reapplying changes from redo one at a time.?
参考文档：
Getting Started with RMAN (oracle.com)
?
Making Incremental Backups
If you specify?BACKUP?INCREMENTAL, then RMAN creates an?incremental backup?of a database. Incremental backups capture block-level changes to a database made after a previous?incremental backup. Incremental backups are generally smaller and faster to make than full database backups. Recovery with incremental backups is faster than using redo logs alone.
The starting point for an incremental backup strategy is a?level 0 incremental backup, which backs up all blocks in the database. An incremental backup at level 0 is identical in content to a?full backup, however, unlike a full backup the level 0 backup is considered a part of the incremental backup strategy.
A level 1 incremental backup contains only blocks changed after a previous incremental backup. If no level 0 backup exists in either the current or parent database?incarnation?when you run a level 1 backup, then RMAN makes a level 0 backup automatically.
Note:
You cannot make incremental backups when a?NOARCHIVELOG?database is open, although you can make incremental backups when the database is mounted after a consistent shutdown.
A level 1 backup can be a?cumulative incremental backup, which includes all blocks changed since the most recent level 0 backup, or a?differential incremental backup, which includes only blocks changed since the most recent incremental backup. Incremental backups are differential by default.
When restoring incremental backups, RMAN uses the level 0 backup as the starting point, then updates changed blocks based on level 1 backups where possible to avoid reapplying changes from redo one at a time. Recovering with incremental backups requires no additional effort on your part. If incremental backups are available, then RMAN uses them during recovery.
To make incremental backups of the database:
-
Start RMAN and connect to a target database. -
Run the?BACKUP INCREMENTAL?command. The following example creates a level 0 incremental backup to serve as a base for an incremental backup strategy: BACKUP INCREMENTAL LEVEL 0 DATABASE;
The following example creates a level 1 cumulative incremental backup: BACKUP INCREMENTAL LEVEL 1 CUMULATIVE DATABASE;
The following example creates a level 1 differential incremental backup: BACKUP INCREMENTAL LEVEL 1 DATABASE;
?1 做一个一个全备份。归档日志是1?
SYS@bak>archive log list
Database log mode Archive Mode
Automatic archival Enabled
Archive destination /u01/archivelog/bak
Oldest online log sequence 1
Next log sequence to archive 1
Current log sequence 1
SYS@bak>
[oracle@redhat762100 backup_test]$ rman target /
Recovery Manager: Release 19.0.0.0.0 - Production on Thu Oct 13 15:34:05 2022
Version 19.15.0.0.0
Copyright (c) 1982, 2019, Oracle and/or its affiliates. All rights reserved.
connected to target database: BAK (DBID=1552936560)
RMAN> list backup of database summary;
using target database control file instead of recovery catalog
List of Backups
===============
Key TY LV S Device Type Completion Time #Pieces #Copies Compressed Tag
------- -- -- - ----------- --------------- ------- ------- ---------- ---
42 B 0 A DISK 13-OCT-22 1 1 YES DB_INCR0_BAK
43 B 0 A DISK 13-OCT-22 1 1 YES DB_INCR0_BAK
44 B 0 A DISK 13-OCT-22 1 1 YES DB_INCR0_BAK
45 B 0 A DISK 13-OCT-22 1 1 YES DB_INCR0_BAK
RMAN> list backup of database;
List of Backup Sets
===================
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
42 Incr 0 1.18M DISK 00:00:00 13-OCT-22
BP Key: 42 Status: AVAILABLE Compressed: YES Tag: DB_INCR0_BAK
Piece Name: /u01/backup_test/BAK_incr0_46_20221013
List of Datafiles in backup set 42
File LV Type Ckp SCN Ckp Time Abs Fuz SCN Sparse Name
---- -- ---- ---------- --------- ----------- ------ ----
7 0 Incr 2906812 13-OCT-22 NO /u01/app/19c/oradata/BAK/users01.dbf
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
43 Incr 0 1.55M DISK 00:00:06 13-OCT-22
BP Key: 43 Status: AVAILABLE Compressed: YES Tag: DB_INCR0_BAK
Piece Name: /u01/backup_test/BAK_incr0_44_20221013
List of Datafiles in backup set 43
File LV Type Ckp SCN Ckp Time Abs Fuz SCN Sparse Name
---- -- ---- ---------- --------- ----------- ------ ----
4 0 Incr 2906808 13-OCT-22 NO /u01/app/19c/oradata/BAK/undotbs01.dbf
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
44 Incr 0 91.07M DISK 00:00:08 13-OCT-22
BP Key: 44 Status: AVAILABLE Compressed: YES Tag: DB_INCR0_BAK
Piece Name: /u01/backup_test/BAK_incr0_45_20221013
List of Datafiles in backup set 44
File LV Type Ckp SCN Ckp Time Abs Fuz SCN Sparse Name
---- -- ---- ---------- --------- ----------- ------ ----
3 0 Incr 2906810 13-OCT-22 NO /u01/app/19c/oradata/BAK/sysaux01.dbf
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
45 Incr 0 1.93G DISK 00:02:54 13-OCT-22
BP Key: 45 Status: AVAILABLE Compressed: YES Tag: DB_INCR0_BAK
Piece Name: /u01/backup_test/BAK_incr0_43_20221013
List of Datafiles in backup set 45
File LV Type Ckp SCN Ckp Time Abs Fuz SCN Sparse Name
---- -- ---- ---------- --------- ----------- ------ ----
1 0 Incr 2906806 13-OCT-22 NO /u01/app/19c/oradata/BAK/system01.dbf
RMAN>
2 创建一个表，大量插入数据，可以看到产生了大量的日志，归档日志到了123，然后清理掉日志?
create table t_20221013 as select * from dba_objects;
insert into t_20221013 select * from t_20221013;
commit;
[oracle@redhat762100 bak]$ ls
1_100_1118084971.dbf 1_114_1118084971.dbf 1_27_1118084971.dbf 1_42_1118084971.dbf 1_58_1118084971.dbf 1_73_1118084971.dbf 1_89_1118084971.dbf
1_101_1118084971.dbf 1_12_1118084971.dbf 1_28_1118084971.dbf 1_43_1118084971.dbf 1_59_1118084971.dbf 1_74_1118084971.dbf 1_90_1118084971.dbf
1_10_1118084971.dbf 1_13_1118084971.dbf 1_29_1118084971.dbf 1_44_1118084971.dbf 1_60_1118084971.dbf 1_75_1118084971.dbf 1_91_1118084971.dbf
1_102_1118084971.dbf 1_14_1118084971.dbf 1_30_1118084971.dbf 1_45_1118084971.dbf 1_61_1118084971.dbf 1_76_1118084971.dbf 1_9_1118084971.dbf
1_103_1118084971.dbf 1_15_1118084971.dbf 1_31_1118084971.dbf 1_46_1118084971.dbf 1_6_1118084971.dbf 1_77_1118084971.dbf 1_92_1118084971.dbf
1_104_1118084971.dbf 1_16_1118084971.dbf 1_3_1118084971.dbf 1_47_1118084971.dbf 1_62_1118084971.dbf 1_78_1118084971.dbf 1_93_1118084971.dbf
1_105_1118084971.dbf 1_17_1118084971.dbf 1_32_1118084971.dbf 1_48_1118084971.dbf 1_63_1118084971.dbf 1_79_1118084971.dbf 1_94_1118084971.dbf
1_106_1118084971.dbf 1_18_1118084971.dbf 1_33_1118084971.dbf 1_49_1118084971.dbf 1_64_1118084971.dbf 1_80_1118084971.dbf 1_95_1118084971.dbf
1_107_1118084971.dbf 1_19_1118084971.dbf 1_34_1118084971.dbf 1_50_1118084971.dbf 1_65_1118084971.dbf 1_81_1118084971.dbf 1_96_1118084971.dbf
1_108_1118084971.dbf 1_20_1118084971.dbf 1_35_1118084971.dbf 1_51_1118084971.dbf 1_66_1118084971.dbf 1_8_1118084971.dbf 1_97_1118084971.dbf
1_109_1118084971.dbf 1_21_1118084971.dbf 1_36_1118084971.dbf 1_5_1118084971.dbf 1_67_1118084971.dbf 1_82_1118084971.dbf 1_98_1118084971.dbf
1_110_1118084971.dbf 1_2_1118084971.dbf 1_37_1118084971.dbf 1_52_1118084971.dbf 1_68_1118084971.dbf 1_83_1118084971.dbf 1_99_1118084971.dbf
1_111_1118084971.dbf 1_22_1118084971.dbf 1_38_1118084971.dbf 1_53_1118084971.dbf 1_69_1118084971.dbf 1_84_1118084971.dbf
1_11_1118084971.dbf 1_23_1118084971.dbf 1_39_1118084971.dbf 1_54_1118084971.dbf 1_70_1118084971.dbf 1_85_1118084971.dbf
1_1_1118084971.dbf 1_24_1118084971.dbf 1_40_1118084971.dbf 1_55_1118084971.dbf 1_71_1118084971.dbf 1_86_1118084971.dbf
1_112_1118084971.dbf 1_25_1118084971.dbf 1_41_1118084971.dbf 1_56_1118084971.dbf 1_7_1118084971.dbf 1_87_1118084971.dbf
1_113_1118084971.dbf 1_26_1118084971.dbf 1_4_1118084971.dbf 1_57_1118084971.dbf 1_72_1118084971.dbf 1_88_1118084971.dbf
[oracle@redhat762100 bak]$ pwd
/u01/archivelog/bak
[oracle@redhat762100 bak]$
[oracle@redhat762100 bak]$ rm -rf *
You have new mail in /var/spool/mail/oracle
[oracle@redhat762100 bak]$ ls
[oracle@redhat762100 bak]$
SYS@bak>archive log list
Database log mode Archive Mode
Automatic archival Enabled
Archive destination /u01/archivelog/bak
Oldest online log sequence 122
Next log sequence to archive 124
Current log sequence 124
SYS@bak>
3 开始增量备份，可以看到有增量备份 .list backup of database可以看到有0级备份和一级备份
[oracle@redhat762100 backup_test]$ rman target /
Recovery Manager: Release 19.0.0.0.0 - Production on Thu Oct 13 16:17:36 2022
Version 19.15.0.0.0
Copyright (c) 1982, 2019, Oracle and/or its affiliates. All rights reserved.
connected to target database: BAK (DBID=1552936560)
RMAN> list backup of database summary;
using target database control file instead of recovery catalog
List of Backups
===============
Key TY LV S Device Type Completion Time #Pieces #Copies Compressed Tag
------- -- -- - ----------- --------------- ------- ------- ---------- ---
42 B 0 A DISK 13-OCT-22 1 1 YES DB_INCR0_BAK
43 B 0 A DISK 13-OCT-22 1 1 YES DB_INCR0_BAK
44 B 0 A DISK 13-OCT-22 1 1 YES DB_INCR0_BAK
45 B 0 A DISK 13-OCT-22 1 1 YES DB_INCR0_BAK
47 B 1 A DISK 13-OCT-22 1 1 YES DB_INCR1_BAK
48 B 1 A DISK 13-OCT-22 1 1 YES DB_INCR1_BAK
49 B 1 A DISK 13-OCT-22 1 1 YES DB_INCR1_BAK
50 B 1 A DISK 13-OCT-22 1 1 YES DB_INCR1_BAK
RMAN>
RMAN> list backup of database;
List of Backup Sets
===================
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
42 Incr 0 1.18M DISK 00:00:00 13-OCT-22
BP Key: 42 Status: AVAILABLE Compressed: YES Tag: DB_INCR0_BAK
Piece Name: /u01/backup_test/BAK_incr0_46_20221013
List of Datafiles in backup set 42
File LV Type Ckp SCN Ckp Time Abs Fuz SCN Sparse Name
---- -- ---- ---------- --------- ----------- ------ ----
7 0 Incr 2906812 13-OCT-22 NO /u01/app/19c/oradata/BAK/users01.dbf
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
43 Incr 0 1.55M DISK 00:00:06 13-OCT-22
BP Key: 43 Status: AVAILABLE Compressed: YES Tag: DB_INCR0_BAK
Piece Name: /u01/backup_test/BAK_incr0_44_20221013
List of Datafiles in backup set 43
File LV Type Ckp SCN Ckp Time Abs Fuz SCN Sparse Name
---- -- ---- ---------- --------- ----------- ------ ----
4 0 Incr 2906808 13-OCT-22 NO /u01/app/19c/oradata/BAK/undotbs01.dbf
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
44 Incr 0 91.07M DISK 00:00:08 13-OCT-22
BP Key: 44 Status: AVAILABLE Compressed: YES Tag: DB_INCR0_BAK
Piece Name: /u01/backup_test/BAK_incr0_45_20221013
List of Datafiles in backup set 44
File LV Type Ckp SCN Ckp Time Abs Fuz SCN Sparse Name
---- -- ---- ---------- --------- ----------- ------ ----
3 0 Incr 2906810 13-OCT-22 NO /u01/app/19c/oradata/BAK/sysaux01.dbf
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
45 Incr 0 1.93G DISK 00:02:54 13-OCT-22
BP Key: 45 Status: AVAILABLE Compressed: YES Tag: DB_INCR0_BAK
Piece Name: /u01/backup_test/BAK_incr0_43_20221013
List of Datafiles in backup set 45
File LV Type Ckp SCN Ckp Time Abs Fuz SCN Sparse Name
---- -- ---- ---------- --------- ----------- ------ ----
1 0 Incr 2906806 13-OCT-22 NO /u01/app/19c/oradata/BAK/system01.dbf
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
47 Incr 1 48.00K DISK 00:00:01 13-OCT-22
BP Key: 47 Status: AVAILABLE Compressed: YES Tag: DB_INCR1_BAK
Piece Name: /u01/backup_test/in0/BAK_incr1_51_20221013.bak
List of Datafiles in backup set 47
File LV Type Ckp SCN Ckp Time Abs Fuz SCN Sparse Name
---- -- ---- ---------- --------- ----------- ------ ----
7 1 Incr 2944657 13-OCT-22 NO /u01/app/19c/oradata/BAK/users01.dbf
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
48 Incr 1 360.00K DISK 00:00:03 13-OCT-22
BP Key: 48 Status: AVAILABLE Compressed: YES Tag: DB_INCR1_BAK
Piece Name: /u01/backup_test/in0/BAK_incr1_50_20221013.bak
List of Datafiles in backup set 48
File LV Type Ckp SCN Ckp Time Abs Fuz SCN Sparse Name
---- -- ---- ---------- --------- ----------- ------ ----
3 1 Incr 2944655 13-OCT-22 NO /u01/app/19c/oradata/BAK/sysaux01.dbf
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
49 Incr 1 97.30M DISK 00:00:12 13-OCT-22
BP Key: 49 Status: AVAILABLE Compressed: YES Tag: DB_INCR1_BAK
Piece Name: /u01/backup_test/in0/BAK_incr1_49_20221013.bak
List of Datafiles in backup set 49
File LV Type Ckp SCN Ckp Time Abs Fuz SCN Sparse Name
---- -- ---- ---------- --------- ----------- ------ ----
4 1 Incr 2944653 13-OCT-22 NO /u01/app/19c/oradata/BAK/undotbs01.dbf
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
50 Incr 1 2.22G DISK 00:04:03 13-OCT-22
BP Key: 50 Status: AVAILABLE Compressed: YES Tag: DB_INCR1_BAK
Piece Name: /u01/backup_test/in0/BAK_incr1_48_20221013.bak
List of Datafiles in backup set 50
File LV Type Ckp SCN Ckp Time Abs Fuz SCN Sparse Name
---- -- ---- ---------- --------- ----------- ------ ----
1 1 Incr 2944651 13-OCT-22 NO /u01/app/19c/oradata/BAK/system01.dbf
RMAN>
4 开始恢复控制文件?
restore controlfile from '/u01/backup_test/in0/BAK_cont_57_20221013.ctl';
[oracle@redhat762100 backup_test]$ rman target /
Recovery Manager: Release 19.0.0.0.0 - Production on Thu Oct 13 16:20:11 2022
Version 19.15.0.0.0
Copyright (c) 1982, 2019, Oracle and/or its affiliates. All rights reserved.
connected to target database (not started)
RMAN> startup nomount
Oracle instance started
Total System Global Area 1241513480 bytes
Fixed Size 8896008 bytes
Variable Size 335544320 bytes
Database Buffers 889192448 bytes
Redo Buffers 7880704 bytes
RMAN> restore controlfile from '/u01/backup_test/in0/BAK_cont_57_20221013.ctl';
Starting restore at 13-OCT-22
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=20 device type=DISK
channel ORA_DISK_1: restoring control file
channel ORA_DISK_1: restore complete, elapsed time: 00:00:01
output file name=/u01/app/19c/oradata/BAK/control01.ctl
output file name=/u01/app/19c/fast_recovery_area/BAK/control02.ctl
Finished restore at 13-OCT-22
RMAN>
5? restore datafile ,可以看到，使用的是0级备份来恢复数据文件
RMAN> alter database mount;
released channel: ORA_DISK_1
Statement processed
RMAN> restore database;
Starting restore at 13-OCT-22
Starting implicit crosscheck backup at 13-OCT-22
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=23 device type=DISK
Crosschecked 17 objects
Finished implicit crosscheck backup at 13-OCT-22
Starting implicit crosscheck copy at 13-OCT-22
using channel ORA_DISK_1
Finished implicit crosscheck copy at 13-OCT-22
searching for all files in the recovery area
cataloging files...
cataloging done
List of Cataloged Files
=======================
File Name: /u01/app/19c/fast_recovery_area/BAK/autobackup/2022_10_13/o1_mf_s_1117988171_knhlbcgy_.bkp
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 00007 to /u01/app/19c/oradata/BAK/users01.dbf
channel ORA_DISK_1: reading from backup piece /u01/backup_test/BAK_incr0_46_20221013
channel ORA_DISK_1: piece handle=/u01/backup_test/BAK_incr0_46_20221013 tag=DB_INCR0_BAK
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:00:01
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 00004 to /u01/app/19c/oradata/BAK/undotbs01.dbf
channel ORA_DISK_1: reading from backup piece /u01/backup_test/BAK_incr0_44_20221013
channel ORA_DISK_1: piece handle=/u01/backup_test/BAK_incr0_44_20221013 tag=DB_INCR0_BAK
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:00:07
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 00003 to /u01/app/19c/oradata/BAK/sysaux01.dbf
channel ORA_DISK_1: reading from backup piece /u01/backup_test/BAK_incr0_45_20221013
channel ORA_DISK_1: piece handle=/u01/backup_test/BAK_incr0_45_20221013 tag=DB_INCR0_BAK
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:00:15
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 /u01/app/19c/oradata/BAK/system01.dbf
channel ORA_DISK_1: reading from backup piece /u01/backup_test/BAK_incr0_43_20221013
channel ORA_DISK_1: piece handle=/u01/backup_test/BAK_incr0_43_20221013 tag=DB_INCR0_BAK
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:03:45
Finished restore at 13-OCT-22
RMAN>
6? recover database，可以看到 recover database的时候，用到了增量备份，以及增量备份后的归档124和125（其实是增量备份的时候，切的日志）
RMAN> recover database;
Starting recover at 13-OCT-22
using channel ORA_DISK_1
channel ORA_DISK_1: starting incremental datafile backup set restore
channel ORA_DISK_1: specifying datafile(s) to restore from backup set
destination for restore of datafile 00007: /u01/app/19c/oradata/BAK/users01.dbf
channel ORA_DISK_1: reading from backup piece /u01/backup_test/in0/BAK_incr1_51_20221013.bak
channel ORA_DISK_1: piece handle=/u01/backup_test/in0/BAK_incr1_51_20221013.bak tag=DB_INCR1_BAK
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:00:01
channel ORA_DISK_1: starting incremental datafile backup set restore
channel ORA_DISK_1: specifying datafile(s) to restore from backup set
destination for restore of datafile 00003: /u01/app/19c/oradata/BAK/sysaux01.dbf
channel ORA_DISK_1: reading from backup piece /u01/backup_test/in0/BAK_incr1_50_20221013.bak
channel ORA_DISK_1: piece handle=/u01/backup_test/in0/BAK_incr1_50_20221013.bak tag=DB_INCR1_BAK
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:00:01
channel ORA_DISK_1: starting incremental datafile backup set restore
channel ORA_DISK_1: specifying datafile(s) to restore from backup set
destination for restore of datafile 00004: /u01/app/19c/oradata/BAK/undotbs01.dbf
channel ORA_DISK_1: reading from backup piece /u01/backup_test/in0/BAK_incr1_49_20221013.bak
channel ORA_DISK_1: piece handle=/u01/backup_test/in0/BAK_incr1_49_20221013.bak tag=DB_INCR1_BAK
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:00:15
channel ORA_DISK_1: starting incremental datafile backup set restore
channel ORA_DISK_1: specifying datafile(s) to restore from backup set
destination for restore of datafile 00001: /u01/app/19c/oradata/BAK/system01.dbf
channel ORA_DISK_1: reading from backup piece /u01/backup_test/in0/BAK_incr1_48_20221013.bak
channel ORA_DISK_1: piece handle=/u01/backup_test/in0/BAK_incr1_48_20221013.bak tag=DB_INCR1_BAK
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:05:45
starting media recovery
archived log for thread 1 with sequence 124 is already on disk as file /u01/archivelog/bak/1_124_1118084971.dbf
archived log for thread 1 with sequence 125 is already on disk as file /u01/archivelog/bak/1_125_1118084971.dbf
archived log file name=/u01/archivelog/bak/1_124_1118084971.dbf thread=1 sequence=124
archived log file name=/u01/archivelog/bak/1_125_1118084971.dbf thread=1 sequence=125
unable to find archived log
archived log thread=1 sequence=126
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 10/13/2022 16:34:12
RMAN-06054: media recovery requesting unknown archived log for thread 1 with sequence 126 and starting SCN of 2944930
RMAN>
7 开库?
RMAN> alter database open resetlogs;
Statement processed
RMAN>
SYS@bak>select open_mode from v$database;
OPEN_MODE
--------------------
READ WRITE
SYS@bak>
END
|