Browsed by
Category: pdb

Back to basics: controlfile autobackup and recovery

Back to basics: controlfile autobackup and recovery

Sometimes it’s not bad to look back to the basics. Due to circumstances I’m focusing more on backups nowadays. This time I wanted to have a closer look to controlfile autobackups. Oh by the way, for the one who follow me on twitter, yes, it’s this post which is related to this picture 🙂 Most of the tests I do, I do them at night (not this one, because I needed it for my customer) and yes, I write most…

Read More Read More

oops, sorry I dropped the wrong directory

oops, sorry I dropped the wrong directory

There are some days, that you play around in your lab and end up with a situation you hope will never happen in real life. Today was one of those days. While playing around with 12.2 pdb’s I found following scenario. Imagine a container database in noarchivelog. I would not recommend to run in noarchivelog, but sometimes, it still happens. At a certain moment in time, you play around with the db_create_file_dest parameter and you decide to set it to /u03…

Read More Read More