QUOTE (mandrake @ Dec 7 2007, 12:38 PM)
Still waiting for your reply to why i am being asked for july archive when my controlfile are of monday. Which backup controlfile is my database reading from and how can i change it...
even as given in the metalink note you suggested the first file i am being asked irchive file of july. How is it when my controlfile is of this MONDAY
This can happen if you have a read only tablespace or sometimes if you have an offlined data file. desc v$datafile to see what information you can get.
If this is the case, be sure you have a copy of the offending data files, startup mount, then alter database datafile 'whatever' offline drop
This happens because using the backup controlfile syntax, the recovery ignores what the control file says the current SCN's in each data file should be, in favor of what each data file says it should be. So when it sees that it is trying to bring everything up to what the control file says should be current, the offline or read-only datafile says the SCN is very old, and the recovery asks for logs that will bring it up to be current. If you actually have all of those logs, you would probably run through them all, just so the recovery can mark the datafile with a current SCN.
Or something like that.
So, if you have a read only tablespace you can get it back from when you originally backed it up, right?