Protected: RMAN Backup

This content is password protected. To view it please enter your password below:

Backup controlfile

You add a datafile, you backup your controlfile. It’s that simple…. Read the rest of this entry »

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 »

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 »