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

    backup set /piece info

    user13809017
      Hi,

      Application guy deleted few rows.
      So I am asked to do tablespace point time recovery in 11.2.0.3 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
      RECID
      STAMP
      SET_STAMP
      SET_COUNT

      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?

      Thanks.