recover success ,but ORA-01547

Clark_1130

于 2022-11-27 21:27:19 发布

阅读量414

点赞数

分类专栏： Oracle® Database SQL Reference 文章标签： oracle 数据库

本文链接：https://blog.csdn.net/qq_23170065/article/details/128069985

版权

Oracle® Database SQL Reference 专栏收录该内容

5 篇文章 0 订阅

订阅专栏

最近在做备库rman备份恢复测试，最后发现因缺少archive log导致无法恢复。于是尝试在archive log丢失的情况下做不完全恢复：

问题现象：

---------------------------------------------------
RMAN> run {
ALLOCATE CHANNEL ch00 TYPE 'SBT_TAPE' parms 'ENV=(NB_ORA_CLIENT=l01test01)';
recover database until scn 36364245312048;
release channel ch00;
}2> 3> 4> 5>

released channel: ORA_SBT_TAPE_1
released channel: ORA_DISK_1
allocated channel: ch00
channel ch00: SID=361 device type=SBT_TAPE
channel ch00: Veritas NetBackup for Oracle - Release 10.0 (2022021519)

Starting recover at 08-NOV-22

starting media recovery
Oracle Error:
ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below
ORA-01194: file 1 needs more recovery to be consistent
ORA-01110: data file 1: '/u02/oradata/orcl/system.258.963133925'

media recovery complete, elapsed time: 00:00:02

Finished recover at 08-NOV-22

released channel: ch00

Error Codes
---------------------------------------------------
ORA-01547

不完全恢复方法过程：

alter system set UNDO_MANAGEMENT=manual scope=spfile;
create pfile='/tmp/pfile.ora' from spfile;
vim /tmp/pfile.ora
#注释掉 UNDO_TABLESPACE 和 UNDO_RETENTION 
#添加 JOB_QUEUE_PROCESSES=0 , _ALLOW_RESETLOGS_CORRUPTION = TRUE 
#添加event="21307096 trace name context forever, level 1" 

#启动数据库至mount 状态
sqlplus / as sysdba
startup pfile ='/tmp/pfile.ora'

#做虚拟恢复
SQL> recover database using backup controlfile until cancel;
输如 CANCEL 大写

#启动数据库
alter database open resetlogs;