2 Replies Latest reply: Feb 5, 2013 4:46 PM by L-MachineGun RSS

    backup set /piece info


      Application guy deleted few rows.
      So I am asked to do tablespace point time recovery in on aix using old backup(two week before taken).
      I would like to check how many backup set and piece name in a L0 backup.Is there any query?

      Most of the V$backup_* views contains the following columns

      what is the use of it?

      We taking backup in disk on production machine.We going to do TPIR on test machine.So that we moved particular backup set to tape.Os team changed TPO file settings.
      While restoring control file,we got the following info.
      channel t1: no autobackup in

      Even we specified until time clause.

      How to check what are the control file's and backup piece aviable in a tape?