POUWIEL|COM

JeroenPouwiel

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.

Starting backup at 01-FEB-09
using channel ORA_SBT_TAPE_1
channel ORA_SBT_TAPE_1: starting full datafile backupset
channel ORA_SBT_TAPE_1: specifying datafile(s) in backupset
including current controlfile in backupset
channel ORA_SBT_TAPE_1: starting piece 1 at 01-FEB-09
channel ORA_SBT_TAPE_1: finished piece 1 at 01-FEB-09
piece handle=coldincr0_ctrfile_tsm_tapepool_******01_19072_1_677658225 comment=A
channel ORA_SBT_TAPE_1: backup set complete, elapsed time: 00:00:03
Finished backup at 01-FEB-09

Recovery Manager complete.

The first line of the logging was in offline mode, the rest in online mode.
Seeing, as there are no ORA-*****/RMAN-*****, i’ll take that as a mission completed.

NEXT… !

Comments are closed.

Categories