This content has been marked as final. Show 9 replies
Pl post OS details. What exactly do you mean by "backup of ORACLE_HOME" - what tools or commands are you using to back up ?
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.
PerYcut wrote:No, you can use tar command to do this.
it is required to shutdown all databases and Listeners etc. before i can make a Backup of the ORACLE_HOME (11gR2) ?
$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
No need to bring down the DB & TNS ...u can proceed for ORACLE_HOME backup......
My Blog: http://shishirtekade.blogspot.com
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 ?
Yes - correct
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