ORACLE数据库在曾经的备库（路径一致）进行不完全恢复

一、利用主库的pfile文件，启动备库（曾经的备库，简称备库）数据库到nomount(如果使用原备库的参数文件，在后面做restore的时候一直报错)：
    SQL> startup nomount pfile='/nas_epm/initepm.ora.bak';
    ORACLE instance started.
    Total System Global Area 1.0737E+11 bytes
    Fixed Size		   19252696 bytes
    Variable Size		 1.3690E+10 bytes
    Database Buffers	 9.3416E+10 bytes
    Redo Buffers		  249180160 bytes

二、利用主库的控制文件备份，恢复备库数据库控制文件：
    RMAN> restore controlfile from '/nas_epm/epm_control_EPM_20260105_9932.bkp' ;
    Starting restore at 05-JAN-26
    using target database control file instead of recovery catalog
    allocated channel: ORA_DISK_1
    channel ORA_DISK_1: SID=5079 device type=DISK
    channel ORA_DISK_1: restoring control file
    channel ORA_DISK_1: restore complete, elapsed time: 00:00:01
    output file name=/tqls_system/app/oracle/app/oradata/epm/control01.ctl
    output file name=/tqls_system/app/oracle/app/fast_recovery_area/epm/control02.ctl
    Finished restore at 05-JAN-26
    RMAN> alter database mount;
    Statement processed

