Database Backup and Recovery (MOSC)

MOSC Banner

Restore database to before time from recent backup

edited Feb 5, 2015 10:00AM in Database Backup and Recovery (MOSC) 9 commentsAnswered

Hi All,

I need to restore the database to 14th Dec. Full database is available for 15th Dec.

Can I restore it till 14th DEC using until clause.

startup database in nomount stage.


restore controlfile from 14th backup

Run

{

<span style="font-size: 10.0pt; color: #1f497d;">set</span> <span style="font-size: 10.0pt; color: #1f497d;">until time "to_date('14-12-2014:10:00:00','DD-MM-YYYY:HH24:MI:SS')";</span>

restore database;

}


Will this is applicable to restore to before time using until time rman clause.


Env Details - 

OS - Linux 5.7

Database - 11.2.0.4


Please suggest.

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