4 Replies Latest reply: Jun 11, 2014 6:25 PM by petra-K RSS

    Overwrite dbf files

      Hi all,

       

      11.2.0.3

      aix 6

       

       

      I have done recovery of our PROD db to another server for running reports, just like in dataguard. I want  refresh the database again for new backup copy.

      Does RMAN recovery overwrites existing dbfs? Or do I need to remove them 1 by 1?

       

      Thanks all,

      pK

        • 1. Re: Overwrite dbf files
          tvCa-Oracle

          That's a good question ... to which I can't give you the answer

           

          In general, it's advised to remove files, so that it is easier later to differ files that belong to the database, and files that don't. Or, for other reasons I can't think of right now, but mostly creating unnecessary files (if any) in the same folder, maybe files that also end up in backups (file level backups) that should not, etc. etc.

           

          Same as for a file restore (not being a database), it's always advised to clean the structure, before adding again.

          • 2. Re: Overwrite dbf files

            Thanks tv

            • 3. Re: Overwrite dbf files
              Paul M.

              I have done recovery of our PROD db to another server for running reports, just like in dataguard.

              Then it's not a standby database.

              I want  refresh the database again for new backup copy.

              Does RMAN recovery overwrites existing dbfs?

              If "RMAN recovery" means "RMAN restore", then the answer is Yes. If not, please clarify.

              Or do I need to remove them 1 by 1?

              As above, the answer is No.

              • 4. Re: Overwrite dbf files

                Thanks Paul