oracle11g数据文件和日志文件损坏恢复

1、重建数据文件
RMAN> restore database;

SQL> select checkpoint_change# from v$datafile_header;

CHECKPOINT_CHANGE#

    925071
    925070
    925070
    925071
    925070

SQL> select checkpoint_change# from v$datafile;

CHECKPOINT_CHANGE#

    926020
    926020
    926020
    926020
    926020

2、追归档
RMAN> recover database;

Starting recover at 12-MAY-20
using channel ORA_DISK_1

starting media recovery

archived log for thread 1 with sequence 2 is already on disk as file /home/oracle/arch/1_2_1040191579.dbf
archived log for thread 1 with sequence 3 is already on disk as file /home/oracle/arch/1_3_1040191579.dbf
archived log for thread 1 with sequence 4 is already on disk as file /home/oracle/arch/1_4_1040191579.dbf
archived log file name=/home/oracle/arch/1_2_1040191579.dbf thread=1 sequence=2
archived log file name=/home/oracle/arch/1_3_1040191579.dbf thread=1 sequence=3
archived log file name=/home/oracle/arch/1_4_1040191579.dbf thread=1 sequence=4
RMAN-00571: =================