March 17, 2009
Comments Off on Backup controlfile
You add a datafile, you backup your controlfile. It’s that simple…. Read the rest of this entry »
February 1, 2009
Comments Off on Interrupt a cold-backup of an archivelog-enabled db
Ran into a offline backup that took too long and went outside of the blackout.
A little querieng against the V$SESSION_LONGOPS told me it would take prox. another 3.8 hrs to finish.
Not something you want to wait for @ 02:00 am.
This is a 9i database (9.2.08) in archivelog mode, mounted an’ all.
All it took was a: “alter database open” and the offline backup transformed into a online version. Read the rest of this entry »
December 13, 2008
Comments Off on RMAN backup & recovery
Just began reading this book, in aid of my (short-term) memory, here are (the first of) a few excerpts from that book, after the jump:
Read the rest of this entry »