Automated Tablespace Point-In Time Recovery

Pre-requistie for automated Tablespace Point-In Time Recovery:-

---------------------------------------------------------------

1. Specifiy the auxiliary location for rman to restore auxiliary datafiles.

2. Configure the auxiliary channel on target database.



Step:-

-----------

1. Run the below script.

run {

recover tablespace users

until logseq xxx thread 1

auxiliary destination '/u01/temp';

}

How rman works.

a. Rman creates a auxiliary instance , starts it up and connect to it ,

if there is no connection to auxiliary instance.

b. Rman makes the tablespace users offline , in target database.

c. Rman restores backup control file before point in time to the auxiliary instance.

d. Rman restores datafiles from the recovery set and the auxiliary

set to the auxiliary instance.

e. The restored data files are recovered till point in time in auxiliary instance.

f. Rman opens auxiliary instance with resetlogs option.

g. Rman exports the dictionary metadata about the object.

h. It shuts down the auxiliary instance.

i. Rman issues the switch command on the target database to the recovered auxiliary

instance tablespace.

j. Dictionay metadata are imported in the target database.

k. Deletion of auxiliary set files.



------------