A question on forums.oracle.com asked: can we recover a database further in time then the time of backup of the last controlfile. Nice question…my gut feeling immediately says : YES we can. But…I do not have a proof of it, and one quick search on the internet did not supply a adequate answer. So…then I […]
Continue ReadingBasic Rman Configuration
A basic rman configuration (backups to disk): RMAN> show all; RMAN configuration parameters for database with db_unique_name TINUS are: CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 31 DAYS; CONFIGURE BACKUP OPTIMIZATION ON; CONFIGURE DEFAULT DEVICE TYPE TO DISK; CONFIGURE CONTROLFILE AUTOBACKUP ON; CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO ‘/u04/backups/tinus/%F’; CONFIGURE DEVICE TYPE […]
Continue ReadingRestore and recover a database when everything is gone
Today someone deleted everything: datafiles gone, controlfile gone, spfile gone. What to do?…..not to worry….if you have backups (and the logging of those backups) you can get everything back 🙂 Lookup your DBID Lookup the autobackup file you want to use (probably the latest) Startup database nomount from a init.ora (spfile is also possible but […]
Continue ReadingRestore and recover a database when the controlfiles are missing
That’s a little more complicated. The controlfile (nocatalog) is the place where oracle stores all information regarding the backups. So no controlfile …. no restore/recover you might think…. If there is only one thing you take with you from this article it will be: make sure you have the logging of your backups handy. All […]
Continue ReadingRestore and recover a database when datafiles are awol
A sysadmin wasn’t paying attention and deleted a few datafile from the (running) database. What can we do? Actually we will do the same as here. Startup database in mount mode Restore the database Recover the database Open the database pffff….that was easy.
Continue ReadingRestore and recover a database up to a point in time
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 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