暂无图片
rman恢复完成后提示ORA-01589: must use RESETLOGS or NORESETLOGS option for database open
我来答
分享
黄伟
2020-10-04
rman恢复完成后提示ORA-01589: must use RESETLOGS or NORESETLOGS option for database open
暂无图片 10M

错误信息:
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: {=suggested | filename | AUTO | CANCEL}
/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.归档日志文件解压出来?

我来答
添加附件
收藏
分享
问题补充
1条回答
默认
最新
Moone

catalog backuppiece ‘/rmanback/2020092922_2uvblll3_1_1.arch’;
restore archivelog from sequence 188972;

暂无图片 评论
暂无图片 有用 0
回答交流
提交
问题信息
请登录之后查看
邀请回答
暂无人订阅该标签,敬请期待~~
暂无图片墨值悬赏