Skip to content

RMAN restore validate and preview

Here are steps to follow for restore validate and preview.

I did practice to restore database 30 days ago and it was useful before performing actual steps.

i found for one date data file and archive log were available but not control file so i need to forward date until i find control file. so it was very helpful before performing real time restore so we do waste time in critical moment.

rman
connect target “c##rman/a123@abc as sysbackup”

— restore preview

run
{
set until time “to_date(‘2019-30-06:23:00:00′,’yyyy-dd-mm:hh24:mi:ss’)”;
restore database preview;
}

— restore validate

run
{
set until time “to_date(‘2019-30-06:23:00:00′,’yyyy-dd-mm:hh24:mi:ss’)”;
restore database validate;
}

— from restore preview result get sequence and validate

run
{
restore archivelog from sequence 1246 until sequence 1248 thread 1 validate;
restore archivelog from sequence 1036 until sequence 1037 thread 2 validate;
}

— control file and spfile validate

run
{
set until time “to_date(‘2019-30-06:23:00:00′,’yyyy-dd-mm:hh24:mi:ss’)”;
restore controlfile validate;
restore spfile validate;
}

note: all of the above steps should be successful in order to perform real time restore.

 

 

No comments yet

Leave a Reply

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

WordPress.com Logo

You are commenting using your WordPress.com 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: