Database Memory & 4030/4031 (MOSC)

MOSC Banner

11g Database restore from last backup failing

edited Mar 1, 2015 10:52PM in Database Memory & 4030/4031 (MOSC) 3 commentsAnswered


Hi,

I am trying to restore database from last nights backup.   But  it is failing.

RMAN> run {

2> restore database until time "to_date('2015-01-21 08:37:00', 'YYYY-MM-DD HH24:MI:SS')";

3> recover database until time "to_date('2015-01-21 08:37:00', 'YYYY-MM-DD HH24:MI:SS')";

4> }

Starting restore at 21-JAN-15

allocated channel: ORA_DISK_1

channel ORA_DISK_3: restore complete, elapsed time: 00:02:45

Finished restore at 21-JAN-15

Starting recover at 21-JAN-15

using channel ORA_DISK_1

using channel ORA_DISK_2

using channel ORA_DISK_3

using channel ORA_DISK_4

starting media recovery

Oracle Error:

ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below

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