Restore Preview Reports RMAN-05119 and Recover Database Reports RMAN-06054 ( Multi-tenant ) (Doc ID 2233445.1)

Last updated on MAY 09, 2017

Applies to:

Oracle Database - Enterprise Edition - Version 12.1.0.1 to 12.2.0.1 [Release 12.1 to 12.2]
Information in this document applies to any platform.

Symptoms

In Multi-tenant Database (Version 12.1.0.1.2)


(1)  Restore Database Preview reports  'RMAN-05119: recovery can not be done to a consistent state' although we have level 0/Full Database backup along with archivelogs backup to clear the Fuzziness

{ Output Truncated }
RMAN>

run {
ALLOCATE CHANNEL CH1 DEVICE TYPE sbt_tape parms 'SBT_LIBRARY=/u01/app/oracle/product/12.1.0/dbhome_1/lib/libopc.so,
ENV=(OPC_PFILE=/u01/app/oracle/product/12.1.0/dbhome_1/dbs/opcConfig.ora)';

restore database preview;  }

allocated channel: CH1
channel CH1: SID=249 device type=SBT_TAPE
channel CH1: Oracle Database Backup Service Library VER=3.16.9.21

Starting restore at 14-FEB-17
Starting restore at 14-FEB-17

List of Backup Sets
==================

BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
20 Full 549.75M SBT_TAPE 06:37:35 13-FEB-17
BP Key: 20 Status: AVAILABLE Compressed: NO Tag: TAG20170212T201557
..
..

new media label is "em2.storage.oraclecloud.com/v1/Storage-froracleco74955/crskConta" for piece "0prsem3o_1_1"
validation succeeded for backup piece
RMAN-05119: recovery can not be done to a consistent state.                                                                      <<<<<<<<<<<<<<<<<<<
Media recovery start SCN is 2819679
Recovery must be done beyond SCN 2836475 to clear datafile fuzziness
new media label is "em2.storage.oraclecloud.com/v1/Storage-froracleco74955/crskConta" for piece "06rsdsft_1_1"
..
new media label is "em2.storage.oraclecloud.com/v1/Storage-froracleco74955/crskConta" for piece "0lrseguo_1_1"
validation succeeded for backup piece
Finished restore at 14-FEB-17
released channel: CH1

(2)  Recover Database also errors out 'RMAN-06054: media recovery requesting unknown archived log for... starting SCN of xxxxx" during recovery

RMAN> recover database ;
allocated channel: CH1
channel CH1: SID=249 device type=SBT_TAPE
channel CH1: Oracle Database Backup Service Library VER=3.16.9.21

Starting recover at 14-FEB-17

starting media recovery
..
..

channel CH1: restored backup piece 1
channel CH1: restore complete, elapsed time: 00:00:01
archived log file name=/u04/oradata/121cdb/arch/1_51_931000987.arc thread=1 sequence=51
unable to find archived log
archived log thread=1 sequence=52
released channel: CH1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 02/14/2017 09:49:47
RMAN-06054: media recovery requesting unknown archived log for thread 1 with sequence n and starting SCN of xxxxx               <<<<<<<<<<<<<

RMAN>

 

Changes

Database upgraded to 12.1.0.1.2 and valid full database with archivelogs backup exists.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms