At (let’s say) around 08:30 this morning something (probably someone) messed up the database. I would like to go get back the database to 08:00 this morning: Startup the database in nomount For future reference: look at the incarnations we know Set an until time (this must be done in a run block) Restore the […]
Continue ReadingRMAN recipes
A few recipes I like to go through: Restore and recover a database as far as we can go Restore and recover a database up to a point in time Restore and recover a database when datafiles are awol. Restore and recover a database when the controlfiles are missing Restore and recover a database when […]
Continue ReadingRestore and recover a database as far as we can go
Something went wrong…we need the database back to the point we have archivelogs of: List incarnation (just to see what we have…no actual need to) Restore database (getting the datafiles back in place) Recover database (creating an actual working database with all updates we can possibly find in the archives) Open the database (and start […]
Continue Reading