
错误信息:
Recovery Manager complete.
[oracle@localhost ~]$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.4.0 Production on Sun Oct 4 21:42:13 2020
Copyright © 1982, 2013, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL> shutdown immediate;
ORA-01109: database not open
Database dismounted.
ORACLE instance shut down.
SQL> startup;
ORACLE instance started.
Total System Global Area 2137886720 bytes
Fixed Size 2254952 bytes
Variable Size 587204504 bytes
Database Buffers 1543503872 bytes
Redo Buffers 4923392 bytes
Database mounted.
ORA-01589: must use RESETLOGS or NORESETLOGS option for database open
SQL> alter database open resetlogs;
alter database open resetlogs
*
ERROR at line 1:
ORA-01194: file 1 needs more recovery to be consistent
ORA-01110: data file 1: ‘/home/his1/data/system.dbf’
SQL> recover database using backup controlfile;
ORA-00279: change 29964408689 generated at 09/29/2020 22:00:53 needed for
thread 1
ORA-00289: suggestion :
+FRADG/his1/archivelog/2020_09_29/thread_1_seq_188972.2047.1052431387
ORA-00280: change 29964408689 for thread 1 is in sequence #188972
Specify log: {
/rmanback/2020092922_2uvblll3_1_1.arch
ORA-00317: file type 0 in header is not log file
ORA-00334: archived log: ‘/rmanback/2020092922_2uvblll3_1_1.arch’
SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
[oracle@localhost ~]$ ls -l /rmanback/
total 357761608
-rw-r–r-- 1 root root 359088439296 Oct 2 04:03 2020092922_2rvblksk_1_1.bak
-rw-r–r-- 1 root root 135856128 Sep 30 16:32 2020092922_2svbllja_1_1.bak
-rw-r–r-- 1 root root 3551862272 Sep 30 16:41 2020092922_2tvbllks_1_1.arch
-rw-r–r-- 1 root root 3435900416 Sep 30 16:50 2020092922_2uvblll3_1_1.arch
-rw-r–r-- 1 root root 135823360 Sep 30 16:50 2020092922_ctlf.bak
[oracle@localhost ~]$
缺失的文件日志文件在/rmanback/2020092922_2uvblll3_1_1.arch 中,我应该如何将2020092922_ctlf.归档日志文件解压出来?