Video Screencast Help

backing up oracle 11g R2 on linux as flat files skips the data, redo, control files

Created: 08 Oct 2012 | 6 comments

hello....

we have purchased oracle agents to backup oracle database table space ... 

but we want also to backup the oracle database as flat files....

so.. we created a backup job to backup the oracle directory with everything inside ...

the directory in the red circle is the most important because it contains the data files , the control files and the redo logs ...

 

but when we try to restore we discovered that the contents of that directory were skipped... as for the backup job it was successful ... but these files were skipped ...

 

that database were backed up as an oracle resource already... but we need to back it up as flat files...

all the other directory and files were backed up except that directory and its contents 

why does the backup exec skipps these files ???

 

Comments 6 CommentsJump to latest comment

pkh's picture

This is because of AFE which automatically excludes certain file types, like .dbf

Simply backing the .dbf files may not do any good because when you restore the .dbf files, you might end up with an unusable database.  If you want to do flat file backup, then dump the databases using RMAN and then back the resultant files using BE.  However, I don't know why you would want to do this as you already have the BE Oracle agent.

Haytham Helmy's picture

hello.... our IT manager policy says that he needs to keep tha plain files of the database .. beside the table space..so i need to include the data files , redo logs  and control files in the flat files backup..

could you please tell me how to tell backup exec not to skip these files???...

pkh's picture

I have not come across any way to turn off AFE, except for Domino databases.

You should talk to your IT manager about this policy.  There is no point in doing a backup if you cannot do a restore.  As I said before, just restoring these files would probably not give you a usuable database.  If it is possible to just backup the databases as flat file and restore them to a usuable state, then why would Oracle invest time and effort into RMAN to backup and restore Oracle databases.

Lilavati's picture

 

 

I assume that you have configured oracle database on Linux machine using "AgentConfig" Utility, for running backup of oracle database

In Backup Exec 2012 we have fixed an issue: If customer has oracle Agent license and oracle database is configured in "AgentConfig" for backup, then Backup Exec skips the oracle files.

If you want backup the oracle database directory then remove the database entry from Agent Config utility and run the oracle database directory backup

In short if you want backup the oracle database file as flat file then remove that oracle database entry from the "AgentConfig” and run the backup of oracle directory

 

Note:

Backup Exec 2012 is skipping oracle database files because of new feature that is “Advanced Open file Option for Linux”. This feature will back up the oracle database file too though it is online. But backup exec does not recommend the flat file backup that is why backup exec is skipping these files

Hope this piece of Information Helps you... and if it does then mark this response as Solution....!!!

Haytham Helmy's picture

hello...

thanks for your reply ....

i need to configure two jobs at the oracle server

the first job to backup the oracle resource database... and the second job is to backup the flat files..

i have asked the oracle people and they recommend that i keep a physical backup ( flat files ) for the database beside the logical backup ( oracle resources )

the logical backup ( oracle resources ) is an online backup.. and the physical backup ( flat files ) is done offline ...

so.. i need the other job to include all the files... and the data files of the database too ...

the other job has the snapshot technology enabled and it still skipps the files...

and in the same time i can't unconfigure the database entry in the agent or then i will not be able to take a logical backup...

so... what do i need to do to make the other job ( physical backup ) includes all the files ?

Haytham Helmy's picture

ok... here is exactly what we did..

the oracle server has a backup server... we have configured the database agent on the main server... and we didn't configure the agent on the other server... and now we take the logical backup from the main server... and the physical offline backup from the backup server...