Oracle does not completely restore the lost archive log

Oracle does not completely restore the lost archive log, but does not completely restore the log. The purpose is to reset the log. Here, the time point is the time point after the backup set is generated. We can see that only records can be recovered.

Oracle does not completely restore the lost archive log, but does not completely restore the log. The purpose is to reset the log. Here, the time point is the time point after the backup set is generated. We can see that only records can be recovered.

Environment:
OS: Red Hat Linux As 5
DB: Oracle 10.2.0.4

The following describes how to simulate Incomplete recovery after archiving logs are lost.
1. Back up the database
Run {
Allocate channel c1 device type disk;
Allocate channel c2 device type disk;
Allocate channel c3 device type disk;
Allocate channel c4 device type disk;
Backup database format'/u02/rman_bak/full _ % u _ % T. bak ';
Release channel c1;
Release channel c2;
Release channel c3;
Release channel c4;
}

2. Incomplete recovery is performed to reset the log. The time point here is the time point after the backup set is generated.
Run {
Set until time "to_date ('2017-07-06 21:52:00 ', 'yyyy-MM-DD HH24: MI: ss ')";
Restore database;
Recover database;
}
Reset logs
RMAN> alter database open resetlogs;
Database opened
SQL> archive log list;
Database log mode Archive Mode
Automatic archival Enabled
Archive destination USE_DB_RECOVERY_FILE_DEST
Oldest online log sequence 0
Next log sequence to archive 1
Current log sequence 1

3. Back up data again to simulate restoration after log loss
Run {
Allocate channel c1 device type disk;
Allocate channel c2 device type disk;
Allocate channel c3 device type disk;
Allocate channel c4 device type disk;
Backup database format'/u02/rman_bak/full _ % u _ % T. bak ';
Release channel c1;
Release channel c2;
Release channel c3;
Release channel c4;
}

4. Simulate data
SQL> connect scott/scott
SQL> create table tb_test
(
Id number,
Remark varchar2 (30 ),
Create_time date default sysdate
);
Table created.
SQL> connect/as sysdba
Write the first record and generate archive log 1
SQL> insert into scott. tb_test values (1, 'First switchover ', sysdate );
SQL> commit;
SQL> alter system switch logfile;
Archive log 1 is generated at this time.
[Oracle @ hxl 2012_07_06] $ ls
O1_mf_000000007zfx44j4 _. arc
Write the second record and generate archive log 2
SQL> insert into scott. tb_test values (2, 'second failed', sysdate );
SQL> commit;
SQL> alter system switch logfile;
Archive log 2 is generated at this time.
[Oracle @ hxl 2012_07_06] $ ls-1
O1_mf_000000007zfx44j4 _. arc
O1_mf_1_2_7zfxmbq9 _. arc
Write the third record and generate archive log 3
SQL> insert into scott. tb_test values (3, 'third failed', sysdate );
SQL> commit;
SQL> alter system switch logfile;
Archive log 3 is generated at this time.
[Oracle @ hxl 2012_07_06] $ ls-1
O1_mf_000000007zfx44j4 _. arc
O1_mf_1_2_7zfxmbq9 _. arc
O1_mf_1_3_7zfy5jnz _. arc
Write article 4 Record and generate archive log 4
SQL> insert into scott. tb_test values (4, 'Fourth failed', sysdate );
SQL> commit;
SQL> alter system switch logfile;
Archive log 4 is generated at this time.
[Oracle @ hxl 2012_07_06] $ ls-1
O1_mf_000000007zfx44j4 _. arc
O1_mf_1_2_7zfxmbq9 _. arc
O1_mf_1_3_7zfy5jnz _. arc
O1_mf_00004_7zfyth7x _. arc

5. We use Incomplete recovery to restore the time point at which the archive log is generated, and record the time point '2017-07-06 22:50:00'
[Oracle @ hxl 2012_07_06] $ ls-al
Total 14264
Drwxr-x --- 2 oracle oinstall 4096 Jul 6.
Drwxr-x --- 11 oracle oinstall 4096 Jul 6 ..
-Rw-r ----- 1 oracle oinstall 9038848 Jul 6 o%mf_%%7zfx44j4 _. arc
-Rw-r ----- 1 oracle oinstall 5408256 Jul 6 o1_mf_1_2_7zfxmbq9 _. arc
-Rw-r ----- 1 oracle oinstall 41984 Jul 6 o1_mf_1_3_7zfy5jnz _. arc
-Rw-r ----- 1 oracle oinstall 45568 Jul 6 o1_mf_1_4_7zfyth7x _. arc

,