Pavan DBA's Blog

The DBA Knowledge Store

until time reovery using RMAN

Posted by Pavan DBA on March 18, 2010

Generally until time recovery will be used to move the database to a particular time in the past (from 10g you can do the same using FLASHBACK which we will discuss later). Maximum times we will do this because of loosing important table.

One thing we need to keep in mind before performing until time recovery is to get acceptance from all the users as it will rollback their changes

The following are the steps to do that using RMAN

set until time ‘2010-03-18:12:00:00′;
restore database;
recover database;

sometimes you may get below error

RMAN-03002: failure of set command at 09/25/2007:11:08:52
ORA-01861: literal does not match format string

this is because your NLS_DATE_FORMAT is not set correctly. in such case, first export your NLS_DATE_FORMAT parameters and then invoke RMAN

export NLS_DATE_FORMAT=’YYYY-MM-DD:hh24:mi:ss’

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

%d bloggers like this: