RMAN - IV (TSPITR, corrupted block Recovery)

Tablespace Point in time recovery (TSPITR):

Push the tablespace to past time.

Steps:

        1. Create a directory that will keep the auxiliary database

                 $auxdb 

        2. Recover the tablespace up to a particular time by following command:

                 Rman>recover tablespace users until time “to_date(’19:49:53 21-oct-                           2010’,’hh24:mi:ss dd-mon- yyyy’)”  auxiliary destination                   ‘/u01/user18/auxdb’;

          3. Online tablespace

                 Sql>alter tablespace users online;

Maintenance commands

1.    Updating the catalog

             Eg:

                 Rman>crosscheck backup;

                 Rman>crosscheck backupset;

2.    Re-synchronization of catalog

                 Rman>resync catalog;

3.    Taking backup of image copy of datafile

                 Rman>backup as copy datafile 4 ;

Block recovery

 Using rman we can recover corrupted block using following commands

Rman>blockrecover datafile 4 block 1233;

Rman>blockrecover corruption list;

Rman>backup validate database;// to verify corruption

View:

V$database_block_corruption