Database Backup and Recovery (MOSC)

MOSC Banner

Point-In-Time Recovery database : until time failed

edited Jan 3, 2014 4:40AM in Database Backup and Recovery (MOSC) 4 commentsAnswered
 I have a problem to restore backup prod to dev server , there is a scenario  :

ON PROD :

o  28/12 Backup full for data base

o  29/12 backup archivelog

o  30/12 backup control file to trace

 On DEV server :

o  I restore control file

o  I use  until clause (i choose a date time , arbitrary,  between start full backup and the end of archive log backup)

        SET UNTIL TIME "to_date('2013-12-29:12:00:00','YYYY-MM-DD:HH24:MI:SS')";

o  Restore

o recover database  :  The recover  failed with error :

RMAN-03002: failure of recover command at 01/02/2014 16:47:15

ORA-00283: recovery session canceled due to errors

RMAN-11003: failure during parse/execution of SQL statement: alter database recover if needed

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