三、CATALOG备份文件和归档日志文件到数据库：
    RMAN> create spfile from memory;
    Statement processed
    RMAN> shutdown immediate
    database dismounted
    Oracle instance shut down
    RMAN> startup mount
    connected to target database (not started)
    Oracle instance started
    database mounted
    Total System Global Area  107374182400 bytes
    Fixed Size                    19252696 bytes
    Variable Size              13690210856 bytes
    Database Buffers           93415538688 bytes
    Redo Buffers                 249180160 bytes
    RMAN> CATALOG START WITH '/tqls_system/oracle_bak/';
    Starting implicit crosscheck backup at 05-JAN-26
    allocated channel: ORA_DISK_1
    channel ORA_DISK_1: SID=5923 device type=DISK
    allocated channel: ORA_DISK_2
    channel ORA_DISK_2: SID=6771 device type=DISK
    Crosschecked 9 objects
    Crosschecked 2678 objects
    Finished implicit crosscheck backup at 05-JAN-26
    Starting implicit crosscheck copy at 05-JAN-26
    using channel ORA_DISK_1
    using channel ORA_DISK_2
    Crosschecked 2 objects
    Finished implicit crosscheck copy at 05-JAN-26
    searching for all files in the recovery area
    cataloging files...
    cataloging done
    List of Cataloged Files
    =======================
    File Name: /tqls_system/fast_recovery_area/EPM/archivelog/2025_08_02/o1_mf_1_60201_n8swmvjj_.arc
    File Name: /tqls_system/fast_recovery_area/EPM/archivelog/2025_08_02/o1_mf_1_60191_n8sw8rl4_.arc
    File Name: /tqls_system/fast_recovery_area/EPM/archivelog/2025_08_02/o1_mf_1_60198_n8swjlry_.arc
    File Name: /tqls_system/fast_recovery_area/EPM/archivelog/2025_08_02/o1_mf_1_60212_n8tp4wkm_.arc
    File Name: /tqls_system/fast_recovery_area/EPM/archivelog/2025_08_02/o1_mf_1_60206_n8swwo8b_.arc
    File Name: /tqls_system/fast_recovery_area/EPM/archivelog/2025_08_02/o1_mf_1_60186_n8svvlbf_.arc
    File Name: /tqls_system/fast_recovery_area/EPM/archivelog/2025_08_02/o1_mf_1_60192_n8sw9vd6_.arc
    File Name: /tqls_system/fast_recovery_area/EPM/archivelog/2025_08_02/o1_mf_1_60194_n8swd0xd_.arc
    File Name: /tqls_system/fast_recovery_area/EPM/archivelog/2025_08_02/o1_mf_1_60188_n8sw1xyn_.arc
    File Name: /tqls_system/fast_recovery_area/EPM/archivelog/2025_08_02/o1_mf_1_60205_n8swttpd_.arc
    File Name: /tqls_system/fast_recovery_area/EPM/archivelog/2025_08_02/o1_mf_1_60181_n8stmhbm_.arc
    File Name: /tqls_system/fast_recovery_area/EPM/archivelog/2025_08_02/o1_mf_1_60204_n8swss5p_.arc
    File Name: /tqls_system/fast_recovery_area/EPM/archivelog/2025_08_02/o1_mf_1_60203_n8swp0tm_.arc
    File Name: /tqls_system/fast_recovery_area/EPM/archivelog/2025_08_02/o1_mf_1_60209_n8tp55h1_.arc
    File Name: /tqls_system/fast_recovery_area/EPM/archivelog/2025_08_02/o1_mf_1_60190_n8sw7cj0_.arc
    File Name: /tqls_system/fast_recovery_area/EPM/archivelog/2025_08_02/o1_mf_1_60195_n8swf3xm_.arc
    File Name: /tqls_system/fast_recovery_area/EPM/archivelog/2025_08_02/o1_mf_1_60200_n8swlrgv_.arc
    File Name: /tqls_system/fast_recovery_area/EPM/archivelog/2025_08_02/o1_mf_1_60193_n8swbxns_.arc
    File Name: /tqls_system/fast_recovery_area/EPM/archivelog/2025_08_02/o1_mf_1_60187_n8svx00d_.arc
    File Name: /tqls_system/fast_recovery_area/EPM/archivelog/2025_08_02/o1_mf_1_60183_n8stx0p2_.arc
    File Name: /tqls_system/fast_recovery_area/EPM/archivelog/2025_08_02/o1_mf_1_60182_n8stsvby_.arc
    File Name: /tqls_system/fast_recovery_area/EPM/archivelog/2025_08_02/o1_mf_1_60211_n8tp48kd_.arc
    File Name: /tqls_system/fast_recovery_area/EPM/archivelog/2025_08_02/o1_mf_1_60196_n8swg5cx_.arc
    File Name: /tqls_system/fast_recovery_area/EPM/archivelog/2025_08_02/o1_mf_1_60210_n8tp3z1g_.arc
    File Name: /tqls_system/fast_recovery_area/EPM/archivelog/2025_08_02/o1_mf_1_60213_n8tp5dhh_.arc
    File Name: /tqls_system/fast_recovery_area/EPM/archivelog/2025_08_02/o1_mf_1_60207_n8swxtto_.arc
    File Name: /tqls_system/fast_recovery_area/EPM/archivelog/2025_08_02/o1_mf_1_60199_n8swkol8_.arc
    File Name: /tqls_system/fast_recovery_area/EPM/archivelog/2025_08_02/o1_mf_1_60208_n8swz1y8_.arc
    File Name: /tqls_system/fast_recovery_area/EPM/archivelog/2025_08_02/o1_mf_1_60197_n8swhbqh_.arc
    File Name: /tqls_system/fast_recovery_area/EPM/archivelog/2025_08_02/o1_mf_1_60184_n8stxpov_.arc
    File Name: /tqls_system/fast_recovery_area/EPM/archivelog/2025_08_02/o1_mf_1_60185_n8svhzbk_.arc
    File Name: /tqls_system/fast_recovery_area/EPM/archivelog/2025_08_02/o1_mf_1_60202_n8swnztt_.arc
    File Name: /tqls_system/fast_recovery_area/EPM/archivelog/2025_08_02/o1_mf_1_60189_n8sw2ohf_.arc
    searching for all files that match the pattern /tqls_system/oracle_bak/
    List of Files Unknown to the Database
    =====================================
    File Name: /tqls_system/oracle_bak/EPM_DATA_20260105_m94d3skm_1_1.dbf
    File Name: /tqls_system/oracle_bak/EPM_DATA_20260105_ma4d4erm_1_1.dbf
    File Name: /tqls_system/oracle_bak/CATALOG
    File Name: /tqls_system/oracle_bak/EPM_ARCHIVELOG_20260105_mb4d4ert_1_1.arc
    Do you really want to catalog the above files (enter YES or NO)? yes
    cataloging files...
    cataloging done
    List of Cataloged Files
    =======================
    File Name: /tqls_system/oracle_bak/EPM_DATA_20260105_m94d3skm_1_1.dbf
    File Name: /tqls_system/oracle_bak/EPM_DATA_20260105_ma4d4erm_1_1.dbf
    File Name: /tqls_system/oracle_bak/EPM_ARCHIVELOG_20260105_mb4d4ert_1_1.arc

