Timeline for Oracle 11g database structural change doesn't autobackup controlfile/spfile
Current License: CC BY-SA 3.0
8 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Dec 9, 2013 at 5:36 | history | edited | kupa | CC BY-SA 3.0 |
changed format and added a clear explanation.
|
| Dec 9, 2013 at 5:33 | vote | accept | kupa | ||
| Dec 6, 2013 at 19:47 | comment | added | kubanczyk | @Ivan Both NBU and TSM work when executed from RMAN script. In fact, you cannot execute them in any other way, which kind-of sucks. | |
| Dec 6, 2013 at 13:13 | comment | added | kupa | @Ivan So you may be taking backups on tapes as usual but your controlfile autobackups taken by server process will be located on disk :) | |
| Dec 6, 2013 at 13:07 | comment | added | kupa | @Ivan such kind of automatic backups of controlfile are saved always on disk(when database structure changes, because backup is taken by server process itself, rather than one of the RMAN channels) Also , in 10g every structural change was causing controlfile to be backed up (so many controlfile autobackups were being generated) , in 11g it waits for a few minutes and then generates(nice upgrade) <- have tested myself , believe me :) | |
| Dec 6, 2013 at 12:53 | comment | added | ibre5041 | Interesting. Good to know. I thought something like that must be impossible, because in many cases RMAN cooperates with backup SW like NetBackup or TSM. In these envs. one can not simply execute RMAN to put the backup onto tapes. I assume this is specific to envs. where backup are kept on disk. | |
| Dec 6, 2013 at 12:27 | history | edited | kupa | CC BY-SA 3.0 |
added 3 characters in body
|
| Dec 6, 2013 at 12:19 | history | answered | kupa | CC BY-SA 3.0 |