9 Replies Latest reply: Feb 14, 2013 6:16 AM by Helios-GunesEROL RSS

    Backup ORACLE_HOME

      Hello All
      it is required to shutdown all databases and Listeners etc. before i can make a Backup of the ORACLE_HOME (11gR2) ?

        • 1. Re: Backup ORACLE_HOME
          Not required.
          • 2. Re: Backup ORACLE_HOME
            Srini Chavali-Oracle
            Pl post OS details. What exactly do you mean by "backup of ORACLE_HOME" - what tools or commands are you using to back up ?

            • 3. Re: Backup ORACLE_HOME
              Robert Geier
              It is not necessary to shutdown databases or listeners to backup binary files or logfiles.
              Since binary files will only change when you patch the software, many companies just do a weekly full / daily incremental backup of the binary files and logs.
              • 4. Re: Backup ORACLE_HOME
                PerYcut wrote:
                Hello All
                it is required to shutdown all databases and Listeners etc. before i can make a Backup of the ORACLE_HOME (11gR2) ?

                No, you can use tar command to do this.
                • 5. Re: Backup ORACLE_HOME

                  $ORACLE_HOME does not require to bring down the services running/dependent on it , it is not specific to 11g but to all oracle versions ( at least in UNIX environment )
                  No binaries being modified when DB /TNS are up but log/trace files within $ORACLE_HOME keeps on updating unless it is configured in non-default location, which should not be an issue for binary backup

                  Ajay More
                  • 6. Re: Backup ORACLE_HOME
                    No need to bring down the DB & TNS ...u can proceed for ORACLE_HOME backup......
                    Best Regards,
                    Shishir Tekade.
                    My Blog: http://shishirtekade.blogspot.com
                    • 7. Re: Backup ORACLE_HOME
                      thanks to all .
                      we use aix , linux and solaris os
                      the answer is . the oracle home can be copy or tar d if any binaris are in use and we have a consistent backup of the oracle home. only for patching we must shutdown the services.
                      thats right ?
                      • 8. Re: Backup ORACLE_HOME
                        Srini Chavali-Oracle
                        Yes - correct

                        • 9. Re: Backup ORACLE_HOME

                          Actually your question has missing part such as why do you need to take backup Oracle_Home.. What is your issue?

                          ORACLE_HOME is keeping binary which oracle need to run. You can take this path backup regularly or not, it depends. For patching you need to backup this path.

                          If you check patch readme part you can get all information about what you have to do before patching

                          PS:Please dont forget to change thread status to answered if it possible when u belive your thread has been answered, it pretend to lose time of other forums user while they are searching open question which is not answered,thanks for understanding