暂无图片
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
打赏 0
回答交流
Markdown


请输入正文
提交
相关推荐
Redo log file 大小分配问题
回答 1
可参考Archivedredologis(significant)smallerthantheredologfile.(文档ID1356604.1)的算法说明:1、logfile大小对unfill的l
Oracle如何删除大表的重复记录
回答 4
已采纳
这个当然是用开窗函数结合rowid定位记录更快,这样就只要根据rowid删数据就好了。createtabletemprdasselectrdfrom(selectrowidrd,rownumber()
Oracle中的ora_p00x_sid的进程不释放是怎么原因?
回答 2
1、找到该进程的进程号;psef|greporap00xsid2、查看进程的会话情况selectinstid||':'||sid||','||serialssid,username,sqlid,eve
各位大佬问个问题,我在用人rman恢复数据库时,在这个过程中提示要备份时间点之前的归档日志,数据文件的scn大于需要的归档日志的scn,这个怎么回事?怎么处理呢
回答 2
需要redo在线日志,如果没有,则会丢失部分数据。
ORA-01554 reason: no undo segment found with available slot
回答 4
好像是个数据库BUG,我看我的阻塞事件是“libcacheinterruptactionbyLCK”,疑似BUG30384121.我的库是12.2R2版本
Oracle的ARRAYSIZE对逻辑I/O的影响?
回答 9
已采纳
ARRAYSIZE对逻辑I/O的影响是个很有意思的话题。ARRAYSIZE是数据库每个批次向客户端返回的行数。客户端会缓存这些行,处理完这些缓存的数据之后,它会向数据库请求下一批数据。ARRAYSIZ
oracle 中调整字段精度有哪些方法?
回答 1
已采纳
✅oracle调整字段精度的四种方法:调整方式一:(精度只能调大不能调小)altertabletablenameaMODIFY(columnAXXnumber(27,15));调整方式二:(借用一个新
怎么查看打过的GI补丁,lspatches\lsinventory看不到对应的GI PSU号码
回答 1
你看到的就是对的,31718723这是一个GIPSU的合集,包含了下面几个部分,打完之后你只能看到下面图里这几个应用于各个具体部分的patchnumber,而不会看到合集的父patch代号317187
Oracle数据库怎样抓出带有自定义函数的SQL?
回答 6
已采纳
在开发过程中,应该避免在SQL语句中调用自定义函数,可以通过以下SQL语句抓出调用了自定义函数的SQL。selectdistinctsqlid,sqltext,module fromV$SQ
Oracle的用rman做备份,有什么场景需要每隔十分钟要对本机做一次增量备份?
回答 8
如果是客户提的要求还可以理解呵!