cancel
Showing results for 
Search instead for 
Did you mean: 

Which Oracle files do I exclude from normal backup?

M_Janne
Level 3
 Using BE 9.1 Oracle Agent to backup Oracle 9i Rel 2. It works fine, but my question is what Oracle files do I have to EXCLUDE when I perform a normal (non-Oracle agent) backup. I want to avoid the unnecessary copying of duplicate files, but I also want to make sure I do not miss anything!

I know I have to exclude the Oracle Tablespaces; do I also need to exclude the files that make up the {ARCHIVED LOGFILES} and {DATABASE CONTROL FILE}?

Also, do I have to INCLUDE all the other files that reside in my database directory?

Janne
1 ACCEPTED SOLUTION

Accepted Solutions

lyon
Level 5
 Not sure about all the files you need to exclude, but definately leave out ORADATA. Attempting to backup this file may cause shutting down your database, as it is a log file that is constantly updating.

Lyon

View solution in original post

2 REPLIES 2

lyon
Level 5
 Not sure about all the files you need to exclude, but definately leave out ORADATA. Attempting to backup this file may cause shutting down your database, as it is a log file that is constantly updating.

Lyon

M_Janne
Level 3
 Thanks lyone, that's a good point I didn't notice.

Janne