Sunday, September 10, 2006

Database Control RMAN Wizard Bug

Here is a bug that I found in our 10gR1 systems. This bug has to do with Enterprise Manager (EM) Database Control 10.1.0.5 and scheduling backups with the Recovery Manager (RMAN) wizard. Whenever you do a custom RMAN backup and choose to only backup certain tablespaces, the UNDO tablespace is never given as an option.

Now, without the undo tablespace, database recovery is not possible. However, the EM RMAN wizard will not allow you the option of adding the undo tablespace to the list of tablespaces to be selected for backup.

So, here is the workaround:

  • Modify the RMAN script that is created and manually include the undo tablespace in your list of tablespaces to be backed up. Then submit your job.

I will be creating some RMAN backups for a 10.2 database soon and will let you know if this bug is also in 10gR2.

2 comments:

Neetu said...

Yes its is absolutely true that there is a bug in that version of Oracle but now as the new version has arrived so it is completely removed in it. But the solution that you have suggested to make all things work sound is a great help to all those people who are still working on this version. Thanks.
sap support package implementation

Neetu said...

Yes its is absolutely true that there is a bug in that version of Oracle but now as the new version has arrived so it is completely removed in it. But the solution that you have suggested to make all things work sound is a great help to all those people who are still working on this version. Thanks.
sap support package implementation