If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

The database must be closed to perform database point-in-time recovery. Note that if you are recovering to
a time, you should set the time format environment variables before invoking RMAN (see "Setting NLS
Environment Variables"). For example, enter:

3.Determine which time you want to recover to. For example, if you discover at 9:15 a.m. that a user
accidentally dropped a tablespace at 9:02 a.m., then you can recover to 9 a.m.--just before the drop
occurred. You will lose all changes to the database made since that time.

4.Perform the following operations within your run command:

a.Set the end recovery time using the date format specified in your NLS_LANG and
NLS_DATE_FORMAT environment variables.

b.Allocate channels.

c.Restore the database.

d.Recover the database.

e.Open the database with the RESETLOGS option.

For example, this job performs an incomplete recovery until Nov 15 at 9 a.m.

3.Determine the SCN to which you want to recover. For example, if you made a backup of tablespace
TBS_1 and then shortly afterwards a user accidentally overwrote a datafile in TBS_3, then you can issue
a list command to determine the SCN for the TBS_1 backup and then restore yesterday's whole
database backup and recover to that SCN.