Database Backup and Recovery (MOSC)

MOSC Banner

Unable recover database and open resstelogs

edited Nov 14, 2017 9:16PM in Database Backup and Recovery (MOSC) 9 commentsAnswered ✓

RMAN> recover database;

Starting recover at 29-OCT-17

using channel ORA_DISK_1

using channel ORA_DISK_2

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: '+TEST_AREA/uat9/datafile/system.323.958652285'

RMAN-00571: ===========================================================

RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============

RMAN-00571: ===========================================================

RMAN-03002: failure of recover command at 10/29/2017 17:30:42

RMAN-06053: unable to perform media recovery because of missing log

RMAN-06025: no backup of archived log for thread 1 with sequence 1687 and starting SCN of 6187267477866 found to restore

But last log sequence is 1694.

Please help to recover and open database.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

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

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center