4 Replies Latest reply: Jul 24, 2013 12:53 PM by Hermes_Pimentel RSS

    REPORT NEED BACKUP n DAYS - Diferent results from control/catalog

    Hermes_Pimentel

      Hi there,

       

       

      I have a Oracle Database running on 10gR2 and using a RMAN catalog to backups, all the last 5 FULL backups were completed as expected, no errors, no warnings.

       

       

      . When I execute "REPORT NEED BACKUP 2 DAYS" on RMAN using the catalog they show this:

       

       

       

      Report of files whose recovery needs more than 2 days of archived logs

      File Days  Name

      ---- ----- -----------------------------------------------------

       

       

       

      This is OK, because I don't have datafiles that need more than 2 days off archives to be restored.

       

      So... when I try the same command using NO catalog, just the controlfile (rman target =/):

       

      File Days  Name

      ---- ----- -----------------------------------------------------

      1    94    /cx4_01/oradata/prod/dados/system01.dbf

      2    94    /cx4_01/oradata/prod/dados/undotbs01.dbf

      3    94    /cx4_01/oradata/prod/dados/sysaux01.dbf

      4    94    /cx4_01/oradata/prod/dados/users01.dbf

      5    94    /cx4_01/oradata/prod/dados/users02.dbf

      6    94    /cx4_01/oradata/prod/dados/users03.dbf

      7    94    /cx4_01/oradata/prod/dados/adm_data01.dbf

      8    94    /cx4_04/oradata/prod/dados/ln_homolog_data01.dbf

      9    94    /cx4_04/oradata/prod/indices/ln_homolog_index01.dbf

      10   94    /cx4_04/oradata/prod/indices/ln_index01.dbf

      11   94    /cx4_01/oradata/prod/dados/dados_p01.dbf

      12   94    /cx4_01/oradata/prod/indices/indices_p1_01.dbf

      13   94    /cx4_01/oradata/prod/dados/ln_data01.dbf

      14   94    /cx4_01/oradata/prod/dados/gkoscf_dtau01.dbf

      15   94    /cx4_04/oradata/prod/indices/gkoscf_indx01.dbf

      16   94    /cx4_04/oradata/prod/dados/gkoscf_data2_01.dbf

      17   94    /cx4_01/oradata/prod/dados/kisacommerce_data_01.dbf

      18   94    /cx4_04/oradata/prod/dados/TS_DW01.dbf

      19   94    /cx4_04/oradata/prod/indices/TS_DW_IX01.dbf

      20   94    /cx4_01/oradata/prod/dados/klgdwetl_data01.dbf

      21   94    /cx4_04/oradata/prod/indices/TS_WSA_IX01.dbf

      22   94    /cx4_01/oradata/prod/dados/TS_WSA01.dbf

      23   94    /cx4_04/oradata/prod/dados/NFE_DATA01.dbf

      24   94    /cx4_01/oradata/prod/dados/NFE2_DATA01.dbf

      25   94    /cx4_01/oradata/prod/dados/NOTAMAX01.dbf

      26   94    /cx4_04/oradata/prod/dados/AUDIT_DATA_01.dbf

       

       

      I did the full rsync catalog but the same happens... Anyone, any ideia ? Why when i'm not connected on catalog the command don't work ?

       

       

      Best Regards!

       

       

      PS> Please excuse my bad English.