7 Replies Latest reply on Jun 4, 2014 5:22 AM by Warrior25

    Oracle home deleted

    1050168

      Hi Experts,

       

      Oracle version : 11.2.0.3

       

      I have accidently deleted the entire Oracle home directory using rm -rf command on a prod server.

      Checked with OS team, there are no filesystems backups

       

      Please suggest what can be done now and how do I restore

       

      Thanks

        • 1. Re: Oracle home deleted
          sb92075

          c5681228-9c95-48a8-b13e-e11421eeea64 wrote:

           

          Hi Experts,

           

          Oracle version : 11.2.0.3

           

          I have accidently deleted the entire Oracle home directory using rm -rf command on a prod server.

          Checked with OS team, there are no filesystems backups

           

          Please suggest what can be done now and how do I restore

           

          Thanks

          reinstall the software

          • 2. Re: Oracle home deleted
            1050168

            Hi SB92075,

             

            Thanks for the reply

             

            The situation is that due to client requirements , we have 3 databases which have their own distinct Oracle 11.2.0.3  homes on the same server

             

            /apps/xyz/oracle/oracle-xyz-13P-p/product  -  Database1

            /apps/xyz/oracle/oracle-xyz-14P-p/product - Database2

            /apps/xyz oracle/oracle-xyz-15P-p/product - Database -3

             

             

            /apps/xyz oracle/oracle-xyz-15P-p/product - Database -3 is deleted

             

             

            Since version is the same 11.2.0.3 , Can I use all the files from the/apps/xyz/oracle/oracle-xyz-13P-p  home and copy it to /apps/xyz oracle/oracle-xyz-15P-p

            • 3. Re: Oracle home deleted
              sb92075

              > Can I use all the files from the/apps/xyz/oracle/oracle-xyz-13P-p  home and copy it to /apps/xyz oracle/oracle-xyz-15P-p

              I give up.

              Can you?

              Since I don't know you or your capabilities, I can't answer your question directly.

              • 4. Re: Oracle home deleted
                jgarry

                Whether you have exactly the same patches may be the biggest determinant, and you have to be careful about not changing links, file protection or copying running executables.  Personally, I'd install fresh.  Also watch out for dbconsole/em dependencies, I can't recall what they are, but I know I've run into things. 

                 

                Not having these backups are an indicator there may be other inconsistencies between homes, and perhaps other procedural problems.

                • 5. Re: Oracle home deleted
                  Krishna-Oracle

                  If you have same kind of patches in both the environment, then you can clone the binaries to new  location.

                   

                  Cloning an Oracle Home

                  • 6. Re: Oracle home deleted
                    ddf_dba

                    c5681228-9c95-48a8-b13e-e11421eeea64 wrote:

                     

                    Hi Experts,

                     

                    Oracle version : 11.2.0.3

                     

                    I have accidently deleted the entire Oracle home directory using rm -rf command on a prod server.

                    Checked with OS team, there are no filesystems backups

                     

                    Please suggest what can be done now and how do I restore

                     

                    Thanks

                    No filesystem backups on a production server???  Why would you NOT backup production filesystems???  I could possibly understand that decision for a DEV or TEST machine, but PROD is far too important.

                     

                    David Fitzjarrell

                    • 7. Re: Oracle home deleted
                      Warrior25

                      The only option left is:


                      If you have same kind of patches in both the environment, then you can clone the binaries to new  location.