7 Replies Latest reply: Jan 9, 2013 1:55 AM by Niket Kumar RSS

    RMAN restore

    DOA
      Hello All,

      we are running 11g on LINUX and is our PROD.

      we have rman implemented, the retention policy is 7 days.

      Flashback is not ON.

      We have some data missing on a perticular table which belongs to 27th DEC-2012 to 3rd of JAN 2013.

      after the before said date data is currently available.

      So basically we need to see data of this perticular days.


      Kindly suggest a way.
        • 1. Re: RMAN restore
          sb92075
          DOA wrote:
          Hello All,

          we are running 11g on LINUX and is our PROD.

          we have rman implemented, the retention policy is 7 days.
          Given that today is 8 January, you don't have any 2012 data.
          • 2. Re: RMAN restore
            Niket Kumar
            restore you backup on other machine taking old backups and you can get that table data...
            • 3. Re: RMAN restore
              Aman....
              You just want to see the data or want to permanently get it back? If the answer is yes for the 2nd option than you would need to do a TSPIT recovery for this table.
              http://docs.oracle.com/cd/B28359_01/backup.111/b28270/rcmtspit.htm

              Aman....
              • 4. Re: RMAN restore
                DOA
                Hi,

                we have all data before 27th DEC 2012 and after 3rd JAN 2013

                the missing data date range is between 27th DEC-2012 to 3rd of JAN 2013.
                • 5. Re: RMAN restore
                  kuljeet singh -
                  DOA wrote:
                  Hi,

                  we have all data before 27th DEC 2012 and after 3rd JAN 2013

                  the missing data date range is between 27th DEC-2012 to 3rd of JAN 2013.
                  so do restoration of backup which was taken on these day into another machine.
                  • 6. Re: RMAN restore
                    DOA
                    We have last backup of rman till 2nd JAN2013 only and we are looking for the object status from 27th DEC 2012.

                    Kindly suggest ...
                    • 7. Re: RMAN restore
                      Niket Kumar
                      try to restore backup of 2nd..... may be you get the rows....other wise wait for guru's to reply.... AFAIK you are not able to restore the database to 27th untill you have old backup which is taken before 27th.

                      and move your question to RMAN category.