四、执行不完整恢复到指定时间点：
    RUN {
        SET UNTIL TIME "TO_DATE('2026-01-05 14:00:00', 'YYYY-MM-DD HH24:MI:SS')";
        RESTORE DATABASE;
        RECOVER DATABASE;
    }
    2> 3> 4> 5> 
    executing command: SET until clause
    Starting restore at 05-JAN-26
    using channel ORA_DISK_1
    using channel ORA_DISK_2
    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 /tqls_system/app/oracle/app/oradata/epm/system01.dbf
    channel ORA_DISK_1: restoring datafile 00002 to /tqls_system/app/oracle/app/oradata/epm/DBS_EPMREP_INDEX01.dbf
    channel ORA_DISK_1: restoring datafile 00003 to /tqls_system/app/oracle/app/oradata/epm/sysaux01.dbf
    channel ORA_DISK_1: restoring datafile 00004 to /tqls_system/app/oracle/app/oradata/epm/undotbs01.dbf
    channel ORA_DISK_1: restoring datafile 00005 to /tqls_system/app/oracle/app/oradata/epm/DBS_EPMREP_DATA01.dbf
    channel ORA_DISK_1: restoring datafile 00007 to /tqls_system/app/oracle/app/oradata/epm/users01.dbf
    channel ORA_DISK_1: restoring datafile 00008 to /tqls_system/app/oracle/app/oradata/epm/DBS_EPMBUDGET_DATA01.dbf
    channel ORA_DISK_1: restoring datafile 00009 to /tqls_system/app/oracle/app/oradata/epm/DBS_EPMBUDGET_INDEX01.dbf
    channel ORA_DISK_1: restoring datafile 00010 to /tqls_system/app/oracle/app/oradata/epm/DBS_EPMBUDGET_DATA02.dbf
    channel ORA_DISK_1: restoring datafile 00011 to /tqls_system/app/oracle/app/oradata/epm/DBS_EPMODS_DATA01.dbf
    channel ORA_DISK_1: restoring datafile 00012 to /tqls_system/app/oracle/app/oradata/epm/DBS_EPMODS_INDEX01.dbf
    channel ORA_DISK_1: restoring datafile 00013 to /tqls_system/app/oracle/app/oradata/epm/DBS_EPMBUDGET_INDEX02.dbf
    channel ORA_DISK_1: restoring datafile 00014 to /tqls_system/app/oracle/app/oradata/epm/DBS_EPMBUDGET_INDEX03.dbf
    channel ORA_DISK_1: restoring datafile 00015 to /tqls_system/app/oracle/app/oradata/epm/DBS_EPMBUDGET_DATA03.dbf
    channel ORA_DISK_1: restoring datafile 00016 to /tqls_system/app/oracle/app/oradata/epm/DBS_EPMREP_DATA02.dbf
    channel ORA_DISK_1: restoring datafile 00017 to /tqls_system/app/oracle/app/oradata/epm/DBS_EPMBUDGET_DATA04.dbf
    channel ORA_DISK_1: restoring datafile 00018 to /tqls_system/app/oracle/app/oradata/epm/DBS_EPMBUDGET_INDEX04.dbf
    channel ORA_DISK_1: restoring datafile 00019 to /tqls_system/app/oracle/app/oradata/epm/DBS_EPMODS_DATA02.dbf
    channel ORA_DISK_1: restoring datafile 00020 to /tqls_system/app/oracle/app/oradata/epm/undotbs02.dbf
    channel ORA_DISK_1: restoring datafile 00021 to /tqls_system/app/oracle/app/oradata/epm/undotbs03.dbf
    channel ORA_DISK_1: restoring datafile 00022 to /tqls_system/app/oracle/app/oradata/epm/DBS_EPMODS_DATA03.dbf
    channel ORA_DISK_1: restoring datafile 00023 to /tqls_system/app/oracle/app/oradata/epm/DBS_EPMODS_DATA04.dbf
    channel ORA_DISK_1: restoring datafile 00024 to /tqls_system/app/oracle/app/oradata/epm/DBS_EPMODS_DATA05.dbf
    channel ORA_DISK_1: restoring datafile 00025 to /tqls_system/app/oracle/app/oradata/epm/DBS_EPMODS_DATA06.dbf
    channel ORA_DISK_1: restoring datafile 00026 to /tqls_system/app/oracle/app/oradata/epm/DBS_EPMODS_DATA07.dbf
    channel ORA_DISK_1: restoring datafile 00027 to /tqls_system/app/oracle/app/oradata/epm/DBS_EPMODS_DATA08.dbf
    channel ORA_DISK_1: restoring datafile 00028 to /tqls_system/app/oracle/app/oradata/epm/DBS_EPMODS_DATA09.dbf
    channel ORA_DISK_1: restoring datafile 00029 to /tqls_system/app/oracle/app/oradata/epm/DBS_EPMODS_DATA10.dbf
    channel ORA_DISK_1: restoring datafile 00030 to /tqls_system/app/oracle/app/oradata/epm/DBS_EPMODS_DATA11.dbf
    channel ORA_DISK_1: restoring datafile 00031 to /tqls_system/app/oracle/app/oradata/epm/DBS_EPMBUDGET_DATA05.dbf
    channel ORA_DISK_1: restoring datafile 00032 to /tqls_system/app/oracle/app/oradata/epm/DBS_EPMBUDGET_DATA06.dbf
    channel ORA_DISK_1: restoring datafile 00033 to /tqls_system/app/oracle/app/oradata/epm/DBS_EPMBUDGET_DATA07.dbf
    channel ORA_DISK_1: restoring datafile 00034 to /tqls_system/app/oracle/app/oradata/epm/DBS_EPMBUDGET_DATA08.dbf
    channel ORA_DISK_1: restoring datafile 00035 to /tqls_system/app/oracle/app/oradata/epm/DBS_EPMBUDGET_DATA09.dbf
    channel ORA_DISK_1: restoring datafile 00036 to /tqls_system/app/oracle/app/oradata/epm/DBS_EPMODS_DATA12.dbf
    channel ORA_DISK_1: restoring datafile 00037 to /tqls_system/app/oracle/app/oradata/epm/DBS_EPMODS_DATA13.dbf
    channel ORA_DISK_1: restoring datafile 00038 to /tqls_system/app/oracle/app/oradata/epm/DBS_EPMBUDGET_DATA10.dbf
    channel ORA_DISK_1: restoring datafile 00039 to /tqls_system/app/oracle/app/oradata/epm/DBS_EPMBUDGET_DATA11.dbf
    channel ORA_DISK_1: restoring datafile 00040 to /tqls_system/app/oracle/app/oradata/epm/DBS_EPMBUDGET_DATA12.dbf
    channel ORA_DISK_1: restoring datafile 00041 to /tqls_system/app/oracle/app/oradata/epm/DBS_EPMODS_DATA14.dbf
    channel ORA_DISK_1: restoring datafile 00042 to /tqls_system/app/oracle/app/oradata/epm/DBS_EPMODS_DATA15.dbf
    channel ORA_DISK_1: restoring datafile 00043 to /tqls_system/app/oracle/app/oradata/epm/DBS_EPMODS_DATA16.dbf
    channel ORA_DISK_1: restoring datafile 00044 to /tqls_system/app/oracle/app/oradata/epm/DBS_EPMODS_DATA17.dbf
    channel ORA_DISK_1: restoring datafile 00045 to /tqls_system/app/oracle/app/oradata/epm/DBS_EPMODS_DATA18.dbf
    channel ORA_DISK_1: restoring datafile 00046 to /tqls_system/app/oracle/app/oradata/epm/DBS_EPMODS_DATA19.dbf
    channel ORA_DISK_1: restoring datafile 00047 to /tqls_system/app/oracle/app/oradata/epm/DBS_EPMODS_DATA20.dbf
    channel ORA_DISK_1: restoring datafile 00048 to /tqls_system/app/oracle/app/oradata/epm/DBS_EPMODS_DATA21.dbf
    channel ORA_DISK_1: restoring datafile 00049 to /tqls_system/app/oracle/app/oradata/epm/DBS_EPMODS_DATA22.dbf
    channel ORA_DISK_1: restoring datafile 00050 to /tqls_system/app/oracle/app/oradata/epm/DBS_EPMODS_DATA23.dbf
    channel ORA_DISK_1: restoring datafile 00051 to /tqls_system/app/oracle/app/oradata/epm/DBS_EPMREP_DATA03.dbf
    channel ORA_DISK_1: restoring datafile 00052 to /tqls_system/app/oracle/app/oradata/epm/DBS_EPMBUDGET_DATA14.dbf
    channel ORA_DISK_1: restoring datafile 00053 to /tqls_system/app/oracle/app/oradata/epm/DBS_EPMBUDGET_DATA15.dbf
    channel ORA_DISK_1: restoring datafile 00054 to /tqls_system/app/oracle/app/oradata/epm/DBS_EPMODS_DATA24.dbf
    channel ORA_DISK_1: restoring datafile 00055 to /tqls_system/app/oracle/app/oradata/epm/DBS_EPMODS_DATA25.dbf
    channel ORA_DISK_1: restoring datafile 00056 to /tqls_system/app/oracle/app/oradata/epm/DBS_EPMODS_DATA26.dbf
    channel ORA_DISK_1: restoring datafile 00057 to /tqls_system/app/oracle/app/oradata/epm/DBS_EPMODS_DATA27.dbf
    channel ORA_DISK_1: restoring datafile 00058 to /tqls_system/app/oracle/app/oradata/epm/DBS_EPMODS_DATA28.dbf
    channel ORA_DISK_1: reading from backup piece /tqls_system/oracle_bak/EPM_DATA_20260105_m94d3skm_1_1.dbf
    channel ORA_DISK_1: piece handle=/tqls_system/oracle_bak/EPM_DATA_20260105_m94d3skm_1_1.dbf tag=TAG20260105T061757
    channel ORA_DISK_1: restored backup piece 1
    channel ORA_DISK_1: restore complete, elapsed time: 06:32:08
    Finished restore at 05-JAN-26
    Starting recover at 05-JAN-26
    using channel ORA_DISK_1
    using channel ORA_DISK_2
    starting media recovery
    archived log for thread 1 with sequence 67008 is already on disk as file /tqls_system/archivelog/1_67008_1083423494.dbf
    archived log for thread 1 with sequence 67009 is already on disk as file /tqls_system/archivelog/1_67009_1083423494.dbf
    archived log for thread 1 with sequence 67010 is already on disk as file /tqls_system/archivelog/1_67010_1083423494.dbf
    archived log for thread 1 with sequence 67011 is already on disk as file /tqls_system/archivelog/1_67011_1083423494.dbf
    archived log for thread 1 with sequence 67012 is already on disk as file /tqls_system/archivelog/1_67012_1083423494.dbf
    archived log for thread 1 with sequence 67013 is already on disk as file /tqls_system/archivelog/1_67013_1083423494.dbf
    archived log for thread 1 with sequence 67014 is already on disk as file /tqls_system/archivelog/1_67014_1083423494.dbf
    archived log for thread 1 with sequence 67015 is already on disk as file /tqls_system/archivelog/1_67015_1083423494.dbf
    archived log for thread 1 with sequence 67016 is already on disk as file /tqls_system/archivelog/1_67016_1083423494.dbf
    archived log for thread 1 with sequence 67017 is already on disk as file /tqls_system/archivelog/1_67017_1083423494.dbf
    archived log for thread 1 with sequence 67018 is already on disk as file /tqls_system/archivelog/1_67018_1083423494.dbf
    archived log for thread 1 with sequence 67019 is already on disk as file /tqls_system/archivelog/1_67019_1083423494.dbf
    archived log for thread 1 with sequence 67020 is already on disk as file /tqls_system/archivelog/1_67020_1083423494.dbf
    archived log for thread 1 with sequence 67021 is already on disk as file /tqls_system/archivelog/1_67021_1083423494.dbf
    archived log for thread 1 with sequence 67022 is already on disk as file /tqls_system/archivelog/1_67022_1083423494.dbf
    archived log for thread 1 with sequence 67023 is already on disk as file /tqls_system/archivelog/1_67023_1083423494.dbf
    archived log for thread 1 with sequence 67024 is already on disk as file /tqls_system/archivelog/1_67024_1083423494.dbf
    archived log for thread 1 with sequence 67025 is already on disk as file /tqls_system/archivelog/1_67025_1083423494.dbf
    archived log for thread 1 with sequence 67026 is already on disk as file /tqls_system/archivelog/1_67026_1083423494.dbf
    archived log for thread 1 with sequence 67027 is already on disk as file /tqls_system/archivelog/1_67027_1083423494.dbf
    archived log for thread 1 with sequence 67028 is already on disk as file /tqls_system/archivelog/1_67028_1083423494.dbf
    archived log for thread 1 with sequence 67029 is already on disk as file /tqls_system/archivelog/1_67029_1083423494.dbf
    archived log for thread 1 with sequence 67030 is already on disk as file /tqls_system/archivelog/1_67030_1083423494.dbf
    archived log for thread 1 with sequence 67031 is already on disk as file /tqls_system/archivelog/1_67031_1083423494.dbf
    archived log for thread 1 with sequence 67032 is already on disk as file /tqls_system/archivelog/1_67032_1083423494.dbf
    archived log for thread 1 with sequence 67033 is already on disk as file /tqls_system/archivelog/1_67033_1083423494.dbf
    archived log for thread 1 with sequence 67034 is already on disk as file /tqls_system/archivelog/1_67034_1083423494.dbf
    archived log for thread 1 with sequence 67035 is already on disk as file /tqls_system/archivelog/1_67035_1083423494.dbf
    archived log for thread 1 with sequence 67036 is already on disk as file /tqls_system/archivelog/1_67036_1083423494.dbf
    archived log for thread 1 with sequence 67037 is already on disk as file /tqls_system/archivelog/1_67037_1083423494.dbf
    archived log for thread 1 with sequence 67038 is already on disk as file /tqls_system/archivelog/1_67038_1083423494.dbf
    archived log for thread 1 with sequence 67039 is already on disk as file /tqls_system/archivelog/1_67039_1083423494.dbf
    archived log for thread 1 with sequence 67040 is already on disk as file /tqls_system/archivelog/1_67040_1083423494.dbf
    archived log for thread 1 with sequence 67041 is already on disk as file /tqls_system/archivelog/1_67041_1083423494.dbf
    archived log for thread 1 with sequence 67042 is already on disk as file /tqls_system/archivelog/1_67042_1083423494.dbf
    archived log for thread 1 with sequence 67043 is already on disk as file /tqls_system/archivelog/1_67043_1083423494.dbf
    archived log for thread 1 with sequence 67044 is already on disk as file /tqls_system/archivelog/1_67044_1083423494.dbf
    archived log for thread 1 with sequence 67045 is already on disk as file /tqls_system/archivelog/1_67045_1083423494.dbf
    archived log file name=/tqls_system/archivelog/1_67008_1083423494.dbf thread=1 sequence=67008
    archived log file name=/tqls_system/archivelog/1_67009_1083423494.dbf thread=1 sequence=67009
    archived log file name=/tqls_system/archivelog/1_67010_1083423494.dbf thread=1 sequence=67010
    archived log file name=/tqls_system/archivelog/1_67011_1083423494.dbf thread=1 sequence=67011
    archived log file name=/tqls_system/archivelog/1_67012_1083423494.dbf thread=1 sequence=67012
    archived log file name=/tqls_system/archivelog/1_67013_1083423494.dbf thread=1 sequence=67013
    archived log file name=/tqls_system/archivelog/1_67014_1083423494.dbf thread=1 sequence=67014
    archived log file name=/tqls_system/archivelog/1_67015_1083423494.dbf thread=1 sequence=67015
    archived log file name=/tqls_system/archivelog/1_67016_1083423494.dbf thread=1 sequence=67016
    archived log file name=/tqls_system/archivelog/1_67017_1083423494.dbf thread=1 sequence=67017
    archived log file name=/tqls_system/archivelog/1_67018_1083423494.dbf thread=1 sequence=67018
    archived log file name=/tqls_system/archivelog/1_67019_1083423494.dbf thread=1 sequence=67019
    archived log file name=/tqls_system/archivelog/1_67020_1083423494.dbf thread=1 sequence=67020
    archived log file name=/tqls_system/archivelog/1_67021_1083423494.dbf thread=1 sequence=67021
    archived log file name=/tqls_system/archivelog/1_67022_1083423494.dbf thread=1 sequence=67022
    archived log file name=/tqls_system/archivelog/1_67023_1083423494.dbf thread=1 sequence=67023
    archived log file name=/tqls_system/archivelog/1_67024_1083423494.dbf thread=1 sequence=67024
    archived log file name=/tqls_system/archivelog/1_67025_1083423494.dbf thread=1 sequence=67025
    archived log file name=/tqls_system/archivelog/1_67026_1083423494.dbf thread=1 sequence=67026
    archived log file name=/tqls_system/archivelog/1_67027_1083423494.dbf thread=1 sequence=67027
    archived log file name=/tqls_system/archivelog/1_67028_1083423494.dbf thread=1 sequence=67028
    archived log file name=/tqls_system/archivelog/1_67029_1083423494.dbf thread=1 sequence=67029
    archived log file name=/tqls_system/archivelog/1_67030_1083423494.dbf thread=1 sequence=67030
    archived log file name=/tqls_system/archivelog/1_67031_1083423494.dbf thread=1 sequence=67031
    archived log file name=/tqls_system/archivelog/1_67032_1083423494.dbf thread=1 sequence=67032
    archived log file name=/tqls_system/archivelog/1_67033_1083423494.dbf thread=1 sequence=67033
    archived log file name=/tqls_system/archivelog/1_67034_1083423494.dbf thread=1 sequence=67034
    archived log file name=/tqls_system/archivelog/1_67035_1083423494.dbf thread=1 sequence=67035
    archived log file name=/tqls_system/archivelog/1_67036_1083423494.dbf thread=1 sequence=67036
    archived log file name=/tqls_system/archivelog/1_67037_1083423494.dbf thread=1 sequence=67037
    archived log file name=/tqls_system/archivelog/1_67038_1083423494.dbf thread=1 sequence=67038
    archived log file name=/tqls_system/archivelog/1_67039_1083423494.dbf thread=1 sequence=67039
    archived log file name=/tqls_system/archivelog/1_67040_1083423494.dbf thread=1 sequence=67040
    archived log file name=/tqls_system/archivelog/1_67041_1083423494.dbf thread=1 sequence=67041
    archived log file name=/tqls_system/archivelog/1_67042_1083423494.dbf thread=1 sequence=67042
    archived log file name=/tqls_system/archivelog/1_67043_1083423494.dbf thread=1 sequence=67043
    archived log file name=/tqls_system/archivelog/1_67044_1083423494.dbf thread=1 sequence=67044
    archived log file name=/tqls_system/archivelog/1_67045_1083423494.dbf thread=1 sequence=67045
    media recovery complete, elapsed time: 00:10:51
    Finished recover at 05-JAN-26
    RMAN>

