Database Administration (MOSC)

MOSC Banner

restore from NBU end up with ORA-01110,ORA-01194

edited Dec 13, 2017 8:34PM in Database Administration (MOSC) 2 commentsAnswered ✓

oracle 12.1

while restore from NBU ,will end up with following error:

channel ch01: starting archived log restore to default destination
channel ch01: restoring archived log
archived log thread=1 sequence=1274
channel ch01: reading from backup piece al_2768_1_962612723
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: '/oradata/ap16/datafile2/PHKSTUA1/system_01.dbf'

released channel: ch01
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 12/13/2017 16:45:12
ORA-27192: skgfcls: sbtclose2 returned error - failed to close file
ORA-19511: non RMAN, but media manager or vendor specific failure, error text:

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