Is it possible to restore and recover the System tablespace using RMAN? I can't seem to allocate a channel in RMAN with the target database closed, and yet I know I cannot take the System ts offline in order to perform recovery.
If I have to manually restore the System ts, then how do I do that if all I have is one big backuppiece for the entire database? (Online complete backups are taken daily.)
I have not done that before but I think target database should be in mount state if you want to do a cold backup or restore system tablespace. RMAN should be able to read the control file of the target database.
I think that my backups must have been corrupted. I deleted all old backups and took a new one. Then I tried it and it worked with the db in "mount". Thanks for the link - that is a great example. How did you find that? Are there any more examples?
I'm trying to test all likely scenarios on our db before we go live...