五、打开数据库和监听器
    [oracle@epm-db-sundaily dbs]$ sqlplus / as sysdba
    SQL*Plus: Release 12.2.0.1.0 Production on Tue Jan 6 06:56:20 2026
    Copyright (c) 1982, 2016, Oracle.  All rights reserved.
    Connected to:
    Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production
    SQL> alter database open resetlogs
      2  ;
    Database altered.
    SQL> exit
    Disconnected from Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production
    [oracle@epm-db-sundaily dbs]$ lsnrctl status
    LSNRCTL for Linux: Version 12.2.0.1.0 - Production on 06-JAN-2026 07:00:44
    Copyright (c) 1991, 2016, Oracle.  All rights reserved.
    Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=epm-db-sundaily)(PORT=1521)))
    TNS-12541: TNS:no listener
     TNS-12560: TNS:protocol adapter error
      TNS-00511: No listener
       Linux Error: 111: Connection refused
    Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))
    TNS-12541: TNS:no listener
     TNS-12560: TNS:protocol adapter error
      TNS-00511: No listener
       Linux Error: 2: No such file or directory
    [oracle@epm-db-sundaily dbs]$ lsnrctl start
    LSNRCTL for Linux: Version 12.2.0.1.0 - Production on 06-JAN-2026 07:00:46
    Copyright (c) 1991, 2016, Oracle.  All rights reserved.
    Starting /tqls_system/app/oracle/app/product/12.2.0/bin/tnslsnr: please wait...
    TNSLSNR for Linux: Version 12.2.0.1.0 - Production
    System parameter file is /tqls_system/app/oracle/app/product/12.2.0/network/admin/listener.ora
    Log messages written to /tqls_system/app/oracle/app/diag/tnslsnr/epm-db-sundaily/listener/alert/log.xml
    Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=epm-db-sundaily)(PORT=1521)))
    Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
    Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=epm-db-sundaily)(PORT=1521)))
    STATUS of the LISTENER
    ------------------------
    Alias                     LISTENER
    Version                   TNSLSNR for Linux: Version 12.2.0.1.0 - Production
    Start Date                06-JAN-2026 07:00:46
    Uptime                    0 days 0 hr. 0 min. 0 sec
    Trace Level               off
    Security                  ON: Local OS Authentication
    SNMP                      OFF
    Listener Parameter File   /tqls_system/app/oracle/app/product/12.2.0/network/admin/listener.ora
    Listener Log File         /tqls_system/app/oracle/app/diag/tnslsnr/epm-db-sundaily/listener/alert/log.xml
    Listening Endpoints Summary...
      (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=epm-db-sundaily)(PORT=1521)))
      (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
    Services Summary...
    Service "epm" has 1 instance(s).
      Instance "epm", status UNKNOWN, has 1 handler(s) for this service...
    The command completed successfully
    [oracle@epm-db-sundaily dbs]$