Restore Preview Reports RMAN-05119 and Recover Database Reports RMAN-06054 ( Multi-tenant )
(Doc ID 2233445.1)
Last updated on AUGUST 17, 2020
Applies to:
Oracle Database - Enterprise Edition - Version 12.1.0.1 to 12.2.0.1 [Release 12.1 to 12.2]Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
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 "<label>" for piece "<piece name>"
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 "<label>" for piece "<piece name>"
..
new media label is "<label>" for piece "<piece name>"
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=<path>/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
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Symptoms |
| Changes |
| Cause |
| Solution |
| References |