Point in Time Recovery

Explain the steps to perform the point in time recovery with a backup which is taken before the resetlogs of the db?

shanthiavari
Profile Answers by shanthiavari Questions by shanthiavari
Jun 10th, 2008
3
3026

Showing Answers 1 - 3 of 3 Answers

satyam_2007
Profile Answers by satyam_2007

Dec 14th, 2009

RMAN can perform recovery of the whole database to a specified past time, SCN, or log sequence number. This type of recovery is sometimes called incomplete recovery because it does not completely use all of the available redo.
Incomplete recovery of the whole database is also called database point-in-time recovery (DBPITR).
1. Rman> RUN{ SET UNTIL TIME 'Nov 15 2002 09:00:00'; # SET UNTIL SCN 1000;
# alternatively, specify SCN
# SET UNTIL SEQUENCE 9923;
# alternatively, specify log sequence number RESTORE DATABASE;
RECOVER DATABASE;}