I have an HP OpenView database. When zillions of events were occurring I received the "Could not extend tablespace" message and I had to add a datafile. Then tons of transactions occurred and a thousand archivelogs were generated. I did a full backup with RMAN so that they could be deleted (space became an issue which is another problem that I am NOT asking about).

But since the problems were really in the application, the OpenView administrator decided to restore the whole server to a point about a week earlier when everything was working fine.

Now everything is working fine but RMAN is not able to backup any more because that file I added is gone (it disappeared as a result of the restore). The database knows nothing about it but RMAN does. If I try to do "resync catalog"
I get the message "controlfile sequence# too low" and I've tried a number of other things.

This is what I don't understand. If I ask RMAN for a full backup, why should it care what files used to be there? I want the database backed up as it is NOW. How can I tell RMAN to forget the past and give me a full backup of the database
as is?

Any assistance would be greatly appreciated.


Gary Sokola

Oracle LazyDBA home page