Recovery Manager-IV

Recovery Manager-IV

 

 

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 tech 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  tech online;

Maintenance commands

 

1. Updating the catalog

             Eg:

                 Rman>crosscheck backup;

                 Rman>crosscheck backupset;

                 Rman>crosscheck archivelog all:

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;   

Rman>validate database; // to verify corruption

                                                                (OR)

                                 Block corruption

]$dd of=datafilename bs=8192 conv=notrunc seek=131 <<EOF

    #MESSEAGE#

    EOF

 

      Rman> validate database;

      Rman>list failure; (list block corruption and data failure)

      Rman>list failure <id>

      Rman>advise failure;

      Rman >repair failure;

View:

V$database_block_corruption

Parallel backup through section(chunks)       

        Rman>run

      {

      Allocate channel c1 device type disk;

      Allocate channel c2 device type disk;

      Allocate channel c3 device type disk;

      Backup datafile 4 section size 500m;

      }